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
This blog post provides an overview of the data flows inside CockroachDB and its data security architecture. Note This post was originally published in February 2020, targeting CockroachDB v20.1. It was edited in February 2022 to reflect changes in CockroachDB v22.1. A summary of changes is available in …| dr knz @ work
What is faster: a local connection over a unix domain socket, or a local TCP/IP connection with TLS encryption? To a network expert, the answer seems intuitively obvious: the unix socket. But why? And by how much? Moreover, online docs and tutorials for both PostgreSQL and CockroachDB recommend—or …| dr knz @ work
In 2020, I published the following two articles: Data flows and security architecture in CockroachDB Authentication configuration in PostgreSQL and CockroachDB The original text was targeting version v20.1 of CockroachDB. This month, I have updated these two pages to reflect the improvements between v20.1 and the upcoming v22 …| dr knz @ work