Compose's Little Bits #10

A collection of links that have caught the eye of Compose's Technical Content Curator over the past week. This week, PostgreSQL 9.5 for 2016, JetBrains gets a DataGrip, Yahoo Partitioning, Elasticsearch postmortems, PostGIS tutorials, Go 1.6 beta and Blockchain.

Database-y

PostgreSQL 9.5 for Jan 2016 - With 2015 running out rapidly, it was only to be expected that the PostgreSQL 9.5 release would slip into 2016. With the announcement of PostgreSQL 9.5 RC1, that's been confirmed. There's now an "early January" date pencilled in for the release, pending new major issues. There's been a number of issues fixed since the beta 2; for users eager to test, and the PostgreSQL developers hope there are, there are downloads appearing and draft release notes.

JetBrains DataGrip 1.0 - Jetbrains make a whole host of commercial IDEs and have been working for a while on a database IDE. Now they've released that work as DataGrip 1.0, a (currently) SQL-centric IDE which supports PostgreSQL, MySQL, SQLite, Oracle, DB2 and others. JetBrains plans to add NoSQL support to the commercial product (there's a 30 day trial available).

Yahoo's MySQL Partition Manager -Yahoo does a lot of partitioning of their MySQL database tables. So much so that they wrote a tool to help them do it automatically. Now they've open sourced that tool and put it up on GitHub under an Apache License.

Elasticsearch - An interesting post mortem post about one company's downtime with Elasticsearch is a good reminder that understanding how databases behave can be key to keeping them live. Even though the Elasticsearch in use is an older version it's a great read about how a combination of mapping and type conversions can fail.

PostGIS – We love an interesting tutorial and Using PostGIS, SQL, and CartoDB to identify schools at risk from Oklahoma's earthquakes is a fascinating dive which starts from gathering the data to practical visualization.

Developer-y

Go 1.6 goes beta - The first beta for Go 1.6 has been released. Due in February 2016, Go 1.6 is not changing the language but is adding new ports (Linux on 64-bit MIPS and Android in 32-bit x86), new rules for code interacting with C and automatic and transparent HTTP/2 support - the draft release notes have more.

Blockchain - Behind cryptocurrencies like BitCoin is a technology called the Blockchain which allows for transactions to be recorded, distributed, unforgeable and traceable. Many companies are thinking beyond the currency box to potential uses of the blockchain in other scenarios where those properties would pay off, like the financial industry. The Linux Foundation has announced that it has brought a whole host of companies together – among them IBM, Accenture, Fujitsu, Intel, SWIFT and more – to explore creating an "enterprise-grade, distributed ledger" and other tools to let developers plug their applications into the chain. Mark it down as one to watch.

Christmas-y

This is the last Little Bits of 2015. We'll be back in the New Year where you'll be able to enjoy more of our smaller smatterings of useful news and links. Happy Holidays.