Question regarding databases

[osnapitzjamie]

Is it better to use SQLite or MySQL for my scripts tables. I prefer MySQL imo.

[xXMADEXx]

SQLite is better for performance, but MySQL is better for accessibility.

[Baseplate]

Quote

 

MTA Internal Database
+ Simple functions and use

+ No need to set up and install an external server for database

- Limited actions

- Doesn't have the ability to do stuff that SQLite/MySQL does (altering, etc.)

- Slow (?)

MySQL

+ Ability to make tables to save specific data in

+ Ability to modify tables and do stuff with them

+ Good for big data saving and managing

- Slower than SQLite

- Need of an external server to run

- Easy but complex querying

SQLite

+ Fast

+ Nearly the same abilities as in MySQL (limited however)

+ Good for semi-big data saving and managing

+ No need for an external server in order to save

- Doesn't have all the abilities than in MySQL

- Easy but complex querying

If you want to save a few stuff about a few things then you can use the internal database or SQLite. If you're saving a lot, use MySQL or SQLite.

My personal favorite is MySQL but I guess it's because I've used it more times than the two other ones.

 

I remember myonlake posting this once, so yeah here you go mate. 

[Drakath]

You can use multiple databases too.