#282 — November 29, 2019
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.)
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