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.
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 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.
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.
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
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.
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
Ranking Programming Languages
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 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 firstname.lastname@example.org. We're happy to hear from you.