MySQL releases and gRPC-Web is GA - NewsBits at Compose

Published

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

Here's those bits in full...

Database Bits

MySQL

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_Area and 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.

PipelineDB

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.

MongoDB

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.

PgPool-II

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.

Developer Bits

gRCP-Web

gRCP-Web is now GA! This is a JavaScript npm module that allows your browser client to talk to your gRPC services in the backend. This means that you don't need an HTTP server to talk to both ends, giving you an end-to-end gRPC web application experience which is an alternative to REST. Check out the announcement and roadmap of what's to come.

Rust

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 keyword. 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.

Kotlin

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.

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.