|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.
or email your comment to: firstname.lastname@example.org