Issue 140 — February 3, 2017
Featured
Redis 3.2.7 Released: 'Upgrade Urgency High' — The Redis data structure server gets some important security fixes and upgrading is especially important for Redis Cluster users.
Salvatore Sanfilippo news
Online Migrations at Scale at Stripe — How online payment giant Stripe safely did a large migration of hundreds of millions of ‘Subscriptions’ objects.
Stripe story
ScyllaDB: NoSQL at Ludicrous Speed — 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 — RedisGreen's hosting and monitoring service maps your memory usage and tracks how keys in your database behave over time.
Redisgreen sponsored
SQLite's JSON1 Extension — 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 — VoltDB (GitHub repo) is a horizontally-scalable in-memory SQL RDBMS designed for extremely high throughput scenarios.
Datanami news
Using Google BigQuery to Explore Weather Effects on NYC — 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 Platform tutorial
Marija: Data Exploration and Visualisation for Elasticsearch — A data exploration and visualization tool for unstructured Elasticsearch data to see relationships without any modifications to your data or index.
Dutchcoders tools
Getting Started with GitHub Event Data on Citus — 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 Data code
In brief
MySQL news
[Webinar] Monitoring with Percentiles — In this recorded webinar Baron Schwartz leads an exploration of percentiles & how they're used for monitoring.
VividCortex video sponsored
Adam Vanderbush tutorial
Simon Fredsted tutorial
Periscope tutorial
Peter Zaitsev tutorial
Running Microsoft SQL Server 2016 on Google Cloud Platform — "The openness we’re witnessing from Google and Microsoft is impressive."
Fred Bliss tutorial
Joe Kurleto tutorial
William Lyon tutorial
Benjamin Curtis story
SQL Source Control: track each change to your SQL Server database — Get a full history in your source control system. See who made changes, what they did & why. See how.
Red Gate tools sponsored
Forward3D tools
Pavel Pravosud code
MemSQL code