SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 10/05/2013, 06:16 PM   #1
Nostrum
Big Clucker
 
Join Date: Apr 2013
Posts: 59
Reputation: -2
Default dINI vs MySql

Hello, i could someone explain me the difference from having dINI and MySql?
Does it increase the performance of the server if you store your information in .ini files rather than in databases?
Nostrum is offline   Reply With Quote
Old 10/05/2013, 06:18 PM   #2
Blackazur
High-roller
 
Join Date: Apr 2012
Posts: 1,407
Reputation: 12
Default AW: dINI vs MySql

I would recommend MYSQL cause its more ressourcefree and more better.
Blackazur is offline   Reply With Quote
Old 10/05/2013, 06:19 PM   #3
Nostrum
Big Clucker
 
Join Date: Apr 2013
Posts: 59
Reputation: -2
Default Re: AW: dINI vs MySql

Quote:
Originally Posted by Blackazur View Post
I would recommend MYSQL cause its more ressourcefree and more better.
ressourcefree? I didnt understand.. mind explaining in more detail?
Nostrum is offline   Reply With Quote
Old 10/05/2013, 06:30 PM   #4
BigGroter
Huge Clucker
 
Join Date: Jun 2009
Posts: 289
Reputation: 13
Default Re: dINI vs MySql

MySQL is better than y_ini.
y_ini is better than dINI.
I find it easier to use MySQL to create dynamic systems, it's also faster.
I'd definitely go with MySQL if I were you, unless you're new to PAWN.
BigGroter is offline   Reply With Quote
Old 10/05/2013, 06:30 PM   #5
MP2
Godfather
 
MP2's Avatar
 
Join Date: Jan 2011
Location: England
Posts: 6,235
Reputation: 1004
Default Re: dINI vs MySql

mySQL has a lot more features. If you want to save simple stuff, sure use files, but use a good parser/writes such as y_ini, not dini..
__________________
Owner and developer of Mike's Cops and Robbers.

Click here to visit our site and find out more. Click here to view trailers.
Enter referral code SAMPFORUM after registering for a $5000 starting bonus!
MP2 is offline   Reply With Quote
Old 10/05/2013, 06:31 PM   #6
3ventic
Huge Clucker
 
3ventic's Avatar
 
Join Date: Jun 2009
Location: Finland
Posts: 317
Reputation: 70
Default Re: dINI vs MySql

For a small server, ini files are probably the better way to go. If you have a website that would take advantage of the saves being in MySQL, then go for MySQL. Using ini files will be faster if you're not running anything big.
__________________
Follow me on *******
3ventic is offline   Reply With Quote
Old 10/05/2013, 06:38 PM   #7
Goldilox
Huge Clucker
 
Join Date: Mar 2012
Posts: 265
Reputation: 8
Default Re: dINI vs MySql

Well, the actual difference between those two is, Dini saves the accounts in scripfiles whereas in MySQL everything is online. The most important advantage of MySQL is that you can create UCP for the server as fetching the data dynamically from MySQL is easy. No load on scriptfiles as everything is online. You can edit a user data from anywhere, no need to be in the script folder. There is a lot more you can do with the users in MySQL.

The other thing I like of MySQL server is that you can make a system that allows you to register from the fourm/website, no need to go in game for registering. So MySQL is the best!
__________________


SERVER IP: 198.245.61.167:7779
SERVER WEBSITE: TwD Role-Play

Goldilox is offline   Reply With Quote
Old 10/05/2013, 06:45 PM   #8
Vince
Spam Machine
 
Vince's Avatar
 
Join Date: Sep 2007
Location: Belgium
Posts: 10,068
Reputation: 2658
Default Re: dINI vs MySql

They're two different approaches of saving data. But let me tell you one thing: Dini is outdated and terribly inefficient. I think it's been around since 0.1b and it hasn't changed ever since. Try SQLite.
__________________
Vince is offline   Reply With Quote
Old 10/05/2013, 07:24 PM   #9
Jay_Dixon
Huge Clucker
 
Jay_Dixon's Avatar
 
Join Date: Aug 2012
Posts: 248
Reputation: 17
Default Re: dINI vs MySql

Quote:
Originally Posted by Nostrum View Post
Hello, i could someone explain me the difference from having dINI and MySql?
Does it increase the performance of the server if you store your information in .ini files rather than in databases?
Everything these guys said ^^

If anything, go with MySQL, imo it's alot more user friendly. Only thing wrong with it is it's a bitch to script, but once you have it set up, your perfect to go.
__________________


Jay_Dixon is offline   Reply With Quote
Old 10/05/2013, 08:08 PM   #10
CreativityLacker
Big Clucker
 
CreativityLacker's Avatar
 
Join Date: Oct 2012
Location: The chocolate factory
Posts: 134
Reputation: 25
Default Re: dINI vs MySql

I really don't understand why people only talk about MySQL?
MySQL is NOT SOMETHING that a beginner file-writer should start with!

You don't even NEED MySQL for SA-MP, I find it way stupid that people prefer MySQL over EVERYTHING.

MySQL is a database system made for HEAVY business management. And trust me, I only see supermarket's or huge corporate companies using MySQL for data storage.

Reasons why I hate MySQL -
Complex
Hard to set up
Takes up too much space (You need to install some database manager like XAMP or WAMP before you can start using MySQL)


Then what to use? SQLite is the answer.

SQLite is INBUILT in SA-MP, and is MUCH easier to manage.

No plugin, no password or etc. Just PLUG-N-PLAY!

You just need a 6MB SQLite database manager which can be downloaded from anywhere.

Why SQLite?
Easier to set up
Does not consume much space
Easier to manage
Probably one of the FASTEST system's out there (MySQL and SQLite run closely same, except I prefer to believe that SQLite is faster as it doesn't require plugins, and doesn't use stuff like WAMP or XAMP, and the language is much easier to manage, even though it doesn't offer the same features)
Less features, mainly aimed at what we're really going to be using (MySQL has stuff you'll NEVER EVER need if you're going to be creating simple gamemode's)
Easier to debug and fix (I've had problems mainly setting up the database itself, so I never actually properly used MySQL)


MySQL - something I'd prefer for bad-ass management with heavy protection and etc.
SQLite - something for general SA-MP coding or game coding.

You're not going to be managing millions/billions of user accounts at the same time. SA-MP has a number of maximum slots as 1000 (500 in other cases), so why use MySQL?



And just in case you want simpler file systems, go for Y_INI or SII, since you're not going to be around with it so long, efficiency doesn't matter as long as you don't plan to stick to that shit.
__________________
Scripter at Resurrection
91.121.153.202:7778 or resur.cod5samp.com:7778
CreativityLacker is offline   Reply With Quote
Reply

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
DINI to MYSQL TGameR Scripting Help 2 08/04/2013 09:13 PM
DINI to MYSQL UnknownGamer Scripting Help 3 04/12/2012 05:24 PM
Dini To Mysql Rokzlive Help Archive 4 30/12/2010 06:59 AM
Some kinda dini for MYSQL? DRIFT_HUNTER Help Archive 0 12/12/2010 09:44 AM
Dini to MySQL. RealLifeRP Help Archive 3 03/08/2010 01:05 PM


All times are GMT. The time now is 06:24 PM.


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