whats the advantage of using MySQL?
#1

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

Easier, and more features.
Reply
#3

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

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

Quote:
Originally Posted by Kingunit
View Post
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.
Reply
#6

Quote:
Originally Posted by G4M3Ov3r
View Post
Or, ZCMD.
ZCMD is a way to create commands, Y_INI is a file reading/writing plugin...
Reply
#7

Quote:
Originally Posted by G4M3Ov3r
View Post
Or, ZCMD.
...
Quote:
Originally Posted by Kyle_Olsen
View Post
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.
Reply
#8

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

Reply
#9

Quote:
Originally Posted by Kyle_Olsen
View Post
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.
Reply
#10

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


Forum Jump:


Users browsing this thread: 2 Guest(s)