Accounts

[CocaColaBear]

Hi all!

Of interest are "+" and "-" of using standard accounts and accounts for MySQL.

[myonlake]

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.

[CocaColaBear]

Thanks a lot for answer. Im use MySQL but I was wondering how best to store data.