Hacker News Reader

Full thread

nico

Cool concept.

Does anyone know of something like Datomic but that runs on top of Postgres? ie. Postgres + change history/management.

View on HN

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 :)

I believe datomic does theoretically run on top of Postgres.

Do you mean something with sql query syntax?

The 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.

Reply on news.ycombinator.com