Nuno Cruces

I realize my tone in this thread will have come of as unwelcoming and I want to correct that, as I certainly don't want to discourage people from contributing. But...

I applied the above changes to [my version](https://github.com/ncruces/go-sqlite3/blob/litestream/litestream/vfs.go), ~and everything seems to work fine, but it needs more serious testing~. Actually I'm having problems with compactions, after a compaction I...

The current approach seems fundamentally problematic if used to open with a continuously updating snapshot. The `v0.5.0` code tries to update the index in the background, and always reads the...

Expanding a bit on the issue, the retention policy as implemented, is at odds with the VFS in (at least) two ways. `DB.Compact` deletes L0 LTX files as soon as...

@benbjohnson I understand that. My intent was only to help that along, and share my experience, as I've created a few reasonably sophisticated SQLite VFSes. Not complaining/demanding in any way!...

If I could make an additional request, @benbjohnson, it'd be nice if the stuff that the VFS uses didn't use a package that blank imports your SQLite driver. Anyone who...