Welcome to NewsBits where you'll find the database and developer news from around the net for the week ending April 6th 2018:
- CockroachDB 2.0 arrives with JSON data types.
- The future of PostgreSQL is faster table changes.
- And the present of PostgreSQL is annotated configurations.
- ScyllaSB's CEO explains how Scylla is speedy.
- And dqlite is a delightful distributed SQLite for Go.
- The book Refactoring is being refactored.
- SailsJS reaches 1.0 and ready to sail.
- Do machine learning in your browser with TensorflowJS.
- And finally... the best from the first day of the month.
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.
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 email@example.com. We're happy to hear from you.