3 ms·
You can do historical queries two different ways: 1) `SELECT * FROM state_populations AS OF 'master'` to get the repo as it existed at a particular timestamp /
by zachmu 6y ago
You can do historical queries two different ways:
1) `SELECT * FROM state_populations AS OF 'master'` to get the repo as it existed at a particular timestamp / ref name
2) `SELECT * FROM dolt_diff_state_populations WHERE ...` to examine to/from column value pairs between any two commits you choose.
There are a bunch of different supported system tables that provide interesting functionality: https://www.dolthub.com/docs/reference/sql/#dolt-system-tables https://www.dolthub.com/docs/reference/sql/#dolt-system-tabl...