incremental database query for ~stable execution time

https://www.youtube.com/watch?v=Wu-OyLxiP88

#clojure #datomic #sql

Databases: Are We There Yet? - Spasov

YouTube
A Decade on Datomic - Davis Shepherd & Jonathan Indig (Netflix)

YouTube

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/

Super fast aggregations in PostgreSQL 19

This blog talks aggregations in PostgreSQL version 19. Read in, check use cases and learn more about the feature.

CYBERTEC PostgreSQL | Services & Support

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

#Clojure #Datomic #ClojureConj #ClojureConj2025

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

#Clojure

https://blog.danieljanus.pl/2025/04/22/datomic-forking-the-past/

No, really, you can’t branch Datomic from the past

There are hornets in #Datomic that may sting you. Beware!

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?

#clojure

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

XTDB — immutable SQL database for data compliance

XTDB