MySQL, SQLite, Y_INI, or other?

MySQL, SQLite, Y_INI, or other? - 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: MySQL, SQLite, Y_INI, or other? (/showthread.php?tid=483509)

MySQL, SQLite, Y_INI, or other? - Galileo - 26.12.2013

Which one should I use for my server and why?

Thanks!

Re: MySQL, SQLite, Y_INI, or other? - Smileys - 26.12.2013

SQLite, it's easy and everything is stored into 1 file( database ).

with a database browser you can select everything you want, way easier than manually going through every userfile with INI systems.

for example:

pawn Код:

SELECT * FROM \"Players\" WHERE \"adminlevel\" > 0;

selects EVERY player from the database that has an adminlevel greater than 0, meaning the person is admin.

you then can select one of them and delete it, or do other stuff with it.

or if you're looking for a specific person:

pawn Код:

SELECT * FROM \"Players\" WHERE \"name\" = 'yourname'

Re: MySQL, SQLite, Y_INI, or other? - Kyl3 - 26.12.2013

MySQL.

Simple, fast, and secure (if you know how to use).

Re: MySQL, SQLite, Y_INI, or other? - Cypress - 26.12.2013

If you are going to have a really small amount of savings, better use y_ini.

If you want to connect your server with a website such as PHP and so on, use MySQL. Also you can use SQLite for that but you need to have a VPS.

Use SQLite if you don't want to connect your server with website and you do have loads of things to save. Will better and faster.

That's the main reasons, unless you want to use SQLite for small amount of data savings, it's then up to you yo waste your time on whatever you prefer.

Re: MySQL, SQLite, Y_INI, or other? - PT - 26.12.2013

MySQL if you will use one site with one ucp.

if is only to save use SQLite

Re: MySQL, SQLite, Y_INI, or other? - Galileo - 26.12.2013

Ok, thanks guys, I'll use SQLite then

Re: MySQL, SQLite, Y_INI, or other? - [WA]iRonan - 26.12.2013

Y_INI is easier than SQlite though, check out some tutorials from sqlite and some from Y_INI, pick a wise choice

, I have been trying SQlite but it's more difficult than Y_INI

Re: MySQL, SQLite, Y_INI, or other? - Vince - 26.12.2013

What's easy all depends on what you're doing. Try getting the top five users with the most kills with Y_Ini. Good luck.