Compose's Little Bits #27 - ScyllaDB, PostgreSQL now and future, Ubuntu 16.04, Amazon Inspector and more

ScyllaDB heads past 1.0, PostgreSQL expression indexes and future parallel queries, Ubuntu 16.04 LTS arrives, Amazon's Inspector comes calling, Let's Encrypt issues two millionth certificate, Sinatra hits the road for 2.0 and Monod is an interesting Markdown editor - all the links that caught the eye of Compose's technical content curator this week, in one place for you. These are Compose's Little Bits.

Database-y

ScyllaDB - Cassandra-compatible open source, columnar database ScyllaDB had reached version 1.0 at the end of last month and, after the inevitable post-release bug fix release 1.0.1, version 1.1 is already shaping up with authorization support just being committed.

PostgreSQL Now - Tomas Vondra takes a look at the usefulness of expression indexes on 2ndQuadrant's blog and shows the value, when appropriate, of indexing according to an expression rather than selecting with expressions.

PostgreSQL Future - Parallel queries are a new feature coming in PostgreSQL 9.6 and Robert Haas has given them a run at a TPC-H query benchmark. Queries sped up by up to 5.0x, but some only got a minor boost or no boost at all and one slowed down. This is a first pass though and Haas picks out some of the issues to be addressed in future versions.

Cloud-y

Ubuntu 16.04 - Canonical's latest LTS (Long Term Support) release of Ubuntu is out and you can head straight to the release notes to find out more about 16.04 "Xenial Xerus". The release notes page also contains links to the many variants of it. Ubuntu is widely used in cloud platforms, and the previous LTS, 14.04, is ubiquitous as a default Linux offering. With 16.04, expect that to repeat, but don't forget there's another three years of support to go for 14.04's core flavours.

Amazon Inspector - The cloud, books, games and groceries giant has made Amazon Inspector generally available. It's an automated security assessment system which can be configured, through a template, to test collections of AWS resources. The tests are developed by Amazon's own security researchers.

Let's Encrypt - The EFF note that the Let's Encrypt service has already issued its two millionth certificate. Let's Encrypt is a free certificate authority which can be automated so that having encrypted web connections is easy. With some big players sponsoring and and open governance, it is worth looking at to help securing sites.

Developer-y

Sinatra - There's a roadmap to Sinatra 2.0 now. The tiny Sinatra framework for Ruby, is a stable stalwart of microservices and 2.0 won't change that but it will add protection against web attacks, a new pattern matcher for routing and a contrib gem of helpful extensions.

Monod - An interesting experiment in Markdown editing is one way to describe Monod. It's just been open-sourced by TailorDev (find it on Github) and supports CommonMark, FontAwesome icons and emoji, PDF generation and collaborative editor. It also sets out not to share the documents you write with the host server by encrypting in the browser.