Jump to content

Question regarding databases


Recommended Posts

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. ;)

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...