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


MDN Web Docs Call For Participation
27/10/2020

There's a new editorial strategy for MDN Web Docs and a radical platform change is on the cards. Meanwhile the call has gone our for the community to rally round and help out with day-to-day tasks on  [ ... ]



Haskell Foundation Launched
05/11/2020

Launched at this week's Haskell eXchange online event, the newly formed Haskell Foundation has been established as a non-profit dedicated to broadening the adoption of the Haskell programming language [ ... ]


More News

square

 



 

Comments




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