#282 — November 29, 2019

Read on the Web

Database Weekly

Amazon Athena Adds Support for Running SQL Queries Across Multiple Sources — You can now run SQL queries across data stored in relational, non-relational, object, and custom data sources – so just imagine running a query joining S3, Redshift, CloudWatch, MySQL, DynamoDB, etc. Currently in preview in one AWS region for now.

Amazon Web Services

SQL Performance Explained: The Database Tuning Book for Developers — In honor of next Monday’s Cyber Monday (a sort of digital answer to Black Friday, I guess), Markus has temporarily made his fabulous SQL performance book available for free for a few days. Your reading for this weekend is all set!

Markus Winand

Managed PostgreSQL by DigitalOcean — Deploy a highly scalable PostgreSQL cluster with no admin overhead.

DigitalOcean sponsor

QuestDB: A Performance-Focused 'NewSQL' Time-Series Database System — A new(ish) Apache-licensed, Java-built, ‘NewSQL’ relational database focused on fast time-series data processing. Works over HTTP, via a Web console, or even wire protocols (PostgreSQL and Influx).

QuestDB Limited

SQL Tops the List Of Most In-Demand Tech Skills — SQL is the most in-demand tech skill by US employers claims the IEEE.

IEEE Spectrum

You Can Now Bring Your Own Encryption Keys to Amazon DynamoDB — DynamoDB has introduced support for customer managed customer master keys (CMKs) to encrypt DynamoDB data, a.k.a. BYOK.

Amazon Web Services

💻 Jobs

Full Stack Engineer — Expensify seeks a self-driven individual passionate about making code effective, with an understanding of algorithms and design patterns.

Expensify

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.

Vettery

📒 Everything else

▶  The Most Popular Databases Between 2004 - 2019 — An animated month-by-month view of the TOPDB index, a sort of database equivalent of the TIOBE index, that analyzes the popularity of database names on Google.

YouTube

Auto Trader’s Tips for a 3-Step MongoDB Atlas Migration — Auto Trader’s Principal Database Engineer describes how they successfully migrated their databases to MongoDB’s Atlas and Google Cloud Platform.

Marissa Jasso (MongoDB, Inc.)

UUIDs are Popular, but Bad for Performance (in MySQL)

Yves Trudeau

eBook: Best Practices for Optimizing Postgres Query Performance — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook.

pganalyze sponsor

Introducing Real-Time Anomaly Detection in Open Distro for Elasticsearch — Amazon’s Elasticsearch and machine learning teams have open sourced and released anomaly detection plugins for their controversial Elasticsearch distribution.

Amazon Web Services

SQL: A SQL-ish Language for Working with DynamoDB — If you’re using DynamoDB but you really like SQL, here’s an option.

Steven Arcangeli

▶  Processing Streaming Data with KSQL

Tim Berglund