#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.) |
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 |