MySQL goes OpenSSL for all with MySQL 8.0.4 - NewsBits

Published

Welcome to NewsBits where you'll find the database, cloud, and developer news from around the net for the week ending January 26th:

And now, the bits...

Database Bits

MySQL 8.0.4: MySQL 8.0.4 has been announced; this is the second release candidate for MySQL 8.0 and adds JSON table views, sets a new default password method (cachingsha2password), brings unicode to regular expression functions and more. Most usefully, it also moves to dynamically linking the OpenSSL libraries in MySQL 8.0 allowing users to select which OpenSSL version they can use. That will be really useful if there's a future TLS security issue which needs an OpenSSL update.

MySQL and OpenSSL: That OpenSSL change also brought other news: from 8.0.4 onwards, all MySQL binaries will be compiled with OpenSSL. The community edition of MySQL has traditionally been compiled with YaSSL rather than OpenSSL. YaSSL is pretty much abandoned and completely lacks support for TLS 1.2. The switch to OpenSSL is, therefore, welcome. Older versions of MySQL Community Edition will continue to come with YaSSL though.

Redis 4.0.7: Redis 4.0.7 has been released and, unlike the recent releases, contains no critical fixes - just lots of useful bug fixes. These include fixes to 32 bit overflows allowing larger data structures, read-only scripts and better buffer handling.

Redis Streams: Salvatore Sanfillipo has also given an update on streams development for Redis saying it is "my main priority" and that "in two months if you upgrade to Redis 5.0 you’ll have production ready streams with consumer groups fully implemented."

PostgreSQL: PostgreSQL 10 laid down a raft of infrastructure for table partitioning in the database, designed to replace the older and somewhat problematic inheritance-based partitioning. As PostgreSQL 11 development continues, we're seeing the developers building on that. You can track things in the PostgreSQL wiki, but briefly, coming features include hash partitioning, support for updates that move rows between partitions, routing to foreign tables, index constraints across partitions and default/catch-all partitions. And, as Michael Paquier blogs, some new features will make table partitioning and indexing much easier than in PostgreSQL 10. PostgreSQL 11 is tentatively scheduled for the third quarter of 2018.

TimescaleDB: The company behind TimescaleDB has raised $16M Series A financing to build the business and the database. TimescaleDB is interesting because it's a time series database built as a PostgreSQL extension. The time series side can maintain high insert rates, essential for scaled up environments with lots of events taking place. For users, they can approach it with all the tooling they usually use in the SQL environment; time scale data looks like normal tables but is actually a hypertable synthesized from right-sized chunks. Find out more and check out the Apache 2 licensed open source project at the TimescaleDB github repository.

Developer Bits

Go: Go 1.10's first release candidate is now available. The preliminary documentation for what is expected to be a February release points many improvements in the toolchain with better code generation, support for Fossil source code repositories and smarter deduction over where the GOROOT for tools is.

Go read: Talking about Go upgrades, this blog posting from GitLab tells the tale of anomalous performance and Go which led to the tracking down of issues in their Git gRPC service... and how Go 1.9 changes fixed it all.

Bootstrap 4: The latest round of Bootstrap, the handy open sourced toolkit for putting language agnostic front-ends together, has been released. It's been a long time coming and during that time, it's switched CSS processor (from Less to SASS - with libsass) and adopted Flexbox as its default layout tool allowing for odd numbers of columns, equal-height columns and more. Bootstrap is all about CSS and layout so these are big changes.

WebSub and ActivityPub: Two new recommendations for moving content around the web have been announced at the W3C, WebSub and ActivityHub. WebSub, formerly PubSubHubbub, is already in use by Blogger and WordPress and allows content to be delivered between hubs using just web hooks for notification. ActivityPub offers a platform to make decentralized social networking. W3C recommendation status means the specifications are ready for wide deployment.

And Finally... Can't remember where you left that expensive satellite? Don't worry, someone is looking and sometimes even they are surprised by what they find. In this case, NASA's IMAGE satellite has been found after being lost since 2005. Read how it was found and about what other things are being sought out in the radio waves of the sky.

NewsBits. News in bits, every Friday at Compose.


Read more articles about Compose databases - use our Curated Collections Guide for articles on each database type. If you have any feedback about this or any other Compose article, drop the Compose Articles team a line at articles@compose.com. We're happy to hear from you.

attribution Rubén Bagüés

Dj Walker-Morgan
Dj Walker-Morgan is Compose's resident Content Curator, and has been both a developer and writer since Apples came in II flavors and Commodores had Pets. Love this article? Head over to Dj Walker-Morgan’s author page to keep reading.

Conquer the Data Layer

Spend your time developing apps, not managing databases.