Issue 169 — August 25, 2017
A Guide to Writing Better SQL Queries — A two part series (part 2 here) digging into how SQL queries are processed, some anti-patterns, and where big-O complexity gets involved.
Karlijn Willems tutorial
Finding all Palindromes Contained in Strings with SQL — Using SQL for unusual and complex tasks can be both fun and a great way to learn more.
Lukas Eder tutorial
Get a preview of what's coming in MongoDB 3.6 — Watch as MongoDB CTO, Eliot Horowitz, explains his commitment to improving, expanding, and innovating on MongoDB before walking through several major improvements coming in MongoDB 3.6 including change streams, retryable writes, and more.
MONGODB sponsored
Amazon Aurora Under The Hood: Quorums and Correlated Failure — Anurag Gupta discusses the design considerations and technology underpinning Aurora, AWS’s highly distributed relational database.
Amazon Web Services story
Understanding Correlated and Uncorrelated Sub-Queries in SQL — Sub-queries are queries within another query, but they come in two types: correlated and uncorrelated.
Ben Richardson tutorial
In-Memory Database Provider Redis Labs Raises 44ドルM — Redis Labs, a database company focused on Redis, has raised 44ドル million in a funding round led by Goldman Sachs.
Matthew Lynley news
Index Sorting Coming to Elasticsearch 6.0 — Will allow users to optimize indexes to store documents on disk in a specific order.
Elastic Blog news
M|18 MariaDB User Conference Call for Papers Open — Takes place in February next year in New York.
Shane Johnson news
Computer World news
The 2017 Firebase Summit is coming to Amsterdam 31 October 2017 — Attend technical sessions, instructor-led codelabs & demos, and meet-ups with Firebase developers.
Google, Inc. sponsored
Michelle Young tutorial
Hacker Noon tutorial
Kyle Rankin tutorial
Amazon Web Services story
Vadim Solovey story
Best Practices for Architecting Highly Monitorable Applications — Is your application easy to monitor in production? Many applications are, but sadly, some are designed with observability as an afterthought.
VividCortex sponsored
Predixy: A High Performance Redis Proxy — A fully featured Redis proxy with support for Sentinel and Cluster.
Joyield, Inc. tools
2nd Quadrant tools