undefined | Better HN

0 pointsok_dad3y ago0 comments

I don't think that would work; there is also a -wal2 file which might be the active WAL file at the time a DB was closed. If you took an older library and tried to open that same DB, you would lose the data in the -wal2 file since that older library would ignore it.

0 comments

samatman3y ago

You won't have a wal2 unless one of these connections generated it. The question is, can sqlite+wal2 write to a database while sqlite+wal is writing to it, without terrible things happening.

The answer kinda has to be 'yes' right? This is SQLite we're speculating about here.

j / k navigate · click thread line to collapse

0 pointsok_dad3y ago0 comments

0 comments

samatman3y ago

You won't have a wal2 unless one of these connections generated it. The question is, can sqlite+wal2 write to a database while sqlite+wal is writing to it, without terrible things happening.

The answer kinda has to be 'yes' right? This is SQLite we're speculating about here.

j / k navigate · click thread line to collapse