Benefits of 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Benefits of MySQL? (/showthread.php?tid=265988)
+- 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Benefits of MySQL? (/showthread.php?tid=265988)
Benefits of MySQL? - Outcast - 03.07.2011
What are the benefits of using MySQL system? Is it really that good or it's just a popular way these days? Just wanna know.
Re: Benefits of MySQL? - Jochemd - 03.07.2011
Faster than files, accessible from 9/10 existing apps, better summary (depends on the app you use, I sugegst using Navicat)... And going on.
Re: Benefits of MySQL? - Bakr - 03.07.2011
No, Jochemd, MySQL is not faster than files, if they're used correctly. That is a huge misconception.
I prefer to use MySQL as it feels more organized for me. However, if I'm just writing a simple script and don't feel like using a plugin, I'll stick with files (or SQLite).
Re: Benefits of MySQL? - Benzodiazepine™ - 03.07.2011
Convenience, easy to build and maintain.
Re: Benefits of MySQL? - [HiC]TheKiller - 03.07.2011
Personally, I use it so that I can create a ACP and UCP easier.
Re: Benefits of MySQL? - Outcast - 03.07.2011
Well, it seems good and all, but I looked at some of the tutorials and it seems a bit complicated for me. Can someone give me a link for a newbie tutorial for MySQL?
Re: Benefits of MySQL? - Benzodiazepine™ - 03.07.2011
Quote:
|
Originally Posted by Outcast
 Well, it seems good and all, but I looked at some of the tutorials and it seems a bit complicated for me. Can someone give me a link for a newbie tutorial for MySQL?
|
Re: Benefits of MySQL? - Outcast - 03.07.2011
Also, this wamp server... Can you host it on the same server where you host your SA-MP server or...?
Re: Benefits of MySQL? - maij - 03.07.2011
Mysql is a RDBMS. (Rational DataBase Management System)
It works on almost all Operation Systems out there.
Because of the structure of the code, most of the database functions are executed fluently and swiftly.
Mysql also uses files to store data, but the data handling is way more efficient that MOST RDBMS's.
Mysql is a variant on SQL, which is known as Sequel or Structured 'English' Query Language.
As the name suggests, it not only manages data using a clear structure, but also gives function to queries.
Functions such as pattern searching are common uses for SQL.
Some of these functions are hard to replicate yourself.
Besides functionality:
The many variants on SQL such as MySQL are widely supported. Plugins, Mods, Addons.
When it comes to SQL it might be one of the most popular softwares out there for RDBMS.
If you still don't get why you would want to use it:
It grants the power of queries which that alone is usually stronger and more efficient than home-made systems.
It is wide-ly supported, so the same database can be accessed anywhere.
It is fairly efficient. Special algorithms and genius coding on some parts allow fast lookup and retrieving, usually within milliseconds, despite the complexity of the query.
On top of that, SQL is considered useful to most programmers. Many programmers use this language for database management. Thus, there is a lot of support available on this.
Was this any help for you?
Re: Benefits of MySQL? - Outcast - 03.07.2011
Yes, thank you.