On: CockroachDB 20.1

[gigatexal]

Online primary key migrations is some interesting voodoo.

We ran it in production from the v2.x days before they moved to a new versioning schema and the support was really good. The paid support is worth the enterprise license.

It's also good to see the added work on supporting ORMs for shops that use it. We used SQLAlchemy heavily and had to do a lot of work to fix our app to work around the transaction retry errors which CRDB has been working on lessening in recent releases.

[rsanders → gigatexal]

Retrying transactions is something every app ought to handle, but it's rare enough that most codebases I've seen just punt on it.

[gigatexal → rsanders]

The thing is before CRDB the application was operating just fine in MySQL's default isolation level.