
Blog
Engineering insights and development updates from the XTDB team

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




The DIY Bitemporality Challenge
Guest blog post by Eric Newcomer (Intellyx) on the complexity of capturing change in traditional SQL databases


The missing SQL sub-queries
How to yield tree-shaped data in XTDB without setting your hair on fire.


Why it's time to retire CRUD
Guest blog post by Jason Bloomberg (Intellyx) on the database user experience


The Challenge of Data Compliance
Guest blog post by Eric Newcomer (Intellyx) on the evolving demand for data compliance


Development Diary #13 - Beta Release
The XTDB v2 beta1 release is out! Postgres wite protocol compatibility and the path to General Availbility


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


Development Diary #12
Playing with XTDB, nested query results, Postgres compatibility and more.
