3 ms·
Cool concept. Does anyone know of something like Datomic but that runs on top of Postgres? ie. Postgres + change history/management.
by nico 4y ago
Cool concept.
Does anyone know of something like Datomic but that runs on top of Postgres? ie. Postgres + change history/management.
- refset 4y agoOne 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/nearform/temporal_tables - https://github.com/xocolatl/periods https://github.com/xocolatl/periods - https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal - https://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables I haven't used any of them but I work on https://xtdb.com https://xtdb.com which is also implementing SQL:2011's temporal features :)
- nikodotio 4y agoI believe datomic does theoretically run on top of Postgres. Do you mean something with sql query syntax?
- grzm 4y agoThe on-prem version can use PostgreSQL as a backing store, but it’s essentially blob storage of serialized data: the schema in Postgres isn’t the logical representation of the corresponding Datomic schema.