3 ms·
I've never seen a business actually use them, large or small. Any auditing requirements are usually fed from other sources, like Kafka event streams, files on S
by manigandham 5y ago
I've never seen a business actually use them, large or small. Any auditing requirements are usually fed from other sources, like Kafka event streams, files on S3, or a OLAP data warehouse.
- code_biologist 5y agoHow do you set up and feed the warehouse? Temporal-ish tables have been an obvious, simple, and mostly foolproof solution for many of our historical analytics and reporting needs. Bitemporal stuff (enabling edited versions of history) is where things get hairy and I definitely question the utility outside of a dedicated use case.
- manigandham 5y agoMost databases have built-in CDC (change data capture) that can be exported. Otherwise the WAL logs can be read with other tooling. Debezium is a great open-source product for streaming changes from many relational databases: https://debezium.io https://debezium.io