SA-MP Forums

Go Back   SA-MP Forums > Other > Everything and Nothing

View Poll Results: Best saving system, choose below.
dini 3 5.66%
y_ini 8 15.09%
SQLite 13 24.53%
MySQL 26 49.06%
SII 0 0%
Others (If others, post your comment) 3 5.66%
Voters: 53. You may not vote on this poll

Thread Tools Display Modes
Old 25/10/2014, 06:01 AM   #1
JaKe Elite
JaKe Elite's Avatar
Join Date: Apr 2012
Location: Philippines
Posts: 3,687
Reputation: 486
Default Saving Systems

Best saving systems? Choose above, the highest vote wins, gonna use it on JakAdmin.
Haven County Roleplay (Click here to join the server)
Discord: Click here to join our Discord
Website: Click here to register
Discord: Corporal★Shepard#3135
JaKe Elite is offline   Reply With Quote
Old 25/10/2014, 07:10 AM   #2
Join Date: May 2011
Location: Russia
Posts: 3,012
Reputation: 824
Default Re: Saving Systems

Depend on your needs.

But if you want to use the data outside your SAMP server, e.g. - user control panel or admin control panel.
Then you definitely should go with MySQL because it's supported by every programming language (and should) and it remains it's query functionality anywhere.

so you don't have to learn again the basics such as SELECT, DELETE, UPDATE and INSERT INTO.
Kaperstone is offline   Reply With Quote
Old 25/10/2014, 07:51 AM   #3
Posts: n/a
Default Re: Saving Systems

I recommend you use SQLite. INI files can clutter your folder overtime and backing up can be a pain in the ass. MySQL would be inconvenient to use for an admin system - what if the server owner doesn't know how to use MySQL, doesn't have access to a MySQL database or is not interested in using MySQL anyway?

SQLite is great because data is more organized, easy to backup and overall convenient for an admin system.
  Reply With Quote
Old 25/10/2014, 09:04 AM   #4
Team_PRO's Avatar
Join Date: Aug 2012
Location: Philippines
Posts: 1,816
Reputation: 87
Default Re: Saving Systems

Depends what you like..

but i use y_ini
Retired Player, Since 2009 Player
Team_PRO is offline   Reply With Quote
Old 25/10/2014, 01:56 PM   #5
Huge Clucker
Join Date: May 2014
Location: England
Posts: 390
Reputation: 61
Default Re: Saving Systems

How about an alternate between all saving systems?
Steel_ is offline   Reply With Quote
Old 25/10/2014, 02:26 PM   #6
Big Clucker
Anzipane's Avatar
Join Date: Feb 2014
Location: Ravenna, Italy
Posts: 49
Reputation: 4
Default Re: Saving Systems

There's no "best" saving system, it really just depends on your needs: if you need to store datas for internal usage only (in the game-server), you won't need a MySQL database, you can simply go for a SQLite database or some text files.
Anzipane is offline   Reply With Quote
Old 25/10/2014, 02:37 PM   #7
Rudy_'s Avatar
Join Date: Nov 2011
Location: Pakistan
Posts: 1,357
Reputation: 230
Default Re: Saving Systems

Use Y_Ini :/
And now my Watch has Ended.

[TuT]How to create a car shooting Neon

Neon Vehicle Laser

Rudy_ is offline   Reply With Quote
Old 25/10/2014, 02:52 PM   #8
Sergei's Avatar
Join Date: Mar 2008
Location: Slovenia
Posts: 2,870
Reputation: 230
Default Re: Saving Systems

Use SQLitei include and you will be okay. If you want to have easy external access then use MySQL.
Sergei is offline   Reply With Quote
Old 25/10/2014, 02:55 PM   #9
Big Clucker
Skully82's Avatar
Join Date: Apr 2014
Location: Egypt
Posts: 149
Reputation: 22
Default Re: Saving Systems

I would suggest you "MySQL"
Skully82 is offline   Reply With Quote
Old 25/10/2014, 03:17 PM   #10
Big Clucker
papedo's Avatar
Join Date: Oct 2009
Location: Czech Republic
Posts: 162
Reputation: 6
Default Re: Saving Systems

When you use files for saving user stats i recommand load (after login) and save (when disconnect) with manual method of working with files. fopen, fclose, fwrite.. This is the fastest method, i think.

Dini open and close the file with every dini_IntSet operation, that is very slow. You can save about 50ms when you saving user foldes when 10 players are online.

Sql can slow down server and sometimes cause crash. I tried to use MySQL to save user folders but it is very unstable. You can read user data in 100ms but sometimes it takes over 1second.

When you want to use database I recommand SQlite. It is similar to working with files but in this files is database no text. Also you need no MySQL server => you have simple file you work with. Its faster than MySQL, but the files are the fastest method.
papedo is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Saving Systems Ryan_Obeles Scripting Help 14 21/04/2013 05:54 AM
[Tutorial] Optimising saving systems Misiur Tutorials 1 26/02/2013 05:21 PM
using multiple saving systems milanosie Scripting Help 9 18/02/2012 02:18 PM
Vehicle Systems [Plate/Saving Car Mods] X3nZ Scripting Help 0 01/11/2011 11:43 AM
File Systems / Ways of saving data Giovanni Scripting Help 3 13/10/2011 09:12 PM

All times are GMT. The time now is 02:30 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.