devxlogo

Open Source Database Feature Comparison Matrix

Open Source Database Feature Comparison Matrix

?

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

?

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

?

Apache Derby 10.1

MySQL 5.0

PostgreSQL 8.1

One$DB 4.0

Security

?

?

?

?

Users

?

?

?

?

Role

X

X

?

?

Privilege

X

?

?

?

Encryption

?

?

?

X

Database Administration Tools

?

?

?

?

Tools

IJ Scripting Tool, Cloudview,
Import/Export

WinMySQL Admin, MySQL Administrator, MySQL Query Browser
Command Shell

PgAdmin, psql, phpPgAdmin

Shell, Browser, Shell Server, Browser Server, Server

Hot Backup

?

*

?

X?

Table Spaces

X

?

?

X?

Point in Time recovery

X

*

?

X?

Table partitioning

X

X

?

X?

Graphical Interface

?

?

?

?

Creating Database Objects

*

?

?

??

Manipulate Data in Database Objects

*

?

?

??

Viewing Properties of Various Database Objects

*

?

?

??

Graphical Interface to Execute SQL Queries

*

?

?

??

Support for Executing Multiple Queries Simultaneously

*

?

?

??

?

Key to Symbols

?

Feature supported

X

Feature not supported

*

External or unofficial support

devx-admin

Share the Post: