←back to thread

Dolt is Git for Data

(github.com)
334 points gjvc | 2 comments | 23 Jun 22 11:04 UTC | HN request time: 0.423s | source
1. nibab ◴[24 Jun 22 21:30 UTC] No.31869589[source]▶
Git-like functionality on top of existing RDBMS solutions would significantly reduce the overhead of managing ephemeral test environments for us. It would be awesome to see Dolt as a thin layer on top of MSSQL or Postgres that would allow my team to easily test changes before deploying to prod.

Today, this means creating a snapshot of the DB, creating a new DB instance, copying the data over, doing a deploy, testing changes, teardown and cleanup. Branching with copy-on-write (very similar to what neon.tech offers) on top of on-prem instances would be lifechanging for teams operating in legacy dbs.

replies(1): >>31873299 #
2. mildbyte ◴[25 Jun 22 07:28 UTC] No.31873299[source]▶
We might have what you're looking for with sgr [0] (I'm the co-founder) which works by running SQL commands on top of a PostgreSQL instance and uses PostgreSQL audit triggers for versioning, though note it currently only works on top of a custom PostgreSQL Docker image, since it requires some extensions.

[0] https://www.splitgraph.com/docs/sgr-advanced/getting-started...