Compose Articles

Compose Tooltime 2016

As is becoming Compose tradition, in our annual Tooltime we look at the tools, both digital and physical, that Compose folk would not be without. Our tools selection has evolved since 2014 and 2015 and as the content curator, I like to keep track of…

Continue reading »

Compose Travelogue - Marin

The Compose Travelogue moves on in the Bay Area, from meeting the East Bay Composers and gets off the ferry at Marin where we meet up with Michele. We don't stay by the ferry for long though, as Michele whisks us away and we head over to San Rafael a…

Continue reading »

Introducing FIDO Universal 2nd Factor Authentication

To better help you ensure your account is safe and secure with Compose, we've expanded our authentication system to support FIDO Universal 2nd Factor (U2F). If you're currently accessing your Compose databases, now would be a good time to increase th…

Continue reading »

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 one sweet little package. In this article, we'll take a closer look at why query string queries are special and how you can…

Continue reading »

Making the most of Compose - Human Design

This is the first in a series of case studies of Compose database users and how Compose enables them to do their business. This is Making the most of Compose. When your business is all about providing the highest quality experiences for your clients,…

Continue reading »

Compose Travelogue - East Bay

The Compose Travelogue continues and down at San Francisco's Ferry Building, I meet up with Jon and Mat. Jon is Compose's marketing whizz and Mat is a Compose developer, but there's one thing they share - the Compose remote lifestyle. Jon is based in…

Continue reading »

Compose's Little Bits #31 - PostgreSQL 10?, Horizon, OrientDB, Firebase, Meteor and Heroku

A potential change in PostgreSQL version numbers, a new backend for JavaScript apps wanting to get the full power of RethinkDB, a new release of OrientDB, the revamped Firebase from Google, Meteor's 1.4 plans and free SSL at Heroku - all the links th…

Continue reading »

Compose Travelogue - San Francisco

After a flight which saw hour-long TSA queues at Chicago's O'Hare airport, we touched down in San Francisco ready to meet all the Compose people who work around the Bay Area. San Francisco itself is gently cooking itself, both literally with the sun…

Continue reading »

Turn Small Data Into Smart Data. Part 1: The Star Schema

This is the first of a three part series focused on an open source tool chain for small data business intelligence. Part 1 explores the history and reasoning behind dimensional modeling via a use case: online video viewing analysis. We examine the de…

Continue reading »

Cross-Database Querying in Compose PostgreSQL

In Compose PostgreSQL you can now perform cross-database queries using some extensions we've recently made available: postgres_fdw and dblink. In this article we'll walk through how to set up your database to take advantage of them. Both the postgres…

Continue reading »