2 ms·
> Databases with journal_mode=wal cannot be modified via LiteVFS (but can be read) Without modifying SQLite (what the Turso guys did), the WAL index is hard (b
by ncruces 1y ago
> Databases with journal_mode=wal cannot be modified via LiteVFS (but can be read)
Without modifying SQLite (what the Turso guys did), the WAL index is hard (but not impossible) to share across a network boundary. I'm guessing that's the why here. There's a hack that I'm pretty confident works, but I'm not sure how it behaves under latency (sure enough that I use it for Windows, and it hasn't caused issues running mptest thousands of times in CI over months).
Leaving it here, maybe Ben's interested.
https://github.com/ncruces/go-sqlite3/blob/c780ef16e277274e706b8dec36baef655163d3f4/vfs/shm_copy.go#L16-L32 https://github.com/ncruces/go-sqlite3/blob/c780ef16e277274e7...