Jump to content

[QUESTION] SQLite or MySQL?


Enargy,

Recommended Posts

MySQL should be more reliable because it doesn't depend on your MTA server. You can configure the way your MySQL runs, in opposite to SQLite in MTA. You can access the same data from MySQL on 2 or more servers, MTA's SQLite can't be shared unless you edit db files via your code. This list can go on forever though.

Link to comment
MySQL should be more reliable because it doesn't depend on your MTA server. You can configure the way your MySQL runs, in opposite to SQLite in MTA. You can access the same data from MySQL on 2 or more servers, MTA's SQLite can't be shared unless you edit db files via your code. This list can go on forever though.

SQLite is more reliable than MySQL since it's nothing more than a file, whereas MySQL is a service. SQLite is a lot more convenient and easier to manage than MySQL, but I wouldn't use it in a large-scale production environment, or an environment where you want multiple services to access it.

Link to comment

Main difference is:

SQLite = offline.

MySQL = online.

Now if we go in details, you'll see what difference is:

Data value types of SQLite:

NULL

INTEGER

REAL

TEXT

BLOB

Data value types of MySQL:

TINYINT

SMALLINT

MEDIUMINT

INT or INTEGER

BIGINT

FLOAT

DOUBLE, DOUBLE PRECISION, REAL

DECIMAL, NUMERIC

DATE

DATETIME

TIMESTAMP

TIME

YEAR

CHAR

VARCHAR

TINYBLOB, TINYTEXT

BLOB, TEXT

MEDIUMBLOB, MEDIUMTEXT

LONGBLOB, LONGTEXT

ENUM

SET

That clearly says MySQL can store data values with more efficient types, those which goes perfectly with your data value. Though, you wont understand all of those types, check that on google by " in Sqlite/MySQL".

Another thing is that MySQL is used by most professionals, and mostly to connect websites with your object-oriented programming. While we see, SQLite is more handy for starters, can save every data as same as MySQL does, its just that MySQL can store it under more categories. Also, SQLite is used in (most) android apps, i'm not sure about iOS.

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