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.

cockroachdb

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.

cockroachdb

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.

Banner


Gnome Foundation Settles Lawsuit
25/06/2020

The GNOME Foundation has settled its lawsuit with Leigh M Rothschild and Rothschild Patent Imaging. Rothschild Patent Imaging agreed that, for all of their patents and future patents, they will not su [ ... ]



Apache Hudi Achieves Top Level Status
29/06/2020

Apache Hudi has been adopted as a top-level project. The open source data lake technology for stream processing on top of Apache Hadoop is already being used at organizations including Alibaba, Tencen [ ... ]


More News

graphics

 



 

Comments




or email your comment to: comments@i-programmer.info