3 ms·
Looks great. Are users able to query commits/historical values to a cell inside their SQL query? i.e. "Select population.master, population.branch2, populatio
by bduerst 6y ago
Looks great. Are users able to query commits/historical values to a cell inside their SQL query?
i.e. "Select population.master, population.branch2, population.commit123.diff from state_populations"
- zachmu 6y agoYou 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...