[gotwarzone]

Hi guys, I was looking for a good fs admin system that include sqlite or mysql. Can you please recommend me?

I'm sorry if this is not the board to post it but at the same time I want to know which one is the fastest and better?
Also from this sqlite and mysql which one is not too much complicated to use?

If you only know after 4 months making a gamemode now I realized I had to I gave up y_ini.

I need your advise. Thanks alot.

[iZN]

MySQL is using a plugin for all the functions and natives. If you're going for threaded queries with cache, you must be having good knowledge about using the threaded queries; If you think threaded queries is harder, so just try BlueG's MySQL R6 (unthreaded queries)

SQLite is implemented in SA-MP, so you don't need any type of plugin to use SQLite. SQLite is so far easy to use.

About the speed measurements, MySQL could be faster than SQLite but I'm not really confirmed about the speed.

[gotwarzone]

Quote:

Originally Posted by iZN MySQL is using a plugin for all the functions and natives. If you're going for threaded queries with cache, you must be having good knowledge about using the threaded queries; If you think threaded queries is harder, so just try BlueG's MySQL R6 (unthreaded queries) SQLite is implemented in SA-MP, so you don't need any type of plugin to use SQLite. SQLite is so far easy to use. About the speed measurements, MySQL could be faster than SQLite but I'm not really confirmed about the speed.

Thanks alot brother fro the info. I just found out most admin system are using MySQL rather than SQLite. But I see different kinds of MySQL and I don't know which one I should use. I'm kinda bit confused.

Can you please help me? which version of MySQL is the latest and mostly compatible with server hosting for SA-MP?

EDIT: And please someone send me a link for a good admin system fs that uses MySQL?

[iZN]

Quote:

Originally Posted by gotwarzone Thanks alot brother fro the info. I just found out most admin system are using MySQL rather than SQLite. But I see different kinds of MySQL and I don't know which one I should use. I'm kinda bit confused. Can you please help me? which version of MySQL is the latest and mostly compatible with server hosting for SA-MP

Use BlueG's MySQL Plugin. The last version for unthreaded queries is R6. Later it was developed by maddinat0r, the threaded queries from R7. Threaded queries (optional cache) is R20 and cache-only last version is R34.

You must learn some basics about MySQL first before getting used to it.

[Konstantinos]

SQLite is really fast while executing queries with SELECT clause, but it's not that fast with queries which contains INSERT INTO, UPDATE clauses.

I'd choose MySQL as well and of course, threaded queries. You can find a really good tutorial here: https://sampforum.blast.hk/showthread.php?tid=337810

[Champ]

you can find the list of admin system here.

https://sampforum.blast.hk/showthread.php?tid=356383