I wrote this about WAL mode with Django and SQLite last year: https://simonwillison.net/2022/Oct/23/datasette-gunicorn/
Your configuration looks right to me.
Your configuration looks right to me.
> I asked Django Fellow Carlton Gibson what it would take to update that advice for 2022.
Glad to see that SQLite is being presented as a valid option in the current version of the docs.
> Even without WAL mode, bumping the SQLite “timeout” option up to 20s solved most of the errors.
Can you say anything about the tradeoffs when increasing the timeout, maybe in the context of Django?
My hunch is that if you bump it up to 20s while receiving a huge amount of concurrent traffic you may find yourself running out of available Python workers to serve requests.