Articles by Lisa Smith
Metrics Maven: Crosstab Revisited - Pivoting Wisely in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Calculating an Exponentially Weighted Moving Average in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Calculating a Weighted Moving Average in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Calculating a Weighted Average in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Mode d'Emploi - Finding the Mode in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Meet in the Middle - Median in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Beyond Average - A Look at Mean in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Creating Pivot Tables in PostgreSQL Using Crosstab
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Metrics Maven: Making Data Pretty in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Deeper into RethinkDB 2.3 - Fold in Use
Earlier this year, RethinkDB released their Fantasia 2.3 version. In this article, we're going to take a closer look at one o…
Metrics Maven: Calculating a Moving Average in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Visualizing Compose PostgreSQL Data with Leftronic
At Compose, we use Leftronic for metrics at-a-glance. Leftronic is a real-time, browser-based data visualization service that…
Metrics Maven: Window Frames in PostgreSQL
In our Metrics Maven series, Compose's data scientist shares database features, tips, tricks, and code you can use to get the…
Using Query String Queries in Elasticsearch
In Elasticsearch, query string queries are their own breed of query - loads of functionality for full text search rolled into…
Cross-Database Querying in Compose PostgreSQL
In Compose PostgreSQL you can now perform cross-database queries using some extensions we've recently made available: postgre…