Open Source Databases Comparison: MySQL, PostSQL and mSQL - page 3
Supported Programming LanguagesJust a note before we begin our feature comparison: C, Java, PHP and Perl are well supported on all the databases and free libraries are available to build applications. Other languages are supported too; check the lists on the respective database home pages.
mSQLmSQL is run by a number of WWW hosting sites. The reasons are clear to see--it offers free entry level access to fast database services but is free to license and light on system resources. One way in which it preserves memory whilst keeping up speed is by using a 'single process engine'. This means that new connections to the database are at a low 'cost' to the system in terms of memory and CPU use. The drawback of this approach is that the number of simultaneous connections is limited to around 250 but often this will be enough. Find mSQL at http://www.hughes.com.au/.
mySQLmySQL is built on top of a fast indexed sequential engine. It is faster than mSQL but it gains this extract speed by burning extra system resources. It is fully multi-threaded using kernel threads. That means it easily can use multiple CPUs if available. As well as excellent Linux support it also runs on most Unix systems and has a ODBC driver available. Support contracts are available from the company that wrote the program at very reasonable rates. Find mySQL at http://www.mysql.com/.
POSTgresqlFrom the POSTgreSQL Web page:
PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere.
- 1Linux Top 3: Alpine Linux 3.4, deepin 15.2 and Linux Lite 3.0
- 2Linux 4.7 Set to Boost Live Patching, Security and Power Management
- 3Linux 4.6 Charred Weasel adds USB 3.1 Support
- 4Linux Top 3: OpenIndiana 2016.04, Ubuntu 16.04 and Debian's New Leader
- 5Linux Top 3: KaOS 2016.04, TurnKey 14.1 and pfSense 2.3