I published an article on the Cockroach Labs Blog: Nested transactions in CockroachDB 20.1. In this article, I explain how I implemented nested transactions and SQL savepoints in CockroachDB v20.1. Also available via the Wayback Machine.| dr knz @ work
I published an article on the Cockroach Labs Blog: Local and distributed query processing in CockroachDB. In this article, I explain the software architecture and overall mechanisms in the SQL execution engine of CockroachDB, in the code leading up to version v1.1. Also available via the Wayback Machine.| dr knz @ work
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
I published an article on the Cockroach Labs Blog: Critters in a Jar: Running CockroachDB in a FreeBSD Jail. In this article, I report on how to build and install CockroachDB on FreeBSD. Also available via the Wayback Machine.| dr knz @ work
CockroachDB happens to be somewhat compatible with PostgreSQL, meaning that software written to use PostgreSQL can sometimes (often!) be used with CockroachDB without changes. Why was CockroachDB designed to be compatible with PostgreSQL? Perhaps surprisingly, the answer to this question is currently (as of early May 2018) not documented publicly …| dr knz @ work