Welcome to NewsBits where you'll find the database and developer news from around the net for the week ending October 26th.
- MySQL announces a few releases
- Version 1.0 is available for PipelineDB
- MongoDB 3.6.4 is analyzed by Jepsen
- The pooling middleware PgPool-II is now 4.0
- gRPC-Web is GA
- Module improvements and more in Rust version 1.30
- Kotlin is the fastest growing language on Github
- Predicting the winner of the World Series
- ... and a bot that fixes and patches software bugs
Here's those bits in full...
MySQL announced the release of MySQL Server versions 8.0.13, 5.7.24, 5.6.42, and 5.5.62. Version 8.0.13 got some spatial data changes to
ST_Validate they now support geographic SRS within geometry arguments. This version also got support for functional indexing of key parts, and better error handling messages for OpenSSL errors thanks to a bug fixed by Facebook. Both versions 8.0.13 and 5.7.24 got some security enhancements, as well as numerous bug fixes mostly related to InnoDB, partitioning, and replication.
There appears to be a trend of databases starting out as PostgreSQL forks then becoming full-on PostgreSQL extensions (think TimescaleDB), and PipelineDB is another one. Three years old, open-source, and releasing version 1.0 this week, PipelineDB is used for data analytics by aggregating large streams of time-series data into summary data - think dashboard analytics. The announcement gives you an overview of their history and what version 1.0 brings, while packing in a short tutorial on how it works.
Jespen published an analysis of MongoDB 3.6.4's sharded cluster configuration and casual consistency model, first introduced in 3.6. They provide a very detailed analysis of both, and give some sound advice on how to best utilize casually consistent sessions.
Another release that happened at the end of last week was PgPool-II version 4.0. The popular PostgreSQL middleware's 4.0 release added support for SCRAM and CERT authentication, improved load balancing controls, added PostgreSQL 11 SQL parser and a client message logger. Read more about the release here and how to migrate from your current version.
We're one step closer to Rust 2018 with the latest release of Rust version 1.30. This release adds a couple more advanced macros, adds a progress bar for crate compilation, and adds some new syntax to let you use keywords as identifiers. But, the real focus in this release is on the
use now brings macros and items beginning with
crate into scope, and adds a couple improvements to the module system and its syntax. You can read all about it in the announcement's blog post.
According to Github's Octoverse, Kotlin is the fastest growing language on Github. Behind it, is a growing trend of statically typed languages gaining prominence such as TypeScript, Rust, and Go.
And Finally ...
Are you watching the World Series and betting on who the winner or loser is going to be? If so, we've found a World Series simulator for you. No spoiler alerts here...
... and a bot disguised as a human that finds and patches software bugs. Researcher's in Sweden have been testing out whether bots can be just as efficient as developers in this process. Read more to find out about their results.