3 ms·
Implementing AS OF clauses with Git refs (HEAD~) in our open-source database
- zachmu 7y agoThis blog post discusses our implementation of the AS OF clause for our custom open-source SQL database, Dolt! In addition to the usual timestamp semantics, Dolt databases can be queried using git-like refs. Examples: SELECT * FROM myTable AS OF 'HEAD~'; SELECT * FROM myTable AS OF 'HEAD~20'; SELECT * FROM myTable AS OF 'feature-branch'; SELECT * FROM myTable AS OF '4gunscn1j6ijtsj121m7bjaj4j8grjmv'; About Dolt: Dolt is a SQL database with the revision features of git. So you can clone, branch, fork, merge, push and pull databases just like you would git repositories. Ask us anything!