#What's the Point of Extra Databases?
24 messages · Page 1 of 1 (latest)
Some game or plugins of games needs databases. And somethimes you have more then 1 plugin that needs its own database.
oh okay interesting! Yeah I've never really been into plugins so that's news to me. Thanks!
Different tables exist for that reason.
they do ofc but it is just there if people want it
One database is enough, you can just create multiple tables within that database
I guess. It is just a bit impractical, because within the same database you can easily make relations etc, while if you use multiple databases it gets a bit more complicated.
not recommended really, one plugin messes up and you loose everything connected to it
For relations between tables one database would be key.
If one plugin messes up one table you can just reset that table or correct it.
Unless you assume that a plugin could wipe an entire database. (Accidentally or otherwise)
In this case I would agree with your statement.
Plenty of plugins have table names that would overlap. Far more reasonable to use separate databases for each plugin.
Trying to use one database for a whole bunch of unrelated things is just asking for trouble
plugins can accidently mess the entire database up
how would a plugin with malicious intent be accidentally
^^
My wording was a bit awful on that one
“Unless you assume that a plugin could wipe an entire database. (Accidentally or otherwise)”
That is what I meant with it
I guess I am just used to using only one database with a lot of tables due to web development. (Per website)
That's totally different tho. That's one application, and you have control over the development of the schema or at least table prefixes.
Yes it is different, I went at it with that approach. This conversation has adjusted my views on this topic and I will implement something for it accordingly.
👍