Our users love Studio 3T

SBIA is a team of data scientists working to develop analytical insights to US sports. We made the move to MongoDB in 2018. In doing so, the usual challenges of learning a new database language lead us to discover Studio 3T. Studio 3T has dramatically reduced the learning curve when onboarding new members to the team and is relied upon heavily even for those that have significant experience using MongoDB. For the less experienced user, the visual query builder offers a soft entry into database interaction and helps the user to learn the query language.

For more advanced users, the ability to develop aggregate pipelines stage by stage is tremendously helpful while needing to confirm the output of each stage is as expected before extending the pipeline. And once completed, having the full pipeline delivered in your language of preference, Python for us, provides the very helpful opportunity to deploy the pipeline with a few key-strokes. In production, we take advantage of MongoDB views for web and social content.

Studio 3T provides very easy management of these views. The full integration of Studio 3T with MongoDB makes Studio 3T our product of choice to work with MongoDB, and the clean interface provides advantages to users of all levels of experience.

Additionally, the team at 3T Labs are willing and ready to respond to your feedback. We have seen first hand that requested modifications from our team have been deployed in software updates. At SBIA, we appreciate the effort invested to develop this product and make our everyday lives more efficient. 

SBIA, Sports Betting Innovative Analytics

Terryberry and Studio 3T:
With Studio 3T, Terryberry saves an estimated $185,796 per year

“Lately, in one of our main projects this year, we’ve been separating out functional chunks of this monolithic app and turning them into microservices. These we can release much more frequently, in a much more resilient and agile way. We’re a couple of months away from the end of a 12 month project to to break up the monolith into microservices.”

“Depending on which features customers have enabled, the new microservices architecture maps, as practically as possible, on to the subscription modules.”

“The thing that’s pretty unusual is that we’ve got several thousand collections. We’re kind of switching away from that approach, but in the past we gave each customer its own ‘wall-post’ collection. A social feed is what we call a wall-post and each one is its own collection.

“Studio 3T definitely saves time, when considering that we all work in it all the time. Even just finding that a particular collection exists is pretty useful. So the collection would be prefixed with the customer’s name. Go to that prefix and you’ll get all the collections for that customer. When you have several thousand collections, it’s crucial to be able to find stuff fast. Studio 3T is a lifesaver for that.”

Dan Cumings, Development Manager, Terryberry

WIS and Studio 3T:
A SQL-to-MongoDB migration case study.

“So the problem was, how do I migrate the data that’s been collected over the last 10 years from MySQL over to MongoDB? And that’s when I found Studio 3T. The project is ongoing and I continue to run migrations almost every day, trying to get the data moved over in the perfect way. It’s been invaluable and I don’t know how we would have gotten this far without it, to tell you the truth.”

“And, so the nice thing about Studio 3T, is I can just tell it to drop the connection on the next import and or collection and, just re-run the import process. It takes about, I don’t know, 32 hours, for most of our tables to do a complete migration. So it’s, it’s a little involved, but Studio 3T just does it so perfectly. I mean, I could not imagine trying to do it myself by hand… If it hadn’t been for Studio 3T, I probably would’ve just left it all in the SQL database.”

“You just specify your relationship between which field and which table, and you specify what you’re going to join on. As far as this column relating to that column. And then it automatically goes and interrogates the database and comes back with a list of fields that’ll be available for you after it does this, after it creates this relationship, you just pick… I want these in an array, or I want these in a nested object, or I want these, at the same level as the main object. So really… it’s kind of the funnest part of my job, just because it’s so quick, it’s so effective. And it’s the kind of thing that people missed because, without a tool like this, it would take ages.”

Rand Nix, IT Director, Wakefield Inspection Services