MySQL
MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) relational database server. MySQL is free software: it is licensed under the GNU General Public License. It was written and is maintained by the Swedish company MySQL AB, which sells support and service contracts as well as commercially licensed copies of MySQL and employs people all over the world who communicate over the internet. MySQL AB was set up by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius. Despite the widespread pronunciation of SQL being "sequel", the generally accepted pronunciation of MySQL by professionals is "My ess-que-ell", not "My-Sequel".
| Table of contents |
|
2 Programming Languages 3 Early versions 4 The latest production version 5 The development version 6 Future releases 7 Wikipedia on MySQL 8 External links |
Platforms
MySQL is open source and works on many different platforms including AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS X, NetBSD, OpenBSD, /A> Warp, SGI IRIX, Solaris, SunOS, SCO OpenServer, SCO UnixWare, Tru64, Windows 95, 98, NT and 2000.
Programming Languages
MySQL databases can be accessed using the programming languages C, C++, Eiffel, Java, Perl, PHP, Python, and Tcl; for each of these, a specific API is available. An ODBC interface called MyODBC is also available. MySQL's "native" language is C.
Early versions
Early versions of MySQL included few standard DBMS features. This led some database experts, such as Chris Date and Fabian Pascal, to criticize MySQL, particularly for the lack of transactions, as well as enforced integrity constraints, which in other DBMSes allow the database system to ensure that applications cannot insert inconsistent values. [1]
See also: PostgreSQL, Berkeley DBThe latest production version
The latest production version is 4.0. It includes the following features:
It does not include the following features:
The development version
Version 4.1 is the development version, and includes support for the following features:
Future releases
MySQL 5.0 will contain support for the following features:
MySQL 5.1 will contain support for:
MySQL 6.0 will contain support for views.Wikipedia on MySQL
In August 2001, a test version of the Wikipedia software using PHP and MySQL appeared; in January 2002 it was adopted as the new software running Wikipedia. See the MediaWiki page. In May 2003, this code base was upgraded to MySQL version 4.0.12 from the previous version 3.x.
