Graham Thomson

About Graham Thomson

It all started with a Dragon 32… and has led to here, the most exciting place to be in software and databases right now. After helping hunt for the Higgs at CERN, and building large-scale, intelligent systems in industry, Graham is now doing the best job of all – building world-class tools that empower you to achieve world-class performance. Graham holds a Ph.D. in Computer Science from the University of Strathclyde.

How to Compare MongoDB Collections, Analyze Differences, and Sync Data

In this post, we'll show you how to compare MongoDB collections located in different databases and/or servers, analyze differences between their documents and fields, and sync your data using Studio 3T's Data Compare & Sync feature. The Importance of Comparing MongoDB Databases Choose Your Source and Target Connections Choose MongoDB Collections to Compare Configure Your [...]

How to Query MongoDB with SQL

Introduction Getting Started - A Basic SELECT * Query Edit Results Inline Read-Only Mode Expressing Query Criteria Projection Comparison Combining Expressions Sorting Matching Boolean Values Translating SQL Queries to the MongoDB query language, JavaScript, Java, Python, and C# Explain Data for the Query More Advanced Expressions GROUP BY, ORDER BY and Aggregate Functions Limit and [...]

By |November 13th, 2017|Blog|0 Comments

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 [...]

Autocomplete Queries with IntelliShell, Studio 3T’s MongoDB Shell Integration

In this post, we'll show you how to get started with IntelliShell, Studio 3T's full MongoDB shell integration. With IntelliShell, there's no need to type out complex connection details. Simply click on a connection, database, or collection and open an instance of the IntelliShell at that location. It supports effortless multi-line editing - so creating complex [...]

3T at NoSQL Matters Dublin 2014

  Graham will be at NoSQL Matters Dublin 2014 @nosqlmatters. Come and say hello, and tell us about all the amazing things you’re doing with @MongoDB. I’ll doubtlessly mention our amazing 3T MongoChef, 3T Data Compare and Sync, and 3T Schema Explorer tools for @MongoDB. :-) See you there! @3TSoftwareLabs