4 ms·
Automatic versioning of data and CDC (change data capture) broadcast of data deltas to external systems.
by kweinber 5y ago
Automatic versioning of data and CDC (change data capture) broadcast of data deltas to external systems.
- reilly3000 5y agoCDC is build-in via binlog; it’s the basis of most replication schemes but can be consumed by anything.
- refset 5y ago> 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)
- sam_lowry_ 5y agoIsn't this part of the SQL standard already, to some extent?
- sterlinm 5y agoTemporal 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.