[QUESTION] SQLite or MySQL?

[Enargy,]

Hey, I wonder who is the safest database to save data, if SQLite or MySQL(or need to learn both ). the issue is that I want to learn to use one of these two options to create my own systems or something else.

Thnx.

[MIKI785]

What do you mean safest? They're both SQL so they're both vulnerable to SQL injection.

[Enargy,]

What do you mean safest? They're both SQL so they're both vulnerable to SQL injection.

I mean if they have something different, they are the same or another is more "complete".

[JR10]

They have their differences. A simple Google search will provide you with the main ones.

[Gallardo9944]

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.

[Callum]

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.

[Ryancit2]

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.