Datomic is Free

Post by shard_rocker6 » Fri, Apr 28, 2023, 3:46 PM UTC

Post by slay_hearts7 » Fri, Apr 28, 2023, 3:47 PM UTC

Post by peez_weez9 » Fri, Apr 28, 2023, 3:49 PM UTC

Post by heart_stealer1 » Fri, Apr 28, 2023, 3:52 PM UTC

Post by mjul » Fri, Apr 28, 2023, 3:54 PM UTC

wwweston wrote: post #241

bvanderveen wrote: post #236

Earlier quoted context omitted.

We implemented it in Postgres with 'created_at' and 'deleted_at' columns on everything and filtering to make sure that the object 'exists' at the time the query is concerned with. Changes in relationships between objects are modeled as join tables with a boolean indicating whether the relationship is made or broken and at what time. Our data model is not large and we had a very complete test suite already, so it was…

Yeah, it seems you could be able to substitute thoughtful schema design avoiding updates/deletes for time-travel as a feature. I wonder if anyone has made a collection of reference examples implemented this way (and in general think that a substantial compendium good examples of DB schema and thinking behind them could be worthwhile).