Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

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.


advertisement

 

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



Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap