This one was a really enjoyable chat - jOOQ is an impressive project that has been delivering typesafe & SQL-centric database goodness for far longer than most developers have cared about such things. Good ideas stand the tests of time 🏆

⭐ New talk! andymatuschak.org/tat Coding agents might help us finally break out of two cages: the app model, which traps computing in one-size-fits-all silos; and programming as a specialization, which has crowded out cultures of imagination and domain insight.

Software is not soft. It arrives rigid, opaque, and brittle. The most malleable medium we have produced is, in practice, among the least malleable materials we encounter in daily life.

The theme of @CMUDB's ongoing Future Data Systems seminar series is "what should a database system look like in the future to handle more of our past so we never forget" - clearly I'm biased, but the answer has to be @xtdb_com ! Join us live on 24th November to learn more...

In the build up to an official XTDB v2 release we are running a series of informal chats on our Discord server - come join! This Friday we're speaking with @narayanarjun who has battled many times with as-of chaos during his time at Materialize - see github.com/orgs/xtdb/discuss…

🕰️ Ever needed to track exactly when data was valid, or how it changed over time? 🔎 XTDB makes historical data management seamless with #bitemporality, letting you query past states, track expiring records, and analyse changes—all with precision and control. (1/3)

"Handling the element of time in SQL has been a challenge since it was created" "current databases require you to manually insert time values that track when a data item was added, when it became valid, and when it became invalid" Reflections by @Intellyx's Eric Newcomer [1/2]

💡Struggling with tracking data changes/mistakes in SQL #databases? 🌟XTDB introduces powerful tools to handle historical data, from managing corrections with soft deletes to permanently erasing records, XTDB offers bitemporal capabilities that SQL alone can’t provide! (1/3)

@refset shares his vision for how to make SQL better and more fit for the future by making it more compatible with #Clojure’s philosophy: youtu.be/ot4DDcEHhLs

"SQL queries start with SELECT" has been true for 50 years, but what could we unlock by allowing you to start a query with FROM instead...? Check out our latest beta5 release to learn more - featuring some rather exciting SQL pipelining and templating capabilities [1/2]

🚀 Need accurate reporting and seamless data corrections in your #Database? 📹 See how XTDB's bitemporality makes auditing and historical queries effortless. Correct mistakes, track changes, and retrieve past states—all with simple SQL queries. (1/2)

I am just having the time of my life building lightning fast complex virtual scrolled tables with server-streamed differential record spooling over 10k records ... in 12 lines of simple, straightforward code. #ElectricClojure

The older I get, the more amazed I am that John McCarthy invented Lisp in 1958 when the popular programming languages were Algol, Fortran, and Cobol. 66 years later and it's still mind-blowing to the vast majority of the industry.

🎁 Day 1⃣🎱– JUXT Content Advent Calendar 🎄🗓️ @RealGeneKim – bestselling author of The Phoenix Project The DevOps Handbook – joins @malcolmsparks & @refset to discuss modularity, AI, and innovation in software development. 🎧 Full episode here ➡️ juxt.pro/blog/gene-kim-podca…

Can we do better than JSON_AGG? #SQL has had sub-queries since SQL:92 - but it's still a challenge to return properly nested data through SQL queries. #XTDB delivers first-class support for nested values, as well as `NEST_ONE` and `NEST_MANY`, which fill this gap. 1/n

Are JSON columns and versioning painful in your existing databases? Probably! 📹 Check out this short tour through some of XTDB's novel SQL features for handling semi-structured data ('records') and as-of queries.

I had so much fun watching Christoph Neumann's (@enigma2a) Clojure/conj talk on his work enabling live sports and e-sports programming. I haven't watched e-sports much, but I did watch the documentary of Google DeepMind’s AlphaStar, where it played some of the best StarCraft II players in the world. The event was so brilliantly done, and was hosted by professional commentators, who helped explain and give context to what we were observing. It was so good that I made my kids watch it, and I’m not ashamed to say that it actually made me cry! (As did watching the documentary on Google DeepMind AlphaGo — holy cow. Move 37 FTW!) (I'll include the links to those videos at the bottom of this tweet.) Christoph gave an amazing talk on how the code he wrote enables these types of live e-sports broadcasts of some amazing gaming brands: - Heroes of the Storm (including the draft tool to facilitate team hero selection in real-time, as well as enabling the commentators to do their job, too) - Hearthstone (including tools to analyze and display the game state live on-air) - Overwatch (including integrating live game statistics for the Overwatch League) He also describes some of the work he did to help brands such as Blizzard Entertainment (home of StarCraft II, which was obviously the game that AlphaStar competed in), NFL, Overwatch League, Heroes of the Storm, Activision, Call of Duty League, Hearthstone: Heroes of Warcraft, NEP, Twitch, Wimbledon Championships. One reason I was nerding out so much during Christoph’s talk was because he had hinted at so many of these things in his awesome Functional Design in Clojure podcast (@clojuredesign), but never really elaborated on what he actually did. I’ve listened to every one of their 100 episodes that he did with Nate Jones, @ndj, and always hoped they would go into more detail about what they’ve done in e-sports. Wish granted! It’s such a cool talk. Among other things, he talks about the high stakes involved in live events — mistakes are seen by everyone, and could actually jeapordize events where hundreds, thousands, or even millions of people are watching! Christoph: "You have hours of boredom followed by seconds of terror." Ha! Everything he's built is done in Clojure, whether it's a event in front of an audience, broadcast over the airwaves, or streamed to a channel. "My hope is that by the end of this talk, you're going to have an idea of what's involved in pulling off a live sports production, and then how to build a system using it." Yes!!! 1/n Source: youtube.com/watch?v=kIhY4VDa… Also: the amazing video of StarCraft II AlphaStar live broadcast: youtube.com/watch?v=cUTMhmVh…

The bitemporal data model can solve key reporting & compliance requirements, but it is tricky to implement and maintain. 📺 Watch this talk by @refset covering various approaches to implementing bitemporal systems, and how to ensure a smooth process ➡️ juxt.pro/blog/reconciliation…

XTDB Bi-Temporal SQL. Time-travel scrubbing. IYKYK. The "as-is vs as-was" convo is dead.