I use the architecture you described as *the* go-to architecture for most of so ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		mkleczek 10 months ago \| parent \| context \| favorite \| on: Turning the database inside-out (2015) I use the architecture you described as the go-to architecture for most of so called "business" applications (with PostgreSQL as dbms though). The missing pieces are: - incremental materialized view maintenance - (bi)temporal primary and foreign keys (upcoming in Pg18) Lately I found out about DBSP and Feldera which looks very promising as it is based on sound theory: https://github.com/feldera/feldera?tab=readme-ov-file#-theor...

dagss 10 months ago [–]

Great link, thanks!

What do you do postgres for consuming old events and smoothly transitioning to consuming new events? Anything like an event ID allocated at commit time that is usable? As I talk about in sibling comment..

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact