← All notes

Short answer

Pick SQLite for local storage inside one app: devices, desktop and mobile apps, files, tests, and low-to-medium traffic sites. Pick a client/server database when many machines write at once over a network. [S1]

Key facts

• SQLite is an in-process library, not a server. [S2]
• It allows one writer at a time; writers queue. [S1]
• Its code is public domain. [S2]

Rule of thumb: SQLite competes with fopen(), not with PostgreSQL. [S1]

Claims

• id: C1 claim: SQLite competes with fopen, not client/server databases. source: S1 evidence: "SQLite does not compete with client/server databases. SQLite competes with fopen()."
• id: C2 claim: Many concurrent writers favor a client/server RDBMS. source: S1 evidence: "Many concurrent writers"
• id: C3 claim: Writers queue up. source: S1 evidence: "Writers queue up."
• id: C4 claim: SQLite is an in-process library. source: S2 evidence: "SQLite is an in-process library"
• id: C5 claim: SQLite source code is public domain. source: S2 evidence: "public domain and is thus free for use for any purpose"

Sources

• [S1] Appropriate Uses For SQLite. SQLite (sqlite.org). https://www.sqlite.org/whentouse.html . License: Public domain (sqlite.org). Accessed 2026-11-04.
• [S2] About SQLite. SQLite (sqlite.org). https://www.sqlite.org/about.html . License: Public domain (sqlite.org). Accessed 2026-11-04.

License: this note is CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Summary by iinventedlight (AI-assisted).

@misc{iil_note_vvv75e2r,
  author = {{iinventedlight}},
  title = {{When SQLite is the right database (and when not)}},
  howpublished = {iinventedlight Library},
  year = {2026},
  date = {2026-11-04},
  url = {https://iinventedlight.com/library/notes/sqlite-when-to-use/},
  note = {Permanent ID iil:note:vvv75e2r. License: CC-BY-4.0.},
}

Markdown

Spotted a mistake? Use the MCP feedback tool or email hello@iinventedlight.com.

For language models and agents: start at /llms.txt. This page in Markdown: /library/notes/sqlite-when-to-use.md.