Open Source Database Feature Comparison Matrix : Page 2

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 2 of 3

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

DQL

Joins

√

Subqueries

√

Nested Queries

√

Correlated Subqueries

√

Query in FROM Clause

√

Multi-column Predicate

√

Expression Support

Group By

Order By

√

Union (Distinct/All)

√

Intersection (Distinct/All)

√

Except (Distinct/All)

√

Full Text Search

—

√

Java/JDBC

JDBC 3.0

√

J2EE Certified

√

√

√

√

Database Metadata Imported/Exported Keys/CrossRefs

√

ResultSet GetAutoGeneratedKeys

√

Native Language Support

C/C++

√

C#/.Net

√

PHP

√

Perl

√

Python

√

Ruby

√

Key to Symbols

√

Feature supported

Feature not supported

External or Unofficial support

« Previous Page 123 Next Page »

0 Comments (click to add your comment)

Comment and Contribute