
Working on @xtdb_com #ToolsForThought obsessive, 4GL maximalist (SQL is alright), always happy to chat :)
UK
Joined April 2012
- Tweets739
- Following4.8K
- Followers1.3K
- Likes5.2K
I'm giving an online tech talk with @FINOSFoundation 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. XTDB helps you to quickly figure out how data has changed and why /1
Ultimately though I suspect the 'best' protocol will be very data & situation dependent. It feels like all the same set of trade-offs you face when thinking about optimal LSM-trees and compression more generally
Replying to @testestear @muratdemirbas
Replying to @ohmypy
> recalculate the indexes on each insert
In principle this shouldn't be a blocker. Simpler is better if there's any hope for a database to accelerate the workload.
Like it might be okay *if* you could tune an LSM index to match the workload.
> no free lunch
aka RUM Conjecture
Just in case anyone was in doubt about the stability argument, Q1 (1974) still works great: dl.acm.org/doi/pdf/10.1145/8…
SQL is turning 50 years old later this week 🎉
In your opinion, which are the best bits? Which are the worst?
Replying to @swardley
Related - I've only just realised that @MapsAsCode now supports Iterations 😍 docs.onlinewardleymaps.com/2…







