MySQL: Difference between revisions
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
====Administrative tools and utilities==== | ====Administrative tools and utilities==== | ||
* [[phpMyAdmin]] - Administration over WWW - Requires [[PHP]] - Open source - Current | * [[phpMyAdmin]] - Administration over WWW - Requires [[PHP]] - Open source - Current | ||
* [[REXX/SQL]] - SQL access for [[REXX]] - Open source - Current. | |||
====OS/2 text editors with MySQL support==== | ====OS/2 text editors with MySQL support==== | ||
Revision as of 05:18, 6 March 2016
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
- phpMyAdmin - Administration over WWW - Requires PHP - Open source - Current
- REXX/SQL - SQL access for REXX - Open source - Current.
OS/2 text editors with MySQL support
- jEdit - Java based editor - MySQL syntax highlighting built in - 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.