I published an article on the Cockroach Labs Blog: On the Way to Better SQL Joins in CockroachDB. In this article, I explain how I improved the first design of SQL joins in CockroachDB to support basic forms of optimizations in CockroachDB v1.0. Also available via the Wayback Machine …| dr knz @ work
I published an article on the Cockroach Labs Blog: Modesty in Simplicity: CockroachDB’s JOIN. In this article, I explain how I designed the first (and overly simplistic) implementation of SQL joins prior to CockroachDB v1.0. Also available via the Wayback Machine.| dr knz @ work
A few months ago, I was invited to present CockroachDB to a tech consulting office in Amsterdam. The audience was welcoming and receptive. They understood, appreciated, and lauded the “flagship” features of CockroachDB: distribution, scalability, high availability, operating simplicity. Yet a question came up which I had not heard before …| dr knz @ work
SQL defines many statements for different things: creating tables, putting data into tables, using tables, between other things. To reason about groups of statements with related behavior, the data community uses common, widely accepted acronyms to designate these groups. For example, the acronym “DDL” stands for “data definition language”, the …| dr knz @ work
