Ingest historical data from some log files into datomic (maybe local) and preserving the transaction time

Datomic Applications
1

In my new team, I notices the support team has to query the past for things that happened and this is achieved by keeping some json log files , where all the modifications (adds, updates and deletions ) are kept as diffs and with the timestamp.

I’d create a new support tool based on datomic (local or pro) and my question is how can I ingest the log files as transactions , keeping the :db/txInstant as the date marked in the log files without getting: :db.error/past-tx-instant Time conflict: Mon Jan 01 01:00:00 CET 2024 is older than database basis.

Thank you

2

I figured why I got the exception when including the :db/txInstant. I created the database and transacted the schema now, then tried to insert data in the past.

So transacting the schema before the first data made it work. Maybe it’s useful for others

1 Like