MongoDB, A Database with Porpoise

When you have a whale of a performance problem Before you get into dealing with the minutia of database performance, you have to stand back and ask the obvious questions like ‘do I actually need all this data?’. Even with the cleverest querying or aggregation, fine tuning indexes and studying execution plans, you are unlikely [...]

How to Do MongoDB Aggregation Queries Easily

In this post, we're going to take a look at how to do MongoDB aggregation queries with the Aggregation Editor in Studio 3T (formerly MongoChef). We're going to build a query based on the freely available housing data from the City of Chicago Data Portal. Create the MongoDB Aggregation Query Identify the Question MongoDB Aggregation [...]

How to Do MongoDB Map-Reduce Jobs Easily

In this post, we will see how Studio 3T can make your life easy with writing, debugging, and running MongoDB Map-Reduce jobs using the amazing new Map-Reduce screen. In case you haven't yet, download our MongoDB GUI and let's go through a Map-Reduce example together. MongoDB Map-Reduce vs Aggregation Pipeline A Map-Reduce Example Filtering the [...]

New MongoDB Aggregation Pipeline Operators

MongoDB 3.4 has brought out a number of new, very useful aggregation operators for both recursive search ($graphLookup), and faceted search ($bucket, $bucketAuto, $facet, $sortByCount). See below for a brief explanation of each new operator. And of course, both IntelliShell and the Studio 3T aggregation builder fully support the new additions. OPERATOR DESCRIPTION $bucket Categorizes incoming [...]

How to Temporarily Enable/Disable Stages in Your MongoDB Aggregation Pipeline

With the release of MongoChef 4.1.1, we have made it super-easy to quickly disable stages temporarily in your MongoDB aggregation query. This often comes in very handy while debugging. To demonstrate this, let's consider the following simple aggregation query on the City of Chicago's publicly available housing database. Our aggregation pipeline consists of 4 stages: Limit the documents [...]