Fork me on GitHub
#datomic
<
2016-07-20
>
tengstrand17:07:05

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

stuartsierra17:07:55

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

tengstrand17:07:13

@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?

stuartsierra17:07:10

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

tengstrand18:07:29

@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 😉

jgdavey18:07:33

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.

stuartsierra18:07:00

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

tengstrand18:07:25

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

stuartsierra18:07:20

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

stuartsierra18:07:02

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

bkamphaus19:07:35

@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

tengstrand19:07:09

@bkamphaus: This can be helpful. Thanks!