Posts: 253
Threads: 85
Joined: Jan 2011
Reputation:
0
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.
Posts: 2,220
Threads: 154
Joined: Jul 2009
Reputation:
0
Faster than files, accessible from 9/10 existing apps, better summary (depends on the app you use, I sugegst using Navicat)... And going on.
Posts: 977
Threads: 10
Joined: Apr 2011
Reputation:
0
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).
Posts: 21
Threads: 0
Joined: Jun 2011
Reputation:
0
Convenience, easy to build and maintain.
Posts: 2,629
Threads: 40
Joined: Mar 2008
Reputation:
0
Personally, I use it so that I can create a ACP and UCP easier.
Posts: 253
Threads: 85
Joined: Jan 2011
Reputation:
0
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?
Posts: 253
Threads: 85
Joined: Jan 2011
Reputation:
0
Also, this wamp server... Can you host it on the same server where you host your SA-MP server or...?
Posts: 181
Threads: 10
Joined: Nov 2008
Reputation:
0
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?