whats the advantage of using MySQL?

whats the advantage of using MySQL? - 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: whats the advantage of using MySQL? (/showthread.php?tid=279092)

whats the advantage of using MySQL? - lewismichaelbbc - 25.08.2011

whats the advantage of using MySQL rather than just using a plugin like Dini?

I am trying to decide wether to use a MySQL car system or a Dini version.

Thanks

Re: whats the advantage of using MySQL? - =WoR=G4M3Ov3r - 25.08.2011

Easier, and more features.

Re: whats the advantage of using MySQL? - [MWR]Blood - 25.08.2011

Loading data from files is faster, and in MySQL you need to make strings that use huge amount of cells because of the queries.
It has many advantages, though - such as making live stats signatures, connecting your website to the server, so you can make an user control panel in it, and more.

Re: whats the advantage of using MySQL? - Kingunit - 25.08.2011

It's nice and you can match it with PHP and such. By the way, never use DINI. If you aren't using MySQL use something like Y_INI.

Re: whats the advantage of using MySQL? - =WoR=G4M3Ov3r - 25.08.2011

Quote:

Originally Posted by Kingunit

It's nice and you can match it with PHP and such. By the way, never use DINI. If you aren't using MySQL use something like Y_INI.

Or, ZCMD.

Re: whats the advantage of using MySQL? - Kyle_Olsen - 25.08.2011

Quote:

Originally Posted by G4M3Ov3r

Or, ZCMD.

ZCMD is a way to create commands, Y_INI is a file reading/writing plugin...

Re: whats the advantage of using MySQL? - Kingunit - 25.08.2011

Quote:

Originally Posted by G4M3Ov3r

Or, ZCMD.

...

Quote:

Originally Posted by Kyle_Olsen

ZCMD is a way to create commands, Y_INI is a file reading/writing plugin...

Yes that, we are talking about a reading and writing plugins. Not about strcmp, ZCMD or YCMD. But ok.
I suggest him also to use ZCMD yes, but I think he know that strcmp isn't the best.

Re: whats the advantage of using MySQL? - Kyle_Olsen - 25.08.2011

However, on-topic:

MySQL is faster than file reading and is easier when it comes to storing information.
You can also get and write to the database from PHP, or any program made in any kind of code language that accepts MySQL (which is almost all of them).

Let me give you an example.
3 user rows in MySQL:

Quote:

USERNAME: | AGE: | COUNTRY:
Jake | 20 | USA
Mohammed | 31 | Iraq
Cheng | 23 | China

(just a little cleaner)

However, in file storage, there will be 3 different files looking like this inside:

Quote:

File "Jake.ini":
Username=Jake
Age=20
Country=USA

File "Mohammed.ini":
Username=Mohammed
Age=31
Country=Iraq

File "Cheng.ini":
Username=Cheng
Age=23
Country=China

Re: whats the advantage of using MySQL? - [MWR]Blood - 25.08.2011

Quote:

Originally Posted by Kyle_Olsen

However, on-topic:

MySQL is faster than file reading and is easier when it comes to storing information.

It's not faster, not at all.

Re: whats the advantage of using MySQL? - Tee - 25.08.2011

Also another thing that MySQL does is you can connect your forums to the database. So you can make cool things like, little signatures that display a player's stats (deaths, kills, cash etc). And in my own opinion, it's safer (excluding injections).