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 Joshua D. Drake
Uday Parmar
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
Please enable Javascript in your browser, before you post the comment! Now Javascript is disabled.
Digg
del.icio.us
Newvine
furl
StumbleUpon
BlinkList
Newsvine
Magnolia
Facebook
Tailrank
Slashdot
Technorati
Google Bookmarks
Yahoo Favorites
Windows Live
Ask
Reddit
Google
Linkedin
Twitter
