SQLLite
H2
MySQL Embeded
等
| 比较项目 | SQLite | H2 database engine | MySQL Embedded |
|---|---|---|---|
| Footprint | 350KiB | ~1MB | <2MB |
| 授权协议 | Public domain | Dual: Modified MPL 1.1 / EPL 1.0(commercial friendly) | GPL 2.0 (only commercial friendly if not redistributed) |
| 自容器 | ✔ | ✔ | ✔ |
| 单文件 | ✔ | ✔ | ✖ |
| 无服务器 | ✔ | ✔ | ✖ |
| 服务器模式 | ✖ | ✔ | ✔ |
| 零配置 | ✔ | ✔ | ✔ |
| 事物处理 | ✔ | ✔ | ✔ |
| 索引 | ✔ (B-tree, R-tree, full-text) | ✔ (B-tree, tree, hash, full-text) | ✔ (B-tree, R-tree, hash, full-text) |
| MySQL 兼容性 | ✖ | ✔ (but not 100%) | ✔ |
| 兼容其他数据库 | ✖ | ✔ MySQL, PostgreSQL, Oracle, MSSQL, DB2, HSQLDB and Derby | ✖ |
| 加密 | ✖ | ✔ | ✖ |
| 内存中数据库 | ✔ | ✔ | ✔ (MEMORY storage engine) |