NewsBits: PostgreSQL 10 debuts

Welcome to NewsBits where you'll find the database and developer news that you need for the week ending October 6th:

  • PostgreSQL 10 arrives.
  • And so does a pgAdmin update.
  • PostGIS is updated too.
  • Redis begins streaming.
  • A small bump for etcd.
  • Spring users get a new AMQP package.
  • Go for a security update.
  • PyPy now runs Python's NumPy and Pandas.
  • Git is encrypted by Keybase.
  • macOS users get touchy with new VS Code.
  • Atom rolls out Atom IDE.
  • Cowboy up for HTTP/2 on Erlang.

Here are the bits:

Database Bits

PostgreSQL 10: The latest PostgreSQL, 10, is now available. We had been expecting more release candidates but it seems the way was clear for the updated PostgreSQL to go straight out. The new release is a landmark release if only for the versioning as PostgreSQL moves from denoting a major release with the second digit of the version (9.2, 9.3, 9.4, 9.5, 9.6...) and starts using the first digit (10.0 is the release, 10.1 will be a minor patch and 11.0 will be next years major release).

But enough of why every version management system will get confused. PostgreSQL 10 is full of good things. Logical replication looks to provide a whole new layer of smarter replication, while declarative table partitioning is going to make the job of splitting up big datasets a whole lot easier.

There's also big improvements to the parallel query support introduced in 9.6, quorum commits for traditional replication and hardened authentication encryption. Those are just the headlines of course. The release notes have all the details, What's new in postgres 10 offers a more digested version and PostgreSQL 10 New Features (pdf) offers a walkthrough complete with examples.

pgAdmin 4: Hot on the heels of PostgreSQL 10, pgAdmin 4 2.0 got released. As well as support for the new Postgres release, there's improved icons and embedded fonts, faster startup, web and desktop variants bundled together and detailed dashboards on connecting to a server.

PostGIS: Just before the release of PostgreSQL 10, the PostGIS developers released PostGIS 2.4.0. The update supports the new release while dropping 9.2 support and making better use of PostgreSQL's parallel query optimization. There's also interesting changes in PostGIS comparison operators.

Redis Streams: Redis is getting a new general purpose data structure in the form of streams. Antirez, aka Salvatore Sanfilippo, introduced the concept in a blog post of a list with time based (plus sequence number) ids which retain fields and values and allow multiple clients to track their own read position through the stream of data. It looks likely to open up a whole new set of use cases for Redis and it is likely to be availabile in Redis 4.0 by the end of the year; there's already a "streams" branch of Redis where the XADD, XRANGE and XREAD commands (streams commands start with an X) are available.

etcd 3.2.8: The CoreOS developers released etcd 3.2.8 which is a couple of fixes for the v2 client and grpc-proxy.

Spring AMQP: Java-using RabbitMQ consumers may be interested in the new 2.0.0 Spring AMQP release with Java 8, Spring Framework 5.0 and amqp-client 5.0 support.

Developer bits

Go: Make sure you've updated your Go to 1.8.4 or 1.9.1. A security update for Go addressed source code control problems and a flaw in the smtp library.

PyPy 5.9: Python developers may like to know that PyPy 5.9 is now working with NumPy and Pandas as C-API support for the alternative Python runtime is tuned up.

Keybase's Git: The good folks at Keybase have just introduced end-to-end encrypted git which builds on their encryption/keys app (with public verification) and gives you straight git (no githubby extensions) where the repo is encrypted on their server. And they added Teams so you can coordinate within a group of trusted users.

VS Code: The monthly drop of Visual Studio Code this month brings up version 1.17 with macOS TouchBar support (for navigating back and fore through documents and running the debugger), faster terminal rendering, more documentation, more color for regex and format strings and more. Oh and a new logo (orange means stable, green means preview release).

Atom: Github's Atom 1.21 has also arrived with the new Language Server Integration and Atom IDE, built on a new filesystem watcher, extended Github support including Pull Requests and more. And the beta for 1.22 may have nailed the long pauses that happened getting git status and make it easier to match brackets.

Cowboy: Erlang users can now get their hands on Cowboy 2.0, a modern web server. Version 2.0 brings HTTP/2 support and compressed websockets.

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.