MySQL, SQLite, Y_INI, or other?
#1

Which one should I use for my server and why?

Thanks!
Reply
#2

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'
Reply
#3

MySQL.

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

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.
Reply
#5

MySQL if you will use one site with one ucp.

if is only to save use SQLite
Reply
#6

Ok, thanks guys, I'll use SQLite then
Reply
#7

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
Reply
#8

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


Forum Jump:


Users browsing this thread: 1 Guest(s)