Content deleted Content added
one more open source dbms (firebird) |
re-stating criticisms, new link to "MySQL Gotchas" |
||
Line 13:
==Programming Languages==
[[programming language|Programming languages]] which can access MySQL databases include [[C programming language|C]], [[C Plus Plus|C++]], [[Eiffel programming language|Eiffel]], [[Java programming language|Java]], [[Perl]], [[PHP]], [[Python programming language|Python]], and [[Tcl]]; each of these using a specific [[API]]. An [[ODBC]] interface called MyODBC also exists. MySQL uses C as its "native" language.
Early versions of MySQL included few standard DBMS features. This led some database experts, such as [[Christopher J. Date|Chris Date]] and [[Fabian Pascal]], to criticize MySQL, particularly for the lack of transactions, as well as the lack of 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==
Line 57 ⟶ 54:
MySQL 6.0 will contain support for views.
==Criticisms of MySQL==
▲Early versions of MySQL included few standard DBMS features, and the current production version still lacks many properties found in other SQL DBMSes. This has led some database experts, such as [[Christopher J. Date|Chris Date]] and [[Fabian Pascal]], to criticize MySQL
Many of the early criticisms have been remedied in later versions of the software, including the lack of transactions and relational integrity constraints. These are features necessary to support the "[[ACID]] properties" for relational databases, which allow the DBMS to ensure that client applications cannot interfere with one another or insert inconsistent values. [http://www.service-architecture.com/database/articles/acid_properties.html] Other criticisms include MySQL's divergence from the SQL standard on the subject of treatment of NULL values and default values. [http://sql-info.de/mysql/gotchas.html]
Critics find MySQL's popularity surprising in the light of the existence of other open-source database projects with comparable performance and in closer compliance to the SQL standards. MySQL advocates reply that the program serves its purpose for its users, who are willing to accept the program's limitations (which decrease with every major revision) in exchange for speed, simplicity, and rapid development.
==Wikipedia on MySQL==
| |||