MySQL: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 5: | Line 5: | ||
==Versions== | ==Versions== | ||
* | * 5.0.67 (2008-08-09) | ||
* [http://os2ports.smedley.id.au/index.php?page=mysql-5-1 MySQL 5.1.7.2] - Sep 2013 | |||
===Administrative tools and utilities=== | ===Administrative tools and utilities=== | ||
* [[phpMyAdmin]] - Administration over WWW - Requires [[PHP]] - Open source | * [[phpMyAdmin]] - Administration over WWW - Requires [[PHP]] - Open source | ||
* [[REXX/SQL]] - SQL access for [[REXX]] - Open source | * [[REXX/SQL]] - SQL access for [[REXX]] - Open source | ||
===Text editor support=== | ===Text editor support=== | ||
* FTE | * FTE | ||
* [[jEdit]] - Java based editor - MySQL syntax highlighting built in | * [[jEdit]] - Java based editor - MySQL syntax highlighting built in | ||
==License== | ==License== | ||
| Line 28: | Line 26: | ||
* [[Antony T. Curtis]] (Worked on early OS/2 ports and was later a part of the MySQL dev team) | * [[Antony T. Curtis]] (Worked on early OS/2 ports and was later a part of the MySQL dev team) | ||
[[Category:Open Source Software]][[Category: | ==Publications== | ||
* Paul DuBois: ''MySQL Cookbook'' - O'Reilly 2005, ISBN 059652708X | |||
==Links== | |||
* [http://www.mysql.com MySQL homepage] | |||
[[Category:Open Source Software]][[Category:DBMS]][[Category:Software written in C]][[Category:SQL]] | |||
Revision as of 02:14, 23 October 2018
Open source multi-platform SQL compatible, multi user database. Although it lacks strong transaction and data integrity capabilities and despite long standing corruption problems with Unicode and other codepages larger than 256 characters it has become a de-facto standard for database use on the web.
Has been forked by one of the original authors into a product called MariaDB.
Versions
- 5.0.67 (2008-08-09)
- MySQL 5.1.7.2 - Sep 2013
Administrative tools and utilities
- phpMyAdmin - Administration over WWW - Requires PHP - Open source
- REXX/SQL - SQL access for REXX - Open source
Text editor support
- FTE
- jEdit - Java based editor - MySQL syntax highlighting built in
License
- Available in both commercial version and open source version known as the "community edition" that is licensed under the GPL v2.
Alternatives
- Postgresql - Also open source and multi-platform, much stronger transaction and data integrity capabilities.
- SQLite - If your database is primarily for web use and only does limited writing to file, i.e. primarily handles database reads, this can be much faster and takes up considerably less resources. Can be run from a memory based disk if dataset is small.
Authors
- Antony T. Curtis (Worked on early OS/2 ports and was later a part of the MySQL dev team)
Publications
- Paul DuBois: MySQL Cookbook - O'Reilly 2005, ISBN 059652708X