Open Source Database Feature Comparison Matrix

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

General

Database Connections

Multiple

Multiple

Multiple

Multiple

Concurrent Access to Multiple Databases

√

√

√

√

Multi-version Concurrency Control

X

√

√

√

Unicode Support

√

√

√

√

Replication Support

√

√

√

√

License

Apache (BSD)

GPL

BSD

LPGL

Specifications

SQL 99

√

X

√

√

ODBC

*

√

√

√

Relational Database Features

Sequences/Auto-increment Column

√

√

√

√

User Defined Functions

√

√

√

X

Update-capable Views

√

√

√

√

Referential Integrity

√

√

√

√

√

√

√

√

√

√

√

√

√

X

√

√

√

√

√

√

Domains

X

X

√

√

BLOB

√

√

√

√

CLOB

√

√

√

√

Name Length Limit

128

64

64

128

Delimited Identifiers

√

√

√

√

Stored Procedures

√

√

√

√

Procedural Languages

PL/SQL (or equivalent)

X

√

√

√

Java

√

X

*

X

Python

X

X

√

X

Perl

X

X

√

X

PHP

X

X

√

X

Ruby

X

X

*

X

R

X

X

*

X

Key to Symbols

√

Feature supported

X

Feature not supported

*

External or unofficial support