H2是一个短小精干的嵌入式数据库引擎,主要的特性包括:
几个嵌入式数据库的对比:
H2 | Derby | HSQLDB | Mysql | PostgreSQL | |
---|---|---|---|---|---|
Pure Java | Yes | Yes | Yes | No | No |
Memory Mode | Yes | No | Yes | No | No |
Transaction Isolation | Yes | Yes | No | Yes | Yes |
COSt Based Optimizer | Yes | Yes | No | Yes | Yes |
Encrypted Database | Yes | Yes | No | No | No |
ODBC Driver | Yes | No | No | Yes | Yes |
Fulltext Search | Yes | No | No | Yes | Yes |
Multi Version Concurrency | Yes | No | No | No | Yes |
FoOTPrint (jar/dll size) | ~1 MB | ~2 MB | ~600 KB | ~4 MB | ~6 MB |