Record · corpus.blog/posts/01a08752-090c-73d6-a2a6-ae110fc562bc

Gotchas with SQLite in Production

Anže's Blog · published 17 July 2024

A record is what was published and who pointed at it. The text of the post is not held here: read it at the source, or at its Wayback capture.

Read the post at blog.pecar.me Wayback capture

2blogs citing

First cited: 14 Sept 2024
Most recent: 28 Oct 2025
Rank this month: not ranked
Links from this post: 23
Words captured: 1,662

Cited by

Blog

In the post

Date

pythonbynight.com

Now For Something A Little Different Read at the source ↗

28 Oct 2025

rrees.me

August 2024 month notes Read at the source ↗

14 Sept 2024

Links from this post

Link

Host

https://x.com/dhh/status/1782033353606382011

x.com

https://www.sqlite.org/limits.html

sqlite.org

Django SQLite Production Config Read at the source ↗

blog.pecar.me

https://en.wikipedia.org/wiki/High_availability

en.wikipedia.org

https://youtrack.jetbrains.com/issue/DBE-1436/SQLite-remote-tunneling

youtrack.jetbrains.com

https://github.com/tursodatabase/libsql

github.com

https://rqlite.io/

rqlite.io

https://fly.io/docs/litefs/

fly.io

https://devcenter.heroku.com/articles/sqlite3

devcenter.heroku.com

https://fly.io/

fly.io

https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md

sqlite.org

https://docs.djangoproject.com/en/5.0/ref/databases/

docs.djangoproject.com

https://en.wikipedia.org/wiki/Isolation_(database_systems

en.wikipedia.org

https://www.sqlite.org/cgi/src/doc/begin-concurrent/doc/begin_concurrent.md

sqlite.org

https://youtu.be/0rlATWBNvMw?si=6sg2NGbMw06NnWRF&t=427

youtu.be

Django, SQLite, and the Database Is Locked Error Read at the source ↗

blog.pecar.me

https://litestream.io/

litestream.io

https://dqlite.io/

dqlite.io

https://www.postgresql.org/docs/current/warm-standby.html

postgresql.org

https://alembic.sqlalchemy.org/en/latest/batch.html

alembic.sqlalchemy.org

https://sqlite-utils.datasette.io/

sqlite-utils.datasette.io

https://sqlite-utils.datasette.io/en/stable/python-api.html

sqlite-utils.datasette.io

https://www.youtube.com/watch?v=GTDYwEXv-sE

youtube.com