Skip to content

Add missing WAL pragma support (wal_autocheckpoint, wal_checkpoint) #1397

@kju2

Description

@kju2

The following WAL-related pragmas are not yet exposed through SQLiteConfig:

  • wal_autocheckpoint — configures the automatic checkpoint threshold (number of WAL pages)
  • wal_checkpoint — triggers a manual checkpoint with a configurable mode (PASSIVE, FULL, RESTART, TRUNCATE, NOOP)

I need to disable automatic WAL checkpointing (wal_autocheckpoint=0) in my application because Litestream is managing the checkpointing.

There is currently no way to configure this through SQLiteConfig. I have a workaround, but setting it through SQLiteConfig would be nicer.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancement:SQLiteEnhancement about sqlite featuresreleasedIssue has been released

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions