Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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"



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-tabl...




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: