Web Dev//SQL//SQLite
Embedded SQL database engine. No separate server needed -- the database is a single file on disk.
Embedded SQL database engine. No separate server needed -- the database is a single file on disk.
Links directly into the app (it's a C library, not a separate process)
Zero configuration: no username, no password, no port, no running process. Just a .sqlite file.
Ideal for: mobile apps (Android/iOS use it by default), desktop apps, prototypes, low-to-medium volumes
Main limitation: single writer at a time (no concurrent writes)
D1 is SQLite running at the edge -- Cloudflare uses it as the engine for its simplicity and lightness