Learn Desktop and Web Programming: Advantages And Disadvantages MySQL

Sabtu, 24 Desember 2011

Advantages And Disadvantages MySQL

indeed there are many applications in addition to the MySQL database management, but why in this book was chosen MySQL as the database management application as a supplement in learning web programming with PHP processing implemented on the database.some of the exact reasons are the following :1. Portability. MySQL can run stable on a variety of operating systems Windows, Linux, FreeBSD, Mac Os X Server, Solaris, Amiga, and many more.
2. Software is open source. MySQL is distributed as open source software, licensed under the GPL so it can be used free of charge
3. Supports Multi-user. MySQL can be used by multiple users at the same time without experiencing any problems or conflicts.
4. Performance Tuning: MySQL has an amazing speed in dealing with simple queries, in other words be able to process more SQL per unit time
5. Various types of dataMySQL has a variety of data types that are very rich, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
6. Commands and Functions MySQL:MySQL has full operators and functions that support the SELECT command in the command where the funds(Query)
7. Is safeMySQL has several layers of security such as the level subnetmask, host name, and access permissions a user with a detailed system permissions and passwords encrypted
8. Scalability and restrictions.MySQL database capable of handling large scale, with a number of records more than 50 million 60 thousand tables as well as 5 billion baris.selain it limits the index that can fit up to 32 indexes on each table.
9. connectivityMySQL DAPT to connect with clients using TCP / IP, Unix socket (unix), or Named Pipes (NT).
10. LocalizationMySQL can detect the error message on the client by using more than twenty languages. however, the Indonesian language has not been included therein.
11. InterfaceMySQL has an interface to a variety of applications and programming languages ​​by using the function API (Application Programming Interface).
12. ToolMySQL comes with a variety of equipment (tools) that can be used for database administration, and any existing equipment pa online manual included.
13. Table structureMySQL has a table structure that is more flexible in handling change, compared to other databases like PostgreSQL or Oracle.
14. Free of chargeis perfect for anyone who wants to learn as well as for the expert level because complex software with a myriad of advantages of this is free.
So much of the information before me, may be useful.



| Free Bussines? |

0 Commented:

Posting Komentar