Embedded & local-first data

What if the database lives inside the product?

Study in-process storage, offline operation, sync, conflict resolution, portability, and zero-operations analytics.

Systems compared

• SQLite
• DuckDB
• Realm
• PGlite

Open the engine

1. In-process execution
2. File formats
3. Offline-first writes
4. Sync and conflicts
5. Extension and embedding models

Reconstruction lab

Create an offline-capable application and explain what must happen when two devices reconnect.