MYSQL

MySQL is a database software relations (Relational Database Management System or RDBMS), such as Oracle, Postgresql, MS SQL, and so on. MySQL AB product called as the most popular open source database in the world. Based on the research revealed that it many found the Web platform, and suitable to open source too. MySQL is a database of the most widely used. According to the company's developers, MySQL has been installed in about 3 million computers. many of sites rely on MySQL to work day and night to pump the data for its visitors.

MySQL Features

When the series 3:22 MySQL began  adopted a lot of people, then at 3:23 and the 4.0 series is there much improvement in terms of technology. This can not be separated from the demands of an increasingly rely on user MySQLwhich are requires that features more.

At 3:23 MySQL series adds three new table types: first MyISAM, which until now become the default table type; the second BerkeleyDB, which was first added to the MySQL transaction capabilities; and third InnoDB.

In the new series 4.0 this is alpha stage, the developer promised to make MySQL to one degree higher. Features that had always requested will be granted, such as subselek (at 4.1), union (4.0), foreign key constraint (4.0 or 4.1, InnoDB is provided though this in 3.23.x), stored procedures (4.1), view (4.2 ), cursor (4.1 or 4.2), trigger (4.1). MySQL AB develops and remains dedicated to improving MySQL, and MySQL to maintain as the most popular open source database.

Advantages MySQL

The main thing make MySQL so popular among the Web is because it is fit to work in that environment. First, MySQL is available on various Linux platforms and various Unix variants. Something that does not have M. access, for example, when Access is very popular in the Windows platform. Many Unix-based Web server, it automatically makes the Access can not be used because he did not have the ability client-server/networking.

Second, the features MySQL is required in many web applications. For example, SQL LIMIT clause, practically to do paging. Or type fulltext index fields, for full text searching.

Third, MySQL has a low overhead connection. This characteristic makes MySQL suitable to work with CGI applications, which is in every request script will connect, send one or more SQL commands, and then disconnect again. Try doing this with Oracle or Interbase. So the load a few requests per second Web server / database you may soon give up because they can not compensate for this burden.