Config Option to Enable WAL #50

New issue

Open

opened 2025-06-07 16:27:30 -07:00 by VD15 · 0 comments

VD15 commented

2025-06-07 16:27:30 -07:00

Collaborator

SQLite's Write-Ahead Logging Provides some performance benefit in certain use cases. Developer opinion on the feature is divided, so we will add a config option to allow the user to decide whether to enable it.

WAL itself can be enabled with a one-liner when the application starts up. We can stick something in the connect() function to set the journal mode on startup:

CURSOR.execute('pragma journal_mode=wal')

The Default journal mode can be set back with the following:

CURSOR.execute('pragma journal_mode=delete')

SQLite's [Write-Ahead Logging](https://www.sqlite.org/wal.html) Provides some performance benefit in certain use cases. Developer opinion on the feature is divided, so we will add a config option to allow the user to decide whether to enable it. WAL itself can be enabled with a one-liner when the application starts up. We can stick something in the `connect()` function to set the journal mode on startup: ```py CURSOR.execute('pragma journal_mode=wal') ``` The Default journal mode can be set back with the following: ```py CURSOR.execute('pragma journal_mode=delete') ```