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

Add sqlite_dbpage extension build tag

Open hifi opened this issue 9 months ago • 2 comments

Provides raw access to database pages. Useful for taking consistent live snapshots of WAL databases without causing write locks by reading out all of the pages and writing them either to a file or some external storage.

The sqlite3_rsync utility that is bundled with sqlite3 source is one way to use it to somewhat efficiently synchronize a remote database.

Fixes #1288

hifi avatar Feb 25 '25 07:02 hifi

Can you write a test?

mattn avatar Apr 01 '25 13:04 mattn

Added a test that makes a full copy of a database using sqlite_dbpage table and checks the copy is consistent and has the expected data.

hifi avatar Apr 09 '25 04:04 hifi