News for hackers. Stuff that matters.

A comment on Django SQLite Production Config. Parent comment

Re:Django SQLite Production Config by stefanos82 on Saturday June 15, 2024 @07:40AM (#40689129)
I think there's a workaround if I understood the official documentation correctly: https://www.sqlite.org/wal.html#avoiding_excessively_large_w...
[ Parent | on HN ]
Re:Django SQLite Production Config by kgeist on Saturday June 15, 2024 @07:43AM (#40689145)
Yeah, when implementing this hack, I took the advice from this exact page:

>This scenario can be avoided by ensuring that there are "reader gaps": times when no processes are reading from the database and that checkpoints are attempted during those times

I create reader/writer gaps by calling sleep() (before opening transactions) and activate the checkpointer manually in the checkpointer goroutine.

[ Parent | on HN ]