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
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.
