a curated list of database news from authoritative sources

March 24, 2021

Code generation in Vitess

Cross posting link Golang is a wonderful language. It's simple, and most of the time not confusing or surprising. This makes it easy to jump into library code and start reading and quickly understand what's going on. On the other hand, coming from other languages, there are a few features that would make our lives easier. We are building Vitess using mostly golang, and most of us are happy with this choice.

March 23, 2021

March 22, 2021

March 17, 2021

The problem with MySQL foreign key constraints in Online Schema Changes

This post explains the inherent problem of running online schema changes in MySQL, on tables participating in a foreign key relationship. We’ll lay some ground rules and facts, sketch a simplified schema, and dive into an online schema change operation. Our discussion applies to pt-online-schema-change, gh-ost, and Vitess based migrations, or any other online schema […]

March 16, 2021

Coming soon on ClickHouse: Window functions

An exploration on what's possible to do with the most recent experimental feature on ClickHouse - window functions, and an overview of other interesting features to come.

March 11, 2021

March 08, 2021