Things that surprised me while running SQLite in production

Re:Things that surprised me while running SQLite in production by simonw on Tuesday July 04, 2023 @07:00AM (#36584990)

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.

[ Parent | on HN ]

Re:Things that surprised me while running SQLite in production by joseferben on Tuesday July 04, 2023 @07:28AM (#36585217)

Thanks for the link.

> 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?

[ Parent | on HN ]

Re:Things that surprised me while running SQLite in production by simonw on Tuesday July 04, 2023 @07:35AM (#36585290)

I've not explored it in any more depth than I wrote about in that article and my issue comments.

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.

[ Parent | on HN ]