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

Oct 14, 2005

Page 1 of 3

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps

~~Watch~~→

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

General

Database Connections

Multiple

Concurrent Access to Multiple Databases

√

Multi-version Concurrency Control

√

Unicode Support

√

Replication Support

√

License

Apache (BSD)

GPL

BSD

LPGL

Specifications

SQL 99

√

ODBC

√

Relational Database Features

Sequences/Auto-increment Column

√

User Defined Functions

√

Update-capable Views

√

Referential Integrity

√

Triggers

Statement / Row Level

Before / After

Nesting

Compound

√

Domains

√

BLOB

√

CLOB

√

Name Length Limit

128

Delimited Identifiers

√

Stored Procedures

√

Procedural Languages

PL/SQL (or equivalent)

√

Java

√

Python

√

Perl

√

PHP

√

Ruby

Key to Symbols

√

Feature supported

Feature not supported

External or unofficial support

12 3 Next Page »

Author Feedback
Email Article
Print Article
Comment on this Article
- Digg
- del.icio.us
- Newvine
- furl
- BlinkList
- Newsvine
- Magnolia
- Tailrank
- Slashdot
- Technorati
- Google Bookmarks
- Yahoo Favorites
- Windows Live
- Ask

0 Comments (click to add your comment)

Comment and Contribute

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.

WEBINAR:On-Demand

WEBINAR:

On-Demand