Does the snapshot timestamp contain all rows mutated before that timestamp? #472
-
|
I.e. is there any case where timestamp snapshot is at T1, a mutation in the DB exists at T2, and T2 is NOT in the snapshot even though T2 < T1? |
Beta Was this translation helpful? Give feedback.
Answered by
benbjohnson
Apr 30, 2023
Replies: 1 comment 1 reply
-
|
The snapshots and WAL segments contain all changes up to that point in time that they were copied from the database. SQLite has strict serializability so all mutations are visible immediately and are saved to the next snapshot or WAL segment. |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Awesome, just wanted to make sure the timestamp wasn’t something like upload started or finished. |
Beta Was this translation helpful? Give feedback.
Answer selected by
danthegoodman1
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The snapshots and WAL segments contain all changes up to that point in time that they were copied from the database. SQLite has strict serializability so all mutations are visible immediately and are saved to the next snapshot or WAL segment.