Next week, we'll be @ #OSFF2024 #NYC — stop by our Sponsor Table and meet the team 👋 If you're attending, check out Jeremy Taylor's talk: "Reconciliation, Risk, ML and Other Use Cases for Bitemporal Systems" sched.co/1i6vC #OSinFinance #data #bitemporality FINOS

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

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

I had so much fun watching Christoph Neumann's (Christoph Neumann) 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

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.

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

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 🎄🗓️ Gene Kim – bestselling author of The Phoenix Project The DevOps Handbook – joins Malcolm Sparks & Jeremy Taylor to discuss modularity, AI, and innovation in software development. 🎧 Full episode here ➡️ juxt.pro/blog/gene-kim-…

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

"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]

Jeremy Taylor 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

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

"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]

🕰️ 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)

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 Arjun Narayan who has battled many times with as-of chaos during his time at Materialize - see github.com/orgs/xtdb/disc…

The theme of CMU Database Group'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 ! Join us live on 24th November to learn more...