Metrics Maven: Window Functions in PostgreSQL

Metrics Maven: Window Functions 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
Do More with Compose PostgreSQL using Zapier

Do More with Compose PostgreSQL using Zapier

Zapier is a service which allows you to create custom integrations among a variety of applications, including PostgreSQL. Bel…

Lisa Smith
Lisa Smith
Deeper into Postgres 9.5 - New Group By Options for Aggregation

Deeper into Postgres 9.5 - New Group By Options for Aggregation

If you use PostgreSQL, you'll know that its relational model and aggregate functions lend themselves easily to the creation o…

Lisa Smith
Lisa Smith
PostgreSQL 9.5 now on Compose

PostgreSQL 9.5 now on Compose

PostgreSQL 9.5 is now available with Compose. To be precise, PostgreSQL 9.5.2, the very latest release is now available on Co…

Lisa Smith
Lisa Smith
Elasticsearch Query-Time Strategies and Techniques for Relevance: Part II

Elasticsearch Query-Time Strategies and Techniques for Relevance: Part II

In this article, we're going to look at some of the built-in tools that Elasticsearch provides for impacting relevance scores…

Lisa Smith
Lisa Smith
Elasticsearch Query-Time Strategies and Techniques for Relevance: Part I

Elasticsearch Query-Time Strategies and Techniques for Relevance: Part I

In this 2-part series, we'll look at a couple different strategies for applying some of Elasticsearch's built-in tools at que…

Lisa Smith
Lisa Smith
Loading Google Analytics data to PostgreSQL using Python

Loading Google Analytics data to PostgreSQL using Python

Do you have Google Analytics data you'd like to load to a database for better reporting and analysis? We do. Here's a proof-o…

Lisa Smith
Lisa Smith
Indexing for full text search in PostgreSQL

Indexing for full text search in PostgreSQL

Do you have textual content in PostgreSQL that you'd like to be able to search more effectively, but you're not sure you're r…

Lisa Smith
Lisa Smith
Connecting and loading data to PostgreSQL with Perl

Connecting and loading data to PostgreSQL with Perl

Let's walk through a handy little Perl script that connects and loads a CSV data file to PostgreSQL. We'll also see how to ru…

Lisa Smith
Lisa Smith
How scoring works in Elasticsearch

How scoring works in Elasticsearch

In this article, we'll take a look at how relevancy scoring is done in Elasticsearch, touching on information retrieval conce…

Lisa Smith
Lisa Smith
Elasticsearch.pm - Part 4: Querying and Search Options

Elasticsearch.pm - Part 4: Querying and Search Options

In this final article of our Elasticsearch.pm series, we'll finish up by looking at querying and some of the search options.…

Lisa Smith
Lisa Smith
Elasticsearch.pm - Part 3: Index Options

Elasticsearch.pm - Part 3: Index Options

In this third article of our Elasticsearch.pm series, we're going to get into index options for our Elasticsearch instance. I…

Lisa Smith
Lisa Smith
Elasticsearch.pm - Part 2: Basic Document and Index Methods

Elasticsearch.pm - Part 2: Basic Document and Index Methods

This article looks at how you can use the Search::Elasticsearch perl module to create, update, and delete indexes as well as…

Lisa Smith
Lisa Smith
Holiday Wishes from Compose

Holiday Wishes from Compose

Compose wishes everyone a wonderful holiday season! The holidays are a time to spend with family and friends, eat lots of foo…

Lisa Smith
Lisa Smith
Compose PostgreSQL for Your Segment Warehouse

Compose PostgreSQL for Your Segment Warehouse

Learn how to set up your Segment warehouse on Compose PostgreSQL. This article walks you through the process - it's as easy a…

Lisa Smith
Lisa Smith