News for hackers. Stuff that matters.
Re:Recently minted database technologies that I find intriguing by bduerst on Monday June 15, 2020 @08:26PM (#23534656)
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"

Re:Recently minted database technologies that I find intriguing by zachmu on Tuesday June 16, 2020 @02:23PM (#23542381)
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...