|
? |
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 |
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
