I generally try to do that when I use sql, in fact. You can get a good amount of mileage from append-only tables, or failing that, accrete-only records within tables.

@cjhowe you might look into event sourcing. I'd consider it even a bit superior to datomic in terms of tracking exactly what/why things have happened, but not as easy to query ad-hoc.

I actually played around trying to do something like datomic in postgres, but ultimately decided sql not really well suited, especially once you get into queries. Event Sourcing seems a better path for the cases where full history is really important.