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

What is the uplimit of :db/id in datomic

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

@wei whyfor?

@oli using an analytics service that requires SQL

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

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

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

if not, it might be sixth normal form time

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

assuming you don't care about transactions

http://www.anchormodeling.com/