web dev//SQL//SQLite

SQLite is an embedded SQL database engine that needs no separate server: the database is a single file on disk, and the engine is a C library that links directly into the app instead of running as a separate process.

SQLite is an embedded SQL database engine that needs no separate server: the database is a single file on disk, and the engine is a C library that links directly into the app instead of running as a separate process.

It needs zero configuration: no username, no password, no port, no running process, only a .sqlite file.

It suits mobile apps (Android and iOS use it by default), desktop apps, prototypes and low-to-medium volumes.

Its main limitation is a single writer at a time, so there are no concurrent writes.

D1 is SQLite running at the edge: Cloudflare uses it as the engine for its simplicity and lightness, with the same SQL syntax, managed as a service instead of a local file.