HSQLDB 和 H2 数据库比较

前面在介绍Vaadin SQL Container时使用了HSQLDB ，也说过SQL Container在使用上并不十分方便，不如直接使用hibernate 来的实用，最近准备开始介绍hibernate 的开发指南，数据库系统也会使用H2 数据系统，和HSQLDB 一样，H2也是纯Java实现，也支持In-memory 模式，对于使用hibernate 的应用来说，可以完全不考虑底层具体使用的是那种数据库，hibernate 框架提供了对物理数据库的抽象。下面表格给出了HSQLDB和H2数据直接的比较。

NOW COMPARING	HSQLDB	H2
RELATED DATABASE MANAGEMENT SYSTEMS: Apache Derby SQLite MySQL Compare all Database Management Systems	SEE DETAILS›	SEE DETAILS›
SPECIFICATIONS
Product	HSQLDB	H2
Company	HSQL Development	H2 Software
Architecture	Relational ​Model	Relational ​Model
Software License	BSD EPL MPL	BSD EPL MPL
Operating System	BSD Linux Mac OS X UNIX Windows z/OS	BSD Linux Mac OS X UNIX Windows z/OS
Demo?
Interface	SQL	SQL
Website	HSQLDB(hsqldb.org)	H2(h2database.com)
First Public Release Year	2001	2005
Lastest Stable Version	2.​2.​6	1.​3.​163
Latest Release Year	2011	2011
PRICE
Price	$​0	$​0
GENERAL FEATURES
Features	ACID Encryption of Data Referential Integrity Transactions Unicode XML Format Support	ACID Encryption of Data Referential Integrity Transactions Unicode XML Format Support
Indexes	Full-text Hash None	Full-text Hash None
Database Capabilities	Blobs and Clobs Common Table Expressions Except Inner Joins Inner Selects Intersect Outer Joins Parallel Query Union Windowing Functions	Blobs and Clobs Common Table Expressions Except Inner Joins Inner Selects Intersect Outer Joins Parallel Query Union Windowing Functions
Partitioning	None	None
Access Control	Brute-force Protection Native Network Encryption Patch Access Resource Limit Run Unprivileged Separation of Duties	Brute-force Protection Native Network Encryption Patch Access Resource Limit Run Unprivileged Separation of Duties
Tables and Views	Temporary Table	Temporary Table
Other Objects	Data Domain External Routine Function Procedure Trigger	Data Domain External Routine Function Procedure Trigger
Support Features	FAQ Forums Mailing List	FAQ Forums Mailing List
PRODUCT DESCRIPTION
Product Description	HSQLDB (HyperSQL DataBase) is the leading SQL relational database engine written in Java. It support...More	H2 is a Java SQL database. The main features of H2 are: Very fast, open source, JDBC API Embedded and server modes; in-memory databases ...More
CONTACT INFORMATION
Contact Link	Contact Link(hsqldb.org)
Email		dbsupport@h2database.com
LIMITS
Max Blob/Clob Size	64 ​TB	64 ​TB
Max CHAR Size	Unlimited	Unlimited
Max Column Name Size	128	Unlimited
Max Columns per Row	Unlimited	Unlimited
Max DATE Value	12/​31/​9999	99999999
Max DB Size	64 ​TB	64 ​TB
Max NUMBER Size	Unlimited	64 ​bits
Max Row Size	Unlimited	Unlimited
Max Table Size	Unlimited	Unlimited
Min DATE Value	0001-​01-​01	-​99999999
DATA TYPES
Type System	Static
Integer	BIGINT (64-bit) INTEGER (32-bit) SMALLINT (16-bit) TINYINT (8-bit)
Floating Point	DOUBLE (64-bit)
Decimal	DECIMAL NUMERIC
String	CHAR CLOB LONGVARCHAR VARCHAR	CHAR CLOB LONGVARCHAR VARCHAR
Binary	BINARY LONGVARBINARY VARBINARY
Date/Time	DATE INTERVAL TIME TIMESTAMP
Boolean	BOOLEAN
Other	ARRAYS BIT BIT VARYING
	More Details	More Details