On: LiteTree: SQLite with Branches

[natmaka]

Is the function similar to PostgreSQL's deprecated "Time Travel" https://www.postgresql.org/docs/6.3/static/c0503.htm ?

AFAIK this can be a foundation for some form of Snapshot Isolation https://www.sqliteconcepts.org/SI_index.html (?)

[kroggen → natmaka]

Well, we can read the database at any point-in-time by selecting the branch and commit number. So it is similar to a snapshot. And yes, it is a type of Snapshot Isolation or MVCC (Multi Version Concurrency Control) but more than that because we can have concurrent readers on different branches.

[_m6bh → kroggen]

How do you find the branch associated with a specific point in time? Didn't see that in the docs.

Also, are there guarantees that no two branches can be created at the exact same point in time?

Thanks for the excellent work! I can actually see some use cases for this in one of my side project. :-)

[kroggen → _m6bh]

I guess I wrote it wrong. The access is made by specifying the branch and desired commit number (integer value). It is not done by a date-time value. Although adding metadata (like date-time) can be supported if required by the users.