News for hackers. Stuff that matters.
Re:Recently minted database technologies that I find intriguing by zachmu on Tuesday June 16, 2020 @02:28PM (#23542448)
Dolt actually addresses this need exactly. You can query tables at two different revisions without checking out the two different branches. E.g.:

`SELECT * FROM S AS OF '2fabbg';` `SELECT * FROM W AS OF '4c4490';`

(Branch names work as well as commit hashes for the above).

You can even do joins between the tables as they existed at those revisions:

`SELECT * FROM S AS OF '2fabbg' JOIN W AS OF '4c4490' ON ...`

As long as your data is actually relational, it's a pretty good fit.

There are no comments on this comment yet.