a curated list of database news from authoritative sources

May 14, 2024

May 09, 2024

May 02, 2024

April 30, 2024

ClickHouse®️ JOINs... 100x faster

We recently introduced two pull requests to ClickHouse that significantly improve JOIN performance in common scenarios.

ClickHouse®️ JOINs... 100x faster

We recently introduced two pull requests to ClickHouse that significantly improve JOIN performance in common scenarios.

April 29, 2024

Consistent Lookup Vindex: Achieving Data Consistency without 2PC

Vindex # Vitess uses Vindexes (short for Vitess Index) to associate rows in a table with a designated address known as Keyspace ID. This allows Vitess to direct a row to its intended destination, typically a shard within the cluster. Vindexes play a dual role: enabling data sharding through Primary Vindexes and facilitating global indexing via Secondary Vindexes. Through this mechanism, Vindexes serve as an indispensable tool for routing queries in a sharded database, ensuring optimal performance and scalability.

April 26, 2024