Database Comparison Table : H2, HSQLDB, DERBY, PostgreSQL, MySQL

The following table describes the comparison between several open source databases. The comparison will cover: HSQLDB, H2, PostgresSQL, MySQL, Derby in terms of their limitations and strength. This analysis could help to select database for our next project.

DB Comparison: H2, HSQLDB, DERBY, PostgreSQL, MySQL

  H2 HSQLDB DERBY PostgreSQL MySQL
ACID no(ACI) no yes yes yes
referential integrity yes yes yes yes yes
transactions yes yes yes yes yes
unicode yes yes yes yes partial
interface SQL SQL SQL SQL SQL
data size DB Limit 256 GB 8 GB unlimited unlimited unlimited
temporary table yes yes yes yes yes
materialized view no no no no no
indexes (R-/R+ tree) no no no yes MyISAM tables only
union yes yes yes yes yes
intersect       yes no
except       yes no
inner joins yes yes yes yes yes
outer joins yes yes yes yes yes
blobs and clobs yes   yes yes yes
data domain yes   no yes no
cursor no no yes yes yes
trigger yes yes yes yes yes
function yes yes yes yes yes
procedure yes yes yes yes yes
external routine yes yes yes yes yes
maintainer H2 Software HSQL Development Group Apache PostgreSQL Global Development Group Sun Microsystems
latest stable version 1.1.107 1.8.0 10.4.2.0 8.3.6 5.1.32
software license EPL and modified MPL BSD Apache License BSD GPL or proprietary
OS support Windows yes yes yes yes yes
OS support MAC OS X yes yes yes yes yes
OS support Linux yes yes yes yes yes
OS support BSD yes yes yes yes yes
OS support UNIX yes yes yes yes yes
OS support Symbian no no no yes yes
webaddress www.h2database.com www.hsqldb.org www.db.apache.org/derby www.postgresql.org www.mysql.com

Share


One Response to “Database Comparison Table : H2, HSQLDB, DERBY, PostgreSQL, MySQL”

  1. james says:

    good

Leave a Reply