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
WEBINAR:On-Demand
Building the Right Environment to Support AI, Machine Learning and Deep Learning
Apache Derby 10.1
This widget requires JavaScript to run. Visit Site for more ...
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.
