Fork me on GitHub
#datomic
<
2018-05-29
>
chrisblom11:05:49

What are your experiences with storing timeseries in datomic?

dominicm12:05:58

@chrisblom if you have a lot of it, it's not ideal.

chrisblom12:05:36

yeah i’m finding out that its not a great fit, we currently have a database that keeps on growing, with no good way to remove old data

dominicm12:05:18

I think Nubank do something where they create new databases regularly, but that depends on a complex aws setup from what I recall.

chrisblom12:05:57

i’m also looking into the timescale plugin for postgres, but no AWS RDS support yet unfortunately

cjohansen13:05:48

If you’re on AWS, might as well stick timeseries in Dynamo?

matthavener13:05:01

@chrisblom if you want a “sliding window” snapshot of the data, you can store it in kafka or some unindexed store, and then load it into a memory datomic db at fixed intervals

chrisblom13:05:50

thanks, i’ll look into Dynamo