Hacker News new | ask | show | jobs
by kweinber 1743 days ago
Automatic versioning of data and CDC (change data capture) broadcast of data deltas to external systems.
2 comments

> Automatic versioning of data

More specifically, I would argue for the ability to run arbitrarily complex, non-locking, fully-consistent queries against all historic versions of the database, a.k.a. "the database as a value" (also "transaction time" or "system time" temporal queries)

Isn't this part of the SQL standard already, to some extent?
Temporal queries have been part of the SQL standard for a while but are mostly not supported by the major databases. Some databases have partial support or extensions that add some temporal capabilities.
CDC is build-in via binlog; it’s the basis of most replication schemes but can be consumed by anything.