MySQL: Difference between revisions
mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
[[Image:Mysql.jpg|250px|right]] | [[Image:Mysql.jpg|250px|right]] | ||
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. | 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. | ||
| Line 7: | Line 6: | ||
==Versions== | ==Versions== | ||
* Latest OS/2 version: [http://os2ports.smedley.id.au/index.php?page=mysql-5-1 MySQL 5.1.7.2] - Sept 2013 | * Latest OS/2 version: [http://os2ports.smedley.id.au/index.php?page=mysql-5-1 MySQL 5.1.7.2] - Sept 2013 | ||
====Administrative tools and utilities==== | |||
==PHP Based programs== | |||
* [[phpMyAdmin]] - Administration over WWW - Requires [[PHP]] - Open source - Current | |||
==Links== | ==Links== | ||
* [http://www.mysql.com MySQL homepage] | * [http://www.mysql.com MySQL homepage] | ||
Revision as of 21:25, 21 June 2015
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
- Latest OS/2 version: MySQL 5.1.7.2 - Sept 2013
Administrative tools and utilities
PHP Based programs
- phpMyAdmin - Administration over WWW - Requires PHP - Open source - Current
Links
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.