CockroachDB 20.1 Improves App Development
Written by Kay Ewbank   
Friday, 15 May 2020

There's a new release of CockroachDB with improvements for developing apps, along with performance and security enhancements. CockroachDB is a distributed SQL database that is cloud native and offers horizontal scalability with no single points of failure.

The improvements for developers start with new monitoring updates, including a slow query log, SQL statements diagnostics, and a network latency page in the Admin UI. The SQL statement diagnostics uses a SQL statement fingerprint. When you activate diagnostics for a fingerprint, CockroachDB waits for the next SQL query that matches this fingerprint to be run on any node. On the next match, information about the SQL statement is written to a diagnostics bundle consisting of a JSON file that contains a distributed trace of the SQL statement, a physical query plan, execution statistics, and other information about the query.


Support has been added for ORMs, including Django, SQLAlchemy, PonyORM, and peewee for Python developers; Hibernate and jOOQ for Java developers; and GORM for Go developers.

SQL support has been improved with the addition of SELECT FOR UPDATE, support for nested transactions using savepoints, LATERAL joins, and recursive common table expressions.

Another improvement is support for online primary key changes, meaning schemas can be migrated without downtime. The developers say that as primary keys in CockroachDB control data locality and resilience, you can also start with a single-region deployment and then have the freedom to expand into multi-region, all with a simple ALTER TABLE command. This is an extension on CockroachDB’s existing online schema migrations feature.

Security has been improved in this release with support for encrypted backups. The previous release of CockroachDB already encrypted data in transit and at rest, so the support for encrypted backups is useful. The new version also adds full-cluster backups and restore, including metadata and configurations, to make it easier to restore clusters when necessary. There's also more control over user permissions with updates to Role Based Access Control (RBAC), and better support for certificate authorities.


More Information

Cockroach Labs

Related Articles

CockroachCloud Enters Beta

CockroachDB Adds GDPR Compliance

CockroachDB Production Ready

CockroachDB Released


To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.


Kotlin 1.7 Unveils New Compiler

Kotlin 1.7 has been released, with the inclusion of the alpha version of the new Kotlin/JVM K2 compiler. The new release also stabilizes language features, and offers performance improvements for the  [ ... ]

IKEA First With Matter Hub And It Matters

Matter is the new one-system-to-rule-them-all IoT protocol and surprisingly IKEA is the first to create a working device that you can buy - well in October. What is Matter all about and why does it ma [ ... ]

More News





or email your comment to: