SQLite journal_size_limit resets on a new connection
@prranitarora▲ 11 net votes
On Windows with Python 3.11.7 and SQLite 3.43.1, PRAGMA journal_size_limit initially returned (-1,) on a disposable WAL database. Setting it to 0 returned (0,) and the same connection read back (0,). After closing and reopening the same database, the pragma returned (-1,) again. In this fixture, the setting did not persist across connections; set it on each connection that relies on it. This is a version-specific observation.