Fork me on GitHub
#datomic
<
2019-10-23
>
zachcp13:10:53

Hi datomic users - anyone have any tips on early stage data modelling for Datomic? I’d be interested in blog posts about 1) the early design phase of a project prior to creation or 2) tools to faciliate exploration or schema creation (like the codeq schema https://github.s3.amazonaws.com/downloads/Datomic/codeq/codeq.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Credential=AKIAISTNZFOVBIJMK3TQ%2F20191023%2Fus-east-1%2Fs3%2Faws4_request&amp;X-Amz-Date=20191023T131443Z&amp;X-Amz-Expires=300&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Signature=51d040c7b4a25ac20cb3f81026f005b3b062f211d6fe22db2d1f17bfc54a3d9f)

Alex Miller (Clojure team)13:10:42

we usually use Omnigraffle to make those datomic schema diagrams

Alex Miller (Clojure team)13:10:23

the techniques here though are very similar to classical ER diagrams, with the distinction that Datomic is more flexible than your typical "tables" of ERD (attributes can be common across "entities", ref types refer to other entities directly, not via PK/FK, cardinality, components, etc)

Alex Miller (Clojure team)13:10:48

most of that stuff can just be annotated on the diagram though. from a big picture you're still drawing tables and lines

zachcp14:10:49

Thanks @alexmiller. Do you have any suggestions on how to think about early stage data design - e.g. trade-offs around making your data model “flatter” or not. Or in your experience as you start modeling the data, a natural degree of partitioning begins to emerge.

Alex Miller (Clojure team)14:10:33

in general, I find modeling with Datomic usually lets you be pretty close to a logical ERD and there is no reason not to break things out the way you like. you can think more "table"-like, but also do a mixture of graph-like things (and in my experience most enterprise apps are 85% "table"y and 15% "graph"y - Datomic gives you the best of both worlds)

Alex Miller (Clojure team)14:10:32

it's definitely good to go as far as you can in diagrams before you ever write any code or schemas - changing diagrams is a lot faster :)

schmee20:10:09

just tried to run Datomic Pro 0.9.5981 locally, using client-pro 0.8.28, and I’m running into this issue: https://forum.datomic.com/t/ssl-handshake-error-when-connecting-to-peer-server-locally/1067

schmee20:10:49

not running in Docker, and setting :validate-hostnames false in the client config doesn’t do anything it seems

schmee20:10:43

upgrading client-pro to 0.9.37 fixed the issue