#280 — November 15, 2019

Read on the Web

Database Weekly

Modern Data Practice and the SQL Tradition — A collection of thoughts on the friction between SQL and ‘modern’ approaches to data science and management that ultimately comes down to backing modern SQL and RDBMS generally as the most qualified tools for most data management jobs.

Florents Tselai

AWS Data Exchange: Find, Subscribe To, and Use Data Products — Another week, another new AWS service! Data Exchange is an addition to AWS Marketplace that contains “licensable data products from over 80 data providers” in areas like financial services, health care / life sciences, geospatial, weather, and mapping.

Jeff Barr

How Heroku Operates its Multi-Tenant Apache Kafka Services — Thousands of developers use Apache Kafka on Heroku to process millions of transactions. Learn how Heroku has architected their infrastructure to meet your needs, even as your events are processed in a multi-tenant environment.

Heroku sponsor

ArangoDB Oasis: A New, Fully-Managed Multi-Model Database Service — Built, unsurprisingly, on the ArangoDB multi-model database, Oasis is a fully-managed graph database, document, and key-value store, as well as a full-text search engine. It’s available on Google Cloud and AWS for now with Azure set to follow.


Architecting Petabyte-Scale Analytics by Scaling Out PostgreSQL on Azure — A case study of using Azure and Citus’s Postgres extension to significantly scale Postgres horizontally up to managing 1.5 petabytes of data (all stored on SSD!) This is the story of one very serious Postgres deployment and use case.

Claire Giordano

Microsoft Announces Azure Synapse Analytics — Described as a ‘limitless’ analytics service that brings together both data warehousing and big data analytics – essentially, a bridge between data warehouses and data lakes, and the ‘next evolution of Azure SQL Data Warehouse’.

Rohan Kumar

Oracle DB 19c Improves JSON Standard Conformance — It’s not just PostgreSQL that’s trying to be the king of JSON storage. Oracle DB 19c has closed some major gaps in its SQL/JSON path implementation.

Markus Winand

💻 Jobs

Calling All MongoDB Consultants - Work Remotely from Anywhere — At Percona you'll get a chance to see and work on any database architecture imaginable. We're looking for MongoDB experts.


Find a Job Through Vettery — Make a profile, name your salary, and connect with hiring managers from top employers. Vettery is completely free for job seekers.


📒 Everything else

Working with the New Microsoft.Data.SqlClient — If you’re a .NET developer working with SQL Server, this is a must watch. Anyone else, no.

Channel 9

Hash Joins in MySQL 8 — A new approach to executing joins in MySQL 8 that uses hashes to be more efficient than using nested loops.

Erik Frøseth

Some Distributed Systems Vocabulary — Brief, high level explanations of CAP, ACID, Harvest and Yield, BASE, CALM, consistency levels, and more. All things worth knowing (or knowing how to look up!)

Will Larson

How to Encrypt Your Existing AWS RDS Database — And without loss of data and with minimal downtime too.

Vincent Larrat

A Brief Interview with Markus Winand — Markus, of Modern SQL fame, answers a few questions about how to get better at SQL.

Dimitri Fontaine

How Walmart Optimizes Search Index Generation using a Secondary Cache — Walmart’s full item catalog is stored in Cassandra and a search index is generated via a Spark job. The performance was poor, however, so Redis was introduced to speed things up.


The Easiest Way to Use MongoDB? It’s Studio 3T. Try It Today — Code translation in a click? Easy SQL to MongoDB Migration? We’ve got it - and more. Get your 30-day trial today to see.

Studio 3T sponsor

Accelerate SQL Server Always On Deployments with AWS Launch Wizard — AWS has introduced a wizard to let users spin up SQL Server deployments quickly (coupled with things like block storage and a private cloud). The wizard itself is free with the provisioned services at their normal cost.

Amazon Web Services

pyBlazing: A Lightweight, GPU Accelerated, SQL Engine Built On RAPIDS


PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released — Fixes over 60 bugs that were reported in the last several months.

PostgreSQL Global Development Group