4 ms·
PostgreSQL is behind on this particular SQL feature, but MariaDB has it: https://mariadb.com/kb/en/library/temporal-data-tables/ https://mariadb.com/kb/en/libra
by dangoor 7y ago
PostgreSQL is behind on this particular SQL feature, but MariaDB has it: https://mariadb.com/kb/en/library/temporal-data-tables/ https://mariadb.com/kb/en/library/temporal-data-tables/
- haolez 7y agoThat’s a very cool addition! I wonder if this can be used in an event sourcing architecture with minimal overhead.
- refset 7y agoI think to be really useful an event sourcing data store needs `as at` support in addition to `as of` (i.e. bitemporality) to cope with retroactive and proactive events and corrections. There are a couple of references for this in the Crux docs: https://juxt.pro/crux/docs/bitemp.html#_known_uses https://juxt.pro/crux/docs/bitemp.html#_known_uses