Attention, South Bay folk! We have The Databaseologist, @andy_pavlo, giving a talk in the bay on August 6th. Come join us for a great time in hearing:. ChatGPT Ain’t Got $%@& On Me! The Future of Automated Database Tuning. Register now!

I had missed @ssougou's blog post series on consensus when it was originally posted. I really like the perspective of breaking down Raft/Paxos/etc. into the individual actions that comprise consensus.

If they're willing to also sponsor some food or drinks that's doubly amazing. We've had a few places already volunteer, but it'd be nice to not strain their generosity. :).

To South Bay folks:. South Bay Systems is currently limited by finding venues willing to host. If you know of somewhere that can host 60+ people and is happy getting a few minutes for a quick "here's who we are, what we do, and who to talk to for hiring", please let me know!.

Generating and loading datasets is also a significant hurdle to solve, and even tools for that alone are of great help. See, for example, introducing

Making it easy to do the right thing means people will do the right thing, and I strongly suspect that it a tpc-rs project appeared in which the defaults all did the standards compliant thing, it'd get a lot of users quickly.

The easiest things to use (sysbench-tpcc, go-tpc, pgbench) are all non standards confirming, but they're the easiest things to use! Credit to PingCAP that go-tpc is the closest (it has TPC-C keying time!), but keeping the required 10:1 terminal:warehouse ratio isn't inherent.

If you'd like to do something great for the database community, write an easy to use implementation of the TPC-* benchmarks. Bonus points if it comes with blog posts describing what it is in a database that each TPC-* benchmark is actually testing.

RT @qianl_cs: The South Bay Systems meetup is back on July 22!. We're excited to welcome @jacopotagliabue (co-founder and CTO of Bauplan)….

I ran across a pretty nice x86 SIMD intrinsics cheat sheet: Thanks @jpfinis!.

RT @panghy: A month after building that construction SaaS prototype, I found myself working on something completely different: reimagining….

[arXiv] TreeTracker Join: Simple, Optimal, Fast. TreeTracker gives a very simple breakdown of what the core differences are between a naive binary join and an optimal multi-way join.

I've heard the folk tale that Orca isn't actually general purpose and can't be easily integrated into other databases, but without any description of specifically why that is. Section 7 Lessons Learned is the discussion I've been looking for; it lists very specific complaints.

[EDBT'22] Integrating the Orca Optimizer into MySQL. Huawei Taurus folk plugged Orca into MySQL to get a better query optimizer for OLAP queries in MySQL.

Wisdom on btree prefix compression from someone who has implemented and benchmarked it. From

I really appreciate the authors pursuing and accepting ugly solutions because they're what's needed to achieve the required result practically.

[arXiv] Fast Userspace Networking for the Rest of Us. "if it doesn't work on the cloud does it even matter?" but applied to kernel bypass networking.

RT @natalievais: Working with several seed/series A infra startups (databases, storage, distributed systems, foundational AI infra) hiring….

[arXiv] Compressing integer lists with Contextual Arithmetic Trits. Which was an interesting skim, partly just because I've never seen trits (bit in base 3) applied to solve a problem effectively before.

[arXiv] BMTree: Designing, Learning, and Updating Piecewise Space-Filling Curves for Multi-Dimensional Data Indexing. I've seen a lot of morton/hilbert curves before, but learning a space filling curve and adapting it to the data distribution is new to me.