---
title: "This week's database news, issue 140"
publication: "DB Weekly"
issue: 140
published_at: "2017-02-03"
canonical_url: "https://dbweekly.com/issues/140"
---

Database Weekly 140   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/140) 

[Database Weekly](http://dbweekly.com) Issue 140 — February 3, 2017     

Featured [Redis 3.2.7 Released: 'Upgrade Urgency High'](https://www.reddit.com/r/redis/comments/5r8wxn/redis_327_is_out_important_security_fixes_inside/?utm_source=dbweekly&utm_medium=email) — The [Redis](http://redis.io/) data structure server gets some important security fixes and upgrading is especially important for Redis Cluster users. Salvatore Sanfilipponews [Online Migrations at Scale at Stripe](https://stripe.com/blog/online-migrations?utm_source=dbweekly&utm_medium=email) — How online payment giant Stripe safely did a large migration of hundreds of millions of ‘Subscriptions’ objects. Stripestory [ScyllaDB: NoSQL at Ludicrous Speed](https://speakerdeck.com/duarten/scylladb-nosql-at-ludicrous-speed?utm_source=dbweekly&utm_medium=email) — A slidedeck looking at the NoSQL database that provides Cassandra compatibility and supports millions of operations per second per node. Duarte Nunes [Explore your memory use over time with RedisGreen](http://www.redisgreen.net/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=expore+time+memory) — RedisGreen's hosting and monitoring service maps your memory usage and tracks how keys in your database behave over time. Redisgreensponsored [![\](https://copm.s3.amazonaws.com/8c5ed2c1.png)](http://www.redisgreen.net/index.html?utm_source=dbweekly&utm_medium=email&utm_campaign=2017a&utm_content=primary&utm_term=expore+time+memory) [SQLite's JSON1 Extension](https://www.sqlite.org/json1.html?utm_source=dbweekly&utm_medium=email) — An extension for SQLite that adds 16 JSON-related functions for working directly with JSON-based data. SQLite [VoltDB 7 Adds Multi-Site and Clustering](https://www.datanami.com/2017/02/01/voltdb-combines-streaming-global-data/?utm_source=dbweekly&utm_medium=email) — VoltDB ([GitHub repo](https://github.com/VoltDB/voltdb)) is a horizontally-scalable in-memory SQL RDBMS designed for extremely high throughput scenarios. Datanaminews [Using Google BigQuery to Explore Weather Effects on NYC](https://cloud.google.com/blog/big-data/2017/02/four-seasons-in-one-post-using-google-bigquery-to-explore-weather-effects-on-nyc?utm_source=dbweekly&utm_medium=email) — With over 150GB of New York City public data, parsing for patterns and insights is a challenge. Learn how to use the CORR function to find correlations. Google Cloud Platformtutorial [Marija: Data Exploration and Visualisation for Elasticsearch](https://github.com/dutchcoders/marija?utm_source=dbweekly&utm_medium=email) — A data exploration and visualization tool for unstructured Elasticsearch data to see relationships without any modifications to your data or index. Dutchcoderstools [Getting Started with GitHub Event Data on Citus](https://www.citusdata.com/blog/2017/01/27/getting-started-with-github-events-data/?utm_source=dbweekly&utm_medium=email) — Getting an example dataset to test out a new database can be as much work as trying the database itself. This example uses GitHub data to guide through how Citus and sharding works. Citus Datacode In brief [What's New in MySQL 8.0](https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html?utm_source=dbweekly&utm_medium=email) MySQLnews [[Webinar\] Monitoring with Percentiles](https://www.vividcortex.com/resources/monitoring-with-percentiles?utm_campaign=DB%20Weekly&utm_source=dbweekly&utm_medium=email) — In this recorded webinar Baron Schwartz leads an exploration of percentiles & how they're used for monitoring. VividCortexvideo sponsored [How to Index Attachments and Files to Elasticsearch](https://qbox.io/blog/index-attachments-files-elasticsearch-mapper?utm_source=dbweekly&utm_medium=email) Adam Vanderbushtutorial [Backing Up Elasticsearch with S3 Compatible Providers](https://simonfredsted.com/1339?utm_source=dbweekly&utm_medium=email) Simon Fredstedtutorial [How SQL Joins Work](https://periscopedata.com/blog//how-joins-work.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [MySQL Sharding Models for SaaS Applications](https://www.percona.com/blog/2017/01/30/mysql-sharding-models-for-saas-applications/?utm_source=dbweekly&utm_medium=email) Peter Zaitsevtutorial [Running Microsoft SQL Server 2016 on Google Cloud Platform](https://medium.com/aptitive/in-under-5-minutes-running-microsoft-sql-server-2016-in-google-cloud-platform-9ccc33681b06?utm_source=dbweekly&utm_medium=email) — _“The openness we’re witnessing from Google and Microsoft is impressive.”_ Fred Blisstutorial [Using EXPLAIN ANALYZE to Debug A Slow SQL Query](https://product.reverb.com/using-explain-analyze-to-debug-a-slow-sql-query-870f6d8ea161?utm_source=dbweekly&utm_medium=email#.pnumz5cav) Joe Kurletotutorial [Combining The BuzzFeed Trumpworld Graph with Government Contracting Data in Neo4j](http://www.lyonwj.com/2017/01/30/trumpworld-us-contracting-data-neo4j/?utm_source=dbweekly&utm_medium=email) William Lyontutorial [How Honeybadger Set Up Postgres for Resiliency](http://blog.honeybadger.io/our-postgres-infrastructure/?utm_source=dbweekly&utm_medium=email) Benjamin Curtisstory [SQL Source Control: track each change to your SQL Server database](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=email&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25324) — Get a full history in your source control system. See who made changes, what they did & why. [See how](http://www.red-gate.com/products/sql-development/sql-source-control/?utm_source=dbweekly&utm_medium=displayemail&utm_content=track_every_change&utm_campaign=sqlsourcecontrol&utm_term=email-25324). Red Gatetools sponsored [Uphold: A Tool for Programmatically Verifying Database Backups](https://github.com/forward3d/uphold?utm_source=dbweekly&utm_medium=email) Forward3Dtools [redis-gcra: Redis-Backed Rate Limiting Based on Generic Cell Rate Algorithm](https://github.com/rwz/redis-gcra?utm_source=dbweekly&utm_medium=email) Pavel Pravosudcode [MemSQL Gets a Spark 2.0 Connector](https://github.com/memsql/memsql-spark-connector?utm_source=dbweekly&utm_medium=email) MemSQLcode    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/140) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK