3 May, 2025
James Henderson
SQL pipelines: reducing some of the accidental structure in SQL
... because it seems like what all the cool databases are doing these days...
Better SQL
Blog
Engineering insights and development updates from the XTDB team
NEWEST
UPDATE RECONSIDERED, delivered?
In 1977, just 3 years after SQL was born, the paper UPDATE RECONSIDERED was published. What can it tell us in 2025?
Bitemporality
Jeremy Taylor
25 April, 2025
James Henderson
Building a Bitemporal Index (part 1): A Taxonomy of Bitemporal Data
A technical deep-dive trilogy explaining how a bitemporal-aware database can handle and optimise for temporal data differently to general-purpose databases.
Deep Dive
14 February, 2025
James Henderson
20 January, 2025
Eric Newcomer
The DIY Bitemporality Challenge
Guest blog post by Eric Newcomer (Intellyx) on the complexity of capturing change in traditional SQL databases
Data Compliance
12 December, 2024
James Henderson
The missing SQL sub-queries
How to yield tree-shaped data in XTDB without setting your hair on fire.
SQL
21 October, 2024
Jason Bloomberg
Why it's time to retire CRUD
Guest blog post by Jason Bloomberg (Intellyx) on the database user experience
Data Compliance
30 September, 2024
Eric Newcomer
The Challenge of Data Compliance
Guest blog post by Eric Newcomer (Intellyx) on the evolving demand for data compliance
Data Compliance
13 September, 2024
Jeremy Taylor
Development Diary #13 - Beta Release
The XTDB v2 beta1 release is out! Postgres wite protocol compatibility and the path to General Availbility
Dev Diary
23 July, 2024
James Henderson
Taking the ² out of O(n²)
A technical deep-dive - tracking down and fixing a performance issue in our bitemporal resolution which caused an O(n²) slowdown in time-series data