? | 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 | ? | ? | ? | ? | |||||
X | ? | ? | ? | ||||||
? | ? | ? | ? | ||||||
Replication Support | ? | ? | ? | ? | |||||
License | Apache (BSD) | GPL | BSD | LPGL | |||||
Specifications | ? | ? | ? | ? | |||||
? | X | ? | ? | ||||||
* | ? | ? | ? | ||||||
Relational Database Features | ? | ? | ? | ? | |||||
Sequences/Auto-increment Column | ? | ? | ? | ? | |||||
User Defined Functions | ? | ? | ? | X | |||||
? | ? | ? | ? | ||||||
Referential Integrity | ? | ? | ? | ? | |||||
| ? | ? | ? | ? | |||||
? | ? | ? | ? | ||||||
? | X | ? | ? | ||||||
? | ? | ? | ? | ||||||
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 | ? | ? | ? | ? | |||
? | ? | ? | ? | ||||
Query in FROM Clause | ? | ? | ? | ? | |||
X | ? | ? | ? | ||||
| ? | ? | ? | ? | |||
? | ? | ? | ? | ||||
Union (Distinct/All) | ? | ? | ? | ? | |||
Intersection (Distinct/All) | ? | X | ? | ? | |||
Except (Distinct/All) | ? | X | ? | ? | |||
Full Text Search | ? | ? | ? | X | |||
Java/JDBC | ? | ||||||
? | ? | ? | ? | ||||
J2EE Certified | ? | X | * | ? | |||
? | ? | ? | ? | ||||
X | X | X | X | ||||
? | ? | ? | ? | ||||
? | X | ? | ? | ||||
Database Metadata Imported/Exported Keys/CrossRefs | ? | ? | ? | ? | |||
? | ? | 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 | ? | ? | ? | ? |
X | X | ? | ? | |
Privilege | X | ? | ? | ? |
Encryption | ? | ? | ? | X |
Database Administration Tools | ? | ? | ? | ? |
Tools | IJ Scripting Tool, Cloudview, | WinMySQL Admin, MySQL Administrator, MySQL Query Browser | 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 |