Whats the difference ? - Printable Version

Whats the difference ? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Whats the difference ? (/showthread.php?tid=516036)

Whats the difference ? - Johnson_Brooks - 29.05.2014

I would like to know the difference between SQL,SQLite and MySQL.
I tried to make a mysql script by following a tutorial , and it compiled fine but when i tried to add it to a copy of my gamemode , things got fucked up .

Anyways whats the difference? And which one is better.

Re: Whats the difference ? - Ciandlah - 29.05.2014

I would like to use MySql, however I prefer SQL or SQLITE, because they all save to databases, its just Mysql you need to connect with a Live PHP database where as SqLite or SQL it saves in a database format to your gamemode directory

Re: Whats the difference ? - Johnson_Brooks - 29.05.2014

Quote:

Originally Posted by Ciandlah

I would like to use MySql, however I prefer SQL or SQLITE, because they all save to databases, its just Mysql you need to connect with a Live PHP database where as SqLite or SQL it saves in a database format to your gamemode directory

So when you use SQL/Lite it saves in a database like in scriptfiles as an .ini file would ? Whats the easiest for controlling a server ?

Re: Whats the difference ? - Konstantinos - 29.05.2014

MySQL by BlueG, R38 with threaded queries or ORM is much faster than SQLite. If you're on a host that doesn't provide MySQL, then go for SQLite (SQLitei by Slice is also recommended).

Quote:

Originally Posted by Ciandlah

SQL is the language that MySQL and SQLite use. MySQL needs a mysql server to be connected to and SQLite saves the .db file in scriptfiles folder.

Re: Whats the difference ? - Ciandlah - 29.05.2014

Quote:

Originally Posted by Johnson_Brooks

So when you use SQL/Lite it saves in a database like in scriptfiles as an .ini file would ? Whats the easiest for controlling a server ?

In my own Opinion, SQLite has worked wonders for me for Performance wise and efficient. However MYSQL is more stable.

Re: Whats the difference ? - Johnson_Brooks - 29.05.2014

Quote:

Originally Posted by Konstantinos

MySQL by BlueG, R38 with threaded queries or ORM is much faster than SQLite. If you're on a host that doesn't provide MySQL, then go for SQLite (SQLitei by Slice is also recommended).

SQL is the language that MySQL and SQLite use. MySQL needs a mysql server to be connected to and SQLite saves the .db file in scriptfiles folder.

So for example could i see an SQL tutorial and make some basic stuff and then if i decide to buy a host with mysql suppot switch to mysql easily ?
If yes , i will do that.

Re: Whats the difference ? - Konstantinos - 29.05.2014

You have to know the basic of SQL so the queries won't fail (errors in the syntax etc).

All you will have to change is the functions since they differ and the way it loads the data. It can take a day or more depending on the script.