NewsBits - CockroachDB 2.0 scuttles into the light


Welcome to NewsBits where you'll find the database and developer news from around the net for the week ending April 6th 2018:

Database Bits

CockroachDB 2.0 - The CockroachDB developers have released version 2.0 of the cloud-native, distributed, SQL and NoSQL, database. CockroachDB 2.0's new features include JSON data types added in a PostgreSQL compatible implementation and self-balancing nodes introduced to manage scaling out read and write workloads. There's also new global cluster management and GDPR aware Geo-partitioning. Other features, noted in the release notes include sequences, CTE support, computed columns, foreign key actions, IP address data types, deployment testing, readiness checks for nodes, and updated documentation with many new sections.

PostgreSQL Futures - PostgreSQL 11 commits are coming thick and fast and one recent addition looks set to make life a lot faster for anyone altering their tables. The Depesz blog noted the addition which cuts out re-writing tables when you add a field with a non-null, non-volatile default. PostgreSQL 11 will instead remember there's a new field with a default and if a SELECT queries it where it has not been set, return the default value. A huge boost for refactoring tables where there's millions of rows.

PostgreSQL Annotated - There's a lot you can configure in PostgreSQL's server, so much so that folks like Josh Berkus have annotated the configuration files in the past. Now, Berkus has announced annotated config files for PostgreSQL 10 and, for the first time, it's on Github, allowing the community to create pull requests with enhanced annotations and corrections. Berkus also raises a point that PostgreSQL's configuration is getting harder.

Scylla Secrets - That Scylla is written in C++ rather than as Cassandra is in Java is often cited as the reason that it performs better. But that's far from the only reason as Dor Laor, ScyllaDB CEO, explains in Seven Design Decisions that Apache Cassandra’s Successor is Built On. Everything asynchronous, a shard per core, unified caches and scheduled I/O are among the design aspects looked at.

dqlite - Now here's an interesting thing, dqlite, a distributed SQLite for Go from Canonical. Some time ago we covered rqlite, another distributed SQLite which used Raft for consensus. While rqlite runs as its own process, dqlite runs as a Go library inside your applications with full support for transactions and frame-based replication. The author explains use cases for dqlite: as a foundation for a distributed application with shared state and SQL semantics.

Developer Bits

Refactoring - The well-regarded book Refactoring is on its way to getting a fully refreshed second edition according to author Martin Fowler. The new edition will also see the examples of refactoring given using JavaScript rather than Java, in part because more people are familiar with it and in part, because it's not locked down to just object-oriented code.

SailsJS 1.0 - It's kinda-like Rails but for JavaScript - It's SailsJS. The MVC styled opinionated framework has just seen its version 1.0 release. Once installed, one line will generate you an app framework with user and password management and get you off to a rapid start. It comes complete with adaptors for PostgreSQL, MySQL, and MongoDB and much-improved documentation over earlier versions.

TensorflowJS - Still on the subject of JavaScript, TensorflowJS is a JavaScript package for doing in-browser machine learning. It automatically uses WebGL to accelerate its learning and because it is in the browser, it can take advantage of sensors in, say your phone, to feed the model.

And finally... the 1st of the month couldn't have gone by without someone announcing an awesome addition to PostgreSQL 11.

NewsBits. News in bits, every Friday at Compose.

Read more articles about Compose databases - use our Curated Collections Guide for articles on each database type. If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at We're happy to hear from you.

Dj Walker-Morgan
Dj Walker-Morgan was Compose's resident Content Curator, and has been both a developer and writer since Apples came in II flavors and Commodores had Pets. Love this article? Head over to Dj Walker-Morgan’s author page to keep reading.

Conquer the Data Layer

Spend your time developing apps, not managing databases.