Embedded database

• Relational
  • SQLite
  • PGLite is a full Postgres database in WASM with reactivity and live sync
    • FTS with pg_search ↗
  • DuckDB ↗ is an in-process SQL OLAP database management system
    • httpfs ↗
  • limbo ↗ is a work-in-progress, in-process OLTP database management system, compatible with SQLite
  • tidb-wasm ↗ is an open-source, MySQL compatible, SQL database
• Multi-model
  • SurrealDB ↗
• Graph
  • KùzuDB ↗ is a highly scalable, extremely fast, easy-to-use embeddable graph database
    • httpfs ↗
    • fts ↗
  • CozoDB ↗ is a transactional, relational-graph-vector database that uses Datalog for query
  • DuckPGQ ↗
• Vector
  • LanceDB ↗ is a serverless vector database for AI application
  • arroy ↗ Arroy (Approximate Rearest Reighbors Oh Yeah) is a Rust library with an interface close of the Annoy Python library to search for vectors in space that are near a targeted vector.
  • PGLite + pgvector ↗
  • SQLite + sqlite-vec ↗
• Key-value
  • RocksDB ↗ is a library that provides an embeddable, persistent key-value store for fast storage
  • Lightning Memory-Mapped Database ↗ With memory-mapped files, LMDB has the read performance of a pure in-memory database while retaining the persistence of standard disk-based databases.
    • lmdb-js ↗ Simple, efficient, ultra-fast, scalable data store wrapper for LMDB
    • heed ↗ Fully typed LMDB wrappers with minimum overhead
  • Log-structured merge trees ↗
• Object
  • PoloDB ↗ is an embedded document database (Rust)
  • lungoDB ↗ is a MongoDB compatible embeddable database and toolkit for Go
  • FerretDB ↗ A truly Open Source MongoDB alternative (maybe, Go)
• Columnar
  • DuckDB ↗ + parquet or arrow or vortex
• other ↗…

Related

• Embedded databases (1): The harmony of DuckDB, KùzuDB and LanceDB ↗

Comparison

	SQLite	PGLite	SurrealDB
browser	+	+	+
┣ HTTPFS	+ 1	- 2	-
┣━ FTS	+ 3 4
┣ OPFS	+	+ 5	- 6
┣ synchronization	+ 7	+ 8 9	? 10
┗ live query		+ 11	+ 12
nodejs	+	+	+
types	basic 13	a lot 14	a lot 15
┗ JSON decode	- 16	+ 17
kysely	+ 18	+ 18	+ 18

Footnotes

1. https://github.com/mmomtchev/sqlite-wasm-http ↗ ↩

2. https://github.com/electric-sql/pglite/pull/364 ↗ ↩

3. https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/#:~:text=SQLite%20FTS ↗ ↩

4. https://github.com/quickwit-oss/tantivy/pull/1067#issue-906458660 ↗ ↩

5. https://pglite.dev/docs/filesystems#opfs-ahp-fs ↗ ↩

6. https://github.com/surrealdb/surrealdb.wasm/issues/59 ↗ ↩

7. SQLite ↩

8. https://pglite.dev/docs/sync ↗ ↩

9. https://github.com/electric-sql/pglite/issues/575 ↗ ↩

10. https://surrealdb.com/features/realtime-data-sync ↗ ↩

11. https://pglite.dev/docs/live-queries ↗ ↩

12. https://surrealdb.com/docs/sdk/javascript/core/streaming#live ↗ ↩

13. https://sqlite.org/datatype3.html ↗ ↩

14. https://www.postgresql.org/docs/current/datatype.html ↗ ↩

15. https://surrealdb.com/docs/surrealql/datamodel ↗ ↩

16. https://kysely-org.github.io/kysely-apidoc/classes/ParseJSONResultsPlugin.html ↗ ↩

17. https://github.com/electric-sql/pglite/blob/2460ee35b9fcf66a39605e7ef435f838bbc88259/packages/pglite/src/types.ts#L108 ↗ ↩

18. https://kysely.dev/docs/dialects ↗ ↩ ↩² ↩³