NewsBits - IndexedDB 2.0, PostgreSQL, Peloton, RabbitMQ, Miller, Terraform and more

Published

NewsBits for the week ending 24 March - IndexedDB 2.0 lands in more browsers, hashed indexes to endure in PostgreSQL 10, Peleton - a database born in academia, RabbitMQ's quick update, Miller - a grinder for files, Terraform gets a 0.9, the latest programming language rankings, the relicensing of OpenSSL and Ruby 2.4.1.

We gather all the database, development, cloud and data news thats has caught out attention over the past week (or so), for you to enjoy. This is NewsBits and here are the bits.

Database bits

IndexedDB 2.0

Browsers aren't usually a place where we talk about databases, but IndexedDB 2.0 seems to be changing that as it adds finer grained access to the database, binary keys, ranged retrieval and more. Browsers that can maintain a local database can mean less load for servers so the emergence of a solid, widely implemented standard can only be a good thing. The W3C spec currently at Editors Draft if moving forward and as with most web standards, browsers are implementing it as it moved forward. Firefox was first to ship a version and this week saw Chrome 58 beta announced.

PostgreSQL 10 tracking

The future PostgreSQL 10 will now support durable hash indexes thanks to recent commits. Though still a work in progress, the durable hash indexes are providing 10 to 22% better performance in some benchmarks.

Peloton

Peloton is a database being developed at CMU which sets out to create a "self driving" relational database management system. One of the faculty leads on Peloton, Andy Pavlo has written about creating a new database in academia where he looks at how Peloton started based on PostgreSQL, dropping PostgreSQL, progress, challenges and other academic database projects. A good read for anyone interested in the future of databases.

RabbitMQ 3.6.8

Last week, we mentioned RabbitMQ 3.6.7 had been released. Well, that was followed quickly by the release of RabbitMQ 3.6.8 which restores compatibility with older Erlang platforms and fixes some bugs in the management plugin and web STOMP plugin.

Miller

We always like tools that grind data for us and the folks at DB Weekly pointed us at Miller, a rather fine looking data grinder written in C which knows its way around CSV, TSV and JSON files so it can select, add, filter, label, join, aggregate, split and reduce files. It's been around since 2015, but the latest release, 5.0.1 is just weeks old

Choose SQL

Two different postings about Choosing SQL - the first is a good approach to many database questions over using SQL or not which. The other, a riposte to that in Trainspotting style.

Cloud Bits

Terraform 0.9

The latest major release for Terraform, Terraform 0.9, the reproducible-infrastructure-as-code tool, extends the platform to manage resource destruction better, instantly handle interruptions, revamps state handling with state environments, revamped remote states and ships with updates to providers

Developer bits

Ranking Programming Languages

The Redmonk Programming Language report for Jan 2017 is now out. We have a preference for this report as rather than being based on searching for keywords, it's current process correlates Github pull requests and StackOverflow discussions to create the ranking. That top 10: JavaScript, Java, Python, PHP, C# and C++ (tied), CSS and Ruby (tied), C and Objective-C, with Scala, Shell and Swift tying just outside at 11th. Read the report for observations around R, Swift, Go, TypeScript, PowerShell and Rust.

OpenSSL relicensing

The OpenSSL project has notified developers that it wants to change license from GPLv2 to Apache v2. There's a lot to commend this change but it does involve getting the agreement of all contributors. If the relicensing goes ahead then expect to see wider adoption of OpenSSL, but that's a big if.

Ruby 2.4.1

Ruby 2.4.1 has been releases and Ruby Inside's Peter Cooper has extracted all the modifications into one quick Ruby 2.4.1 change summary; mostly fixes but the regexp engine gets an absent operator.


If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at articles@compose.com. We're happy to hear from you.

Dj Walker-Morgan
Dj Walker-Morgan is 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.