PostgreSQL 11 gets a release candidate - NewsBits from Compose


Welcome to NewsBits where you'll find the database and developer news from around the net for the week ending October 12th.

Here's those bits in full...

Database Bits


We're out of Betas and into the final stretch with the release of PostgreSQL 11 RC1. This is expected to be the the final version of PostgreSQL 11 before going GA October 18th. The announcement notes several fixes to partitioning by fixing the accidental ability to create multiple primary keys in partitions. If you're interested in the details what was fixed, take a look at PostgreSQL 11 Open Items to track the issues.


Another anticipated RC release is Redis 5 RC6. GA is still on the calendar for an October 17th release. In this release we got some critical bug fixes as well as others related to streams, and we can expect this is what the final version will look like before GA.


There's been a minor release of MongoDB - 4.0.3 that's been released with a number of fixes. One of the fixes is to --repair, a mongod flag which now handles repairing WiredTiger databases more robustly - it'll carry on repairing where it would have previously bailed out and restoring more data. Another is the reintroduction of the countDocuments functions that were mistakenly left out of version 4's shell. However, the changelog shows that most of the changes in this version affected sharding, replication, and storage.


Moving up to minor version to 3.3.10, etcd's changelog shows a lot of additions around monitoring and metrics of networks and servers, and several improvements to warning messages and debugging.

etcd is in the process of moving to and have a new home for documentation . The documentation is still in progress, but they've got some great words for getting set up, monitoring, as well as client architecture and features.

... But that's not all. Check out the etcd playground. It lets get your feet wet setting up etcd as well as simulating how an etcd cluster works in real time using your own input.


Nvidia launched an open-source platform called RAPIDS that uses it's GPUs for accelerating data science and analytics pipelines. Developed with partners like IBM, HPE, Oracle, and Databricks, the platform is based on Python and uses Apache Arrow for in-memory database processing and will soon add Apache Spark as well. IBM is planning to bring RAPIDS to IBM Watson Studio and Watson Machine Learning, and IBM Cloud with GPU-enabled machines. Some RAPID's benefits are that it can accelerate machine learning processing times by up to 50x compared to CPU systems, and it includes interfaces similar to Pandas and Scikit libraries, so it will be familiar to data scientists who want to get started using it quickly.


... and following on from that, BlazingDB announced the release of BlazingSQL, a free-to-use GPU-powered SQL engine built on top of RAPIDS, which let's you run SQL queries on enterprise data lakes using GPU memory. The project is still in it's infancy so we'll be looking out for some changes in the following months.

Developer Bits


[Node.js] version 10.12.0 has been released. The changelog includes quite a few fixes, and changes especially to crypto features. One that stands out is the support for PEM-level encryption, and key-pair generation methods crypto.generateKeyPair and crypto.generateKeyPairSync to generate public and private key pairs supporting RSA, DSA, and ECC encryption methods.


IBM's Strongloop just announced that LoopBack 4, the Node.js framework for building APIs, is now GA. The announcement highlights its move away from a pure JavaScript core to being rewritten in TypeScript and ES2017, and a new developer REST API experience following the OpenAPI spec. Basic support for integrating 3rd party services SOAP, REST, and gRPC has also been added.


While Go's set data structure package by Fatih Arslan has been deprecated for some time, ScyllaDB has released it's own type-safe port of that package called go-set. They've made some significant performance increases with the benchmarks to prove it.


It's something that you probably use every day, but don't quite understand how it works ... TLS connections. We've found a handy illustrated guide to how TLS connections work.

... and something else with a ring to it. MAKERPhone, a DIY mobile phone, is in the early stages of its Kickstarter. If you like building things with Python on an Arduino and want to use it too, check out their promo video and see if it rings with you.

Abdullah Alger
Abdullah Alger is a former University lecturer who likes to dig into code, show people how to use and abuse technology, talk about GIS, and fish when the conditions are right. Coffee is in his DNA. Love this article? Head over to Abdullah Alger’s author page to keep reading.

Conquer the Data Layer

Spend your time developing apps, not managing databases.