What is the best way to ”convert”/import a relational database to Datomic?

@teng: There's nothing that can do it automatically for you. You need to understand the schema of the relational database, then recreate equivalent schema in Datomic.

@stuartsierra: Ok, so I create the schema manually, that sounds reasonable. But should I just write a simple ”program” by myself to import the data from my RDBMS to Datomic?

@teng I'm not aware of any other way it could be done.

@stuartsierra: Thanks. It’s a quite straight forward problem that shouldn’t be too hard I think (even if I’m quite new to Clojure). I will start working with Clojure and Datomic in August, after 20 years of Java and relational databases! And by the way, your Pod is great 😉

In my experience, modeling in Datomic is different enough from RDBMS’s that you wouldn’t want an automated tool to do anything for you.

@teng I'm not sure what "Pod" refers to, perhaps you're thinking of someone else?

@stuartsierra: thought you were the man behind Cognicast pod cast.

@teng: No, although I have participated in the Cognicast, I'm not usually involved in producing it. The Cognicast host is Craig Andera

So if you meant “you” as Cognitect in plural, then I will say thank you on their behalf 🙂

! 🙂

@teng: there may be some things worth looking over in the Onyx examples that go from datoms->rows and back, e.g. https://github.com/onyx-platform/onyx-examples/blob/master/datomic-mysql-transfer/src/datomic_mysql_transfer/core.clj

@bkamphaus: This can be helpful. Thanks!