Cool concept.
Does anyone know of something like Datomic but that runs on top of Postgres? ie. Postgres + change history/management.
One of these Postgres-based implementations of SQL:2011's temporal versioning might get you close enough:
- https://github.com/nearform/temporal_tables
- https://github.com/xocolatl/periods
- https://github.com/scalegenius/pg_bitemporal
- https://github.com/arkhipov/temporal_tables
I haven't used any of them but I work on https://xtdb.com which is also implementing SQL:2011's temporal features :)