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).
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
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.
Our Newest Newsletter: MongoDB Weekly
— We’re covering the vast ecosystem around the most popular non-relational NoSQL database. Check out
this sample issue.
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
Hazelcast In-Memory Data Grid Now for Go Developers Too
— Go now has
an official client
, a popular, open source JVM-based in-memory data grid.
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.
Fishing for Graphs in a Hadoop Data Lake
— Exploring many small regions of a graph at low latency using specialized graph & multi-model databases.
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.
MongoDB Is Now Available in All Google Cloud Regions Via Atlas
How the Citus Distributed Database Rebalances Data
— Citus is an extension for scaling Postgres horizontally.
How Smelly are Your (Database) Relations?
Tuning MySQL: 3 Simple Tweaks
Calculating a Customer's Lifetime Value with SQL
Optimising Graph Lookups in MongoDB
SQL Server 2017 on Linux Webcast Series
— You have to register but they’ll all on demand now.
Use SQL in MongoDB? Of Course You Can. We'll Show You How
5 Real World Uses for Redis
Supporting Operational Systems in a Big Data World
PostgreSQL's Hidden Gems
fx: A Command-Line JSON Processing Tool