What's New in Studio 3T 2023.2 - Improvements to the Connections Sidebar

How do you know which database or collection you are working with? In Studio 3T 2023.2, the new connections sidebar tracks which one you are using and shows that node in the tree. We’ve also made it easier to clone collections between connections. You can copy and paste collections from one connection to another, and if the database doesn’t exist, Studio 3T creates it for you.

Headline Features of Studio 3T 2023.2

Connections Sidebar

We introduced the connections sidebar in Studio 3T 2023.1. We’ve improved it in this release and added a new option that makes it easier to see which connection, database or collection a tab is using. When you select another tab or whenever the active tab changes, the Open Connections sidebar automatically selects the appropriate item in the tree. You can turn off this behavior by opening the Preferences dialog and clearing the checkbox Track active tab path in connection tree on the General tab.

Data Types

When creating or editing a document, Studio 3T now stores fields with numeric values using the most efficient data type. So instead of using a floating point number to store a value like 12, an integer is inserted into the document in MongoDB. This is in line with recent changes to the mongo shell.

Improvements in Studio 3T 2023.2

Collections

Collections can now be pasted directly into a connection on the Open Connections sidebar. The new copy of the collection is a clone and the name of the database is copied from the source collection’s database.

IntelliShell

The startup time of the IntelliShell has been greatly improved.
We’ve added new options to all code editors, to quickly duplicate single or multiple lines of code using (⌘ / Ctrl + D), or to delete a line of code using (⌥ / Alt + Backspace).
If problems occur when IntelliShell starts up, the mongo shell output is logged in the error dialog and includes details about the cause of the problem.

Connections

We have improved support for the retryable writes option for MongoDB server connections. The option will now be read from and written to connection strings. Furthermore, IntelliShell now respects this setting when running scripts.
In the past, the Connection Manager did not display connection configurations if they weren’t compatible with the licensed edition (Basic, Pro or Ultimate) or used authentication methods that were available only in higher editions. You can now view, edit, and test all connections, regardless of possible restrictions.

User Shoutouts

Studio 3T users are a valuable source of feedback helping make the application better. For the release of Studio 3T 2023.2, we’d like to thank Dennis Rocha for suggesting that numeric values are stored with the most appropriate data type, Chris Reynoso for spotting a problem when importing BSON archives and retryable writes, and Leendert Dommicent for identifying a time-out issue with tasks that require passwords for connections.

Fixed in Studio 3T 2023.2

Collections

When working with undocked tabs, new tabs now open in the undocked window instead of the main application window.
Fixed and improved the formatting of queries copied from the Collection tab to the system clipboard. This includes curly brace { } alignment and the spacing between field name and value.
Copying a query from the Collection tab to the system clipboard now uses the correct line endings for the target operating system.

Aggregations

Fixed an issue where the Aggregation Editor’s Pipeline flow did not correctly update the shown stage specifications.

Code Editors

Fixed an application failure that occurred when trying to open the context menu in some code editors in Studio 3T.
Fixed an application failure in IntelliShell that occurred when opening the Visual Query Builder after entering a find query statement with no arguments, for example “db.collection.find()”.

Import Wizard

Added the Force disable retryable writes by setting writeConcern to 0 option to the Import Wizard. This allows imports of BSON archives (mongorestore) to be run with retryable writes turned off.