Clojurians
#datomic
<
2016-03-19
>

This page is not created by, affiliated with, or supported by Slack Technologies, Inc.

wei01:03:45

does anyone have experience exporting datoms into a SQL db or other SQL-queryable format?

isaac04:03:37

What is the uplimit of :db/id in datomic

isaac04:03:57

I found the bigest integer in js is 2^53 - 1

oli05:03:31

@wei whyfor?

wei05:03:30

@oli using an analytics service that requires SQL

oli05:03:45

well there goes my initial thesis (what query do you want to express in sql that can't be expressed in datalog)

oli05:03:48

without knowing the shape of your data it's hard to answer (e.g. are all attributes grouped in a common namespace for a given entity?)

oli05:03:01

if so, you might be able to get away with creating a table for each namespace with columns mapped to the attributes, inserting nulls for missing attributes

oli05:03:39

if not, it might be sixth normal form time

oli05:03:36

that is, creating a [k v] table for each attribute with the v column type mapped to the datomic schema type of the attribute

oli05:03:15

assuming you don't care about transactions