News for hackers. Stuff that matters.

A comment on Databases in 2021: A Year in Review. Parent comment

Re:Databases in 2021: A Year in Review by manigandham on Thursday December 30, 2021 @01:31AM (#29734231)
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.
[ Parent | on HN ]
Re:Databases in 2021: A Year in Review by code_biologist on Thursday December 30, 2021 @06:12AM (#29735732)
How 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.

[ Parent | on HN ]
Re:Databases in 2021: A Year in Review by manigandham on Thursday December 30, 2021 @10:50PM (#29744683)
Most 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

[ Parent | on HN ]