|
|
|
Open Source Database Feature Comparison Matrix
Looking for a database? This handy database feature comparison matrix and glossary let you compare and contrast the supported features of four popular open source databases: Apache Derby 10.1, MySQL 5.0, PostgreSQL 8.1, and One$DB 4.0.
by Uday Parmar |
Joshua D. Drake |
|
|
|
|
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
|
√
|
√
|
√
|
√
|
Triggers
|
Statement / Row Level
|
Before / After
|
Nesting
|
Compound
|
|
√
|
√
|
√
|
√
|
√
|
√
|
√
|
√
|
√
|
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
|
|
|
|
|
|
|