Lisa Smith

Articles by Lisa Smith

Metrics Maven: Crosstab Revisited - Pivoting Wisely in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Calculating an Exponentially Weighted Moving Average in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Calculating a Weighted Moving Average in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Calculating a Weighted Average in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Mode d'Emploi - Finding the Mode in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Meet in the Middle - Median in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Beyond Average - A Look at Mean in PostgreSQL

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…

Lisa Smith
Lisa Smith
Metrics Maven: Creating Pivot Tables in PostgreSQL Using Crosstab

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…

Lisa Smith
Lisa Smith
Metrics Maven: Making Data Pretty in PostgreSQL

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…

Lisa Smith
Lisa Smith
Deeper into RethinkDB 2.3 - Fold in Use

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…

Lisa Smith
Lisa Smith
Metrics Maven: Calculating a Moving Average in PostgreSQL

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…

Lisa Smith
Lisa Smith
Visualizing Compose PostgreSQL Data with Leftronic

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…

Lisa Smith
Lisa Smith
Metrics Maven: Window Frames in PostgreSQL

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…

Lisa Smith
Lisa Smith
Using Query String Queries in Elasticsearch

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…

Lisa Smith
Lisa Smith
Cross-Database Querying in Compose PostgreSQL

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…

Lisa Smith
Lisa Smith