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


advertisement

 

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

X

Expression Support

Group By

Order By

Union (Distinct/All)

Intersection (Distinct/All)

X

Except (Distinct/All)

X

Full Text Search

X

Java/JDBC




 

JDBC 3.0

J2EE Certified

X

*

Pooled Connections

RowSets

X

X

X

X

SavePoints

Parameter Metadata

X

Database Metadata Imported/Exported Keys/CrossRefs

ResultSet GetAutoGeneratedKeys

X

XA

X

Native Language Support


 

 

 

C/C++

*

X

C#/.Net

*

X

PHP

*

Perl

*

X

Python

*

X

Ruby

*

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