How can I design a magical weapon that grants an advantage against fire-base creatures without using water and choking effects?

The party I am DM’ing is going for an adventure to the Elemental Plane of Fire. I want to design a magical weapon that can grant an advantage against fire-based creatures. I see that Fire Elementals have Water Susceptibility (Cold Damage) but I have already house-ruled that elemental planes can not include magical effects of elements from other elemental planes, but just the spells that have elements of the current plane can be cast (as the plane purely consists of element of itself). For example, in the Elemental Plane of Air, not only Earth-based spells but all the spells are impeded, except air-based ones.

After I realized that I can’t use a magical weapon that has cold damage due to my house-rule, I wanted to give the weapon a "heavy smoke" effect to choke the fire, as I thought that fire can not live without oxygen. But this option conflicts with my house-rule, also I saw that the fire-based creatures any other fire source in the Elemental Plane of Fire don’t need air to live.

Now I have no idea how can I design a magical weapon that gives an advantage against fire-based creatures without cold damage and choking the fire via leaving without oxygen is not an option. I can not cancel my house-ruling because of the sake of my setting. I am open to any house ruling ideas beside the official ruling.

TLDR: as in title, how can I design a magical weapon that grants an advantage against fire-base creatures without using water and choking effects?

If the question shows up to be opinion-based, please accept my apologies.

Fantasy economy: how to design a deep, sophisticated crafting system?

I want to construct an immersive, complex and functional fantasy economy in order to inform my world-building process. I’m interested in finding a working economic model and applying that into low-tech, low-magic environments, similar to the authentic late medieval/early modern eras.

  1. What sorts of commodities and raw materials are out there and where to get them? A list of commodities would be great.
  2. How does trade and transportation (land and water) work, and what are the possible pitfalls of trading (taxes, bans on certain goods, robberies, etc.)?
  3. Crafting! How would you proceed in creating this sort of a complex, multilayered system, where raw materials are being converted into more polished materials using various vocations and techniques (which ones?)? How would you design a crafting system, where these commodities and materials are used to assemble finished products? How to fit in the price of labor, and the skill of rare artisans?

I’m looking for something of a complexity along the lines of the economic system of EVE Online. However, EVE Online is a computer game, and science fiction besides. I’m looking for something more varied, middle age-ish, with a personal touch, and that can account for differences based on the cultures participating in the whole trading system.

Front – end design for a MySQL database

Good day everyone!
I have a personal database of film-noir movies. I am looking for a program that I could use to build a front-end on my website to attach to the MySQL database. It will list the title, actors, plot, comments, rating and the film image. I want to be able to advance to the next movie if I want and to be able to search. I do not want to use WordPress. I want to build it myself. I do not mind learning. Most of everything I read is building an App or using WordPress. Thank you.

Lightbox? Gallery? Custom Popup Design

Hello, we love the feel of this site – https://www.entertainmentone.com/

We are looking to try to figure out what exactly is it that they are using on the home page, if you click on one of their projects, it pops up a full screen page with a background for that project and information/video…..it acts like a Lightbox but aren't lightboxes only for Images?

What are they using here and is there a WordPress Plugin that is similar to do this?

Design implementations with little to no JavaScript

As some of you may know I've been writing articles on Medium on a variety of topics. The past week or two I've had a running theme of "do ___ without JavaScript", and today I put up one that requires minimal scripting.

Just thought you folks might find these techniques handy.

Tabbed Interfaces Without JavaScript:
https://levelup.gitconnected.com/tabbed-interfaces-without-javascript-661bab1eaec8

Modal Dialog Driven Websites Without JavaScript…

Design implementations with little to no JavaScript

Schema design of a document-oriented database

I’m designing the database schema for a e-learning website and I’m working with a document-based database (Firestore), so I ran into a problem of design the way of structure the data in order to not make a lot of reads.

So I design the schema based on these primaries features.

  • There are three types of courses
    • Lifetime: Once you bought it you can take the course as many times as you want.
    • Generational: Once you bought the course, you can only take it between certain dates, if you wanna take it again, you need to buy the next generation.
    • Lesson: You bought a pack with 3 tickets, these tickets can be used to watch a lesson, once you use all you need to buy more if you still want you to take another lesson.

Schema

  • The ? after a column name means that the field is optional.

My mindset when I design the schema was the following

  • A unique source of truth about courses, his prices, commercial name, maybe more metadata about it, so I created the collection Course.

  • Do not complicate the design differentiating between course types, for that reason I created the Batch collection, where I save all types of courses and generations. For example, If I have a lifetime course I only have I document on Batch, with the flag lifetime and the course data embedded. If I have a generational course, I have as many documents as generations, with the number of the generation, the initial and the final date, the course could be the current generation or a scheduled one. The behavior of the lessons is similar to that of the courses by generation.

  • I have the subcollection courses on the User that stores the purchased courses, if the course is a generation that is scheduled, instead of saving an embed document I save the reference to the Batch, as scheduled dates may change.

  • I save the number of tickets available to use on the user document.

So, I know there is a lot of info, but I’ll be glad if anyone could tell me if I’m on the right path, I mean I know that there may be a better solution, but if anyone could give me feedback, it will be great.

Is a relational database with a dynamic number of tables a good design?

I have a use case where I wish to create a table for each entity to which the underlying application that owns this entity will publish records.

This table has a fixed structure, so if there are 5 such entities in my system, there will be 5 different tables with the same schema.

The schema is generic with one of the columns in the schema as JSON for flexibility. I do not expect queries based on the fields in the JSON. I expect the following queries on each entity:

  1. On the auto-increment id primary key column with LIMIT and OFFSET where I need to read X rows from the record with id Y.
  2. On the creation date column with LIMIT X.

I expect thousands of such entities to be created on the fly so in turn there will be thousands of tables in the database.

In future when one of these entities have fulfilled their purpose, the table would be simply deleted.

I expect most of these tables to have not more than 100 rows while there will be a few with at least 1M rows as time goes by. This design makes data easy to query as my application can determine the table name from the entity name.

Is this a bad design?

Is there a limit to the number of tables in a database in RDBMS (the above design is with Postgresql 11 in mind) keeping performance in mind?

Should I use any different datastore to achieve this other than RDBMS? Any suggestions?