Issue 189 — February 2, 2018
Advanced SQL: Common Table Expressions — The latest in a series discussing advanced SQL concepts in the context of how they improve more elementary SQL. This time, temporary in-query tables in the form of common table expressions (CTE).
Michal Konarski tutorial
Scaling Time Series Data Storage at Netflix — How the video streaming service has evolved a time series data storage architecture through multiple jumps in scale.
Duvedi, Li, Garg, and Fisher-Ogden story
SelectStar: Turn Database Monitoring Information Into Insight — SelectStar is the only database monitoring solution that digs into today’s modern data tier to provide recommendations, including those that may increase query speeds. Like what you see? You can take action immediately with a single click.
SelectStar sponsored
Our Newest Newsletter: MongoDB Weekly — We’re covering the vast ecosystem around the most popular non-relational NoSQL database. Check out this sample issue.
Cooperpress news
Building a Fast Data Ingestion Pipeline to Redshift — A data team built out a data ingestion pipeline for loading data from S3 into Amazon Redshift. Over a week, they increased its performance 1000x - here's the story of how.
Alex Fish and Jason Ng story
Hazelcast In-Memory Data Grid Now for Go Developers Too — Go now has an official client for Hazelcast, a popular, open source JVM-based in-memory data grid.
Neil Stevenson tutorial
Building a Full-Text Search App Using Docker and Elasticsearch — A thorough tutorial that brings three key technologies together: Node.js, Docker, and the Elasticsearch document database.
Patrick Triest tutorial
Fishing for Graphs in a Hadoop Data Lake — Exploring many small regions of a graph at low latency using specialized graph & multi-model databases.
Max Neunhöffer tutorial
Citus 7.2: Distributed Postgres W/ CTEs, Complex Subqueries, Set Operations, and More — The Citus 7.2 extension to Postgres now includes distributed database features such as expanded support for distributed SQL and the distribution of complex subqueries across multiple nodes, and more.
citusdata news
mongodb sponsored news
How the Citus Distributed Database Rebalances Data — Citus is an extension for scaling Postgres horizontally.
citusdata tutorial
Tushar Sharma tutorial
Rich Barrett tutorial
Luba Belokon tutorial
Guy Harrison tutorial
SQL Server 2017 on Linux Webcast Series — You have to register but they’ll all on demand now.
Microsoft video
Studio 3T sponsored
Ryan McCue tutorial
Lockwood Lyon tutorial
Craig Kerstiens opinion
Anton Medvedev code