MySQL: Difference between revisions

Revision as of 17:28, 14 October 2003

Revision as of 23:12, 17 October 2003

Line 8:

'''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|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".

=== Platforms ===

MySQL is open source and works on many different platforms including [[AIX operating system|AIX]], [[BSDi]], [[FreeBSD]], [[HP-UX]], [[Linux]], [[Mac OS X]], [[NetBSD]], [[OpenBSD]], [[OS/2]] Warp, [[SGI]] [[IRIX]], [[Solaris Operating Environment|Solaris]], [[SunOS]], SCO OpenServer, SCO UnixWare, [[Tru64]], [[Microsoft Windows|Windows]] 95, 98, NT and 2000.

=== Programming Languages ===

MySQL databases can be accessed using the [[programming language|programming languages]] [[C programming language|C]], [[C Plus Plus|C++]], [[Eiffel programming language|Eiffel]], [[Java programming language|Java]], [[Perl]], [[PHP]], [[Python programming language|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. (transactions, stored procedures), andThis leadled some database experts, includingsuch as [[Christopher J. Date|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. [http://www.dbdebunk.com/]

=== The latest production version ===

The latest production version is 4.0. It includes the following features:

* A broad subset of ANSI SQL 99, as well as extensions.

Line 34:

* Stored procedures

=== The development version ===

Version 4.1 is the development version, and includes support for the following features:

* Sub-SELECTS

Line 42:

* Multi-line queries

=== Future releases ===

MySQL 5.0 will contain support for the following features:

* Stored procedures

Line 58:

MySQL 6.0 will contain support for views.

=== Wikipedia on MySQL ===

In [[August 2001]], a test version of the [[Wikipedia]] software using [[PHP programming language|PHP]] and MySQL appeared; in January 2002 it was adopted as the new software running Wikipedia. See the [[wikipediaWikipedia:PHP scriptMediaWiki|Wikipedia PHP scriptMediaWiki]] page. In May 2003, this code base was [[m:Upgrade to MySQL 4.0|upgraded to MySQL version 4.0.12]] from the previous version 3.x.

See also: [[PostgreSQL]], [[Berkeley DB]]