Compose Articles

News, views, tutorials and more from Compose

Simple Index Checking with PostgreSQL

Matt Barr of mySidewalk takes up the Write Stuff challenge this time round, looking at quick and simple way to see how well your indexing is performing on your PostgreSQL database. At mySidewalk, we provide planners, engineers, elected offices, and t…

Continue reading »

Common misconceptions about locking in PostgreSQL

Do you understand locking in PostgreSQL? Robert M. Wysocki has come across quite a few people who don't and in this Write Stuff article, he looks at some of the myths that exist around the subject. At the core of any good database is a great locking…

Continue reading »

RethinkDB 2.1 is Here & Out of Beta

RethinkDB 2.1 Comes to Compose With SSL & HA Over the last few months, we’ve been working to bring some of our database offerings out of beta and today RethinkDB joins MongoDB, Elasticsearch, PostgreSQL and Redis as a fully-supported, production-…

Continue reading »

Transporter Driving 3: Restoring and Extracting

We've previously shown some examples of how to use the Compose Transporter for moving data around between databases, and how to upload files to other databases. Transporter can also be used to transform existing data into more useful formats too. For…

Continue reading »

PLV8 for PostgreSQL and CIDR for all

We've been making some small, but significant, enhancements to your database experience at Compose, so we thought now would be a good time to introduce you to the two latest; a newly supported language extension for PostgreSQL and the ability to be m…

Continue reading »

Why Your Startup Should Be Using a Database as a Service

When you're a startup, the most precious thing to you is time so why would you burn that time up administering a database in the cloud? In this article for the Compose Write Stuff program, Almog Koren talks about his experience doing that and how muc…

Continue reading »

Why (and how to) Redis with your MongoDB

Are you loading your database up with work it doesn't really need to be doing? Are you counting things and storing them in their own collections? Are you spending time working out if something was unique just to count the number of unique things you'…

Continue reading »

Building and breaking replica sets in MongoDB

In the first of our Write Stuff articles, Alex Kilpatrick, CTO at BeehiveID, looks at a subject most Compose users won't need to worry about – building and breaking MongoDB replica sets. If you think you have the Write Stuff to write about databases,…

Continue reading »

Transporter's new namespace-aware data transfer

With the release of the latest Transporter, version 0.1.0, the authors have made quite a change to Transporter with its new namespace handling. The TL;DR version is you are now able to define the latter part of the namespace as a regular expression a…

Continue reading »

Introducing himself, Rocco

He's been with us for a while in his role as mascot, but he's so much more than that. And now, he'd like say hello, so we'll hand over to him... Ah, hello. You may have seen me around the Compose site and wondered who is that handsome odd-toed ungula…

Continue reading »