Great talk! The DBMS ecosystem is badly lacking in sustained revolutionary efforts.
It's understandable - even with OSS accelerators like Calcite and DataFusion the entry costs for addressing the inertia of SQL are extreme. Luckily DuckDB proves that revolutions here are still possible, and welcome!

"If I had a requirement to monitor all the new systems that we've onboarded, for their first three days, to ensure they stay within agreed limits, could we do that with @xtdb.com?"

Time-oriented requirements are *everywhere*!

#bitemporal #sql

Future Data Systems Seminar Schedule (Fall 2025)

Fall 2025 Seminar Schedule:
Sep 22: Apache Iceberg
Sep 29: Apache Hudi
Oct 06: @motherduck.com
Oct 13: SpiralDB Vortex
Oct 27: @singlestore.com
Nov 03: @deltalakeoss.bsky.social
Nov 10: Mooncake
Nov 17: @firebolthq.bsky.social
Nov 24: @xtdb.com
Dec 01: Apache Polaris

[Unikernel Application Spotlight] XTDB YouTube video by nanovms

this week on the unikernel application spotlight we go time traveling with @xtdb.com www.youtube.com/watch?v=2EAG...

The theme of CMU'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 db.cs.cmu.edu/seminars/fal...

[RELEASE] v2.0.0-beta7 is out! · xtdb · Discussion #4383 We're really proud to announce the release of XTDB 2.0.0-beta7 - this is a significant change to our underlying indices which expands the variety of temporal datasets that XT can performantly suppo...

XTDB 2.0.0-beta7 is now available! The release includes a new indexing strategy specifically for handling time-series data: github.com/orgs/xtdb/di...

Welcome! You are invited to join a webinar: Streamlining Regulatory Compliance and Reporting with XTDB: The Future of Bitemporal Data Management. After registering, you will receive a confirmation ema... In industries such as finance, healthcare, energy, and CPG, regulatory compliance and accurate, timely reporting are crucial – but achieving them with traditional systems often comes with high costs a...

Join us LIVE for a 1-hour session on 19 Feb (tomorrow!) at 1500 UTC, where the team will give a tour of the latest developments in v2 ahead of the General Availability launch, which is just a few weeks away 🚀

Register here: us06web.zoom.us/webinar/regi...

[ANN] 2.0.0-beta6 · XTDB

@xtdb.com beta6 is out today 🚀

Containing the sorts of changes that don't make for very exciting release-notes, but all the little things you'll appreciate when you're actually working with it day-to-day/deploying it into production.

No buzzwords this time I'm afraid!

xtdb.com/blog/v2beta6

JUXT Blog: Bitemporal TraderX - XTDB Reflections Using XTDB in a sample microservices trading application for the FINOS 2024 Tech Sprint (part 2)

"A first-class history close to hand is a game changer for application development" 💡

Following on from his initial blog post on integrating with the FINOS 'TraderX' project, Michal Pisanko wrote up a few more reflections on XTDB itself... www.juxt.pro/blog/bitempo...

The Incredible POWER of XTDB and Bitemporal Data! YouTube video by XTDB

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

www.youtube.com/watch?v=Mr4N...

The DIY Bitemporality Challenge · XTDB

"[...] this is very error prone and labor intensive. Many organizations that have such temporal use cases tend to deprioritize this work when they see how costly it is."

"A bitemporal database [...] eliminates such manual programming effort"

Read on - xtdb.com/blog/diy-bit...

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

Release 2.0.0-beta5 · xtdb/xtdb We're pleased to announce the release of 2.0.0-beta5! 🚀 In amongst the usual array of bugfixes and minor improvements, 2.0.0-beta5 adds "template-friendly SQL", as well as a 4x reduction in per-tra...

Check Out the New #XTDB 2.0.0-beta5 Release!
It brings template-friendly SQL for easier query generation and a 4x performance boost for small transactions on the Postgres wire-server. Simplify workflow and enhance your database performance today!

github.com/xtdb/xtdb/re...

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

www.youtube.com/watch?v=Swy2...

Standard SQL which requires extensive subqueries vs. XTDB SQL that supports intuitive pipelining (as well as standard SQL!)

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

discuss.xtdb.com/t/ann-xtdb-2...

The incredible TIME TRAVEL capabilities of XTDB 👀 YouTube video by XTDB

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

youtu.be/gKXpljRpHlo

Why RECORDS are so useful in XTDB! YouTube video by XTDB

Struggling to manage complex data structures in your #database?

📹 Explore how XTDB's RECORDS feature makes handling semi-structured data a breeze. Effortlessly nest, query, and version your data with NoSQL flexibility—all while leveraging the power of SQL.

www.youtube.com/watch?v=QMX2...

The missing SQL sub-queries · XTDB

Blogged: "The Missing SQL Sub-queries"

SQL's had sub-queries since SQL:92 - but it's still a challenge to return properly nested data through SQL queries.

#XTDB has first-class support for nested values, as well as `NEST_ONE` and `NEST_MANY`, which fill this gap:

xtdb.com/blog/the-mis...

Join @refset.bsky.social for an online tech talk this Wednesday (4pm GMT) on 'as-of reporting' in financial services - but really this applies to all organisations who care about the auditability of systems and figuring out how data changes over time. Registration is here: zoom.us/webinar/regi...

#XTDB 2.0.0-beta4's out today 🚀

Featuring a new `PATCH` operation to upsert records, an improved ops story involving shiny Grafana dashboards, initial authn support, as well as the usual array of performance/stability improvements and bugfixes.

Enjoy!

github.com/xtdb/xtdb/re...

FINOS Discover how modern open source database software can simplify reporting and compliance in financial services. Explore insights from OSFF NYC, the inefficiencies of legacy systems, and the transformat...

New blog post! A recap of the recent FINOS NYC conference and how XTDB is positioned for use within financial services and beyond

www.finos.org/blog/osff-in...

AdventOfSQL.com Day 1 discussion Hi folks, I saw adventofsql.com pop up in r/Elixir a few weeks ago and signed-up, then promptly forgot all about it …until I opened my email this morning! The day 1 puzzle was fun - not too hard, an...

The adventofsql.com challenges are written with Postgres in mind - so this will be a good test of XTDB's Postgres compatibility! You can find the XTDB solution for Day 1 here: discuss.xtdb.com/t/adventofsq...

Day 1 of the 2024 Advent of SQL completed ✅🎄#AdventOfSQL

Details of the webinar on 19 Dec @ 11:00 ET

Join us for a live session next week to take a look at what's in store for our first XTDB v2 feedback release coming in 2024 🎄 us06web.zoom.us/webinar/regi...

Hello Bluesky people 👋 seems there's not much chatter here about bitemporality yet...let's see if we can fix that :)

JUXT Blog: JUXTCast: Rama and its Clojure API — with special guest Nathan Marz Malcolm Sparks, Jeremy Taylor, and James Henderson sat with Nathan Marz to talk about Rama, and the influence the Clojure language has had on its design.

⭐ NEW PODCAST EPISODE — with Special Guest Nathan Marz ⭐

Marz, @malcolmsparks.bsky.social, @refset.bsky.social, and James Henderson discuss the new programming platform Rama, how Clojure fits in, and the challenges Nathan and his team encountered in the process.

🎦🎧▶️ www.juxt.pro/blog/juxtcas...