内嵌DB
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) |