Compose's Little Bits #20 - SQL Server on Linux, InfluxDB, Cassandra, Flink and more

Microsoft and SQL Server on Linux, InfluxDB commercial clustering, Cassandra's tock, Flink's 1.0.0, Best Clouds, Qubes, Node.js and DROWN and Github's Thumbs – 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

SQL Server on Linux: Microsoft has announced SQL Server for Linux will be shipping mid 2017, with preview releases at sometime this year. The new SQL Server 2016 supports features such as encryption at rest, in motion and in-memory and support for in-memory database operations. SQL Server has previously been an exclusively Windows application but Microsoft, working with both Red Hat and Ubuntu, is setting about changing that. Pricing is unannounced but Microsoft is taking applications for the preview.

InfluxDB: InfluxData's Paul Dix announced future plans for the open-source time-series database will now involve a new commercial clustering solution to help monetize the company. The next release, 0.11.0, will be the last with clustering code and in April, 0.12.0 will be a standalone server. The commercial clustering is due "in a few months" at around $400 per month.

Cassandra 3.4: The Apache Cassandra distributed columnar database gets monthly releases; odd version numbers are bugfix releases, even numbers are feature releases - it's a "tick-tock" schedule. The latest release is 3.4 which has new features around the management of encrypted credentials and authorisation. The JIRA notes for the release also pick out options for encrypted commitlogs, secondary indices for static columns and many bugfixes and improvements.

Flink 1.0: The Apache Flink distributed stream and batch processing platform hit version 1.0. The new release is using RocksDB to store node state, has a new, generalised complex event processing system and improved connections to Kafka.

Cloud-y

Best Cloud?: In an extensive article, "What's the Best Cloud? Probably GCP", Quizlet's Peter Bakkum takes a look at the state and capabilities of Amazon Web Services and Google Cloud Platform. Quizlet moved from AWS to GCP last year and the information in the article is gleaned from their evaluation and transition. For database folk, this quote stands out – "In several years time there will be very few reasons not to use a hosted database service, even for very high throughput use-cases."

Developer-y

Qubes OS 3.1: The Qubes OS project is about developing an operating system where virtual machines can be used to enforce isolation and security between processes; compartmentalization. The developers have made it work all the way up to the desktop too. In the latest Qubes OS 3.1 release, the challenge of managing such a system has been taken on and now allows for system-wide management. It's a remarkably cool approach to security and privacy.

Node.js and DROWN: If you upgraded to Node 0.12.11 LTS, you won't need to worry about the DROWN attack but if you didn't now would be a good time to upgrade to Node 0.12.12 which bakes in the removal of SSLv2, the mitigation against that attack. LLVM 3.8: The latest LLVM and Clang release brings many varied enhancements to the infrastructure and C Compiler. Expect updates for your toolchain soon on platforms like OS X and FreeBSD which use Clang/LLVM.

Github Thumbs: It's already contraversial but Github have gone and added emoji-style reactions to PRs, Issues and Comments. Will you use them? 👍 or 👎?