joplin-notes/joplin notion extension/Web Development/NOSQL/embedded database.md

embedded database

from llm

Yes — there are several SQLite-like databases that:

• ✅ Store everything in a single file
• ✅ Don’t require a central server
• ✅ Can store BSON / document-style data (instead of strict tables)

Here are the best options depending on what you want:

---

1️⃣ LiteDB (Very close to what you described)

• Embedded
• Single .db file
• No server required
• Stores data as BSON documents
• Very similar to MongoDB API
• Great for .NET apps

If you're using C#, this is probably the cleanest choice.

---

2️⃣ MongoDB + Embedded Alternatives

MongoDB itself requires a server, BUT there are embedded variants:

🔹 Realm

• Embedded
• Local file storage
• Document-style
• Good for mobile apps

🔹 NeDB

• Pure JS
• Stores data in a file
• Mongo-like API
• Good for Node.js apps

---

3️⃣ UnQLite

Very interesting option:

• Embedded (like SQLite)
• Single file
• No server
• Key-value + document store
• JSON-like storage
• Written in C

This is probably the closest SQLite-style NoSQL engine.

---

4️⃣ SQLite itself (with JSON)

Even regular SQLite supports:

• JSON columns
• JSON queries
• Single-file database
• Zero configuration

If you just need document-style storage without strict schema, SQLite + JSON might already be enough.

---

🔎 Quick Comparison

DB	File-based	Serverless	BSON/Document	Best For
LiteDB	✅	✅	✅ BSON	.NET apps
UnQLite	✅	✅	✅ JSON-like	C / embedded
NeDB	✅	✅	✅ JSON	Node.js
SQLite	✅	✅	JSON (not BSON)	General use

---

If you tell me:

• What language you’re using
• Desktop / web / mobile?
• Approx data size?

I can give you a more precise recommendation.