#xtdb — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #xtdb, aggregated by home.social.
-
Has anyone done #bitemporal stuff with postgres 16? I understand SQL:2011 support has landed in postgres 18 but I'm hesitant about upgrading (being very conservative). I'm aware of https://github.com/scalegenius/pg_bitemporal and https://github.com/xocolatl/periods but I'm no database expert and I feel like a baby engineer dipping my toes in. What do y'all recommend?
(I don't want to use #xtdb or #datomic because I know even less about these and I want to be able to maintain what I build)
-
Has anyone done #bitemporal stuff with postgres 16? I understand SQL:2011 support has landed in postgres 18 but I'm hesitant about upgrading (being very conservative). I'm aware of https://github.com/scalegenius/pg_bitemporal and https://github.com/xocolatl/periods but I'm no database expert and I feel like a baby engineer dipping my toes in. What do y'all recommend?
(I don't want to use #xtdb or #datomic because I know even less about these and I want to be able to maintain what I build)
-
My understanding of XTDB (Immutable Databases)
-
Anyone done work with #XTDB? It looks awesome to me, and the few hours I got to spend playing with it last night only made me more convinced. But obviously a huge difference between trying out a DB for fun and having to maintain one in production. So I would love to hear from anyone with experience in the latter. Or in lieu of that, someone else who have used it for fun :)
-
Anyone done work with #XTDB? It looks awesome to me, and the few hours I got to spend playing with it last night only made me more convinced. But obviously a huge difference between trying out a DB for fun and having to maintain one in production. So I would love to hear from anyone with experience in the latter. Or in lieu of that, someone else who have used it for fun :)
-
```clojure
(xt/execute-tx
node
[[:update '{:table :usage
:bind [{:xt/id id} user]
:unify [(from :usage [{:xt/id id} user-id])
(where (nil? user-id))]
:set {:user-id user
:guild-id "98393139101827072"}}]])
```I wanted to copy user->user-id in records that lack a user-id. Am #xtdb ing correctly? Also filling in guild-id with a static value.
Took me a while to get this right!
-
```clojure
(xt/execute-tx
node
[[:update '{:table :usage
:bind [{:xt/id id} user]
:unify [(from :usage [{:xt/id id} user-id])
(where (nil? user-id))]
:set {:user-id user
:guild-id "98393139101827072"}}]])
```I wanted to copy user->user-id in records that lack a user-id. Am #xtdb ing correctly? Also filling in guild-id with a static value.
Took me a while to get this right!
-
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.
-
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.
-
At some point (I missed the memo) #xtdb stopped espousing #datalog and invented #xtql. I'm guessing this was to step out of any annoying dependencies of datalog and dampen comparison with the other major datalog approaches in #Clojure.
https://docs.xtdb.com/intro/what-is-xtql.html I especially enjoy the side-by-side Clojure/JSON comparisons here -
At some point (I missed the memo) #xtdb stopped espousing #datalog and invented #xtql. I'm guessing this was to step out of any annoying dependencies of datalog and dampen comparison with the other major datalog approaches in #Clojure.
https://docs.xtdb.com/intro/what-is-xtql.html I especially enjoy the side-by-side Clojure/JSON comparisons here -
Have you ever heard of a "bitemporal" database? 🤔
This week, I'm talking to James Henderson, lead developer of #XTDB, to explore the world of bitemporality and the life of a #database developer.
Listen: https://pod.link/developer-voices/episode/f191f62237641ea6a53ad8517949154f
Watch: https://youtu.be/3sRKQg9-In8 -
Have you ever heard of a "bitemporal" database? 🤔
This week, I'm talking to James Henderson, lead developer of #XTDB, to explore the world of bitemporality and the life of a #database developer.
Listen: https://pod.link/developer-voices/episode/f191f62237641ea6a53ad8517949154f
Watch: https://youtu.be/3sRKQg9-In8 -
"State of XTDB" by Jon Pither
https://www.youtube.com/watch?v=gQV-XrkJj2oTalk about the current and upcoming evolution of the #XTDB database. The coolest thing about this, to me, is the introduction of the new temporal features and how you're able to query over them. To people who've never used a temporal database before, time travel is mind blowing enough, but what's presented there takes it to a new level. Off the top of my head, I don't have a use case for it, but it sure is interesting.
-
It would be fun to tinker with a full reproducible #guix (or #nixos) system build to run #steamos .
The only variable would be the games as downloaded from the point-in-time when running.
This would provide the user community the benefit of fast, Iterative testing with a parametrized input of software details... Maybe the steam-cli could even non-interactively spin up a game to make sure it bootstraps. Then the game gets a "plus one" from compatibility bot. Or maybe not.
There is a finite number of configuration options stored in #xtdb.
This is how I "do gaming" in my 40s.
-
A great #clojure discussion of #XTDB and others vs standard SQL. https://teddit.net/r/Clojure/comments/yj1oah/open_source_datomic/
-
It's been a while since I saw the @xtdb @xtdb_com front page, but it's looking great now as I did my first bit of workplace evangelism for the #xtdb database https://xtdb.com/ . It has potential for university humanities research projects.
