sqlite3-ruby icon indicating copy to clipboard operation
sqlite3-ruby copied to clipboard

Allow manual checkpointing

Open northeastprince opened this issue 2 years ago • 2 comments

It'd be nice if there was a way to manually checkpoint the WAL file if you need everything in one file at a certain moment.

northeastprince avatar Feb 03 '24 01:02 northeastprince

@northeastprince Thanks for asking about this. Can you share a bit more information about your use case? Adding a wrapper for sqlite3_wal_checkpoint_v2() wouldn't be hard, but I do want to know what it's being used before committing to adding it to the gem.

flavorjones avatar Nov 19 '24 22:11 flavorjones

You may be able to use the pragma for this: https://www.sqlite.org/pragma.html#pragma_wal_checkpoint

flavorjones avatar Nov 20 '24 15:11 flavorjones