Open Source & Freeware DBMS

MySQL

Comparisions with other SQL Servers

  • MySQL Crash-Me Database Comparision Table
    SQL Database Servers: MySQL, Access, Adabas, IBM DB2, Empress, FrontBase, Informix, Microsoft SQL Server, Mimer, mSQL, Oracle, PostgreSQL, Solid, Sybase Enterprise.
    Testes: Crash-Me security test. Suporte a tipos e funções ANSI SQL 92, ODBC 3.0 e outros. Funções em WHERE, Group functions ANSI SQL 92 e Outros, Order By e Group By, Métodos de Join, Tratamento de Strings. Limites de Nomes, Índices, Tipos e Expressões. Suporte a Cometários. Outros recursos e limites.
  • MySQL and PostgreSQL Compared
    Artigo por Tim Perdue, PHPBuilder.com.
  • MySQL Manual: How MySQL Compares to PostgreSQL
  • Why Not MySQL
    Artigo por Ben Adida, Maio 2000.

Programming Interfaces (API) and Drivers for MySQL

  • MySQL Manual - MySQL APIs
  • Connectors - MySQL Drivers
    Connector/ODBC: standardized ODBC database driver for Windows, Linux, Mac OS X, and Unix platforms. Connector/J: standardized JDBC database driver for Java platforms and development.
  • MySQL++
    MySQL++ is a C++ API for MySQL.
  • Perl/DBI modules for MySQL
    DBI is the basic abstraction layer for working with databases in the Perl programming language. DBD::mysql is the driver for connecting to MySQL database servers through DBI. Net::MySQL is a pure-Perl implementation of the MySQL client-server protocol.
    MySQL Perl modules at CPAN.

PostgreSQL

Other Open-Source & Freeware SQL Servers

  • Firebird
    "Relational Database for the New Millennium". Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers good concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981. Firebird is an open-source independent project, based on the InterBase Public License source code released by Inprise/Borland on July 2000, and it is highly compatible with Borland InterBase.
  • HSQL Database Engine (hsqldb)
    hsqldb: Lightweight 100% Java Database Engine. hsqldb Project at SourceForge is a continuation of Thomas Mueller's closed Hypersonic SQL (HSQL) Project. HSQLDB is a relational database engine written in Java, with a JDBC driver, supporting a rich subset of ANSI-92 SQL. It offers a small (about 100k), fast database engine which offers both in memory and disk based tables. HQLDB is Open Source and free to use in any product, commercial or not, so long as the terms of the Licenses are met. The HSQLDB Licence is based on the BSD License, and the license for HypersonicSQL (on which HSQLDB is based) is very similar to the Apache License.
    SourceForge Project: hsqldb.
  • Berkeley DB
    Sleepycat Software builds, distributes, and supports The Berkeley Database (Berkeley DB), Open Source embedded database system. Berkeley DB is a widely-used and well known application-specific data management software. It's fast, scalable and reliable.
  • Apache Derby (open source) & IBM Cloudscape (commercial)
    The Derby project develops open source relational database technology that is: Pure Java, easy to use, small footprint, standards based (ANSI SQL, JDBC), Secure. Java platforms such as OSGi, J2ME, J2SE and J2EE are supported as appropriate. Derby/Cloudscape is fully transactional and it's a purely embedded database that can either be used within an application, or as the database for a more traditional client-server application. There's no need for a database administrator; you just write the application with database calls.
    Why IBM is open sourcing Cloudscape as Derby, by Jon Prial, IBM Vice President, October 2004. Future commercial versions of IBM Cloudscape will be based on the Derby code base.
  • Mini SQL - mSQL by Hughes Technologies