Welcome to Studio 3T 2022.9, the latest release of the MongoDB GUI that saves you a day a week. In this release, we’ve been focussing on something core to MongoDB, the shell itself, and completing our updates to make Mongosh, the Node.js powered MongoDB shell, our new default shell. This is also the first release of Studio 3T which supports creating MongoDB’s native Time Series collections so you can benefit from the time-centered, optimized and compressed collection format. Read on to find out what else is new.
Headline features in Studio 3T 2022.9
The biggest change in Studio 3T 2022.9 is that we are switching the underlying shell technology from MongoDB’s old mongo to the new mongosh. The change should be transparent for most users. If you’ve previously been using the default shell settings, you’ll be migrated over to the new mongosh automatically. This will be the default shell for Studio 3T moving forward, but we will continue to support the older mongo shell for some time. If you’ve already been using mongosh, you’ll be pleased to find we now have Query Assist support too, so there’s full editable tables and super-efficient result retrieval. Learn more in Studio 3T now defaults to the mongosh shell.
Master time and space with support for MongoDB’s Time Series collections. In this release, we’ve added support for creating and working with Time Series collections. If you have a lot of data that’s closely related to time, like Internet of Things or High Frequency trading data, then a Time Series collection could save you storage and speed up your queries. Read more about this in Time Series Collections in Studio 3T.
Users can now be copied and pasted between different MongoDB databases, complete with their configured roles. The process provides a seamless copy of the user in the target database. Due to MongoDB limitations, you’ll need to create a new password for the newly pasted user, but Studio 3T will prompt for that when you perform the paste.
Other Improvements in Studio 3T 2022.9
IntelliShell: IntelliShell’s responsiveness can decrease with bigger shell scripts as there’s more script to take into account for autocompletion. In 2022.9, we’ve boosted the auto-completion performance so you can build bigger shell scripts without slowing down.
Export: A new Clone Unit button that enables the duplication and editing of existing export units has been added.
Tasks: Double-clicking a Task now opens an Edit tab for that Task, where you can edit the tasks details. Renaming a task can be done with the Rename context menu item..
Collections: Focus is moved to the Insert JSON Document editor when it appears.
Reschema: The process of selecting and deselecting fields is more intuitive and simpler. Changing the type or deleting the target _id field is now disallowed.
SQL Table Search: We forgot to mention that in 2022.8, we enhanced the SQL Table Selection dialog. That’s the dialog you see in the Import and Migration when you need to select a table to read from. The dialog now has search powers letting you dig down into table hierarchies using search terms and without pre-expanding sections of the tree.
Studio 3T users are a valuable source of feedback helping make the application better. For the release of Studio 3T 2022.9 we would like to thank Marc Donis for wanting more consistent editor focus, Alejandro Landaverde for spotting replica set connection problems and Rob Gordon for locating some certificate problems on macOS. Finally, thanks to Lewis Wong for isolating a tricky scheduling issue.
Thanks to them, and thanks to you for being Studio 3T users. We’re always listening for your ideas and issues.
Fixed in Studio 3T 2022.9
Aliases -The Search In… tab and tooltips now display aliases.
GridFS – Users of GridFS features will see various refinements to the user interface.
Tasks – Weekly and Monthly scheduled tasks will now only run when scheduled.
IntelliShell – Now able to connect Replica Sets with self-signed SSL certificates.
IntelliShell – Exporting from IntelliShell toArray() is shown as Array-JSON in Operation pane.
Export – Data Masking options only appear when appropriate and can be hidden in General Export Options/Advanced Features settings.
Copy Collections – The dialog is more explanatory when there is a collection name collision.
Collections – The Restore Default Query button operates correctly in the presence of the Visual Query Builder.
Connections – Refresh All will not trigger the appearance of a non-existent “Loading…” collection.
Connections – Search will only search for Functions, Users and Roles if those items are selected to be displayed in Preferences.
Export – When using the Aggregation Editor, the Open dialogs remain correctly labelled.
SQL Migration – More robust handling of array length limits (or lack of them) has been implemented.
For the full history of changes in Studio 3T, see the change log.
Auto-update in the app, or start your free 30-day trial today:Download Studio 3T