---
title: "Redis 5 and PostgreSQL 11 Released"
publication: "DB Weekly"
issue: 226
published_at: "2018-10-19"
canonical_url: "https://dbweekly.com/issues/226"
---

This week's database news       

#226 — October 19, 2018 

[Read on the Web](https://dbweekly.com/issues/226)   

Database Weekly  

[Redis 5 Released](https://groups.google.com/d/msg/redis-db/l0OXDAlwosU/JyYfeQpyBwAJ) — The popular data structure key/value store takes another stride forward with version 5 which includes support for [streams](https://redis.io/topics/streams-intro), improvements to defragmentation, a new [LOLWUT](http://antirez.com/news/123) command(!), and numerous other refactorings and tweaks. 

Salvatore Sanfilippo   

[PostgreSQL 11 Released](https://www.postgresql.org/about/news/1894/) — A long awaited major release for the popular RDBMS that now includes hash partitioning, covering indexes, transactions in stored procedures, [and more.](https://pgdash.io/blog/postgres-11-whats-new.html) Don’t forget, we also have [a Postgres newsletter](https://postgresweekly.com/?utm_source=db&utm_medium=email&utm_campaign=cross_promo&utm_content=226) :-) 

PostgreSQL Global Development Group   [![\](https://copm.s3.amazonaws.com/2efdc5b0.png)](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=newsletter&utm_medium=cooper&utm_campaign=Oct18) 

[Love SQL but Want to Try MongoDB? Get the Best of Both, with Studio 3T](https://studio3t.com/knowledge-base/articles/create-mongodb-joins-with-sql/?utm_source=newsletter&utm_medium=cooper&utm_campaign=Oct18) — Get started fast with a variety of SQL Join queries in MongoDB. 

Studio 3T sponsor   

[AWS Announces Managed Databases for Amazon Lightsail](https://aws.amazon.com/blogs/aws/new-managed-databases-for-amazon-lightsail/) — Lightsail is essentially AWS’s VPS offering where EC2 instances and storage are packaged up in a fixed monthly fee in a style similar to providers like DigitalOcean or Linode. Now, AWS is offering the same with databases - MySQL only for now. 

Amazon Web Services, Inc.   

[MongoDB Issues New 'Server Side Public License' for Its Community Edition](https://www.mongodb.com/press/mongodb-issues-new-server-side-public-license-for-mongodb-community-server) — A new license (to be used on the community edition of MongoDB from here on) specifies how MongoDB can be _run as a service_. The key change is those running MongoDB as a service need to open source their unique contributions. 

MongoDB, Inc.   

[Analysts Get A Guiding Hand with 'TrustCheck'](https://www.datanami.com/2018/10/17/analysts-get-a-guiding-hand/) — It’s just one part of a commercial product but _TrustCheck_, a feature that can give users instant feedback on how ethical and legally compliant their queries are sounds interesting. This could be a feature other systems will eventually implement in a world with increasing numbers of regulations around data use. 

Datanami   

[Managing Backup and Replication for Large PostgreSQL Databases](https://medium.com/leboncoin-engineering-blog/managing-postgresql-backup-and-replication-for-very-large-databases-61fb36e815a0) — Postgres has different models for making backups with various pros and cons, but at scale this company swears on Barman, `pg_basebackup` and `pg_receivewal`. 

Flavio Gurgel   

[A Developer’s Guide to MongoDB Sharding](https://severalnines.com/blog/developer-s-guide-mongodb-sharding) — Provides an overview of sharding in MongoDB and how it can be used concurrently with other methods to achieve high availability. 

Onyancha Brian Henry   

[1-Click Access to Any Database or Server in Any Environment](https://www.strongdm.com/?utm_source=db_weekly&utm_medium=email&utm_campaign=SDM) — Grant or revoke temporary access using your SSO provider & audit every query, SSH & RDP command with strongDM. 

strongDM sponsor   

[How memcached's Cache Replacement Algorithm was Improved](https://memcached.org/blog/modern-lru/) 

Dormando   

[Hadoop And Spark Get A Vector Performance Boost](https://www.nextplatform.com/2018/10/17/hadoop-and-spark-get-a-vector-performance-boost/) — A look at how a chip manufacturer and the creators of Hadoop have been working together to accelerate certain workloads. 

The Next Platform   

[Is it Time to Drain the Data Lake?](https://www.datanami.com/2018/10/15/is-it-time-to-drain-the-data-lake/) — An argument that ‘data lakes’ aren’t particularly useful unless you’re monitoring and acting upon what goes into them in real time. 

Dominic Wellington   

[Is Hadoop Officially Dead? (No.)](https://www.datanami.com/2018/10/18/is-hadoop-officially-dead/) — A hot take based on last week’s news about the merging of two Hadoop heavyweights. This is a good summary of where the Hadoop market is at right now. 

Alex Woodie         

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom