incremental database query for ~stable execution time

incremental database query for ~stable execution time


Even though I mostly use #Datalog databases these days (mostly #Datomic), many #PostgreSQL tidbits make me (unreasonably?) happy. Like this one: “Aggregate first - join later”
https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/
Awesome to hear Davis Shepherd and Jonathan Indig from Netflix talk about how stable the Clojure / Datomic ecosystem has been over the past 10 years, especially in comparison to the number of breaking changes that other open-source infrastructure projects have gone through in the same amount of time.
The talk is called ”A Decade on Datomic” for when videos are published
Today's Google "AI overview" hallucination: "#Datomic between".
No, there is no `:between` operator in Datomic. As a Google user, I need to waste time figuring out that this is a hallucination, and then scroll down to results that actually make sense.
I'm increasingly fed up. I guess I'll just bite the bullet and switch to Kagi.
New blog post! „No, really, you can’t branch #Datomic from the past (and what you can do instead)”
https://blog.danieljanus.pl/2025/04/22/datomic-forking-the-past/
Is it possible to make a re-frame #localfirst app, syncing #datomic on the back-end and #datascript on the front-end? How would you do that?
Me finally deciding I should try #datomic, going all the way through helloworld only to realize that the "datomic local" flavor doesn’t do stored functions.
(╯°□°)╯︵ ┻━┻
So to even try those I'd have to spin up a local postgres, deploy datomic transactor, and figure the pg schema.
#xtdb looks like fun again.
I was sick for the last ~ 10 days. Done almost nothing. 🤒 Feeling kinda recovered today. 🙏 ☀️
But had some shorts moments of clarity to play with #xtdb (#clojure) https://xtdb.com
I saw it ~ year ago when it was v1. Then they've released v2 with some breaking changes.
Summary: cool idea, but still raw as f.
The last drop for me was: they have an option to add metadata to the transaction but it's hidden from the public api and the PR is there for ~ 2 years
Switching to #datomic