H2 HSQLDB Derby

最新推荐文章于 2025-03-31 09:08:13 发布

原创最新推荐文章于 2025-03-31 09:08:13 发布 · 208 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#H2 #HSQLDB #Derby #嵌入式数据库

Database 专栏收录该内容

24 篇文章

订阅专栏

本文对比了H2和HSQLDB两种纯Java数据库的特点及功能，H2支持浏览器控制台应用、加密数据库等功能，并且文件大小仅约1MB；而HSQLDB也有其独特之处，提供了详细的文档供用户参考。

H2 and HSQLDB are different database

H2 official website:[url]http://www.h2database.com/html/main.html[/url]
H2, the Java SQL database. The main features of H2 are:

•Very fast, open source, JDBC API
•Embedded and server modes; in-memory databases
•Browser based Console application
•Small footprint: around 1 MB jar file size

Features
H2 Derby HSQLDB MySQL PostgreSQL
Pure Java Yes Yes Yes No No
Memory Mode Yes Yes Yes No No
Encrypted Database Yes Yes Yes No No
ODBC Driver Yes No No Yes Yes
Fulltext Search Yes No No Yes Yes
Multi Version Concurrency Yes No Yes Yes Yes
Footprint (jar/dll size) ~1 MB ~2 MB ~1 MB ~4 MB ~6 MB

see [url]http://www.h2database.com/html/features.html#comparison[/url]
fore more detail comparision.

HSQL Official website:[url]http://hsqldb.org/[/url]
HSQLDB reference:
[url]http://www.cnblogs.com/fyfblog/archive/2010/12/10/2097149.html[/url]
[url]http://www.blogjava.net/willpower88/archive/2006/11/29/84369.html[/url]
下载了HSQLDB后，hsqldb-2.2.9\hsqldb\doc\guide下有详细文档，doc下还有其它一些帮助文档