What to use when planning databases?

Question

Database design

For large projects, what tools do you use to plan your databases?
I need to visualize what I will do in the future, I need some kind of tool for this, created for this

Answer 1

Try dbdesign

Answer 2

I choose DBMS. Opportunities strongly depend on it: data types, indexes, intermediate tables.
I break pieces of data into entities - thematic data sets.
I scatter entities across tables - I determine what kind of fields should be in each entity, what they are for, what data types will be optimal.
I connect entities with relationships. I find out whether cascading operations are really necessary for relationships or not, where it is better to save obsolete data, where it is possible to clean up, and where it is necessary to save actual relationships by id.
I evaluate the resulting structure, optimize it: denormalize some entities, add data to connections where there is not enough, add service fields, indexes.
Next, I run several iterations in my head on typical usage scenarios: somewhere the non-optimality of the structure or field type pops up, somewhere the absence of the required field, somewhere you can save additional information that is not needed now, but in some scenarios it will significantly speed up data sampling from the DB.
The ideal all the same will not turn out, the rest is finished by migrations as required. But the biggest jambs can be avoided by properly thinking about what to store, why, in what form, how it will be used, how the DBMS works, how to help it.

Answer 3

These are runadout sliders. Search the Toaster for answers to similar questions about sliders, or search for the keyword I gave you. 75% of a slider like this is correct css.