News for hackers. Stuff that matters.

A comment on Django SQLite Production Config. Parent comment

Re:Django SQLite Production Config by kissgyorgy on Saturday June 15, 2024 @09:07AM (#40689559)
Isn't journal_size_limit is exactly for this? From the doc:

"Each time a transaction is committed or a WAL file resets, SQLite compares the size of the rollback journal file or WAL file left in the file-system to the size limit set by this pragma and if the journal or WAL file is larger it is truncated to the limit."

[ Parent | on HN ]
Re:Django SQLite Production Config by anze3db on Saturday June 15, 2024 @09:55AM (#40689839)
From what I understand, you still need the experimental WAL2 mode[0] to not have this problem.

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

[ Parent | on HN ]
Re:Django SQLite Production Config by kgeist on Saturday June 15, 2024 @09:58AM (#40689854)
If there's checkpoint starvation, the WAL file cannot be reset, and it will still grow indefinitely even with this setting.
[ Parent | on HN ]