A roundup of Studio 3T in 2021: All the best bits

2021 has been quite a year for Studio 3T. In case you didn’t catch all the changes that took place, we’ve rounded up the year’s releases into a quick catchup to get you ready for 2022. So let’s dive in starting with…

February, March, and May – 2021.1, 2021.2 and 2021.3

February is for Intellishell – 2021.1

• We started the year boosting the performance of Intellishell. Intellishell is one of our most popular features and we added error highlighting and pinnable query results. We also introduced: the Query Assist button. That makes it clear when Studio 3T was going to optimize your queries to enable inline editing and more.

March is for Tasks – 2021.2

• The Task Scheduler, which lets you run Tasks at some time in the future, was so popular in the top tier of Studio 3T that we decided everyone should have access to it. In March, with 2021.2, being able to set up an Import or Export to run in the future becomes a standard part of all Studio 3T editions. If you have Pro you can schedule Data Compare and Sync and Reschema this way. Ultimate users can use the scheduler to run Data Masking and SQL Migrations too.

May is for Exports and Dark Themes – 2021.3

• Studio 3T’s Data Masking extended its capabilities to mask exported data. That’s where you can obscure or remove data which is too sensitive to export. We also made the Studio 3T dark theme darker and more delightful. Dark theme got softer borders, deeper contrasts, and smoother colors to be easier on the eye.

June, July, and August – 2021.4, 2021.5 and 2021.6

June is for Hotkeys – 2021.4

• In our quest to make Studio 3T the perfect fit for you, we added customisable Hotkeys/Shortcuts. With this feature you can map any keystroke to the command of your choosing. And we added autocompletion to the SQL Query so users could enjoy the same smart help that Intellishell users have. Then we let you edit multiple JSON documents at the same time. Finally, we added a pure JSON view.

July is for Visual Query Builder – 2021.5

• This month, we made the coolness that is Visual Query Builder cooler. All by adding two way synchronization between it and the Query Bar. Edit in one, see it reflected in the other automatically. Data Masking learnt a new trick too: shuffle. Shuffle obscures data by shuffling field values between documents. That means the documents are still obscured but have realistic data in them.

August is for Connections and Integration – 2021.6

• Working with Hackolade, we added the ability to import Hackolade’s data model mapping into Studio 3T’s powerful SQL Migrations. You can read more on MongoDB’s own blog. The Connections Manager got support for Read Preference Tags. These make it easier to direct connections to complex clusters with dedicated nodes, as can be found on MongoDB Atlas. 

September, October, November and December – 2021.7, 2021.8, 2021.9 and 2021.10

September is for Incremental migrations – 2021.7

• Incremental execution was a new feature added to SQL Migration and Export. This addition lets Studio 3T detect what’s new in the source data and only export that new data to the target database.

October is for Column Orders – 2021.8

• Table Views got a big enhancement to their viewability with the addition of custom column orders. Now you are free to drag columns to your preferred position in the view and those changes will automatically persist. We also renamed the tiers of Studio 3T to Basic, Pro and Ultimate with this release. And we added a warning if people disabled Query Assist unknowingly.

November is for Visual Query Builder and more – 2021.9

• Sometimes the smallest changes make the biggest change to the user experience. The Popup Visual Query Builder in 2021.9 is one of those changes. Just grab a field from a table view and start dragging it and the Visual Query Builder pops up to accept your dropping that field into the builder. Simple and compelling. Oh, yes, we also added aggregation index hints, sql migration source flexibility, quicker shell clearing and date aware ID shortcuts

December is for Value Search and More – 2021.10

• The last release of the year brings a new feature, Value Search. It allows a user to search through all the field values in a server’s databases, a database’s collections or just a collection. That search goes all the way down through the embedded documents and arrays hunting for a string or a regular expression. And we added data masking for imports. And remember the Task Scheduler? We made it even more granular in its scheduling with a new user interface.

And Thanks

These were the highlights of the year; there’s also been a vast amount of enhancing and fixing going on throughout the Studio 3T application. Many changes have come from customer reports or suggestions. We’d like to say a big thank you to the users who were involved in 2021’s development, from reporting bugs to suggesting new features:

Ian Winter, Sarel Bar Ilan, John Sewell, Michael Swanson, Jonas de Kegel, Matt Deegler, Mattias Ekberg, Hristo Hristakiev, Ben Cheung, Sven Varkel, Mike Odom, Peter Cankar, Wernfried Domscheit, Vincenzo Palazeti, Andreas Kroll, Alex Ogilvie, Michelle Lewis, Dave Henderson, Scott Coffin, Ed Chalon, Jan Tischler, Andrew Katz, Emin Alexandi, Daragh Lavin, Abdelrahman Hafez, Tim Sullivan, Erik Schannen, Rutger Bevers, Marc Donis, Faizal Martinus, William Luo, Erik Martin, Jörgen Jost, Brad McAllister, Zach Buckner, Trent Deckard, Miljenko Modric, Franz Gerhäuser, Paul Calhoun, Richard Kaplan , Scott Fedorov, Ludovic Peytavin, Sebastian Shinkel, Yaron Levi, Jesse English, David Allardyce, Andy Brown, Chris Ellis, Dean Mann, Joshe Leiba, Michael, Sergey Ivasenko, Ken Whipday, Pramod Anchuparayil, Jayant Agarwal and Bill Robinson.

Thanks to all of you.