Clojurians Log v2
datomic
Hi, I'm trying to pull an entity and pull 1 attribute of it's recursive parents.
'[:node/name, :node/bunch-of-attrs, :node/other-attr, {:node/parent ...}] works, but pulls all attrs every parent. i want to limit that to just name . Any way to achieve that?
Don’t know for sure but try this [,,, {:node/parent [:node/name {:node/parent ...}]}]
That worked! Thanks.
Does anyone know of a good comparison between the various on-prem datomic stores? We're thinking about a new project based on datomic and I was wondering if there exists a discussion of the pros and cons? I think our options would be (1) Postgres (2) Cassandra (3) Some other SQL (4) datomic cloud with the caveat that we're running in google cloud so would require data to cross clouds which may be an issue for dataomic (I can't find an opinion on this either).
Yeah that's the big question with that approach. Although we could potentially host our read clients inside AWS meaning that only the writes would originate in GCP which seems likely to work for our usecase. Not ideal to have to run a service away from our others but we need to weigh that up against running a database. Usually running services is easier than databases!
just to forewarn that datomic cloud is a totally different system to on-prem, you'll architect differently and use completely different libraries
on-prem vs cloud is the big difference. Within on-prem, I think you should just use whatever storage you are most familiar with
datomic on-prem uses storage as a key-value store for smallish (<60kb) binary blobs. I doubt any of the options have a clear advantage
and you’ll run anything serious with memcached or valcache
If you are on Google Cloud you can use their managed PostgreSQL as a backend for Datomic
I can confirm the managed mysql also works fine (with some schema tweaks: https://gist.github.com/favila/ecdcd6c4269ff2bd1bb3)
Thanks all - we do make use of managed postgres at the moment which would make it an obvious choice. Although google does require occasional downtime for updates which is a shame. Sounds like the choice of data store isn't critical then. That's good to know.
That's interesting - I'd not really appreciated that. I've found a good link on on-prem vs cloud. Thanks!
I wouldn't do cross cloud AWS <> GCP without evaluating ingress/egress costs, or latency
Hi there, does datomic cloud have any restrictions regarding AWS regions?
Yes, Datomic Cloud is only available in certain regions the current list is:
2✔️
the hong kong region would be a welcome addition to that list. i have the gut feeling that it supports all the required aws features already.
Thanks
Anyone here is doing serious business with Datomic Cloud without the 24x7 support? The contracted support can be pretty expensive and I notice this is a matter of risk management. We run an application from 9 months and we had problems only when we needed a hands-on help to carry a major migration. It’d be nice to heard about other experiences.
Hi folks — Any tips on how to best approach writing tests for Datomic rules? My app makes extensive use of rules and I would like to button up the testing. Much obliged.
3➕im also just about to explore this topic in our current project. what's your current approach?
My approach has been to use an in-memory database loaded with the right schema and mock data (fixtures) and then run queries against them — but I wonder if there’s a better approach.
I’m also interested in finding a query profiler or explainer, if anyone’s come across any.
How do you architect differently?