What makes MySQL better than all other saving systems?

What makes MySQL better than all other saving systems? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP (https://sampforum.blast.hk/forumdisplay.php?fid=3)
+--- Forum: General (https://sampforum.blast.hk/forumdisplay.php?fid=13)
+--- Thread: What makes MySQL better than all other saving systems? (/showthread.php?tid=547704)

What makes MySQL better than all other saving systems? - Write - 24.11.2014

Delete

Re: What makes MySQL better than all other saving systems? - Mommy - 24.11.2014

It's a lot faster and easy to use.

Re: What makes MySQL better than all other saving systems? - Write - 24.11.2014

Quote:

Originally Posted by Mommy

It's a lot faster and easy to use.

Yeah, but my question is in what way? how is it faster and easy to use? I don't have a problem with dini's speed at all.

Re: What makes MySQL better than all other saving systems? - Vince - 24.11.2014

Grouping and sorting. It's very easy to write a query that asks "Give me the top 10 players with the most money". I'd like to see that being done with a file based system. You'd have to open every player's file to check their money or keep a separate file for every possible query. If I'd alter the above question to say: "give me the top 10 players with the most money, that have been online in the past week". What would you do then?

Re: What makes MySQL better than all other saving systems? - iZN - 24.11.2014

First of all, MySQL is open-source, the process of the MySQL is done through a third-party plugin (BlueG and maddinat0r's MySQL plugin is one of the most used and famous one). There are different storage engine architecture in MySQL (MyISAM, InnoDB, etc..). MySQL or SQLite would be a great choice over y_ini, or any other saving system. SQL language isn't that hard to learn too, whole internet is having tons of tutorials about it which includes online wiki. MySQL plugin eases up the usage with threaded queries and you can use cache or even ORM-based system for your queries in script. Whilst SQLite is having original native by SA-MP Team which does the job good too, you can use SQLite with Slice's SQLitei include which will help you in improving your way of using SQLite in PAWN.

Dini is REALLY an outdated saving system, it was made in the late 2008 by Dracoblue and it was one of the famous PAWN-written system. I've used dini personally in the mid 2009 but later switched to MySQL due to performance and stability. If you're still planning to use PAWN-written system then you should definitely go for y_ini (which is available in YSI library by ******)

Re: What makes MySQL better than all other saving systems? - kristo - 24.11.2014

Quote:

Originally Posted by Turn

Hey folks!
I have used dini for over a decade

This says everything.

Re: What makes MySQL better than all other saving systems? - Write - 24.11.2014

@Gamer_Z Thanks for the explanation!

@Vince Good thinking there, I understand.

AW: Re: What makes MySQL better than all other saving systems? - Mellnik - 24.11.2014

Quote:

Originally Posted by Turn

@Gamer_Z Thanks for the explanation!

@Vince Good thinking there, I understand.

@IZN && kvann Dini may be outdated but it is still a great saving system, there has never been a problem for me.

How can you still say that it's a good saving system after reading Vince's reply.

Re: AW: Re: What makes MySQL better than all other saving systems? - Write - 24.11.2014

Quote:

Originally Posted by Mellnik

How can you still say that it's a good saving system after reading Vince's reply.

It's not like i'm going to create a system that even resembels to what Vince described, why would I need a top ten rich list in a roleplay server?

I got my answer, please don't reply no more.

Thanks!