Benefits of MySQL?
#1

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

Faster than files, accessible from 9/10 existing apps, better summary (depends on the app you use, I sugegst using Navicat)... And going on.
Reply
#3

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

Convenience, easy to build and maintain.
Reply
#5

Personally, I use it so that I can create a ACP and UCP easier.
Reply
#6

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

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?
http://gapsworld.com/Documents/PHP%2...eebooks.tk.pdf
Reply
#8

Also, this wamp server... Can you host it on the same server where you host your SA-MP server or...?
Reply
#9

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?
Reply
#10

Yes, thank you.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)