Skip to content

sqlite: Track WAL size or add support for sqlite3_wal_hook #4012

@FlorianUekermann

Description

@FlorianUekermann

I have found these related issues/pull requests

none

Description

I need to track the WAL size to make sure it doesn't grow indefinitely (only truncated if there are no active readers & writers). Sqlx does not provide a non-unsafe way to do this without triggering a checkpoint.

Prefered solution

It would be very nice if sqlx would track the wal size on it's own by setting sqlite3_wal_hook.
Alternatively a safe wrapper method on LockedSqliteHandle (which has methods for a bunch of hooks already) could be added.

Is this a breaking change? Why or why not?

No, it's just another method.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions