2 ms·
This is so cool! I have been looking around for databases that have any sort of cryptographic digest of data to ensure integrity. And this is the first time I
by philips 6y ago
This is so cool!
I have been looking around for databases that have any sort of cryptographic digest of data to ensure integrity. And this is the first time I have seen something do that.
Could the snapshots and content addressability be used for regular backups of application databases?
- mildbyte 6y agoThanks, glad you like it! Theoretically, yes, you can use Splitgraph as a PostgreSQL replication client and then occasionally run a commit to produce a new delta. But we're currently focused on the OLAP use case and so Splitgraph images don't yet support storing things like indexes, views, triggers, stored procedures etc.
- philips 6y agoVia their (very good FAQ) Writing to PostgreSQL tables that are change-tracked by Splitgraph is almost 2x slower than writing to untracked tables (Splitgraph uses audit triggers to record changes rather than diffing the table at commit time).