How to Create a MongoDB View

Creating a MongoDB View in Studio 3T Creating a MongoDB View from a SQL Query Simple SQL Queries (Not So) Simple SQL Queries In SQL databases, a view lets you pre-specify a query so that you can quickly view its results. Think of it as a virtual shortcut - an additional layer that doesn’t take [...]

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

A Couple of MongoDB Limericks

Today is World Poetry Day, so we've taken a leaf out of Phil's book and wrote a couple of MongoDB limericks - executable and all - in JSON query syntax. Studio 3T, It Must Be db.companies.find({ "country" : "Germany", "number_employees" : { "$gt" : NumberInt(3) }, "office_sport" : "Ping-Pong", "takes_coffee" : "long", "favorite_database" : "MongoDB" }) [...]

How to Connect to Compose with Studio 3T

In this tutorial, we'll show you how to connect to your Compose-hosted MongoDB database with Studio 3T, the GUI for MongoDB. Prerequisites: Sign up for a Compose account through their free 30-day trial. Download our MongoDB GUI on your Windows, Mac, or Linux machine. Connect to Compose Connect to Studio 3T Connect via MongoDB connection string [...]

MongoDB Schema Discovery and Exploration

One of the great things that we love about MongoDB is of course that it's schema-less, which makes adapting your application to changing requirements a breeze. That said, your data will often have a fixed implicit schema, e.g. each document in your employees collection will likely always have a first and last name field. So, making sure [...]

MongoDB Dropped ACID – And It’s Kind of a Big Deal

Nope, we’re not talking chemicals here :-) MongoDB recently made a giant announcement that ACID will be supported in multi-document transactions with the release of 4.0. But what’s ACID anyway? What is ACID? In the database world, ACID stands for Atomicity, Consistency, Isolation, and Durability. This set of properties has been the defining feature of [...]

By |February 26th, 2018|Blog|0 Comments

The Main Types of NoSQL Databases

In this post, we'll walk you through a (very) brief history of NoSQL, then explain the main types of NoSQL databases with examples and use cases for each. The tl;dr History of NoSQL Types of NoSQL Databases   The tl;dr History of NoSQL (It actually stands for "not only SQL") Coined in 1998 by Carlo Strozzi, [...]

By |February 21st, 2018|Blog|0 Comments

What’s New in Studio 3T 2018.2 | Query Code Added to Aggregation Editor, Export Comparison Results, and More

In this release, Studio 3T adds Query Code to Aggregation Editor and the ability to export comparison results from Data Compare & Sync, among many other improvements. Query Code Added to Aggregation Editor Query Code - the Studio 3T feature that lets you automatically translate MongoDB and SQL queries to JavaScript, Python, Java, C#, [...]