2024.2.0 (13-Mar-2024) ====================== - New: Exports - Added a new type of export that allows writing documents directly into an MS Excel file. - Improved: Connection Manager - Added new options on the Advanced tab that allow setting the Write Concern for a connection configuration. - Improved: Visual Query Builder - Added labels such as Where, And, Either, and Or to the Query section of the VQB for better readability. - Improved: Operations View - Added task names to the entries shown in the Operations View for increased clarity. - Fixed: Data Compare & Sync - Fixed an issue where the export of differences could hang when documents have been deleted in the meantime. - Fixed: Data Compare & Sync - Added back the ability to set source or target connections by dragging and dropping them from the Connection Tree. 2024.1.0 (06-Feb-2024) ====================== - New: Collection Tab - Added syntax coloring and completion proposals to all query input fields. - New: Collection History - Now also supports remembering and restoring any edited documents. - Improved: General - Ensured that every operation can be cancelled at least 10 minutes after a loss of connectivity, instead of hanging indefinitely. - Improved: Connection Manager - Upgraded SSH libraries to support a bigger variety of SSH configurations. - Improved: Connection Manager - Allow to connect multiple selected connections with one single click. - Improved: Connection Manager - Added support for the import of Atlas Data Federation connection strings. - Improved: IntelliShell - The editor performance has been improved when working with bigger or more complex scripts. - Improved: Team Sharing - Cleaned up and improved Team Sharing related user interfaces for more clarity. - Improved: Task Manager - Ensured that corresponding tooltips are shown for all task types. - Improved: AI Helper - Improved how multiple source collections are shown on the AI Helpers user interface. - Improved: Query Manager - Allow optionally storing database and collection information with all saved queries, to clarify their context. - Improved: Exports - The Export Overview will now be selected, when opening a tab with multiple export units. - Improved: Session Restore - The "Enable session restore" option has been moved from the Appearance to the Behavior section. - Improved: Product Activation - Improved the Product Activation wizard to make it more clear how many machines are used on the current license. - Fixed: General - Fixed an issue that would have slowed down the user interface, especially on Linux. - Fixed: General - Fixed an issue where tooltips could be missing after changing the layout of the application (e.g. split, undock or move tabs). - Fixed: Connection Manager - Fixed situations in which some options on the Authentication tab of a connection configuration were not shown. - Fixed: Connection Manager - Fixed pasting Studio 3T connection strings containing nested folders. - Fixed: Connection Manager - Fixed an issue where the search on the Connection Manager would ignore the "DB Server" column. - Fixed: IntelliShell - Fixed syntax error that was mistakenly shown on special characters within single quotes. - Fixed: IntelliShell - Fixed syntax error that was mistakenly shown on back-tick template literals. - Fixed: Data Compare & Sync - Fixed documents being considered different, even though they only differed in fields that have been configured to be ignored. - Fixed: Query Profiler - Fixed an application failure that could occur when browsing through results of the Query Profiler. - Fixed: Index Manager - Fixed column header to read "Index type" instead of "Field type". - Fixed: Exports - Fixed an application failure that could occur when renaming a custom field in a CSV or SQL Export right before trying to rename it. - Fixed: IntelliShell Script Task - Fixed an issue where the script was not preserved when the tab was restored or duplicated. - Fixed: Users Tab - Disabled "Copy User" on privileges in the Users tab. 2023.9.2 (08-Jan-2024) ====================== - Improved: Bundled JRE - Updated the bundled Java Runtime (JRE) to version 17.0.9+9. 2023.9.1 (11-Dec-2023) ====================== - Fixed: Query Profiler - Fixed issues where error banners and the ON/OFF switch could show an incorrect state on the Query Profiler tab. - Improved: AI Helper - Update the ChatGPT model from "text-davinci-003" (to be deprecated on 4th of January 2024) to "gpt-3.5-turbo-instruct". - Improved: Result Views - Inline editors on the table and tree view will now properly show values with a center alignment. 2023.9.0 (28-Nov-2023) ====================== - New: Query Profiler - Find slow running queries, investigate, and fix Mongo DB queries to speed up performance. - Improved: Include "loadBalanced" option in non-SRV connections for compatibility with Oracle Autonomous Database. - Improved: IntelliShell is now able to handle large and complex scripts with better performance. - Improved: Added support for custom stage names in aggregation editor. - Improved: Detect when an email address is listed in both the "allow" and "block" lists in Team Sharing preferences. - Improved: More consistent icons for locked connections. - Improved: Support for aggregation stages $listSampledQueries and $listSearchIndexes, and operators $median and $percentile. - Improved: For compatibility with Amazon DocumentDB, Studio 3T now doesn't attempt to use "allowDiskUse" and "collation" options unless they differ from the defaults. - Improved: IntelliShell's autocomplete suggestions are now case-insensitive. - Improved: "Copy selection" contextual option now also available in raw shell output. - Improved: In the Query History and Query Browser windows, "Clear History" is now accessible without having to select an item first. - Improved: The "Insert JSON Document" feature now accepts an array of documents as well as a single document. - Improved: "Refresh" button now available also in IntelliShell results tab and SQL Query results tab. - Improved: In IntelliShell results, treat "findOne" results in a manner consistent with "find". - Improved: "Follow Reference" can now remember different target databases and/or collections for different source fields. Also, the choices are remembered even if the tab is closed. - Fixed: Studio 3T could crash when disabling the trial while having a collection tab open against a shared connection. - Fixed: Empty folder in connection manager would remain collapsed even after adding a connection to it. - Fixed: Compatibility problems from 2023.7 on with CSV export tasks created in previous versions. - Fixed: In the import connections dialog, all the folder options in the dropdown would duplicate each time a file is selected. - Fixed: Hitting "Ctrl/Cmd + Enter" in IntelliShell would insert a new line in certain cursor positions. - Fixed: Crash when rapidly removing and re-setting the read-only lock on a shared query. - Fixed: Input for OpenAI API Key accepted trailing newlines, resulting in an error when trying to use the key. - Fixed: UUIDs not properly displayed in Visual Query Builder. - Fixed: Field name proposals in SQL Query Tab could be sourced from the wrong collection if the SQL script had multiple SELECT statements. - Fixed: Existing indexes sometimes not available for selection for hints in aggregation options. - Fixed: Editing the index specification for the index hint in aggregation options would cause an error message to appear. - Fixed: Index hints were not applied to "Explain Query" within IntelliShell. - Fixed: IntelliShell result tabs would be persisted when restarting the shell, even if not pinned. - Fixed: Pressing enter when entering an email address in the block or allow list for team sharing would close the preferences. 2023.8.0 (26-Oct-2023) ====================== - New: AI Helper - Integrated the AI Helper with the Collection Tab, allowing users to write queries using natural language. 2023.7.0 (12-Oct-2023) ====================== - New: Aggregation Editor - Redesigned the Aggregation Editor for improved usability, e.g. replacing stage tabs with a list view. - New: Aggregation Editor - Integrated the AI Helper with the Aggregation Editor, allowing users to write queries using natural language. - New: Session Restore - Session Restore, which restores all open connections, tabs, etc. when restarting the app, is now enabled by default. - Improved: General - Streamlined the handling of unsaved changes when closing more than one tab to prevent multiple confirmation dialogs. - Improved: Collection Tab - A new option, "Open in aggregation editor", opens the current query as an aggregate query in the Aggregation Editor. - Improved: IntelliShell - Improved the behavior of the undo/redo feature on IntelliShell editors. - Improved: Schema Analyzer - GridFS collections are now excluded from the Schema analysis source dialog. - Improved: Exports - The field table for CSV and SQL exports has been greatly improved for better usability. - Improved: Team Sharing - Added a button in the Connection Manager to create a "New shared folder". - Improved: Team Sharing - For consistency, mentions of "admins" and "users" have been renamed to "managers" and "members" respectively. - Improved: Team Sharing - In Preferences, readability of the email address list in dark theme is improved on the Team Sharing page. - Improved: Query Manager - The Query Manager automatically refreshes when shared folders are added or removed through Team Sharing. - Improved: Query Manager - When opening the Query Manager, the focus is now on the search field, ready to start searching for queries. - Improved: Code Editors - With "Auto-complete bracket pairs", typing a bracket or quotation mark immediately after it has been auto-completed, will be ignored. - Fixed: Connection Manager - Fixed an issue where the "Connection folder" list on the "New Connection" dialog was empty on Linux. - Fixed: Connection Manager - Fixed an issue when editing connection configurations with certificate files containing a certificate followed by a private key. - Fixed: Connection Manager - Fixed the "Expand" option on the context menu for all folders. - Fixed: Collection Tab - Fixed an application failure that occurred when deleting a full line from the multi-line query editor. - Fixed: IntelliShell - Fixed an issue where collation options were ignored when running queries using Query Assist. - Fixed: IntelliShell - Fixed an issue where the read preference of the current connection to MongoDB was not shown correctly. - Fixed: Team Sharing - In My resources, fixed cases where the Local Resources folder couldn't be expanded because it contained only default folders. - Fixed: Team Sharing - Fixed an issue where quick connect shortcuts assigned to shared connections didn't work. - Fixed: Team Sharing - Fixed an issue where the My resources sidebar was empty on startup. - Fixed: Query Manager - Fixed the keyboard shortcut for deleting a resource or folder in the Query Manager. - Fixed: Task Manager - Fixed the keyboard shortcut for renaming items (F2), so that it works on folders. - Fixed: Data Masking - Fixed an error that occurred when excluding multiple fields at a time. - Fixed: What's New - Fixed an issue where the What's New tab failed to load when using dark theme. 2023.6.2 (20-Sep-2023) ====================== - Fixed: Fixed an issue that could occur when running mongodump exports on collections that contain date objects. 2023.6.1 (08-Sep-2023) ====================== - Fixed: Fixed an internal issue that could affect the application performance. 2023.6.0 (24-Aug-2023) ====================== - New: Team Sharing - Share MongoDB connection configurations, queries and scripts with team members using the new Team Sharing feature. - New: Extended Trial - Extend your expired trial for another seven days with Studio 3T 2023.6 and try more of the powerful features. - New: Preferences Dialog - A new preferences dialog now provides easier access to all settings, including license and account details. - Improved: General - Most message dialogs can now be closed by pressing the RETURN or ENTER key, instead of clicking OK. - Improved: AI Helper - For full transparency, the AI Helper now allows users to review the full question that would be sent to OpenAI. - Improved: AI Helper - With Session Restore enabled, the user interface of the AI Helper is now fully restored after restarting Studio 3T. - Improved: IntelliShell - With the new MongoDB Shell (mongosh), IntelliShell now supports proxies on MongoDB connections, even without SSH. - Improved: Collection Tab - Table and Tree View now automatically hide the "_id" column, if that field is not present in the results. - Improved: Collection Tab - The "Add New Collection" dialog now supports Clustered Collections with a new option, "Create clustered collection". - Fixed: General - Fixed an issue where text editors presented invisible text, instead of long lines of code or JSON. - Fixed: General - Fixed an application failure that occurred on restart after closing Studio 3T while an operation was still running. - Fixed: Collection Tab - Fixed an "Index out of bounds" error which could occur on Linux when trying to save contents of a binary field to a file. - Fixed: IntelliShell - Fixed an issue with the Undo function in Studio 3T editors which sometimes gave unexpected results. - Fixed: IntelliShell - Fixed an issue where script editors incorrectly detected invalid escape sequences on valid template literals. - Fixed: Aggregation Editor - Fixed an issue where new Aggregation tabs were marked as having unsaved changes on opening the tab. - Fixed: Schema Analyzer - Fixed an issue where Session Restore failed to restore Schema tabs. 2023.5.0 (13-Jun-2023) ====================== - Improved: General - Updated Mongo Java Driver to version 4.7.2, with full support for MongoDB 6.0. - Improved: General - Updated the Mongo Shell that is shipped with Studio 3T from version 1.5 to version 1.8. - Improved: General - Added support for over a dozen new aggregation operators for MongoDB 5.0 and 6.0. - Improved: Aggregation Editor - Added support for the new aggregation stages: $densify, $documents, and $fill. - Improved: Aggregation Editor - Improved the $lookup stage to support templates for different use cases. - Improved: Aggregation Editor - The dropdown for the selection of stage operators now allows typing stage operators without the "$". - Improved: AI Helper - Added an "Limit number of fields ..." option to prevent running into token count limitations with ChatGPT. - Improved: Index Manager - Associated Index Manager tabs are now automatically closed after dropping a collection. - Improved: Index Manager - The "Add Index" and "Edit Index" dialogs now allow changing the field order via drag & drop or context menu actions. - Improved: IntelliShell - Added the ability to rename output tabs by right-clicking them and selecting "Rename tab". - Improved: Export Wizard - Introduced the ability to load saved queries (find and aggregate) on units of an export task. - Improved: Schema Analyzer - Added support for opening schema analysis results that are associated with a deleted connection. - Fixed: Index Manager - Fixed an application failure that occurred when closing an Index Manager tab while an index operation is still running. - Fixed: Aggregation Editor - When moving stages up or down the pipeline, the stage number next to the "Operator" field is now updated. - Fixed: Aggregation Editor - Fixed an crash that could occur when restarting Studio 3T after collapsing the result view for an aggregation stage. - Fixed: Connection Tree - Fixed an application failure that could occur when resizing the Open Connections tree. - Fixed: Query Manager - Fixed an application failure that could occur when trying to collapse the tree in the Query Manager. - Fixed: Imports - Importing CSV files now works correctly for all delimiter options. - Fixed: Task Manager - Fixed "Authentication failed" errors for scheduled tasks running on databases that do not require authentication. - Fixed: Aggregation Editor - Removed the misplaced option to open IntelliShell from exports of aggregation results. 2023.4.1 (17-May-2023) ====================== - Fixed: Index Manager - Fixed an issue with non-sparse indexes showing as "sparse". - Improved: IntelliShell - Result tabs can now be pinned with a button directly on their tab header. 2023.4.0 (04-May-2023) ====================== - New: Index Manager - See and manage all the indexes of a collection in one place, including information about their usage. - New: Collection History - Let Studio 3T keep track of documents that you deleted on a collection and restore them, if needed. - Improved: General - Improved user interface by tweaking borders, paddings and margins, for a sleeker look. - Improved: Quickstart - Added a link to our free webinars to the "Help and Learning" section of the Quickstart tab. - Improved: AI Helper - Added full support for proxies, and a better handling of collections with special characters in their name. - Improved: IntelliShell - Closing an IntelliShell with unsaved changes, now offers an option to save the changes to the script browser. - Improved: Visual Explain - Improved Visual Explain to support MongoDB servers earlier than version 3.6. - Improved: Aggregation Editor - Result views of Aggregation Editors can now be expanded or collapsed with a double-click on their headers. - Improved: Aggregation Editor - New Aggregation Editors now automatically create a first stage and its tab, ready to be edited. - Improved: Code Editors - Improved the padding in line number rulers so that the numbers are now further away from the left edge. - Improved: Query Manager - All tree elements of the Query Manager and Query history and query browser, can now be expanded or collapsed. - Fixed: General - Fixed an issue where the dialog for entering custom keystore passwords would not display on the same monitor as the application. - Fixed: IntelliShell - Fixed keyboard shortcuts and File menu options for loading scripts and files. - Fixed: Aggregation Editor - The $set stage on aggregation queries now chooses a more appropriate data type for numbers. - Fixed: Aggregation Editor - Fixed an application failure that occurred when using DBRef values in an aggregation query. - Fixed: Collection Tab - The Remove Field dialog now works with query conditions that match date tags. - Fixed: Query Manager - The "&" character in saved query names and script names is now displayed throughout the application. - Fixed: Query Manager - Fixed an issue with line delimiters in saved queries that were causing an application failure. - Fixed: Connection Tree - Fixed an application failure that occurred when clicking "more matches" in search results. - Fixed: Search in ... - Fixed an issue that caused an application failure when using the search on a connection that has no databases. - Fixed: Task Manager - Moving a task in the task tree of the Task Manager will not update the "Last modified" timestamp anymore. - Fixed: Task Manager - Saving or moving a task in the task tree of the Task Manager will now automatically expand all relevant folders. - Fixed: Imports - When importing data, the application now remembers custom field names when saving and reopening an import task. - Fixed: Data Masking - Fixed an issue where the "Add unit" button was unavailable in duplicated or session restored Data Masking tabs. 2023.3.0 (30-Mar-2023) ====================== - New: IntelliShell - OpenAI Integration: Let GPT-3.5 create queries for you when you ask natural language questions about your data. - Improved: General - Introduced some general application stability improvements. 2023.2.0 (16-Mar-2023) ====================== - New: General - The new Connection Sidebar now tracks the connection, database or collection of the currently active tab. - New: General - Numeric fields of newly created or edited documents are now automatically stored with the most efficient data type. - Improved: General - Added new options to duplicate (Command / Ctrl + D) or delete (Option / Alt + Backspace) lines in all code editors. - Improved: Connection Manager - MongoDB's retryable writes option is now read from and written to connection strings. - Improved: IntelliShell - The startup time of the IntelliShell has been greatly reduced. - Improved: Connection Manager - All connections can now be viewed, edited, and tested, regardless of possible Studio 3T license restrictions. - Improved: Connection Tree - Collections can now be pasted directly to connections, creating missing databases if necessary. - Improved: IntelliShell - In case of problems during IntelliShell startup, Studio 3T now includes more details within the error dialog. - Improved: IntelliShell - The IntelliShell now fully respects MongoDB's retryable writes option when spawning a mongo shell. - Fixed: General - Fixed an issue where Studio 3T was not starting up on some macOS installations. - Fixed: General - Fixed some icons that could appear blurry in Studio 3T's user interface. - Fixed: Connections - Instead of timing out, when a task execution requires a connection password, users are now prompted to enter the password. - Fixed: Collection Tab - When working with undocked tabs, new tabs now open in the undocked window instead of the main application window. - Fixed: Collection Tab - Fixed formatting of queries copied to the system clipboard, e.g. alignments and spacing between field name and value. - Fixed: Collection Tab - Copying a query to the system clipboard now uses the correct line endings for the target operating system. - Fixed: Aggregation Editor - Fixed an issue where the "Pipeline" tab did not correctly update the shown stage specifications. - Fixed: Code Editors - Fixed an application failure that occurred when trying to open the context menu in some code editors in Studio 3T. - Fixed: Code Editors - Fixed an issue that could occur in IntelliShell when opening the Visual Query Builder on a find query statement with no arguments. - Fixed: BSON Import - Added an option to forcefully disable retryable writes in imports of BSON archives (mongorestore). - Fixed: Studio 3T Free - Fixed an application failure that occurred when trying to follow a DBRef using "Follow Reference" on a MongoDB field. 2023.1.1 (13-Feb-2023) ====================== - Fixed: Data Compare & Sync - Fixed some issues around loading and restoring Data Compare & Sync tasks and tabs. 2023.1.0 (09-Feb-2023) ====================== - New: General - Introduced a new Connection Sidebar with tabbed views and the option to show as an overlay. - New: General - Introduced a new Query Browser and History feature to replace the old Bookmarks Manager dialog. - New: General - Introduced a new Query Manager, bringing all saved queries, scripts and aggregations into one place. - New: Tasks - The Task Manager now supports organizing tasks in folders. - Improved: General - The toolbars of many main features have been reworked for better discoverability and usability. - Improved: General - Studio 3T will now tell you when it can't reach the update server, instead of assuming that there's no update. - Improved: IntelliShell - The script editor now comes with a new toolbar for faster access to all code formatting options. - Improved: IntelliShell - The IntelliShell's horizontal split layout will not obscure the script editor's toolbar, anymore. - Improved: Aggregation Editor - Improved performance of autocompletion with large aggregation pipelines. - Improved: Connection Tree - Added an option to get the connection string for any open connection: "Export URI...". - Improved: Connection Manager - Connections to CosmosDB or those using X.509 authentication generate less warnings. - Improved: SQL Connection Manager - Allow creating and editing connections that are not supported by the current license. - Improved: Data Compare & Sync - Source and target can now be changed without losing comparison units. - Fixed: General - The "Duplicate Tab" option was shown disabled on tabs where it is not available and now has been removed from them. - Fixed: General - Fixed situations where Copy Collection's option "Replace Existing Collection" created a new collection instead. - Fixed: Connection Tree - Fixed cases where the server list was not updating after a switch of primary/secondary members occurred. - Fixed: Connection Manager - Fixed an issue that would prevent connection strings without port numbers from being imported. - Fixed: Quickstart Tab - Fixed an issue where the read-only lock for connections was not displayed in Recent Connections. - Fixed: Tasks - Fixed situations where the Load Task dialog did not open wide enough to see the last modified date of a task. - Fixed: Table View - Fixed cases where the "Auto-size columns (full values)" option failed to expand the rightmost column. - Fixed: SQL Tab - Fixed cases where the connection information was incorrectly rendered after running a query. - Fixed: Operations View - Fixed cases that would not display database or collection aliases in operations. - Fixed: Aggregation Editor - Fixed an issue where database and collection dropdowns did not take aliases into account when ordering. - Fixed: IntelliShell - Fixed an issue where the IntelliShell did not handle function declaration hoisting correctly. - Fixed: IntelliShell - Fixed an issue where formatting code on the editor could duplicate blocks of script within brackets. - Fixed: IntelliShell - Fixed an issue that would make the IntelliShell hang when a find query's syntax became ambiguous during editing. - Fixed: Export Tasks - Fixed situations in which the "Edit Selected Unit" shortcut on an Export Task was missing. - Fixed: Import Tasks - Fixed an issue with the BSON Import where mongorestore log messages were not being parsed correctly. - Fixed: SQL Migration - Fixed cases where imports from Oracle could enforce incorrect limits for the length of identifiers. - Fixed: Mongo Shell Integration - Fixed an issue where the bundled Mongosh was not working on Ubuntu 20.04. - Fixed: Dark Theme - Fixed missing borders on Connection Tree tooltips when using the Dark Theme on Windows. - Fixed: Dark Theme - Fixed an issue on Windows, where the Dark Theme did show incorrect lines under selected table rows. 2022.10.0 (07-Dec-2022) ====================== - New: General - Code and JSON editors are now automatically completing brackets and quotes. - Improved: Visual Query Builder - Tweak position of automatic tooltips so that they are not blocking input fields. - Improved: Aliases - Reduce delay before showing tooltips on tabs in cases where these do not show collection or database aliases. - Improved: Aliases - Make it easier to see name clashes when creating a new alias for a connection or database. - Improved: IntelliShell - Made the limit for automatically generated result tabs configurable. - Improved: IntelliShell - Both Aliases and Notes are now available with auto completion proposals on the IntelliShell. - Improved: IntelliShell - Limit errors shown at once on IntelliShell editors to 100, showing a notification when there are more. - Improved: Data Masking - Aliases for collections are now also shown for the mapping tree on Data Masking configurations. - Improved: Tasks - Added the action to Rename a task to the toolbar of the Tasks view. - Improved: Tasks - Added the option to change the order of tasks, by simply dragging and dropping them in the Tasks view. - Improved: Aggregation Editor - The stage input/output pane can now be collapsed in order to maximize the stage editor's space. - Improved: General - Added a new Advanced option to set the connection pool size, useful in cases where big connection pools cause problems. - Improved: Connection Manager - Stop adding "- imported on ..." to imported connection names and include a numeric suffix when names already exist. - Improved: Exports - Make it easier to add a new database or collection when choosing the target of an export. - Fixed: General - Fixed an issue where, occasionally, duplicated tabs could immediately close. - Fixed: General - On Ubuntu, the Match Case checkbox now renders correctly in light mode. - Fixed: General - On Ubuntu, the Target Collection selection on Ubuntu now selects the relevant connection. - Fixed: Collections - Capped Collection settings in Create Collections are again correctly enabled for 5.0.6 and earlier MongoDB servers. - Fixed: Collection Tab - Studio 3T is now more resilient to badly formatted queries on the clipboard being pasted. - Fixed: IntelliShell - Syntax coloring on the script editor now shows back-ticked template literals as strings. - Fixed: IntelliShell - Completion proposals on mongosh stop showing the deprecated/removed "save()" function. - Fixed: IntelliShell - Now bundling the native mongosh executable for M1/M2 macs, so that Rosetta is no longer needed. - Fixed: User Copying - Copying users on the same server could mistakenly offer to resolve issues by creating a role. - Fixed: User Copying - Copying users between different servers could fail to resolve issues if the user's role did not exist on the target server. - Fixed: Exports - Index Hints are now applied correctly when an Aggregation is used for export. - Fixed: CSV Import - CSV Imports no longer leave a lock on imported files. - Fixed: CSV Export - Export CSV now defaults to using Windows or Unix end of line characters according to the operating system. - Fixed: Imports and Exports - Export tasks now also save a find query's options. - Fixed: Mongodump/Mongorestore - Exports using mongodump and imports using mongorestore now correctly work with Atlas serverless instances. - Fixed: Search In - Upper case field names are now correctly matched in the Search In ... feature. - Fixed: Reschema - Renaming fields in Reschema shows as a modification on the tab. 2022.9.2 (15-Nov-2022) ====================== - Fixed: UUID function with no argument causing mongosh shell restart 2022.9.1 (10-Nov-2022) ====================== - Fixed: Exports - Fixed an issue that could prevent Studio 3T from loading Export Tasks that have been saved with older releases. - Fixed: IntelliShell - Reintroduced helper functions for creating UUIDs on mongosh: UUID(), JUUID(), CSUUID(), PYUUID(), LUUID(). - Fixed: IntelliShell - Removed a warning that would show up when using KERBEROS/LDAP authentication methods on the bundled mongosh. 2022.9.0 (31-Oct-2022) ====================== - New: Mongosh - Bundled Mongosh 1.5.4 and set it as the default mongo shell in Studio 3T. - New: Time Series - Added full support for creating and working with Time Series collections. - New: User Copying - Copy and paste users between different MongoDB databases, complete with their configured roles. - Improved: Auto Completion - Improved the responsiveness of editors that offer auto completion proposals, like the IntelliShell. - Improved: Exports - Added a new action to the toolbar and context menu of export units, allowing to clone them. - Improved: Tasks - Double-clicking a Task now opens a tab to edit it, while renaming is still available from its context menu. - Improved: Collection Tab - The dialog for inserting a document will now move the focus to the JSON editor directly after opening. - Improved: Reschema - The process of selecting and deselecting fields is more intuitive and simpler. - Improved: Reschema - Changing the type or deleting the target _id field is now disallowed. - Fixed: Aliases - The "Search in ..." tab and tooltips now display aliases. - Fixed: GridFS - Users of GridFS features will see various refinements to the user interface. - Fixed: Tasks - Weekly and Monthly scheduled tasks will now only run when scheduled. - Fixed: IntelliShell - Now able to connect Replica Sets with self-signed SSL certificates. - Fixed: IntelliShell - Exporting from IntelliShell toArray() is shown as Array-JSON in Operation pane. - Fixed: Export - When using the Aggregation Editor, the Open dialogs remain correctly labelled. - Fixed: Export - Data Masking options only appear when appropriate and can be hidden in General Export Options/Advanced Features settings. - Fixed: Copy Collections - The dialog is more explanatory when there is a collection name collision. - Fixed: Collections - The Restore Default Query button operates correctly in the presence of the Visual Query Builder. - Fixed: Refresh All will not trigger the appearance of a non-existent "Loading..." collection. - Fixed: Connections - Search will only search for Functions, Users and Roles if those items are selected to be displayed in Preferences. - Fixed: SQL Migration - More robust handling of array length limits (or lack of them) has been implemented. 2022.8.3 (07-Oct-2022) ====================== - Fixed: Show feature overview dialog before activating Studio 3T Free. 2022.8.2 (04-Oct-2022) ====================== - Improved: Simplified the steps that new users take to activate Studio 3T Free. 2022.8.1 (07-Sep-2022) ====================== - Fixed: Tasks - Fixed an issue that would occur when loading tasks that have a recurring schedule. - Fixed: JSON View - Fixed an issue with legacy UUIDs, where CSUUIDs were wrongly shown as "NUUID". - Fixed: Collection Tab - Fixed an issue that could prevent the tooltips of Collection Tabs from showing. - Improved: Connection Tree - The context menu action "Manage Metadata" has been renamed to "Aliases / Notes". 2022.8.0 (01-Sep-2022) ====================== - New: IntelliShell Script Tasks - Run IntelliShell Scripts on-demand or on schedule through Studio 3T's Tasks. - New: Enhanced Value Search - In addition to field values, Value Search now also supports searching for field names. - New: Shell and Tool Updates - Updated the latest bundled tools to mongo shell 5.0.10 and 100.5.4 for mongodump and mongorestore. - New: Shell and Tool Updates - Updated the default for the bundled tools to use the most recent versions, 5.0.10 and 100.5.4. - Improved: Value Search - To avoid confusion, the Value Search will now appear as "Search in..." in menus and tabs. - Improved: Tree View - Result Tree Views now remember and restore expanded nodes when paging through results or rerunning queries. - Improved: Migration to SQL - Mappings now support any field as a primary key and allow setting initial values other than "0". - Improved: Duplicate Tab - Improved the "Duplicate Tab" option to support many more different tabs. - Fixed: Collection Tab - Fixed an issue that reduced the performance of loading query results when working with large page sizes. - Fixed: IntelliShell - Fixed an issue with the responsiveness of auto-completion when dealing with large scripts over 1000 lines. - Fixed: JSON View - Fixed an issue where Legacy UUIDs in the JSON view were not always rendered in the same way as in other views. - Fixed: IntelliShell - IntelliShells using a Mongosh now work with connections that use LDAP authentication. - Fixed: IntelliShell - IntelliShells using a Mongosh now correctly handle long field values that include single and double quotation marks. - Fixed: Licenses - Messages about the user's current license and trial license status are now clearer for both commercial and free users. - Fixed: Imports and Exports - Collection to Collection imports and exports now support cases where source and target collection have the same name. 2022.7.2 (15-Aug-2022) ====================== - Improved: Reworked the steps that new users take to activate Studio 3T and Studio 3T Free. 2022.7.1 (26-Jul-2022) ====================== - Fixed: General - Fixed an issue with long running queries that would not complete correctly. 2022.7.0 (21-Jul-2022) ====================== - New: Aliases and Notes - Introduced aliases and notes for databases and collections on the connection tree. - New: Connection Padlock Icon - Read-only connections are now shown with a padlock icon throughout the whole application. - Improved: PostgreSQL - The driver for PostgreSQL was upgraded to enable support of SCRAM-SHA-256 passwords. - Fixed: Connection Tree - The keyboard shortcut for "Refresh Selected Item" now refreshes the selected item, instead of behaving like "Refresh All". - Fixed: Connection Tree - Fixed a crash that could occur under specific circumstances when copying collections using copy and paste. - Fixed: Connection Tree - The context menu is now available anywhere in the tree area, even opened without a selected connection. - Fixed: IntelliShell - The "Refresh View" option will now be disabled when there are no refreshable results views. - Fixed: IntelliShell - Fixed an issue on Windows, where the search box would reveal a gray field when users deleted content. - Fixed: Table View - Fixed an issue with resizing columns on Linux when there were few columns and there was a change in the table order. - Fixed: Exports - Connection colors in the source collection selection are now visible. - Fixed: BSON Import - Fixed an issue with saving and loading options for tasks that import from BSON mongodump folders and archives. - Fixed: SQL Import - Fixed a crash that could occur when clicking on an unset target collection of an SQL Import Unit. - Fixed: Connections - Fixed an issue where users could not connect to MongoDB when their user was lacking permission to run "buildinfo". - Fixed: Session Restore - Data Masking units will now restore correctly, even if they have not been saved as a Task or they lack any masked fields. - Fixed: Copy Collections - Fixed an issues that could occur when copying collections between servers where the user has limited permissions. - Fixed: Application Logs - Fixed an issue where Null Pointer Exceptions were being logged when UUIDs were converted to strings. 2022.6.1 (27-Jun-2022) ====================== - Fixed: Connection Tree - Fixed a crash that could occur with the "Refresh All" action when there is no selection. - Fixed: Collection Import/Export - Fixed an issue that did not allow exporting/importing different collections of the same name. 2022.6.0 (21-Jun-2022) ====================== - New: Customize Global Toolbar - Freely choose large or small toolbar icons and whether to show labels or not. - Improved: Connection Manager - New users will now see the Connection Manager appear automatically when they use Studio 3T for the first time. - Improved: Preferences - The editor font setting now has a "Back to default" button to restore default settings. - Improved: Date Tags - Date Tags are now preserved when used in an export task's aggregation query. - Improved: Mongo Java Driver - The mongo java driver has been updated to version 4.6.0. - Improved: Java Runtime - The Java Runtime has been updated to the latest JRE version 17.0.3. - Fixed: Connection Manager - Editing connections now preserves their shortcut settings. - Fixed: Connection Tree - The action "Refresh All" now refreshes all servers. - Fixed: Connection Tree - Copy & paste multiple collections within the same database now functions reliably. - Fixed: Connection Tree - Fixed a crash that could occur when trying to copy & paste a view. - Fixed: JSON View - Spaces are no longer appended to lines in the JSON View. - Fixed: Operations View - Operations progress for copying databases is now more precise. - Fixed: Reschema - Reschema JSON previews now reliably show foreign key fields. - Fixed: Reschema - Reschema now expands unwound arrays in target collections. - Fixed: IntelliShell - Computing auto-completion no longer hangs when querying the "local.oplog.rs" collection. - Fixed: Migration to SQL - For Custom SQL Types, "Reset to default" SQL type will only be shown when there are changes. - Fixed: SQL Connection Manager - SQL Connection Manager now displays a "Close", instead of an "OK" button when launched from the "File" menu. - Fixed: Data Masking - Unsaved data masking configurations are now correctly restored by Session Restore. - Fixed: Ubuntu Wayland - Resolved a number of UI issues with the newly released Ubuntu 22.04 and its new windowing system. 2022.5.0 (19-May-2022) ====================== - New: Load Tasks - Load tasks whenever you are about to create a savable task, or directly from an open tab. - New: IntelliShell Progress - IntelliShell now has reports progress of on-going queries. - New: JSON Find and Replace - A new toolbar makes finding and replacing in the JSON document editor more accessible. - Improved: Hidden Indexes - Studio 3T now supports Hidden Indexes. - Improved: Export - Studio 3T now offers additional options to automatically handle the target path when changing the source of an export. - Improved: Query Find - Improved the performance of performing a Find on query results. - Improved: Updates - Studio 3T Free no longer enforces the limit of three deferred reminders before updating. - Improved: Schema Validators - Schema Validations are now copied when a collection or database with validations attached to them are copied. - Improved: Field Editor - There is now a warning when you edit or delete a field and select "All Documents in Collection" to remind the user that this will affect the entire collection. - Improved: IntelliShell - When Mongosh is in use, a new Mongosh serializer is used to give a more compatible JSON representation. - Improved: Atlas - When using Atlas, users without listCollections privileges can see collections they have access to by setting "Always show all databases and collections defined in the roles of the user account" on the Authentication tab of the Connection Manager. - Improved: New Users - Studio 3T now informs users that their Robo 3T connections have been automatically imported. - Fixed: Export - Mongodump exports with find queries no longer generate a spurious warning. - Fixed: Export - It is no longer possible to try and export using a tab with results of a now deleted connection. - Fixed: SQL Server - A new option to Trust the Server Certificate is available in the SQL Server connection options. It defaults to On. The SQL Server driver has also been updated and is now shipped complete with all required drivers. - Fixed: Reschema - Type conversions are more resilient. - Fixed: JSON Editor - The Enable Word Wrap menu item has been aligned correctly. The Enable Word Wrap menu item and checkbox are also correctly synchronized. - Fixed: Help - Multiple open help windows can now be dismissed. - Fixed: Task Scheduling - The Custom Time schedule can now safely resize. - Fixed: Indexes - Improved resilience on opening indexes after disconnection. - Fixed: SQL Migration - Improved reliability of PostgreSQL Timestamp and Timezone conversions in Migration from SQL. - Fixed: Aggregation - Corrected the background color of controls Find Value is displayed in a set of out-of-date aggregation results. - Fixed: IntelliShell - Disable Query Assist (for IntelliShell) now works consistently within connection and global preferences. - Fixed: IntelliShell - Parsing empty arrays in Intellishell now works correctly. 2022.4.1 (27-Apr-2022) ====================== - Fixed: Collection Tab - Fixed margins of query input fields. - Fixed: Collection Tab - Fixed an additional whitespace being inserted in queries when hitting ENTER. - Fixed: Visual Query Builder - Fixed a crash that could occur with queries that are using empty text values. - Fixed: Tree View - Fixed an issue that would not expand the first document of a query result anymore. 2022.4.0 (21-Apr-2022) ====================== - New: Date Tags - Easily build find or aggregate queries that match for certain dates or date ranges. - New: Saving SQL Mappings - Save and load configurations of any SQL Migration task to or from a file. - Improved: Table View - Improved custom column ordering and made it an option alongside alphabetic or natural ordering. - Improved: Connection Manager - Studio 3T now prevents deleting connections that are still open on the Connection Tree. - Improved: Auto Completion - Autocompletion will now offer proposals appropriate to the connected MongoDB server's capabilites. - Improved: Aggregation Editor - Added support for changing the order of stages via drag and drop directly on the Pipeline tab. - Improved: Auto Completion - Allow proposals to overwrite any matching code snippet after the cursor position. - Improved: IntelliShell - Script editors will now retain focus when a query is run, to allow to directly continue editing. - Improved: Migration to/from SQL - Improved performance of getting tables from particular Oracle instances. - Improved: Tasks - Parallel executions of the same task will now be prevented with an adequate error message. - Fixed: General - Database and Collection names now update correctly for views and undocked aggregation tabs. - Fixed: General - Fixed issues when editing global and connection specifc IntelliShell preferences for the "mongorc.js" file. - Fixed: General - The "Change target collection" dialog will now reliably show the "Remove Database" button on Ubuntu. - Fixed: Table View - The specified custom column order for a collection will now be passed reliably to subsequent result tabs. - Fixed: Collection Tab - Fixed an issue that would prevent deleting or editing documents that have an "_id" with the value "null". - Fixed: Collection Tab - Fixed an issue that, after renaming a field, would still show a column with the original field name. - Fixed: Collection Tab - The projection field now retains its value when toggling the show/hide option. - Fixed: Collection Tab - Fixed an issue that where multiline content was not pasted correctly into the query field. - Fixed: Bookmark Manager - The first line of the bookmark overview is now correctly aligned. - Fixed: GridFS Tab - Fixed an issue that did not release a lock on a file being uploaded to a GridFS bucket. - Fixed: Index Tab - Index creation errors and validation messages are displayed at the right time. - Fixed: CSV Import - Fixed an issue with the data type detection not working for CSV fields. - Fixed: CSV Export - Improved application robustness when opening the Aggregation Editor from the query of a CSV Export. - Fixed: Copy/Paste Index - Fixed a crash that could occur when pasting an index to a server and then disconnecting it. - Fixed: Copy/Paste Collections - Fixed a crash that could occur when copying and pasting multiple databases at once. - Fixed: Reschema - Fixed an issue where a vertical scrollbar would not correctly appear on the Reschema Target table on Ubuntu. - Fixed: Data Masking - Fixed an issue on Data Masking tabs that prompted users twice to save their unsaved changes. - Fixed: Data Masking - Data Masking tabs now correctly reflect when the configuration has changed by appending one * to the title. - Fixed: Data Masking - Fixed an issue that could lead to a crash when closing a connection that was previously used by Data Masking. - Fixed: Data Masking - Fixed a crash that could occur when opening a Data Masking tab while having a selection of multiple collections. - Fixed: Visual Query Builder - Fixed an issue on macOS where clicking the Plus button would create two field rules, not one. - Fixed: Visual Query Builder - Fixed a rare crash that could occur with the Visual Query Builder's split view. - Fixed: IntelliShell - Fixed a crash when running a query with an empty collection name through Query Assist. - Fixed: IntelliShell - The shell no longer hangs when dealing with the result of a "getShardDistribution()" command. - Fixed: IntelliShell - Fixed a crash that could occur when renaming undocked IntelliShell tabs. - Fixed: IntelliShell - Removed incorrect formatting options from the context menu of the "Raw Shell Output" tab. - Fixed: Atlas/AWS Authentication - Use of session tokens now works with a correctly formed auth request. 2022.3.0 (28-Mar-2022) ====================== - New: Studio 3T Free - A new, fully free edition of Studio 3T that includes all essential features. - Fixed: Index Tab - Fixed an issue where fields would be removed from the overview when editing the index JSON. - Fixed: Intellishell - A race condition with shell startup and the user typing into the shell's editor has been resolved. 2022.2.0 (24-Feb-2022) ====================== - New: Full native support on macOS for Apple Silicon systems with a new installer available on our download page. - New: Collection Tab - Added support for additional options on find queries, like setting "Allow disk use" or a collation. - Improved: General - Upgraded to the latest MongoDB Java driver of version 4.4.1, which supports MongoDB 5.2. - Improved: Aggregation Editor - Added stage operator "$setWindowFields", which was introduced with MongoDB 5.0. - Improved: Exports - Exports to another collection now export to a new collection in the same database by default. - Improved: Connection Tree - The connection tree will now automatically refresh after a database has been copied and pasted. - Improved: General - File choosers now behave consistently across platforms, remembering the path to the last folder opened. - Improved: SQL Imports - Reporting on SQL Imports is now more readable in the Operations Pane. - Improved: General - Typing performance in editors with code-folding support has been improved in cases of complex documents. - Improved: Migration to SQL - Enhanced table management when dropping tables during a migration. - Improved: IntelliShell: Improvements to Windows Dark mode handling in autocompletion popups. - Fixed: Server Status Charts - Fixed an issue that prevented Studio 3T from closing correctly on Ubuntu. - Fixed: Connection Tree - Users and Roles no longer duplicate themselves when the tree is refreshed. - Fixed: Aggregation Editor - Fixed a crash which could occur when an invalid query was entered and formatted in the stage editor. - Fixed: JSON View - Selecting documents for Edit, Copy or Remove now selects the correct documents when using code folding. - Fixed: Data Compare & Sync - Fixed a crash that could occur when selecting "Show Documents" in the Compare/Sync "Multiple Matches" tab. - Fixed: Stored Functions - Fixed a crash which could occur when saving a stored function. - Fixed: IntelliShell - When the selected mongo shell is not executable, an improved error message is now displayed. - Fixed: Value Search - JSON view modes now behave correctly when using "Open in Collection". 2022.1.1 (27-Jan-2022) ====================== - Fixed: Visual Query Builder - Fixed projections not being correctly restored with Session Restore. - Fixed: Index Tab - Fixed an issue where the "Validate JSON" button was missing on the "Partial Index Options" tab. 2022.1.0 (25-Jan-2022) ====================== - New: Connection Manager - Added support for MONGODB-AWS authentication method. - New: Visual Query Builder - Introduced support for "$slice" operations in projections. - New: SQL Connection Manager - Added support for the import and export of SQL connections. - Improved: Collection Tab - Improved mouse and keyboard selection of text in query input boxes. - Improved: Aggregation Editor - Improved the startup time of the Aggregation Editor tab. - Improved: Connection Manager - Added support for importing and exporting connection groups. - Improved: SQL Connection Manager - Added the SQL Connection Manager to the global "File" menu. - Improved: Operations Tab - Improved logs of shown operations and added a timestamp to each of them. - Improved: Migration to SQL - Added support for placeholders ("${date)" etc.) in output file names. - Improved: IntelliShell - Auto-completion popups will now automatically close when they are not needed anymore. - Fixed: Collection Tab - Fixed an issue where "Count Documents" would report a wrong document count of "1". - Fixed: Visual Query Builder - Fixed an issue with some "$elemMatch" queries not being represented correctly. - Fixed: Migration from SQL - Added support for importing floating point values from SQL as "NumberDecimal" in MongoDB. 2021.10.1 (14-Dec-2021) ====================== - Fixed: Connection Tree - Resolved an issue that could cause Studio 3T to crash when refreshing the connection tree. 2021.10.0 (09-Dec-2021) ====================== - New: Value Search - Search multiple collections for a specific field value. - New: Task Scheduler - Introduced a new task scheduler that allows for more powerful schedules. - New: Import Data Masking - Integrated data masking with imports, to directly obscure, shuffle or exclude any imported fields. - New: IntelliShell - Experimental support for the new Mongo Shell executable "mongosh". - New: Database Copy - Copy entire databases and multiple databases and paste them into other servers. - Improved: IntelliShell - Updated JavaScript parser to support a wider range of syntax features. - Improved: Connection Tree - Improved connection tree performance when handling thousands of databases or collections. - Improved: Connection Tree - The search functionality of the connection tree now supports case-sensitive matches. - Improved: Collection Tab - "Add/Edit Document" now allows to continue editing a document after the MongoDB server rejected it. - Improved: Visual Query Builder - Greatly improved the handling of arrays and fields inside arrays when building queries visually. - Improved: GridFS Tab - Improved messaging when a GridFS collection would contain illegal metadata entries. - Fixed: General - Fixed an issue where window sizes and positions were not saved when Session Restore was off. - Fixed: General - Fixed an issue where users would not be prompted to save their unsaved changes when exiting the application. - Fixed: General - Fixed a crash that could occur when closing one of the notifications shown below the application's toolbar. - Fixed: IntelliShell - Fixed restoring IntelliShell tabs that were switched to using a horizontal split of editor and result view. - Fixed: Aggregation Editor - Fixed an issue where certain aggregation scripts could not be loaded from a file or the clipboard. - Fixed: Result Views - Fixed an issue where "Step Into Cell" would behave incorrectly when document ids are not unique. - Fixed: Index Tab - Fixed an issue where the option "storageEngine" wasn't preserved when updating an index definition. - Fixed: Result Views - Fixed an issue that did not show embedded fields next to their parent column with a custom column order in place. - Fixed: Exports - Fixed possible error when using Incremental Execution with existing export configurations. 2021.9.0 (10-Nov-2021) ====================== - New: Aggregation Editor - Added support for aggregation index hints under the "Options" tab. - New: MongoDB 5.0 - Now bundling version 100.5 of mongodump and mongorestore with Studio 3T installations. - New: SQL Tab - Added a toolbar option that allows turning off automatic completion proposals when writing SQL queries. - New: Collection Tab - Automatically open the Visual Query Builder when a user starts dragging a field from the result view. - Improved: Table View - Improved the performance of all table views in Dark Mode. - Improved: Collection Tab - Collection queries restored with Session Restore will no longer be run automatically. - Improved: Collection Tab - Extended the quick syntax feature to support more data types, like strings, numbers and many more. - Improved: Migration to SQL - Added support for changing the source collection of existing units in a Migration to SQL task. - Improved: IntelliShell - Added a new toolbar and context menu action to clear the contents of the "Raw Shell Output" tab. - Improved: IntelliShell - The "Restart Mongo Shell" link is now a standard toolbar item for better discoverability. - Improved: Operations Tab - Improved the user interface of the Operations view to better reflect the status of any shown tasks. - Improved: Connection Tree - Studio 3T will now show all accessible collections, even if the "listCollections" privilege is missing. - Improved: Aggregation Editor - The aggregation editor will now be more flexible when parsing queries from the clipboard or a file. - Fixed: Auto Updater - (Windows only) Fixed issues with downloaded updates not installing before the application is closed manually. - Fixed: Exports - Fixed crashes that could occur when trying to export collections that have a name ending with a period. - Fixed: Exports - Fixed crashes that could occur when trying to change the target file or folder of an export to the clipboard. - Fixed: Visual Query Builder - Fixed cursor position in text input fields being reset when they lose and regain their focus. - Fixed: IntelliShell - Fixed the IntelliShell failing to start on databases with special characters in their name. - Fixed: Data Masking - Fixed an issue that could occur when masking documents that are missing one of the fields that are to be masked. 2021.8.1 (20-Oct-2021) ====================== - Fixed: Table View - Fixed crashes that could occur when simply running queries or paging through results. - Fixed: Migration from SQL - Fixed a crash that could occur when trying to edit the dataset properties of an array mapping. 2021.8.0 (13-Oct-2021) ====================== - New: Table View - Added support for custom, persistent column orders in table views. - New: IntelliShell - Added support for retryable writes on the IntelliShell (--retryWrites). - New: General - Renamed Studio 3T Core to Basic and Enterprise to Ultimate to better reflect what's included in each edition. - Improved: Setting a font in the General tab of Preferences now updates the font of windows that have already been opened. - Improved: Migration from SQL - Allow strings (LONGTEXT or VARCHAR) to be converted into a valid ObjectId. - Improved: Exports - When exporting to CSV or SQL, manually entered fields are now preserved when a query is altered. - Improved: Exports - (Linux only) Better handling of export errors when two exports are run concurrently. - Improved: Exports - Export to JSON displays more information for composite sources. - Improved: Exports - JSON Export "other options" now displayed as radio buttons. - Improved: Collection Tab - Table view column sorting now correctly sorts columns that are within an array. - Improved: Collection Tab - Better handling of cancelled "Next page" requests. - Fixed: General - Fixed issues with a high CPU usage on macOS in Dark Mode. - Fixed: General - Toolbar item's hover-on labels now appear for all icons in the global toolbar. - Fixed: Migration from SQL - Handling of unresolved units with custom SQL queries now generates appropriate error messages. - Fixed: Migration from SQL - Warning about free trial limit of 1000 documents now appears when needed. - Fixed: Exports - Export to Mongodump folder now defaults to target destination folder. - Fixed: Exports - Fixed situations where the "Add Custom Field" button would be disabled. - Fixed: Exports - File-based exports now change target file-names if the source is changed. - Fixed: Collection Tab - Brought back type icons for null values in Tables and Trees. - Fixed: Connection Manager - Robo 3T connection passwords are now correctly imported. - Fixed: Current Operations - Fixed Kill Operation not working with MongoDB 4.0 mongos servers. - Fixed: IntelliShell - "Auto-completion enabled" indicator now reflects state correctly. - Fixed: Query Code - Code for Node.js now correctly forms regular expressions. - Fixed: Roles Tab - The "Add New Privilege" dialog's collections option is always populated. - Fixed: GridFS Tab - Tab data is now correctly restored when Session Restore is enabled. - Fixed: Data Masking - Various stability and usability issues have been resolved. 2021.7.1 (21-Sep-2021) ====================== - Fixed: Export Wizard - Fixed an issue that would block running new exports. - Fixed: Export Wizard - Fixed a crash that could occur when changing the default target folder for exports to a path that ends with a slash. 2021.7.0 (16-Sep-2021) ====================== - New: Incremental Migrations & Exports - Export only the newest documents in your collections. - New: MongoDB to SQL Migration - Customize target SQL types or create your own. - New: Data Masking - Added bulk editing, conditional masking based on field types and a new technique: "Replace field value with random string". - New: Import Wizard - Improved and updated the look of the Import Wizard. - Improved: General - Improved application look when the selected light/dark theme differs from the operating system default (Windows and Mac OS only). - Improved: General - Added support on Windows for a dark theme title bar. - Improved: Data Masking - Improved performance when masking an object with nested arrays. - Improved: Export Wizard - The Export Wizard now remembers and suggests the last chosen format selection. - Improved: IntelliShell - Added partial support for mongo shell 5.0. - Improved: IntelliShell - Add auto completion proposals for the shell helper commands "show databases" and "show roles". - Improved: SQL Query - Now supporting comparisons with other fields by using the $expr operator in MongoDB queries. - Improved: Query Code - Now supporting Mongo Java Driver 4.x. - Improved: Table and Tree View - Both Table and Tree View now support navigation with the HOME and END keys. - Improved: Connection Manager - Studio 3T will now remember the width of columns on the Connection Manager window. - Improved: Tasks - Added a new option to rename a task from its contextual menu. - Improved: Query History and Bookmark Manager - Searches in the Bookmark Manager are now case insensitive. - Fixed: General - Fixed crash when dropping a high number of databases. - Fixed: General - Fixed issue where read-only results would continue to allow operations if the _id field was projected out. - Fixed: General - Fixed issue where the read-only lock icon would erroneously display as disabled in read-only Query Assist results. - Fixed: Connection Manager - Fixed issue where directly connecting to a single replica set member would erroneously connect to the entire replica set. - Fixed: Connection Manager - Fixed a crash that could occur when importing an invalid connection string from the clipboard. - Fixed: Data Masking - Fixed issue when masking a string field with the substring regex match technique. - Fixed: IntelliShell - Fixed a crash that could occur when using Studio 3T's code formatter on a script. - Fixed: IntelliShell - Fixed an issue where a direct connection to a server would connect to the full replica set. - Fixed: Visual Query Builder - Fixed an issue where the Visual Query Builder would mistake an "ObjectId" in a textual query to be a "String". - Fixed: JSON Editors and Viewers - Fixed Studio 3T hanging when a search would find a match in a collapsed section. 2021.6.1 (30-Aug-2021) ====================== - Fixed: IntelliShell - Some cursor methods not working for DNS Seedlist connections. 2021.6.0 (24-Aug-2021) ====================== - New: SQL Migrations - Load and use Hackolade schema files within Studio 3T. - New: Connection Manager - Now supporting MongoDB Read Preference Tag Sets. - New: Connection Manager - Added option to set initial page size on a per-connection basis. - New: Export Wizard - Support for placeholders in target file and folder names. - New: JSON Editor and Viewers - Collapse and expand sections of JSON documents. - Improved: General - Upgraded to the latest MongoDB Java driver of version 4.3, compatible with MongoDB 5.0. - Improved: General - Added support for connecting to a serverless Atlas instance. - Improved: General - Added option to "Open recent" files in IntelliShell, SQL Query tab, Aggregation Editor, and Map-Reduce tab. - Improved: JSON Editor - Added support for the UUID function without arguments in all JSON documents. - Improved: Aggregation Editor - Support $out stages that write to Data Lake with Amazon S3. - Improved: Aggregation Editor - Added $search operator to aggregation pipeline, and other aggregation improvements released with MongoDB 4.4. - Improved: IntelliShell - Optimized IntelliShell startup time and improved startup UI. - Improved: IntelliShell - Added support for more find query cursor methods in Query Assist. - Improved: IntelliShell - Added support for using index specification documents when creating an aggregation hint. - Improved: Migration from SQL - Drastically improved speed of SQL operations with Oracle SQL; they now execute up to 44 times faster than before. - Fixed: General - Fixed issue with blurry data type icons, e.g. as shown in Table and Tree Views. - Fixed: General - Fixed issue where the JSON formatter compressed queries erroneously. - Fixed: Connection Tree - Fixed issue of replica set members not shown in the Connection Tree. - Fixed: Connection Manager - Corrected the width of the Connection Manager window on macOS Big Sur (macOS only). - Fixed: JSON Editor - Fixed issue with JSON editor not displaying first lines of content (macOS only). - Fixed: Tree View - Fixed issue when navigating a nested result tree with the left and right arrow keys. - Fixed: Table and Tree View - Fixed issue with shortcuts AltGr + 1/2/3 on some keyboard layouts. - Fixed: Table and Tree View - Fixed issue with last row of Table/Tree View not displaying (macOS only). - Fixed: Collection Tab - Fixed crash that could occur with some invalid queries. - Fixed: SQL Query - Fixed pop-up menu appearing in the SQL tab, even when there is no document present. - Fixed: Visual Explain: Fixed missing icon for EOF stages. - Fixed: IntelliShell - Fixed issue where saving an IntelliShell script would not update its respective tab title. - Fixed: IntelliShell - Fixed issue with code formatting that could break shell helper commands that contain names with special characters. - Fixed: Visual Query Builder - Fixed crash when changing field type to Reference. - Fixed: Export and Import Wizard - Fixed issue where exports with mongodump and imports with mongorestore would report an unclear status. - Fixed: Session Restore - Fixed crash that could occur when restarting Studio 3T with Session Restore enabled. - Fixed: Data Masking - Fixed crash occurring when editing a Data Masking task and the source connection is deleted. 2021.5.1 (28-Jul-2021) ====================== - Fixed: General - Fixed a crash that could occur when working with connections that have a huge number (> 800) of databases. - Fixed: Exports - Fixed an issue that could crash Studio 3T when working with a task that uses disconnected or deleted connections. - Fixed: Exports - Fixed an issue where the command logged for mongodump and mongorestore could reveal the credentials of a connection. - Fixed: IntelliShell - Reverted a change that could create a big number of result tabs from documents embedded in textual shell output. 2021.5.0 (20-Jul-2021) ====================== - New: Data Masking - Shuffle, a new Data Masking technique. - New: Collection Tab - Added two-way interaction between the Query Bar and Visual Query Builder on a collection tab. - New: Operations Tab - Added an option to expand the Operations pane into its own tab. - New: MongoDB 4.4 - Now bundling MongoDB 4.4 tools with Studio 3T installations. - Improved: Connection Manager - The connection manager now allows to assign a keyboard shortcut to every connection. - Improved: Connection Tree - Added options to show nodes for users, roles and functions of a database (Preferences > Appearance). - Improved: Connection Tree - Improved search and added a context menu to the search results. - Improved: Connection Tree - Show the size of an index in the Index Properties tab (right-click index > Show Properties). - Improved: IntelliShell - Added a new option to pin all result tabs of a script execution to keep them open. - Improved: IntelliShell - Introduced a new option to restart the mongo shell process from the toolbar of an IntelliShell tab. - Improved: Visual Query Builder - Introduced an option to turn off the automatic completion of field names while typing. - Improved: Export Wizard - The exact command line of a mongodump or mongorestore execution is now available from an export unit's log. - Improved: Migration from SQL - Improved overall performance of a running migration task. - Fixed: Aggregation Editor - Fixed error thrown when using simplified form of the $merge pipeline stage. - Fixed: Table View - Fixed shift + double-click behavior, in order to let it step into a cell again. - Fixed: Visual Explain - Change the default double-click behavior on explain stages to show the original JSON fragment for each stage. - Fixed: Data Compare & Sync - Fixed an issue where the option "Retain original target document _id" did not work as expected. - Fixed: Migration from SQL - Fixed a crash that could occur when nesting array mappings. - Fixed: Session Restore - Fixed crash when editing a restored "Edit View" tab. - Fixed: Session Restore - Fixed an issue with the Visual Query Builder not restoring field values. 2021.4.1 (01-Jul-2021) ====================== - Fixed: Edit View - Fixed an issue where running the aggregation pipeline of a view would return incorrect or no results at all. - Fixed: JSON Editor - Fixed an issue where the confirmation dialog of the JSON Editor could not be closed with Ctrl/Cmd + Return. 2021.4.0 (24-Jun-2021) ====================== - New: Hotkeys - Customize and add your own shortcuts. - New: SQL Query - Now supporting SQL smart auto-completion. - New: JSON View and Editor - Simultaneously edit multiple JSON documents and view JSON results as pure JSON. - New: Data Masking - Now supporting different source and target connections. - New: Indexes in a collection can now be individually copied and pasted. - Improved: General - Extended the option to include a collection's database name in tab titles to more tabs. - Improved: IntelliShell- Query Assist result tabs now always display headings corresponding to the line number of the executed query. - Improved: IntelliShell - The limit on the maximum line count in the Raw Shell Output is now configurable. - Improved: MongoDB to SQL Migration - Increased field limit for default mappings from a hundred to a thousand fields. - Fixed: General - Fixed issues that could occur with collection names that included spaces. - Fixed: General - Fixed an issue that could occur when trying to resolve server addresses using MongoDB DNS SRV connection strings. - Fixed: SQL Query - Fixed an issue where the export of results from some SQL queries would not be available. - Fixed: Collection Tab - Fixed sizing issue for input fields in the collection tab. - Fixed: Reschema - Fixed a crash that could occur when editing a task associated with a disconnected connection. - Fixed: Tasks - Tasks associated with a specific connection will now update properly when the connection is deleted. - Fixed: Table View - Optimized cell editing in Table View. 2021.3.1 (02-Jun-2021) ====================== - Fixed: SQL Query - Fixed a crash that could occur when trying to export the results of a query. 2021.3.0 (25-May-2021) ====================== - New: Improved Dark Theme. - New: Data Masking - Now available on exports. - New: Visual Explain - Improve aggregation query performance. - New: Improved search in Tasks, Data Masking & Query History. - Improved: Aggregation Editor - Added option to deactivate automatic completion on Aggregation Editor stage tabs. - Improved: Data Compare & Sync - Added option to allow treating 'null' values on match fields just like any other value. - Improved: Export Wizard - Added rescan component to the source widget, CSV, and SQL export unit tabs. - Improved: Export Wizard - Added option to clear an existing collection, instead of dropping it, to preserve index definitions. - Improved: Import Wizard - Added option to clear an existing collection, instead of dropping it, to preserve index definitions. - Improved: In-Place Data Editing - Now supporting aggregation pipeline commands to update your documents. - Improved: In-Place Data Editing - Added option to introduce new field in all existing documents of a collection. - Improved: IntelliShell - Now fully supporting index hint options in IntelliShell. - Improved: MongoDB to SQL Migration - Increased maximum number of documents that can be scanned to set up a migration. - Improved: Query History - New functions in query history and bookmarks: Save a query history item as a bookmark, clear history, and more. - Improved: Reschema - Added rescan component to the source widget. - Improved: Reschema - Now pre-filling connection tree in source and target selection wizards. - Improved: SQL to MongoDB Migration - Improved import UI navigation. - Improved: SQL to MongoDB Migration - Added option to clear an existing collection, instead of dropping it, to preserve index definitions. - Fixed: General: Fixed bug when attempting to navigate between tabs from the toolbar. - Fixed: IntelliShell - Fixed bug when executing long lines of script. - Fixed: Query History - Fixed missing toolbar action when opening a new SQL tab. - Fixed: Table View - Fixed additional columns showing up after editing on Table View. 2021.2.0 (15-Mar-2021) ====================== - New: Task Scheduler - Now available in all editions. - New: Result Tab - Copy and paste query results to Excel and CSV. - New: General - Multi-line text editor for JSON now supports automatic word wrapping. - Improved: Aggregation Editor - Included "Other" option in the stage operator drop-down menu. - Improved: Connection Manager - Now preserving the checkbox state when changing the order of connections during import. - Improved: Data Compare & Sync - Improved text legibility (macOS only). - Improved: Data Compare & Sync - Added ability to turn off the "noCursorTimeout" option. - Improved: Export Wizard - Now pre-filling the Connection Tree in the wizard when choosing "Connection Tree item" as a source. - Improved: IntelliShell - Restored parsing of up to 10 non-contiguous documents and arrays from the raw shell output. - Improved: SQL to MongoDB Migration - Improved UX when importing units using custom SQL queries. - Fixed: General - Fixed margin and dialog layout issues (macOS Big Sur only). - Fixed: General - Fixed query formatting to again include missing space characters. - Fixed: General - Fixed application freezing when disconnecting without a network connection. - Fixed: Aggregation Editor - Now excluding $out and $merge stages when counting aggregation results. - Fixed: Collection Tab - Fixed bug when changing fields using "Document matching query criteria" with unsupported field types. - Fixed: Connection Manager - Fixed "RSA modulus is even" error when opening SSH tunnel. - Fixed: Current Operations - Restored option to "Kill Operation". - Fixed: Data Masking - Fixed crash that could occur when collections contain OS reserved characters. - Fixed: GridFS Support - Fixed UX issues in the bottom bar of the GridFS Bucket tab. - Fixed: Index Manager - Fixed crash with invalid collation options in "Add Index", improved validation error messages. - Fixed: IntelliShell - Fixed crash that could occur when executing invalid queries at cursor. - Fixed: Query History and Bookmark Manager - Clicking the down arrow now again opens a search on the query history. - Fixed: Query History and Bookmark Manager - "Overview" component no longer disappears when changing the window width. - Fixed: Reschema - Now correctly applying the chosen insertion mode when updated. - Fixed: Session Restore - Fixed Session Restore for Visual Query Builder. - Fixed: Session Restore - Fixed checkboxes in the Query section when using Light Mode (Linux only). - Fixed: Visual Explain - Now recognizing projections and rendering them correctly. 2021.1.1 (10-Feb-2021) ====================== - Fixed: Result Tab - Fixed crashes when editing "regex" values using the dialog that opens with the "..." button. - Fixed: IntelliShell - Fixed a crash that would occur when trying to cycle through tabs of an IntelliShell. - Fixed: IntelliShell - Fixed crashes that could occur when trying to run a script while the shell is still busy. - Fixed: IntelliShell - Fixed crashes that would occur when executing big scripts with over a million characters. - Fixed: IntelliShell - Fixed missing syntax highlighting for multi-line comments (/* ... */) in script editors. - Fixed: IntelliShell - Fixed shortcut Ctrl/Cmd-Enter to run the command at the cursor position, like in previous releases. 2021.1.0 (02-Feb-2021) ====================== - Improved: IntelliShell - A better, faster mongo shell. - Improved: General - Rolled out the second phase of Big Sur compatibility updates. - Improved: General - Now limiting batch size for simple queries to optimize performance. - Improved: Connection Manager - Now remembers sort column and order when reopened. - Improved: Connection Tree - Shortcut to expand/collapse connections now works on all selected connections. - Improved: Collection Tab - Introduced a broom icon that clears the query, projection, sort, skip, and limit parameters in one click. - Improved: Collection Tab - Added more options in the Result tab drop-down to view 1, 5, 10, 25, 50, 100, or 200 documents per page. - Improved: Document JSON Viewer - Added _id hover tooltip. - Improved: Document JSON Viewer - JSON formatter now recognizes single-quoted strings. - Improved: Migration from SQL - Improved error messaging when connection times out while adding a one-to-many relationship. - Improved: Migration from SQL - Added "Reuse Dataset" option to make it easier to re-add all fields in a previously-used dataset. - Improved: Migration to SQL - Renamed MongoDB type option from "Unknown", which is used when multiple types have been detected, to "Mixed". - Improved: Role Manager - Added missing privilege actions: replSetStateChange, moveChunk, and renameCollectionSameDB. - Fixed: General - Fixed crash that could occur when changing themes without restarting Studio 3T. - Fixed: General - Fixed display issues that could occur in multi-monitor setups with different scaling. - Fixed: Binary Value Editor - Fixed errors when exporting binary, binary legacy, and function data types. - Fixed: Connection Manager - Fixed performance issues that could occur when opening a database with thousands of collections. - Fixed: Data Compare & Sync - Fixed scrolling issues that could occur in the Differences tab. - Fixed: Data Masking - Now showing all fields as the default view when a configuration is reset. - Fixed: Data Masking - Fixed random values generated by the masking technique "Negate boolean value". - Fixed: Migration to SQL - MongoDB to SQL migrations run from the Task Manager now reflect the correct SQL target format. - Fixed: Query Manager - Fix the time shown for "Execution date and time" and "Last modified date and time" to show in 24-hour format. - Fixed: Reschema - Fixed an issue with "unwind" on arrays. - Fixed: Reschema - Fixed an issue where the toolbar icons in Light Mode appeared too small. - Fixed: Result Tab - Introduced a keyboard short-cut for "Follow Reference". - Fixed: SQL Tab - Fixed UX issue, Query History and Bookmark Manager icons now always visible. - Fixed: View Manager - Now saving custom collation options, fixed redundant in-app messaging. - Fixed: Visual Explain - Fixed display issues when using high DPI settings (Windows only). - Fixed: Visual Query Builder - Fixed display issues when using high DPI settings (Windows only). 2020.10.1 (16-Dec-2020) ======================= - Fixed: Reschema - Fixed a crash that could occur when trying to unwind an empty array. - Fixed: Editor Search - Fixed freezes of Studio 3T that could happen when using the editor search feature. - Fixed: Copy Collection - Fixed failures with collections that contain indexes with a TTL value of type 'NumberInt'. - Fixed: Collection Statistics - Fixed the collection statistics tree to show more than one level of information. 2020.10.0 (09-Dec-2020) ======================= - New: Data Masking - Obfuscate collections on a field level. (Enterprise only) - New: Reschema - Move collections to a new schema. (Pro and Enterprise only) - Improved: General - Rolled out first phase of macOS Big Sur compatibility updates. - Improved: General - Removed mongo tool bundles of version 3.0, 3.2, and 3.4 to reduce installer size. - Improved: General - Implemented new design for source/target selection widget in export tasks. - Fixed: General - Operations timer now runs when carrying out various operations like copy/paste collections and exports. - Fixed: Formatting - Fixed issue of illegal space characters being added to regexes. - Improved: Collection Tab - Added short-hand query options to search by _id in the Query Bar. - Improved: Collection Tab - Restored milliseconds view in the Result Tab's query elapsed time indicator. - Improved: Connection Tree - Now displaying replica set names. - Improved: Dark Theme - Fixed UX issues when used in tandem with Export Wizard. - Improved: Dark Theme - Improved legibility of drop-down options in Aggregation Editor and toolbar texts. - Improved: Dark Theme - Brought back foreground colors on Ubuntu, e.g. color coded connections in the Connection Tree. - Improved: Export Wizard - Improved UX flow. - Fixed: Data Compare and Sync - Fixed issue with differences appearing in the Overview tab but not in the Differences tab. - Fixed: Data Compare and Sync - Fixed crash that could occur when used with Tasks. - Fixed: Export Wizard - Fixed crash that could occur when exporting an aggregation query from the clipboard. - Fixed: Export Wizard - Fixed exports failing with "Illegal state: No users to detach". - Fixed: MongoDB to SQL Migration - "New mapping" will now respect the provided number of documents to scan, instead of defaulting to 50. - Fixed: Server Status Charts - Fixed an issue where errors were reported redundantly. - Fixed: Session Restore - Fixed an issue with auto-completion not working in restored stage editors of Aggregation Editor tabs. - Fixed: Session Restore - Fixed an issue where a broken saved session would prevent Studio 3T from starting. - Fixed: Session Restore - Fixed a crash that could occur when closing restored SQL to MongoDB migration tabs. - Fixed: Tasks - Fixed a crash that could occur when trying to edit an export task with a deleted source connection. 2020.9.3 (28-Oct-2020) ====================== - New: Licensing - Added proxy authentication support for License Manager connections. - Fixed: Connection Manager - Fixed an issue in some connections where server addresses fail to resolve. - Fixed: JSON Formatter - Fixed issues that could occur when formatting constructor arguments or empty arrays. 2020.9.2 (21-Oct-2020) ====================== - Fixed: Query Manager - Fixed a crash that could occur while using bookmarks created with Studio 3T versions older than 2019.7. 2020.9.1 (20-Oct-2020) ====================== - Fixed: General - (macOS only) Fixed an issue that could lead to random crashes on macOS. 2020.9.0 (15-Oct-2020) ====================== - New: Query Manager - Unify Query History and Bookmark Manager. - New: Result Tab - The elapsed time for running queries is now shown in many places. - New: Connection Manager - Allow more control over databases that are added to the connection tree. - Improved: Feedback - Improved in-app feedback mechanism, now auto-filling fields. - Fixed: General - Fixed issues that could occur when typing Chinese characters in editors. - Fixed: General - Fixed issue where "Copy Database" would continue to copy views, even after it has been cancelled. - Improved: Dark Theme - [macOS only] Fixed visual glitch in Visual Query Builder during certain hover actions. - Improved: Preferences - Improved messaging under Preferences > Proxy to warn about missing proxy support on IntelliShell. - Improved: Export Wizard - Improved UX when invalid input is detected while editing the query of an export unit. - Improved: Collection Tab - Improved the Multi-line query editor UX to match those found in other places. - Improved: Aggregation Editor - Added support for $unionWith stage. - Improved: Aggregation Editor - Stage operators now shown in the stage tabs for easier navigation. - Improved: Connection Manager - Now automatically detects and parses connection strings from MongoDB Compass. - Improved: Connection Manager - Now displaying a security reminder when "None" or "Legacy" is chosen as the authentication method. - Improved: MongoDB to SQL Migration - Improved in-app tutorial. - Improved: Visual Query Builder - Now rejecting drag-and-drop of fields with unsupported data types, showing a message dialog instead. - Fixed: Tasks - Brought back confirming and closing "Save Task" dialogs with the Enter key. - Fixed: Tasks - [Ubuntu only] Fixed UI issues when highlighting a cell in the Status column; icons also now showing when a task is selected. - Fixed: Dark Theme - Improved readability of the selected task's name in the Task Manager. - Fixed: Export Wizard - Fixed crash that could occur when running an export task after closing all of its unit tabs. - Fixed: Collection Tab - [Windows only] Fixed Expand and Expand Recursively when multiple documents are selected. - Fixed: Connection Tree - [Ubuntu only] Fixed issue with color-coded connections. - Fixed: Connection Tree - Fixed issue with collections being removed, even though they haven't been dropped, e.g. due to missing permissions. - Fixed: Connection Manager - [Ubuntu only] Fixed status colors in the Test Connection window. - Fixed: Connection Manager - Fixed parsing issue with NoSQLBooster connection strings. - Fixed: Connection Manager - Fixed SRV connections that failed when configured to use a custom Root CA certificate. - Fixed: Aggregation Editor - Fixed code formatting issues in the stage editor. - Fixed: Data Compare and Sync - Fixed color transparency levels in the Comparison Unit table. 2020.8.0 (10-Sep-2020) ====================== - New: Introducing our new product: Server 3T - Run migrations between SQL and MongoDB remotely. - New: Collection Tab - Change sort order of queries in one click. - New: Connection Manager - Disconnect from all connections in one go. - New: Connection Manager - Auto-detect and import connection strings copied to clipboard. - Improved: General - Improved responsiveness of auto-completion in scripts. - Improved: General - Improved visibility of separator labels on Ubuntu 20.04. - Improved: General - Now showing dark title and toolbar on macOS in dark mode. - Improved: Visual Query Builder - Improved color definitions in Visual Query Builder. - Improved: Export Wizard - "Other options" now updating whenever source is updated. - Improved: Export Wizard - Export units with cursor/selected documents as source can now be saved. - Improved: Map-Reduce - Database names now displayed in Map-Reduce tab names. - Improved: SQL to MongoDB Migration - Improved custom SQL query in-app messaging. - Fixed: General - Fixed issue with weird characters appearing as tab names. - Fixed: SQL Query - Restored missing right-click copy options. - Fixed: Map-Reduce - Restored missing right-click copy options. - Fixed: Aggregation Editor - Restored missing right-click copy options. - Fixed: Visual Query Builder - Fixed UI issues on Linux. - Fixed: Role Manager - Fixed issues with editing and updating role privilege actions. - Fixed: Quickstart Tab - Now showing correctly upodated colors in color-coded connections. - Fixed: Export Wizard - Fixed issues with loading indicators shown on Ubuntu. - Fixed: Export Wizard - Fixed crash on export issues on Linux with unsupported MongoDB version. - Fixed: Export Wizard - Fixed issues related to mongodump exports failing when collection names contain a colon. - Fixed: Export Wizard - Fixed issue related to export files being overwritten during failed current cursor exports. - Fixed: Data Compare & Sync - Fixed crash that could occur when editing a DCAS task on an undocked window. - Fixed: Import Wizard - Fixed crash that could occur when clicking options on and off with BSON archive imports. - Fixed: Import Wizard - Target collection now emptied when target database is disabled during BSON archive imports. - Fixed: SQL to MongoDB Migration - Fixed issues with username label shown for Oracle connections. 2020.7.1 (10-Aug-2020) ====================== - New: Licensing - Added proxy support 2020.7.0 (27-Jul-2020) ====================== - New: Table View - Copy selected documents to CSV. - New: Export Wizard - Edit find() queries on an export tab. - New: Query History - Added a new option to allow a custom limit for the number of history entries. - New: MongoDB to SQL Migration - Running a migration will write warnings and errors to a log file. - Improved: SQL to MongoDB Migration - Removed special handling of the internal MongoDB timestamp field type. - Fixed: Result Tab - Brought back "Copy Field Name" option on all table and tree views. - Fixed: Result Tab - Fixed issue with tooltip values being cut off by their corresponding column widths. - Fixed: Aggregation Editor - Pasting a script from clipboard now doesn't override the associated script file. - Fixed: IntelliShell - Fixed an issue that could occur on connections using an SSL certificate and a passphrase. - Fixed: Reference Dialog and Follow Reference - Fixed a crash that could occur when trying to resolve an invalid DBRef. - Fixed: JSON Validator - Fixed the width of the "Edit Validator" dialog when opened on connections that have long names. - Fixed: SQL Import - Fixed a crash that could occur when disconnecting from then reconnecting to a target connection. - Fixed: Connection Manager - Fixed inconsistencies in server names and port numbers when importing connection URIs from other tools. - Fixed: Export Wizard - Fixed an issue with missing export source information when exporting current cursor/selected documents. - Fixed: Session Restore - Fixed a crash that could occur when closing a restored collection tab when the Explain tab is selected. 2020.6.1 (09-Jul-2020) ====================== - Fixed: General - Fixed a memory management issue that could lead to crashes and slower app performance. 2020.6.0 (02-Jul-2020) ====================== - New: In-app makeover with a new look, new colors and better tabs. - Improved: General - Improve behavior when closing tabs with using the middle mouse button. - Improved: Connection Manager - Each connection now shows the date it had last been accessed. - Improved: Connection Manager - Improved handling of imported Robo 3T connections, SSL credentials now being imported. - Improved: Connection Manager - Include local mongo tools settings for connections in exports and imports. - Improved: Connection Tree - Added update shown connection names after they have been edited. - Improved: Export Wizard - Improved handling of GridFS bucket exports. - Improved: Export Wizard - Improved handling of export units that write results to the clipboard. - Improved: Aggregation Editor - Drastically improved performance when working with many aggregation stages. - Improved: Aggregation Editor - Added shortcuts for new stages: $merge, $planCacheStats, $replaceWith, $set, $unset. - Improved: Aggregation Editor - Added ability to change databases, collections, and connections for aggregation queries. - Improved: Aggregation Editor - Improved legibility of Refresh button and pagination controls when results are out of date. - Improved: Aggregation Editor - Support code formatting in stage editor (use Ctrl + Alt + L to format code). - Improved: Aggregation Editor - Improved notifications in the Explain tab. - Improved: SQL Query - Commenting with line comment now preserves selection. - Improved: Schema Explorer - Improved readability of schema analysis progress. - Improved: Data Compare & Sync - Improved UX of compare results tab after session restore. - Improved: Visual Query Builder - Added support for DBref (Reference) value. - Fixed: Table View - Fixed bug when sorting a query result on a binary data field. - Fixed: Table View - Fixed settings so that changes to views do not affect global settings. - Fixed: Tasks - mongodump and mongorestore imports and exports now work with MongoDB Atlas SRV connections. - Fixed: Export Wizard - Fixed a crash that could occur when trying to directly export an index of a collection. - Fixed: Aggregation Editor - Fixed crash that could occur when reordering the pipeline in an undocked aggregation window. - Fixed: Data Compare & Sync - Fixed bug in exported data when there is an instance of "No source/target document matched". - Fixed: Data Compare & Sync - Fixed bug when adding non-object, non-array values. - Fixed: Ubuntu Installer - Fixed text visibility on the installer for Ubuntu 20.04 in Dark Mode. - Fixed: IntelliShell - Fixed keyboard shortcuts when switching between Table, Tree, and JSON Views. - Fixed: Import Wizard - Fixed a crash that could occur when using a source file name with special characters. - Fixed: MongoDB Migration - Fixed bug where the "Scanning collections" would overlap the "First steps". - Fixed: Session Restore - Custom tab names are now restored when starting from a previous session. - Fixed: Session Restore - Data Compare & Sync now restores comparisons configured for system collections. - Fixed: SQL to MongoDB Migration - Fixed validation issues. - Fixed: SQL to MongoDB Migration - Fixed truncated source and target connections. - Fixed: SQL to MongoDB Migration - Fixed SQL Server import behavior for columns names with trailing spaces. - Fixed: SQL to MongoDB Migration - Fixed blank lines that appeared when clicking on an empty source SQL database. - Fixed: SQL to MongoDB Migration - Fixed decimal type handling and mapping, now maps to the BSON counterpart Decimal128. - Fixed: SQL Query - Fixed keyboard shortcuts when switching between Table, Tree, and JSON Views. 2020.5.0 (13-May-2020) ====================== - New: Connection Manager - Encrypt stored passwords via our new cryptographic key store. - Improved: SQL to MongoDB Migration - Added support for importing custom SQL Queries to MongoDB. - Improved: Export Tasks - Added the ability to change target folders for all export units of a task. - Improved: Session Restore - Restore the width of Visual Query Builder in Collection Tab and IntelliShell. - Fixed: Table View - Make "Step Into Cell" behave correctly with documents missing the '_id' column. - Fixed: Table View and Visual Query Builder - Fixed situations where tool tips would 'block' input editors. - Fixed: Session Restore - Fixed an issue with restoring the option "Allow disk use" in Aggregation Editors. - Fixed: Copy/Paste Collection - Preserve all 'capped' options and settings when copying a collection. - Fixed: Collection Statistics - Fixed an error that could occur with very large databases or collections. 2020.4.0 (14-Apr-2020) ====================== - New: License Manager - Manage licenses in one place, online. - New: SQL Migration - Added support for the migration from and to IBM DB2. - Improved: SQL Migration - The migration to SQL now allows to automatically drop existing tables. - Improved: Export Tasks - Improved handling of connections with password prompts. - Improved: Export Tasks - Added support for changing the source of a configured export task. - Improved: Export Tasks - Introduce a global and customizable default target folder for new export units. - Improved: Aggregation Editor - Fixed disabled editors of stages that have been excluded from the pipeline. - Improved: Server Status Charts - Added a notification that is shown for users with insufficient permissions. - Fixed: Export Tasks - Restored the option to show the results of an export in the system's file explorer. - Fixed: Export Tasks - Fixed several issues with the schema scan and export of long running aggregate queries. - Fixed: CSV Import - Fixed a crash that could occur when the delimiter of a CSV import task was changed. 2020.3.1 (11-Mar-2020) ====================== - Fix: Connections - Fixed connections to servers running MongoDB development releases, like v4.2.0-rc0. - Fix: CosmosDB - Fixed connections to servers running Microsoft Azure CosmosDB 3.2 (no official support). 2020.3.0 (06-Mar-2020) ====================== - New: Connection Configuration - Improved interface for different connection types. - Fix: Table View - Fixed a crash that could occur when dragging values during a running operation. - Fix: Aggregation Editor - Fixed appearance of pipeline and stage result views in Dark Mode. - Fix: Aggregation Editor - Fixed shortcut ALT + '7' for users of non-international keyboard layouts. - Fix: Data Compare and Sync - Fixed an error that could occur with documents that have many children. - Fix: Refresh View - Fixed menu entries and shortcuts for "Refresh View". - Improved: MongoDB Tool Bundles - Updated bundled MongoDB tools for version 4.0. - Improved: Application Startup on Linux - Improved long startup times of Studio 3T on Linux. 2020.2.1 (18-Feb-2020) ====================== - Fix: Studio 3T on macOS - Fixed startup of fresh installations of Studio 3T on macOS. - Fix: Connection Configuration - Fixed empty server address for connections of type DNS Seedlist. 2020.2.0 (14-Feb-2020) ====================== - New: Aggregation Editor - Improved layout and user experience. - New: Export Wizard integration with Tasks - Exports can now be saved, automated, and scheduled as tasks. - New: SQL Migration - The migration from SQL now supports the import from Sybase databases. - New: Collection Tab - Allow to set a default query per collection. - Fix: Table View - Fixed an issue with hiding columns. - Fix: IntelliShell - Fixed issues that could occur when running long shell scripts. - Fix: CSV Import Task - Fixed loading saved tasks and restoring them from a previous session. - Improved: IntelliShell - Support connections to servers that use IPv6. - Improved: Visual Query Builder - Improved cloning rules and drag & drop of fields. - Improved: Aggregation Editor - Allow to paste aggregate queries that have an empty pipeline. 2020.1.2 (17-Jan-2020) ====================== - Fix: Collection Statistics - Fixed an error that occurred with big values of 'storageSize'. - Fix: Session Restore - Fixed startup of Studio 3T with Session Restore (beta) enabled on macOS. 2020.1.1 (10-Jan-2020) ====================== - Fix: Table View - Improved horizontal scroll experience in table view when no search is active. - Fix: CosmosDB - Fixed listing collections for connections to Microsoft Azure CosmosDB (no official support). 2020.1.0 (07-Jan-2020) ====================== - New: Quickstart - Enjoy quick access to the most popular options and features in Studio 3T at one glance. - New: What's New - Find the latest Studio 3T release notes, product updates etc. under the separate What's New tab. - Fix: Table View - Fixed a rare crash on Windows that occurred when a table view with an id column was shown. - Fix: Aggregation Editor - Fixed a noticable slowdown in the stage editor performance with bigger aggregation stages. - Improved: Dark Theme - Many improvements to the user interface with dark theme enabled. - Improved: SQL Migration - The migration to SQL now supports a wider charset for the data export: UTF8 MB4. - Improved: JSON View - Support standard options to copy documents, just as in the table and tree view. - Improved: Connection Tree - Introduced option "Duplicate Collection" to easily duplicate a collection. 2019.7.1 (18-Nov-2019) ====================== - Fix: Table View - Fixed broken up/down arrow key navigation. 2019.7.0 (13-Nov-2019) ====================== - New: Session Restore - Automatically save the state of Studio 3T on shutdown and restore it on the next start (BETA). - New: MongoDB Tools Integration - Allow connections to define a specific set of MongoDB tools, overriding global defaults from preferences. - New: Table and Tree View - Both the table and tree view for documents now come with their own, integrated search feature. - New: Table View - The table view now allows to configure and automatically apply automatic column widths to result views. - Fix: Create Index - Fixed creating indices with the partial index option. - Fix: Add Collection - Fixed applying custom collation options when a new collection is created. - Fix: Connection Manager - Fixed situations where shown connections would not be updated after changes when a table search was active. - Fix: Fixed a rare crash of the preferences dialog on Linux operating systems when it was opened with the dark theme enabled. 2019.6.1 (22-Oct-2019) ====================== - Fixed: Support for automatic updates on macOS Catalina. - Fixed: Notarized the application to work with macOS Catalina. - Fixed: Optimized some colors for the dark theme on macOS. - Fixed: Issue that prevented selecting/deselecting databases and collections in BSON Import. 2019.6.0 (15-Oct-2019) ====================== - New: Query Code - Now supports Ruby driver code generation. - New: Aggregation Editor - Added 'Duplicate Stage' option. - Improved: Query Code - Improved PHP driver code syntax. - Improved: Query Code - 'Open in IntelliShell' option is now included everywhere Query Code appears. - Improved: JSON View - Introduces clearer, full-width line separators. - Improved: Support full range of all accepted ISO date formats. - Fixed: Certain index options were not honoured at index creation under particular configurations. - Fixed: Export - Order of fields correctly restored when a saved export configuration is loaded. - Fixed: Shift + Del would fail to cut text on Windows in specific situations. - Fixed: Aggregation Editor - Improved handling of non-breaking space characters. - Plus many other smaller fixes and improvements. 2019.5.1 (19-Sep-2019) ====================== - Fixed: Typing slowdown in Aggregation Editor has been addressed. - Fixed: Retain user preferences after theming is applied. 2019.5.0 (28-Aug-2019) ====================== - New: Dark Mode - Studio 3T now includes a dark theme. - Improved: SQL to MongoDB Migration - By default, a mapping for the _id field is now created for the source table's primary key. - Improved: SQL to MongoDB Migration - When connecting to a new SQL server, the validity of existing configured mappings are automatically checked. - Improved: IntelliShell - Fixed connection failures to particular configurations of MongoDB 3.4 or older. - Fixed: Aggregation Editor - Fixed script copied to the clipboard for empty pipelines with collation option. - Fixed: Table View - "Make All Columns Visible" will now also restore all columns that have been reduced to a zero width. - Fixed: Collection Statistics could fail to report in particular circumstances with MongoDB 4.2. - Fixed: Collection Import - Fixed an issue where unique indices could result in collisions. - Plus several other smaller fixes and improvements. 2019.4.1 (02-Aug-2019) ====================== - Improved: Aggregation Editor - Auto-completion will now activate successfully for users that do not have the 'listDatabases' privilege. - Improved: Document editors now support specifying a MongoDB ISODate without separators, such as ISODate("20190801T000000Z"). - Plus several other smaller fixes and improvements. 2019.4.0 (31-Jul-2019) ====================== - New: Aggregation Editor - Auto-completion has now been added to the Aggregation Editor. - New: Collection View - Shell-format find queries (e.g. db.coll.find(...)) can now be pasted directly into Collection View. - Improved: Oracle SQL Connections - Internally using services-based connections for improved compatibility. - Improved: Collection copy no longer exhibits a possible performance drag when there are undefined fields. - Improved: IntelliShell - Selected text can be (un)indented by pressing (Shift+)Tab. - Improved: Aggregation Editor - Queries viewed in Query Code can be opened directly in IntelliShell. - Plus many other smaller fixes and improvements. 2019.3.0 (03-Jun-2019) ====================== - New: MongoDB to SQL Migration - Export your entire MongoDB domain model, expressing full document structure and relationships, into a rich SQL relational model. (Enterprise only) - New: Connection Groups - Arrange connections in related groups in Connection Manager. - New: Query History - Aggregation Editor, SQL Query and IntelliShell all now offer Query History. - New: From the View menu, or via keyboard shortcut, the main toolbar can be hidden/shown. - New: Visual Query Builder - Query clauses and Project and Sort sections can now be dynamically included/excluded in the query. - New: Support for --retryWrites option available in Advanced connection settings. - New: SQL Query - Added support for regexes in JSON where blocks. - New: SQL Query - Queries that translate to a MongoDB aggregation query can now be opened in the Aggregation Editor directly from the Query Code tab. - Improved: SQL to MongoDB Migration - Improved and simplified Mappings tab. - Improved: SQL to MongoDB Migration - Simplified specifying one-to-many relationships. - Improved: SQL Query - Automatically running explain initially is deferred to when the Explain tab is switched to. - Improved: IntelliShell - Faster start-up and command execution times in high latency environments. - Improved: Recent connections - Upon use, recent connections are moved to the top of the recent connections list. - Improved: Visual Query Builder - The shortcut Ctrl/Cmd+B is now used to show/hide the Visual Query Builder. - Improved: CSV Import Task - Manually tweaked mapping types are saved in the task. - Improved: Field Edit Value/Type - Symbol type supported in auto-converting field types. - Improved: Auto-Update - Improved start-up times when checking for new update. - Improved: Current Operations - Included 'Show JSON Document' option for each operation. - Improved: Current Operations - Included 'Show/Hide All Embedded Fields' options in table view. - Fixed: Data Compare and Sync - Comparison succeeds with excluded fields that have null value. - Fixed: Automation - Scheduled tasks can have their schedule removed when no longer using a trial or Enterprise license. - Fixed: Open Connections Tree - Improved handling of invalid validation schema, which may have lead to collections not appearing in MongoDB 4.0 and later. - Fixed: macOS - Restore fullscreen when restarting. - Fixed: Resolved 'No Route To Host' issue in IPv6 handling on macOS. - Fixed: "SSH tunnel error I/O: Bad Item Length" error which could occur in particular configurations. - And several other smaller fixes and improvements. 2019.2.1 (01-Apr-2019) ====================== - New: Double-click a tab header to maximize the tab (within the main application window). - Fixed: SQL to MongoDB Migration - Improved handling of foreign keys. - Fixed: Tasks - Retain scheduling after particular tasks are edited. 2019.2.0 (21-Mar-2019) ====================== - New: SQL to MongoDB Migration - Import your entire SQL domain model, capturing relationships between tables, into a rich MongoDB document model. (Enterprise only) - New: Tasks - Turn often used import, SQL to MongoDB migration and Data Compare & Sync job into tasks, and be able to conveniently view, manage and execute those tasks all with the new Tasks manager. - New: Automation - Schedule tasks to automatically run at specific times or at regular intervals, as you require. (Enterprise only) - New: Support for short SRV connection strings. - Fixed: Prompt for password if empty for basic (SCRAM-SHA-256) authentication. 2019.1.0 (05-Mar-2019) ====================== - New: SQL Query - Support for SELECT DISTINCT statements has now been added. Please see the SQL Query tutorial at https://studio3t.com/knowledge-base/articles/sql-query/ for details. - New: SQL Query - Object values are now supported in SQL queries. Please see the SQL Query tutorial at https://studio3t.com/knowledge-base/articles/sql-query/ for details. - New: The Field menu -> Edit Value / Type... option now supports changing the type of a field, but preserving its value where possible, allowing you to cleanse data types throughout a collection. - New: What's New and Feature Galleries. - Improved: JSON View - UUID types are now rendered in UUID format, rather than in their BinData representation. - Improved: Rendering of Import/Export dialogs on smaller resolutions. - Fixed: Collection View - Certain complex queries failed to export to CSV. - Fixed: Visual Explain - Improved count statistics in certain complex scenarios. - Fixed: Visual Explain - Resolves 'Failed to determine query execution plan' error when running on a newly copied collection. - Fixed: Shortcut to close without being prompted to save is now correctly reported on Windows to be 'Control+Shift+F4'. - Fixed: 'Unsatisfied link error' error which some customers experienced on startup. - Fixed: IntelliShell - Now retains JSON formatting preference selection from elsewhere in the application. - Fixed: Map/Reduce - 'Sample the output of the map() function' option would fail to run in certain conditions. 2018.6.1 (21-Dec-2018) ====================== - Compatibility: Please note, that as of Studio 3T 2018.6.0, support for the deprecated MongoDB Challenge-Response (MONGODB-CR) authentication mechanism has been discontinued. - Improved: Aggregation Editor - Automatically running explain initially is deferred to when the Explain tab is switched to. - Fixed: Visual Explain - Improved handling of unexpected input. 2018.6.0 (19-Dec-2018) ====================== - Compatibility: Support for the deprecated MongoDB Challenge-Response (MONGODB-CR) authentication mechanism is now discontinued. - New: For new feature releases such as this, you can now opt in to the 7-day re-activated trial, where you can try the amazing Pro and Enterprise features of Studio 3T! - New: Visual Explain - Clear diagrams demonstrate how MongoDB executed your query at a glance, with the option to view runtime statistics like stage output counts and execution times. - New: MongoDB 4.0 SCRAM-SHA-256 authentication supported. - New: IntelliShell - Code formatting is now available! - New: IntelliShell - X.509 authentication with encrypted user certificate now supported. - New: Copy collection name from the open connections tree. - New: Copy field name from results. - Improved: Aggregation Editor - Clearly shows errors in queries that are pasted in. - Improved: Aggregation Editor - Additional 'Close tab' options introduced. - Improved: Connection Manager - Improved usability on lower resolution screens. - Improved: JSON View - Documents are visually separated with a distinct separator line. - Fixed: Enterprise - Improved Windows Kerberos compatibility with MongoDB 4.0.3+. - Fixed: SQL Query - GROUP BY now succeeds when _id is composite and its subfields are used in aggregation. - Fixed: Visual Query Builder - Use explicit $and root group if root group contains more than one subgroup of the same type. - Fixed: Some dialogs for which 'Don't show again' was selected may have been shown again. - Fixed: Password-backed SSL certificates could fail to connect in some cases. 2018.5.1 (19-Nov-2018) ====================== - New: Visual Query Builder - New field rules can now be created by cloning existing ones using the "clone field rule" button. - Improved: Improved compatibility with MongoDB Atlas for reporting collection statistics. - Improved: Aggregation Editor results now offer full 'large table' facilities, e.g. showing and hiding embedded fields. - And other smaller fixes and improvements. 2018.5.0 (06-Nov-2018) ====================== - New: Enterprise Edition - License key and several application properties including disabling auto-update, branding, and the path to the Oracle Database driver can now be configured with Windows Group Policies / Administrative Templates. These configuration files are included the Enterprise .MSI download bundle. - New: IntelliShell Visual Query Builder - the Visual Query Builder you know and love from Collection View now comes to IntelliShell! - New: Type Coloring - values in tree and table views are colored according to their type. Colors and types are configurable in Preferences. - New: Read-only Connections - Configure whether individual connections are read-only in Studio 3T by default. - New: Instantly view the equivalent PHP code for your queries with the new PHP support in Query Code. - New: (Un)commenting shortcuts in Aggregation Editor and SQL Query tabs. - Improved: IntelliShell - Faster start-up times. - Improved: Aggregation Editor - Added keyboard shortcuts to create new stage, above and below current stage. - Improved: Introduced option to show a simplified progress report during export, which will be faster when exporting very large amounts of data. - Improved: Import Connections dialog - can now optionally import from clipboard. - Improved appearance of toolbar separators on Ubuntu. - Improved: Simplified open connections view - attempting to open an already open connection simply selects it in the open connections view, rather than showing it twice. - Fixed: Some dialogs may be shown at an extremely small size under some configurations. - And several other smaller fixes and improvements. 2018.4.6 (08-Oct-2018) ====================== - New: Updated bundled MongoDB tools to version 4.0.2. - Fixed: Improved legibility of selected auto-completion proposal on Windows. - Fixed: Editor rendering issue on Linux. 2018.4.5 (28-Sep-2018) ====================== - Fixed: On macOS Mojave, Connection Manager could fail to render properly. - Fixed: Under some configurations, the application would fail to exit upon quit. 2018.4.4 (19-Sep-2018) ====================== - New: Added JSON format chooser to stand-alone JSON document viewer dialog. - Fixed: F3 key short-cut wasn't activated in JSON view. - Fixed: Crash fix for menu when no ConnectionTree node is selected. 2018.4.3 (11-Sep-2018) ====================== - New: HTTP and SOCKS proxy server support. - New: Monitor slow queries of varying duration in the Current Operations tab. - Improved: Current Operations - Can now select to show only a user's own operations. - Improved: IntelliShell - Improved auto-completion of 'rs' and 'sh' objects. - Improved: IntelliShell - Auto-suggesting hints as you type is now configurable in Preferences (auto-completion may always be explicitly invoked with Ctrl+Space). - Improved: IntelliShell tabs closed when connection they were opened on is disconnected. - Improved: Columns in Connection Manager and SQL Connection Manager are sortable. - Improved: Visual Query Builder - Set focus on value after dragging in fields. - Fixed: Added Server Status Charts support for multiple shard servers. - Fixed: Connection Manager - Fixed case where replica set discovery would not succeed. - Fixed: Visual Query Builder - Improved field name character escaping. - Fixed: Schema Explorer - Export to MS Word includes updated Studio 3T logo. - Fixed: Query Code - Removed redundant $project stage from mongo shell equivalents of certain SQL queries. - Fixed: Match Excel's handling of backslash characters when importing CSV. - Fixed: All collation options included in the Add New Collection dialog. - Fixed: GridFS - Successfully cancel adding a file via drag and drop. - Fixed: Auto-import of external connections correctly handles UTF-8. 2018.4.2 (07-Aug-2018) ====================== - Improved: Auto-completion performance improved on remote connections. 2018.4.1 (25-Jul-2018) ====================== - Fixed: Fixed auto-completion of JavaScript code on the IntelliShell. - Fixed: Fixed an issue where user would get an error resulting from having no permissions on admin db when connecting to a Replica Set. 2018.4.0 (20-Jul-2018) ====================== - New: Enterprise - Support for Oracle databases in SQL Import. - New: User Management - Show mongo shell code in user creation tab. - New: Role Management - Show mongo shell code in role creation tab. - New: Visual Query Builder - Added support for $text search. - New: Updated bundled MongoDB tools to version 4.0 - Improved: IntelliShell - auto-completion has been significantly enhanced, now covering completion of JavaScript variables and structures defined in your own code, as well as completion of shell helper methods, object types, and many more! - Improved: General handling of very large documents. - Improved: JSON View - Improved handling of very large binary data values. - Improved: Visual Query Builder - Better handling of field names with special characters. - Improved: Visual Query Builder remembers its relative size. - Fixed: Data Compare and Sync - Improved handling of comparison between a value and an array of values. - And several other smaller fixes and improvements. 2018.3.2 (22-Jun-2018) ====================== - New: Redesigned and improved Visual Query Builder. - New: Non-commercial licenses can now be obtained at https://studio3t.com/discount/non-commercial/ - New: 'Fuzzy' comparison option in Data Compare and Sync for floating point values. - Improved: Enterprise Edition - Multiple Kerberos realms support. - Improved: Handling of special regular expression characters in find and replace. - Improved: DNS resolution in particular complex setups. - Fixed: SQL joins with group by and having or order by clauses that referenced dotted names could erroneously report an empty result set. - Fixed: IntelliShell - Field name suggestions are included in first auto-completion invocation. - Fixed: Improved legibility of find options in dark mode. 2018.3.1 (28-May-2018) ====================== - Improved: Handling of escaped collection/view names in IntelliShell auto-completion. - Improved: Auto-generated shell code favours the getCollection method. - Fixed: Attempting to export aggregation results results in 'Cursor has been closed' error in some circumstances. - Fixed: Field name suggestions in IntelliShell's auto-completion would fail to show in some circumstances. - Fixed: Certain Aggregation Editor steps could produce a crash in particular conditions. 2018.3.0 (14-May-2018) ====================== - New: SQL Joins - Support for inner and left joins via the aggregation $lookup operator in SQL Query. - New: IntelliShell - Support for ES6. - New: Save/load export job settings. - New: MongoDB tools bundled on Linux (Ubuntu). - New: Enterprise Edition - MSI installer with auto-update disabled. - New: SQL Query - 'Execute Selection' query execution mode. - New: Schema Explorer includes 'Top UUIDs' values chart. - New: Table View - Option to expand all embedded fields, i.e. show a 'flattened' view, by default. - New: Export SQL queries that translate to MongoDB aggregation queries. - New: Crash reporter. - Improved: Studio 3T query performance improved over many different workloads. - Improved: Faster CSV import. - Improved: Display of long strings in 'Top Strings' values chart in Schema Explorer. - Improved: Auto-convert OS reserved file name characters in export. - Fixed: Large collections can be successfully copied into themselves. - Fixed: Query Builder inputs may be clipped when using high scaling on Ubuntu. - Fixed: Restored handling of explain option in aggregation queries in IntelliShell. - Fixed: Query Builder menu item correctly enabled. - Fixed: Improved handling of restoring DCS configuration after collection names have changed. - Fixed: Internal document parser accepts empty strings as keys. - Fixed: Import from MS SQL Server auto-suggests long for INT64 data type. - And many other smaller fixes and improvements. 2018.2.5 (06-Apr-2018) ====================== - New: Initial trial of Studio 3T is now 30 days! - Improved: Upgraded the bundled mongo tools on Mac to improve compatibility with newer TLS standards (now required by IBM Compose). - Improved: Changed labels on $or and $and buttons to be more meaningful. - Fixed: False negative status when running Test Connection on some MongoDB Atlas instances. 2018.2.4 (09-Mar-2018) ====================== - Fixed: Issues relating to uninstall failing on Windows. - Fixed: Reintroduce progress indicator for long running Aggregation Editor queries. - Fixed: Clipped port number box in Connection Manager for some Mac configurations. 2018.2.3 (05-Mar-2018) ====================== - New: SQL Query - support for aggregate functions in ORDER BY and HAVING clauses. - Improved: IntelliShell - further improved support for very large aggregation queries. - Improved: Data Compare and Sync - improved handling of connections that are now invalid or missing. 2018.2.2 (02-Mar-2018) ====================== - Improved: Test connection result reporting for Atlas connections. - Fixed: Deserialization of "Allow disk use" option in aggregation queries. - Fixed: Correct 'Count Documents' results for aggregation queries with "$limit" and/or "$skip" stages. - Fixed: ObjectId validation can be subverted in Query Builder. 2018.2.1 (22-Feb-2018) ====================== - Improved: Download failures for auto-update are more clearly reported. - Fixed: Bundled tools use v3.6.2 for all Windows configurations. - Fixed: Linux desktop shortcut was not created under some configurations. - Fixed: Aggregation Query Code failed to update for some particular operators. - Fixed: SQL Query - Count of initial empty result succeeds. 2018.2.0 (15-Feb-2018) ====================== - New: Query Code comes to Aggregation Editor! - New: Data Compare and Sync - you can now export to CSV the differences discovered in an analysis. - Improved: SQL Query - Query Code now covers SQL queries that translate to a MongoDB aggregation query. - Improved: IntelliShell - improved support for very large aggregation queries. - Improved: Data Compare and Sync - improved support for differences scrolling sync when scrolling via mouse wheel on Mac. - Fixed: CSV import did not correctly import arrays. - Fixed: IntelliShell may hold file locks under certain Windows configurations. - Fixed: Windows desktop shortcut was not created under some configurations. 2018.1.0 (07-Feb-2018) ====================== - New: The SQL Query tab now supports GROUP BY and COUNT, MAX, MIN, SUM, and AVG aggregate functions. - New: CSV import now supports various date formats, selectable on a per column basis. - New: Retain Expired Ops in Current Operations now allows to select the interval over which expired ops are retained. - Improved: Stored Functions tab - mark tab as unsaved if another tab overwrites the function. - Improved: Tabs in New / Edit Connection dialog (Server, Authentication, etc.) now become scrollable when viewed on small screens, allowing all thew content to be viewed. - Improved: Aggregation tab now includes 'Count Documents' function. - Fixed: SSH tunnel converts  in password to different character. - Fixed: Redraw issue in Data Compare and Sync tab when expanding/collapsing all. - Fixed: Table correctly reset to root view when new projection is used. 5.7.4 (17-Jan-2018) =================== - Fixed: Databases and collections visible again when connected to Atlas - Fixed: Connect to SQL database server button (on import) - Fixed: Use read preference "Primary" for system.profile - Fixed: Short-cut Ctrl/Cmd + E in GridFS tab wasn't working 5.7.3 (11-Jan-2018) =================== - Improved: Copy multiple collections and paste (i.e. merge) them into a single target collection - Improved: Multiline in-place editor - added Find & Replace options - Improved: Editor - "replace all" honors case sensitivity - Improved: Prompt to save changes upon hitting quit short-cut - Improved: Handling of try-catch-finally blocks in IntelliShell - Fixed: Connection with hundreds of databases (and each hundreds of collections) could stall UI - Fixed: Close/Save confirm dialog were hidden behind pulled out tabs - Fixed: On Linux - exit short cut is now Ctrl+Q again - Fixed: Unicode chars were not stored properly in query history - Fixed: Databases and collection names weren't visible when directly connecting to a secondary - Fixed: From URI - proper handling of '+' characters in passwords - Fixed: Table component could get stuck under certain configurations on macOS 5.7.2 (20-Dec-2017) =================== - New: Updated to latest 3.6 MongoDB driver => fixes issue with $out aggregation stages - Improved: Copy Field menu option copies full path name of field now - Improved: Installer dialog windows are now resizable - Fixed: JSON editor - Find & Replace UI 5.7.1 (06-Dec-2017) =================== - Fixed: Check for previous versions during installations on Windows could end up taking a long time to finish - Fixed: S3T accidentally was always-on-top on Windows 5.7.0 (05-Dec-2017) =================== - New: Added support for "$listSessions" aggregation stage operator (MongoDB 3.6) - New: Added support for custom Server Name Indication (SNI) when using SSL connections. - New: Data Compare & Sync - specify source and target projections - New: Data Compare & Sync - option to show only differing fields - Improved: Expand / Collapse all menu items in Data Compare & Sync differences tab - Improved: Allow choosing and opening multiple scripts - Improved: Double click didn't expand tree items on import from another collection tree view - Improved: Add maximize button to View JSON dialog - Improved: conventional keyboard short-cuts to flick through tabs - Improved: "Close tab" short-cut applies to (sub) tab folder that has focus - Improved: Use more conventional exit short-cut Alt+X on Windows and Linux (rather than Ctrl+Q) - Improved: Handle display of invalid UUIDs (BinData(4, "...") and BinData(3, "...") ) more gracefully - Improved: Expand/collapse Operations pane by double-clicking header - Fixed: Issue with View menu/Shortcuts being disabled for comparison results tabs - Fixed: Right-click on GridFS collection showed to menu items with "enter" shortcut - Fixed: Wrong timestamps of MS Word files generated for schema documentation - Fixed: Short-cuts weren't refreshed after tab was pulled out - Fixed: Data compare & sync - when synchronizing entire document, UI status could get stuck - Fixed: Flickering progress report of mongodump exports of large collections - Fixed: CSV export of static array results in IntelliShell - Fixed: "Follow Reference" option in IntelliShell results - Fixed: Data Compare & Sync - "Compare" tab in configuration dialog - option selection was faulty - Fixed: Query builder - elemMatch with "equals", "contains", "starts with", and "ends with" operators - Fixed: DB-level collection stats: suppress redundant and empty _id column - Fixed: Expired operations weren't grayed out in Current Ops View 5.6.4 (17-Nov-2017) =================== - Improved: Performance when opening collections (especially with large documents) - Improved: More robust launch script for Linux - Fixed: Better error handling of broken connection setting files 5.6.3 (02-Nov-2017) =================== - Fixed: Data Compare & Sync - when synchronizing entire document, UI status got stuck - Fixed: SQL export - when exporting selected documents only, export was stuck in "pending" 5.6.2 (25-Oct-2017) =================== - Fixed: Wrong column order in table view component when expanding embedded fields after stepping into array column. - Fixed: Table view component: accept default values in in-place editor of empty cells 5.6.1 (19-Oct-2017) =================== - Fixed: Potential application exit when opening "Collection Statistics" on a database - Fixed: Issue with opening IntelliShell on some Windows configurations 5.6.0 (19-Oct-2017) =================== - New: All new table view component (expand/collapse embedded objects, show/hide columns, stepping into array field across documents, etc) - New: Connections tree is now collapsible - New: Ctrl+DEL shortcut for "clear collection" - New: CSV import - header names are now editable in place - New: Global short-cut to close tabs without save prompts - New: Query code extensions - Java 3.X driver - New: Query code generation for SQL tab - Improved: Improved syntax colouring across all languages - Improved: IntelliShell - GUI-centric display of find and aggregate accessed via getSiblingDB - Improved: IntelliShell - Extra large arrays are more conveniently handled - Improved: IntelliShell - Querying made more robust against formatting demands of the MongoDB shell - Improved: CSV import - Changed "Start import from line" with a default of 1 to much clearer "Skip first lines" with default of 0 - Improved: Stored functions tab refreshable via Ctrl/Cmd+R short-cut - Improved: Excluded aggregation stages in the list are marked gray - Improved: Collection tab - "Run count(...)" now clears status bar before showing result pop-up - Inmproved: Collection tab - count status bar honors changed query criteria - Improved: JSON editor - show number of matches in search bar - Improved: Better warning message when trying to refresh the tab of a JS function that was deleted in the background - Improved: Support for ed25519 - Fixed: CSV import - after the import is complete, the file could remain "locked" - Fixed: On aggregation tab toolbar buttons are being disabled as appropriate - Fixed: Editor tabs for deleted stored functions are being closed - Fixed: JSON parser - recognizes capitalized E notation - Fixed: SQL tab - error message upon hitting Cmd+R to refresh before the first query was executed - Fixed: Aggregation tab - open script short-cut immediately available upon opening tab 5.5.1 (27-Sep-2017) =================== - Fixed: macOS High Sierra: disabled menu items when system language is set to something other than English - Fixed: Confusing, duplicate icon usage in view tab 5.5.0 (25-Aug-2017) =================== - New: Query Code - see the corresponding driver code for your query, instantly generated automatically in Java, C#, Python, JavaScript / Node or JavaScript / MongoDB shell! - Improved: The target database can now be explicitly specified in SQL export jobs. - Improved: Multiline comment syntax colouring accuracy. - Improved: stats tooltips in connections tree show when they were last refreshed - Fixed: SQL import only selected columns. - Fixed: Show copied collection names in tree right after copy&paste is complete. - Fixed: Potential application exit for some aggregation configurations - Fixed: Changing the color of a connection in the connection manager didn't overwrite individually set colors of child nodes - Fixed: Changing the color of a connection in the connection manager didn't refresh it in the open connections tree - Fixed: "Close tabs to the right" will also close hidden tabs to the right - Fixed: Code editor pop-up menu had inconsistent copy-to-clipboard icon - Fixed: In Collection View, "Count documents" button didn't correlate with visible results if search criteria were edited but not yet executed - Fixed: potentially unintentionally setting the color of a tree node on macOS because of auto-selected color in color picker dialog 5.4.0 (20-Jul-2017) =================== - Added: searchable connection tree - Added: Copy-to-clipboard pop-up menu for connection, database, and collection info on tabs - Added: Data Compare & Sync: Option to treat all Number types (Int32, Int64, Double) as equal - Fixed: CSV import correctly detects BOMs - Fixed: Data Compare & Sync handles fields of type Undefined correctly - Fixed: Show view type selector for static document results with just a single document - Fixed: JSON import: fixed $date and $timestamp mongoexport-formatted parsing - Improved: dragging of multiple selected fields from a document tree into query builder will add all of them 5.3.5 (04-Jul-2017) =================== - Fixed: error message when trying to access server status charts with root user - Fixed: if required, ask for password when connecting through the recent connections drop-down menu - Fixed: application exit for some aggregation queries containing certain empty stages - Fixed: macOS: accented chars in query textbox of collection view - Fixed: UTF-8 BOM, UTF16BE-BOM, UTF16LE-BOM, UTF32BE-BOM, UTF32LE-BOM detection when loading scripts - Improved: made initial number of child nodes to load when expanding a node in tree view configurable 5.3.4 (19-Jun-2017) =================== - Fixed: hanging UI after inserting and deletion of documents in the collection view tab 5.3.3 (15-Jun-2017) =================== - Improved: Better way of displaying a non-critical warning when feature compatibility version detection failed - Fixed: Potentially long query times on hosted DB instances due to large batch size 5.3.2 (14-Jun-2017) =================== - Improved: warning message when feature compatibility version detection failed - Fixed: Issue opening a collection view tab when projection and sort fields were previously collapsed. - Fixed: Erroneous do-not-infer document structure preset value in CSV import 5.3.1 (09-Jun-2017) =================== - Added: Support for $replaceRoot stage in the Aggregation Editor - Added: Default collection view preference setting - Added: Advanced connection settings: server selection timeout, socket timeout, connect timeout - Improved: SQL Tab: Added support for multiple identifier quoting schemes, so that you can use the one you are most familiar with, depending on which SQL dialect you would typically use; back-ticks (`my.field.name`), square brackets ([my.field.name]) and unadorned identifiers (my.field.name) are all now supported. - Improved: SQL Tab: Added support for boolean keywords true / false - Improved: SQL Tab: Lowered AND/OR operator precedence - some queries work without requiring parenthesis - Fixed: SQL Tab: Auto-generated 'select *' query should quote all special collection names. 5.3.0 (24-May-2017) =================== - New: Query MongoDB using SQL! Check out the new SQL tab! - New: Import data direct from live SQL databases into MongoDB. Check out the new SQL Import option! - Added: Option to retain expired operations in the task monitor - Added: Option to hide particular graph lines in Server Status Charts - Added: "Add & Continue" button on add document dialog - Added: Option to include "replicaSet" option when exporting connection setting URI - Added: Option to show exported files in file explorer - Improved: Import multiple files into the same collection in one go - Improved: More flexible triggering of auto-completion in IntelliShell. - Improved: Documents tree view: handling of large documents - Improved: More robust & consistent SSL certificate parsing & handling - Improved: More descriptive connection error messages - Improved: Better UI for SSL certificates in the "Edit Connection" tab. - Improved: Intellishell support for .hint("index_name") - Improved: GridFS view now also shows custom fields (besides meta fields) - Fixed: Do not choke on aggregation queries with large resulting data set - Fixed: Undo/redo support in search boxes of the collection view - Fixed: Failure to view collection statistics in a database that contains views - Fixed: Boolean values now default back to previous value on 'wrong' input - Fixed: Intellishell's handling of DB names with special characters - Fixed: When editing a read-only view, escape view name to fix issue with names that are not valid JS identifiers - Fixed: Correct tabs coloring - Fixed: IntelliShell's update of tool items toggle status when invoked via keyboard shortcuts 5.2.2 (20-Apr-2017) =================== - Fixed: Canceling of ongoing operation in collection view - Fixed: Proper coloring of collection/view/index tabs 5.2.1 (12-Apr-2017) =================== - Fixed: query builder honors full path name of dragged field 5.2.0 (11-Apr-2017) =================== - Added: Result, query, and explain tabs in Collection View - Added: Ctrl+R / Cmd+R executes IntelliShell script - Improved: Customizable refresh rate in task monitor tab - Improved: Make result tab retention in aggregation Tab configurable - Improved: Make result tab retention in map-reduce Tab configurable - Improved: Type conversion in query builder of collection view - Improved: Clearer license / trial communication / management 5.1.1 (03-Apr-2017) =================== - Added: You can now configure IntelliShell to optionally load .mongorc.js, or any other JavaScript file, at session start up - Added: Manually setting of the version of external mongo executables (needed for certain builds that don't support --version) - Improved: honor connection color in most recent list on welcome tab - Improved: handling of date and timestamp in-place input - Improved: when a tab with modified contents is being closed, the user is warned to save - Improved: pressing keyboard shortcut Ctrl-F4/Cmd-W closes inner tabs with query results first - Improved: do not show transitory error while connecting when feature compatibility level cannot be determined - Fixed: Export of aggregation results to JSON files - Fixed: Data Compare & Sync: Empty source documents when "_id" was excluded from comparison - Fixed: unexpected exit when running a schema analysis with invalid query JSON - Fixed: erroneous "Another operation is still running" message when user cancelled the removal of a JS function - Fixed: closing an undocked tab does not affect the docked ones - Fixed: multi-selecting stored functions for editing properly serializes function bodies now - Fixed: Remove a document field failed when based on a BinData-based query - Fixed: Enable Export button in global toolbar for aggregation tabs 5.1.0 (08-Mar-2017) =================== - Added: Read-only optional lock when viewing collections - Added: Support for $addFields in the Aggregation Editor - Improved: Substantial speed-up of data comparison and sync - Improved: Studio 3T will warn the user if an empty update query was specified in the update dialog - Improved: Studio 3T will warn the user if an empty remove query was specified in the remove dialog - Improved: Clearer notification message for licensed users that Pro and Enterprise features have been unlocked for trial - Fixed: macOS: SSL option "Accept server SSL certificates trusted by the operating system" detects all certificates (not just in the user's keychain) - Fixed: serialization and parsing of regular expression literals. - Fixed: Linux launch script didn't handle special chars well in launch path - Fixed: Import a single collection from a mongodump archive - Fixed: Query builder honors NumberInt() and NumberLong() 5.0.1 (10-Feb-2017) =================== - Fixed: Initial license detection could fail for some legacy license set-ups - Fixed: Copy of 2dsphere geospatial indices failed on 3.4 if FeatureCompatibilityVersion="3.2" 5.0.0 (08-Feb-2017) =================== NOW STUDIO 3T!! - Added: Import/Export wizards remember settings. - Added: Import CSV from clipboard. - Improved: Oplog related export options will be available for replica set connections only. - Improved: Export selected documents via mongodump. - Improved: Better handling of escaped sequences exporting via mongodump. - Fixed: SSH connectivity issues (caused by reverse lookup). - Fixed: Improved regex handling in export. - Fixed: Double-click on empty space disabled the connection manager window - Fixed: Application quit unexpectedly when exporting empty selection in the open connection tree. 4.5.5 (23-Jan-2017) ==================== - Fixed: Floating point precision issue - Fixed: Import of CSV files with UTF-8 BOM mark - Fixed: Copying collections indexes to MongoDB 3.4 with compatibility level set to 3.2 - Fixed: Windows/Linux: Properties menu was disables when focus was on connection tree - Added: Global setting of default _id data type - Improved: Collections can be pasted into the same database (to create a quick duplicate) - Improved: IntelliShell results showing a live collection view now include the 'Count Documents' option. 4.5.3 (17-Jan-2017) ==================== - Improved: When editing in table view, clicking away saves the edited value - Improved: IntelliShell auto-completion for MongoDB 3.4 - Fixed: Ctrl-D opens "Insert Document" dialog. - Fixed: "Drop existing target collection" option wasn't honored during CSV import (Fixed on Windows) - Fixed: Importing from JSON file could for some corner cases produce an extra, gratuitous empty document - Fixed: Kill operation when connection rather than database was selected - Fixed: do not show Decimal128 values in scientific notation 4.5.2 (09-Jan-2017) ==================== - Added: sslInvalidHostNameAllowed support in connection settings - Improved: Made JSON viewer window resizable - Improved: Do not show double values in scientific notation - Fixed: Empty export of query results with ISODate or ObjectId values - Fixed: Parsing of read-only views based on aggregation queries with ISODate or ObjectId values - Fixed: unexpected exit when creating a view out of an aggregation - Fixed: Launch issues with mongodump/restore on Windows with complex passwords - Fixed: "Drop existing target collection" option wasn't honored during CSV import (Fixed on macOS and Linux) 4.5.1 (27-Dec-2016) ==================== - Fixed: Unexpected exit when adding collections to MongoDB <3.4 databases - Fixed: Exporting query results via mongodump - Fixed: Importing JSON from clipboard via import wizard 4.5.0 (19-Dec-2016) ==================== - Added: MongoDB 3.4 compatibility (read-only views, collation support, Decimal128 support, new aggregation operators) - Added: Export to SQL - Added: Json editor understands HexData() - Improved: Better structure of the connections tree - Improved: Simplified add-document dialog - Fixed: inter-collection export issue when collection contained documents with fields of type "Undefined" - Fixed: Json parser parses numbers as doubles by default - Fixed: Json parser unserstands scientific notation 4.4.2 (09-Nov-2016) ==================== - Added: Refresh button in Collection View - Improved: Changed disconnect short-cut to Ctrl+Alt+D - Fixed: Issue around FQHN and Kerberos - Fixed: Proper enabling/disabling of "Search Query History" menu item 4.4.1 (04-Nov-2016) ==================== macOS-only release: - Improved: Stability improvements on macOS Sierra. 4.4.0 (27-Oct-2016) ==================== - Added: Filter connections in the Connection Manager - Added: Undocking of tabs - Added: "Show JSON..." option - Added: Option for alphabetical sorting of CSV exported fields - Added: "Refresh View" (CTRL + R) now executes the full pipeline in the Aggregate view - Added: Added option to import CSV values as empty strings - Improved: Welcome tab - Improved: Default values for Code and Code-with-scope fields - Fixed: Importing regex & null literals from JavaScript - Fixed: Properly update page size in collection view 4.3.0 (21-Sep-2016) ==================== - Added: schema discovery: generate DOCX and CSV documentation - Added: Schema discovery: option to discover documents not containing a certain field - Improved: Ship with 1.8 JRE 102 on Linux to fix high CPU usage on Ubuntu 16.04 - Fixed: undo short-cut (Ctrl+Z / Cmd+Z) works again for query, projection, etc. fields in collection tab - Fixed: Bread crumbs in schema discovery tabs weren't showing underscores in field names - Fixed: Handle index TTL values given as double on the JSON side 4.2.0 (06-Sep-2016) ==================== - Added: Remove field from all documents matching current query - Added: Option to scan all documents on CSV export for field discovery - Added: Save-to-file and load-from-file options in the context menu for a binary blob field - Improved: new SSH library to support latest algorithms - Improved: Show info message box when two compared collections were identical - Improved: Parse user-visible database from URI - Fixed: Double-click on the open connections tree executes default action only when performed on an item - Fixed: Welcome TAB did not go away when my FIRST action is to compare - Fixed: In some contexts in IntelliShell, certain evaluations of arguments to GUI mode executions of find and aggregate methods may resolve to an out-of-date value. - Fixed: Client cert path not saved between sessions 4.1.1 (23-Aug-2016) ==================== - Added: welcome wizard - Added: paging on Collections Stats tab - Added: excluding stages from the Aggregation pipeline - Improved: right-click in JSON view sets the cursor to actual click position - Improved: Import from file/clipboard always reads UTF8 - Fixed: Proper handling/display of NaN double values - Fixed (on Windows): String fields weren't updated when edited in multi-line editor 4.1.0 (27-July-2016) ==================== - Improved: GridFS tab: refresh view automatically after sort-by option selection has changed - Fixed: On refresh in collection view, do not retain current page index if the query json has changed in the meantime - Fixed: IntelliShell saves scripts in UTF-8 - Fixed: Aggregation Screen correctly loads saved queries on collections with special names - Fixed: Issue around certain malformed UTF-8 characters in IntelliShell 4.0.4 (06-July-2016) ==================== - Improved: set allowDiskUse for random sample schema analysis - Fixed: line-break display in collection view tab 4.0.3 (01-July-2016) ==================== - Fixed: export collections 4.0.2 (29-June-2016) ==================== - Added: SSL option to only accept certificates trusted by OS now also available in Core and Pro - Fixed: .json filter was selected by default for CSV export to file - Fixed: Copy Document pop-up menu option 4.0.1 (27-June-2016) ==================== - Fixed tooltip issue on empty table cell 4.0.0 (26-June-2016) ==================== - Added: *BRAND NEW* full Data Compare & Synchronization features - Added: *BRAND NEW* full Schema Analysis and Documentation features - Added: Export documents to JSON files as array and/or comma-separated - Added: Inline help in IntelliShell for methods suggested by auto-completion - Added: Unix vs Windows record separator option for CSV export - Added: Close All Tabs option for global tabs - Added: Close Tabs options for IntelliShell result tabs, aggregation result tabs, and map-reduce result tabs - Added: Disconnect All option on the Open Connections Tree - Added: Alt+D short-cut to disconnect from a server - Added: Recent connections shortcut dropdown - Added: Preference option to include database name in collection tabs title - Improved: Export map-reduce job results - Improved: Error handling when collection creation fails - Improved: Error handling on KERBEROS/LDAP IntelliShell authentication - Improved: Enforce database and collection name restrictions - Fixed: Ctrl+M for editing meta data in GridFS was shadowed by global Ctrl+M for map-reduce -> replaced with Ctrl+E - Fixed: Query text boxes would blow up on Mac OS after relayout if it contained line breaks - Fixed: Show tooltip details for ObjectIDs in table view - Fixed: Retain comment in aggregation stages upon loading - Removed: Quick Connect dialog 3.6.0 (01-June-2016) ==================== - Added: HiDPI support - Added: New 3T Software Labs Limited EULA - Improved: Export wizard replaces complex former export dialog - Improved: Import wizard replaces complex former import dialog - Improved: better handling of time-out cursors in result views - Fixed: Use correct skip and limit when exporting live query result set from IntelliShell 3.5.3 (20-May-2016) =================== - Improved: Kill running operation - Fixed: Read preference wasn't properly set in connection settings dialog - Fixed: Particular forms of aggregation query in IntelliShell and the Aggregation Screen ceased to be accepted. - Fixed: Certain malformed query strings could cause MongoChef to exit 3.5.2 (11-May-2016) =================== - Added: all tabs now also show the current user - Improved: Single Sign On (Kerberos) support on Windows - Improved: much better query history - Improved: Use human readable byte count in DB and collection stats - Fixed: Error when creating text index - Fixed: JS function editor now correctly shows Code objects - Fixed: Ensure remembered window positions are always on screen - Fixed: Ensure remembered window size is at least 100x100 pixels - Fixed: Export of aggregation query results 3.5.1 (21-Apr-2016) =================== - Added: Support for client-side SSL certificates. - Fixed: Mac bundled shell would fail to start under some configurations. - Fixed: Progress tracker of imports could get stuck in "pending" - Fixed: Redundant double use statements failed to parse on Windows. - Fixed: new Date() in collection view returns current date - Fixed: SSL CA Root Certificate file path was not loaded on application start. 3.5.0 (25-Mar-2016) =================== - Added: bulk write operations on multiple threads - Added: The mongo shell executable in now bundled with MongoChef for Windows x64 and Mac. - Added: Count documents button in the bottom status bar - Added: Discard ongoing aggregation queries - Added: Discard ongoing IntelliShell operations - Improved: removed hard page size limit of 1,000 - Improved: multi write option in edit value dialog - Improved: Use no-timeout cursors when exporting to CSV and json files - Improved: Connections through SSH tunnels now reconnect when dropped - Improved: Root CA certificate can be provided for SSL connections - Improved: Trusted by the OS Root CA certificates can be used for SSL connections - Improved: Double-click sensitivity in query builder - Fixed: clear collection tooltip stats after it is cleared - Fixed: Bottom status bar cancel button - Fixed: json parser now enforces quotes around dot-noted field names 3.4.1 (22-Feb-2016) =================== - Added: "skip to last page" button. - Added: Connection settings can now be exported and imported. - Added: MongoChef can now restore connections to servers behind SSH tunnels. - Fixed: Properly escape search string for "contains", "starts with", "ends with" query builder operators. - Fixed: IntelliShell: Under some configurations, shell helper methods may have resulted in an execution error. 3.4.0 (12-Feb-2016) =================== - Added: Tabs can now be viewed side-by-side, split horizontally and vertically. - Added: Drag and drop tabs to reorder. - Added: Connections, databases, and collections can now be colored individually. - Added: Show db and collection stats as tooltip. - Added: Editor font is configurable. - Added: IntelliShell - For greater convenience, a find command is inserted by default when opened on a collection. - Added: UUID helper functions, both in IntelliShell and collection view. - Added: Ignore trailing/leading spaces during CSV import. - Improved: Paging in tree and table result views. - Improved: Greater tolerance in IntelliShell parser, e.g. dangling elses, no semicolons. - Improved: Auto-select new target collection option when pasting collection into its own database. - Improved: Aggregate queries performed in IntelliShell will display result sets of any size. - Improved: IntelliShell displays a status indicator when an operation is currently running. - Improved: Scientific notation is no longer used for doubles in shell export and JSON editor - Improved: Toggle state of query builder is no longer persisted - Fixed: Layout issue in copy collection dialog - Fixed: "Drop duplicates" index option disabled for MongoDB >= 3.0 - Fixed: Stored Functions editor now writes value field of functions in system.js as Code fields (not strings) 3.3.0 (18-Jan-2016) =================== - Added: copy indices when copying collections - Added: MongoChef remembers its last position and size - Improved: JSON editor window remembers its last position and size (for the duration of a MongoChef session) - Improved: Replica set discovery with support for passive secondaries - Improved: Results for queries such as 'db.getCollection("myCollection").find()' are now shown the same way as for queries such as 'db.myCollection.find()' or 'db["myCollection"].find()'. - Improved: Use no-timeout cursors for import/export operations 3.2.4 (05-Jan-2016) =================== - Added: "Rename" option to popup menu on stored JS functions tab - Added: Copy full query command to clipboard from within collection view tab - Added: Tooltip with ObjectID details - Improved: Copy Value As Text, Copy Value, and Copy Field options - Improved: Exporting only selected documents from aggregation will not reset cursor any more - Improved: Minor JavaScript parser improvements - Improved: More specific info messages when script, selection or cursor position has no executable statements - Fixed: Pressing and holding execution shortcut key could cause app to exit unexpectedly under some circumstances - Fixed: Opening an IntelliShell tab on a connection directly will only default to db "test" if test actually exists - Fixed: Export of live documents from IntelliShell always honors query criteria - Fixed: Application could exit unexpectedly on right-click in empty roles tab - Fixed: Reading in of old connection settings 3.2.3 (08-Dec-2015) =================== - Fixed: For very large collections, export set check could erroneously report that there are no documents to export. - Fixed: Document count was wrongly reported for very large collections. - Improved: Update notifications will not be logged anymore. 3.2.2 (04-Dec-2015) =================== - Fixed: Application could unexpectedly quit under some configuration on Windows. 3.2.1 (04-Dec-2015) =================== - Fixed: disable validation support for admin, local, config databases and system.* collections - Fixed: ignore max and size for non-capped collections 3.2.0 (03-Dec-2015) =================== - Added: MongoDB 3.2 compatibility - Added: export from aggregation and IntelliShell output. - Added: IntelliShell: Source code of corresponding query shown in result tab tool tip. - Added: Dedicated management tab for stored JS functions. - Improved: Better error messages when opening or pasting in a query within the Aggregation Screen. - Improved: Export documents dialog now allows skip and limit. - Improved: Simplified toolbar and execution shortcuts in IntelliShell. - Improved: IntelliShell authentication will now accept special characters. 3.1.0 (20-Nov-2015) =================== - Added: CSV import - Added: Line numbers in JSON editors - Added: Bracket matching in JSON editors - Improved: All revamped task monitor - Improved: Show "Export Collections" dialog immediately. Do not wait until collection names have been read. - Improved: Pre-select field name of new field in Ctrl+K dialog on Linux too. - Fixed: Truncate issue when copying collections - Fixed: Fixed button order on Windows in "Document JSON Editor" dialog 3.0.7 (03-Nov-2015) =================== - MongoChef Enterprise - First Public Release - Added: Kerberos authentication support - Added: LDAP authentication support - Added: X.509 authentication support - Added: Copy/paste aggregation query - Improved: comma error detection in JSON parser. - Improved: Improved handling of large queries in IntelliShell. - Fixed: Aggregation screen: "Add New Stage" in drop-down menu would not work on empty aggregation pipeline. 3.0.6 (20-Oct-2015) =================== - Added: Show execution time of queries - Fixed: Vertical table scroll bars were not showing on Linux. - Fixed: UUID("39691D9E-BD5B-45A0-92FA-3BEDD1C9656D") now returns a BinData-4-UUID. - Fixed: Import of JSON doc without _id field would result in "_id": null 3.0.5 (09-Oct-2015) =================== - Improved: Better ISODate parsing - Fixed: Edit Value/Type updates for current query result set only - Fixed: Very long strings could stall tree and table views. - Fixed: IntelliShell could exit unexpectedly when tab was closed while operations were still running. 3.0.4 (06-Oct-2015) ==================== - Improved: Aggregation screen: stage tabs have focus on editor also when selected via double-click in the pipeline tree. - Improved: Prompt user for server version if it cannot be determined. - Fixed: For some users on Mac OS, file dialogs would only work once and fail on all subsequent attempts. - Fixed: Pasting a large amount of documents into a collection view could freeze the application. - Fixed: Pasting of documents wasn't cancelable. - Fixed: Close aggregation tabs after disconnecting. 3.0.3 (25-Sep-2015) ==================== - Improved: Scalable, pageable GridFs view - Improved: Validate JSON document before importing multiple connections - Improved: Better labels for the query builder - Improved: Aggregation screen: stage tabs have focus on editor (not the op combo anymore) - Improved: "Copy Database" more aptly named "Copy Collections" - Fixed: On some configurations, closing an IntelliShell tab may have caused the application to exit. - Fixed: Prevent query history from growing indefinitely. Limited to last 50 queries. - Fixed: Close GridFS tab when underlying connection is actively closed. 3.0.2 (16-Sep-2015) ==================== - Added: Export collection dialog now also offers "To Another Collection" and "To Clipboard" - Improved: Several small IntelliShell improvements - Fixed: JSON parse error in connection with individual unicode chars that, in lower case, are transformed into 2 chars 3.0.1 (08-Sep-2015) ==================== - Fixed: Syntax of $unwind in the Aggregation Editor - Fixed: Paint issues with Aggregation screen on Ubuntu 3.0.0 (06-Sep-2015) ==================== - Added: Aggregation Editor! - Added: Export entire DB - Added: Export multiple collections - Added: Import multiple collections - Added: Drop multiple indices - Added: Drop multiple databases - Improved: Clear multiple collections from different databases - Improved: Delete multiple collections from different databases - Fixed: Progress indicator for json imports 2.1.0 (12-Aug-2015) ==================== - Added: Copy entire DB - Added: Copy multiple collections - Added: Clear multiple collections - Added: Delete multiple collections - Added: "Overwrite existing documents with same _id" option for import/export - Fixed: Unexpected exit when multi-line editor was invoked on orphan "}" - Fixed: Handle null GridFS filenames gracefully - Fixed: IntelliShell always honours JSON format setting for JSON view - Improved: Show warning if CSV export contains JSON text - Improved: Edit JSON will always show full document even when projection is active, so no fields will ever get lost after updating JSON. - Improved: Latest tree/table/json view choice is always remembered - Improved: JSON Parser: Warn if ':' is missing between key and value - Improved: More resilient task monitor in case system processes can't be obtained 2.0.10 (20-Jul-2015) ==================== - Fixed: 2.4 user authentication regression 2.0.9 (16-Jul-2015) ==================== - Added: MongoDB 2.4 user and role management - Added: Copy Value and Copy Field are now separate options - Added: Now configurable: open a collection always in the same tab - Added: Type icons in table view now optional - Fixed: Json parser: erroneous error detection for embedded documents in DBRef() and CodeWScope()- - Fixed: Honor "do not show again" when copy&pasting collections - Fixed: CSV export: values of UUIDs and timestamps - Fixed: IntelliShell could under certain circumstances exit unexpectedly when trying to save a script. 2.0.8 (19-Jun-2015) ==================== - Added: MongoDB 3.0 specific actions - Fixed: Enforce UTF-8 encoding on export files 2.0.7 (19-Jun-2015) ==================== - Added: Manually specify visible databases for non-admin users 2.0.6 (17-Jun-2015) ==================== - Fixed: Database discovery for non-admin users 2.0.5 (16-Jun-2015) ==================== - Fixed: User and role management for direct connections to a mongos. - Improved: Better connection manager error handling 2.0.4 (12-Jun-2015) ==================== - Fixed: Json parser: better handling of JSON comments - Fixed: Control character escaping issue in multi-line string editor - Fixed: IntelliShell: Make commands safe for execution by removing extraneous whitespace - Fixed: erroneous export progress target number 2.0.2 (22-May-2015) ==================== - Fixed: parsing of empty ISODate() - Fixed: reading from secondaries with MongoDB 3.0 when connected directly - Improved: No longer auto-expand all docs in the tree-view (could be very slow) - auto-expansion of first doc is now configurable. - Improved: Connectivity to replica sets and sharded clusters 2.0.1 (05-May-2015) ==================== - Fixed: Parse issue around regexes and other complex (aggregate) queries in IntelliShell. 2.0.0 (01-May-2015) ==================== All new IntelliShell! 1.11.3 (22-Apr-2015) ==================== - Added: Select json view format (mongo shell, mongoexport, simple JSON) - Fixed: When pasting in an index as JSON if _id was not first, it was moved to the first position when switching to the "Fields" tab - Fixed: Concurrently run instances of MongoChef could in certain cases destroy query history and bookmarks. - Fixed: Auto-completion could trigger exit unexpectedly under extremely rare circumstances. - Improved: Better handling of invalid GridFS file metadata - Improved: Consistently escape unicode control chars in in-cell editors 1.11.2 (08-Apr-2015) ==================== - Fixed: bug around unicode control characters in JSON editor - Fixed: Handling of international characters in the embedded shell (affected Windows-users only) - Improved: JSON parser reports line and column numbers of errors - Improved: Behavior during the shell initialization (providing technical information in cases when the shell doesn't start) 1.11.1 (31-Mar-2015) ==================== - Added: App can be pinned to Windows task bar - Fixed: Bug when _id field contained embedded object - Improved: Loading of database names, collection names, and index names dynamically in the background => much faster connection set-up 1.11.0 (27-Mar-2015) ==================== - Added: Run Query button with various advanced options (findOne(), count(), explain()) - Added: GridFS: search by file name - Added: GridFS: support for file meta data - Added: Pop-up menu option "Follow Reference" for ObjectIDs and DBRefs - Added: Keyboard shortcuts to expand (recursively) / collapse tree view - Fixed: On Yosemite, the first row in a table or tree view could initially become hidden - Improved: Queries no longer call count() => much faster execution - Improved: Overwrite null fields in-place too - Improved: Do not show empty _id col in table view if _id field is excluded from projection - Improved: convert input to other type in edit-value dialog when selecting new type - Improved: close related tabs when closing a connection - Improved: In table view, also make natural/alphabetical key sort order togglable, persist setting - Improved: Close tabs with middle mouse button - Improved: Remove and Update dialogs UI 1.10.8 (06-Mar-2015) ==================== - Added: Select and edit a document (via json editor) from JSON view - Added: Remove documents from JSON view - Improved: Update connection tree via keyboard short-cut Cmd+R/Ctrl+R 1.10.7 (06-Mar-2015) ==================== - Fixed: Escape connection names on welcome page - Improved: pre-select leaf fields for CSV export 1.10.6 (05-Mar-2015) ==================== - Fixed: Secondary RS members weren't able to see collections for some configurations 1.10.5 (01-Mar-2015) ==================== - Fixed: Bug after adding a new document without an explicit _id - Improved: Copy&paste collection: make target collection name editable - Improved: Don't prefix the target collection with "Copy_of" when pasting a collection that doesn't yet exist in the target db. - Improved: Make "contains" operator in the query builder case-insensitive 1.10.4 (25-Feb-2015) ==================== - Fixed: ObjectId(). auto-completion hang-up in shell - Fixed: show newly added database in roles dialog - Improved: JSON parser now allows hexadecimals data values inside BinData() - Improved: various minor UI issues 1.10.3 (19-Feb-2015) ==================== - Fixed: bug when dropping top-level document into query builder 1.10.2 (16-Feb-2015) ==================== - Added: Copy&paste entire collections across databases and servers - Added: Operation pane to easily see (and cancel) long-running operatuions - Added: add, rename, and drop target collection in export dialog - Improved: easier way (just one click) to show/hide projection and sort fields 1.10.1 (11-Feb-2015) ==================== - Added: Remove dialog - Improved: Collection View UI 1.10.0 (09-Feb-2015) =================== - Added: Full compatibility with MongoDB 3.0 - Improved: Update dialogs can now also be applied to current query (before: only current doc or all docs) - Improved: various smaller UI tweaks. - Fixed: Exporting byte field value to file. - Fixed: Properly handle NaN, Infinity, and -Infinity (also in the JSON parser) 1.9.3 (16-Jan-2015) =================== - Added: Export to CSV - Improved: SSH support (added connectivity to OpenSSH 6.7 servers) - Improved: Auto-completion in the shell now shows field names and function parameters - Improved: collection view UI - Fixed: disappearing execute buttons in search pane upon resize 1.9.2 (06-Jan-2015) =================== - Fixed: incorrect date parsing when display format was set to "Current locale" - Fixed: Time zones behind UTC (i.e. -HH:MM) reverted to UTC - Fixed: auto-completion didn't work when entering multiple commands in the shell input box 1.9.1 (19-Dec-2014) =================== - Added: "Find", "Find One", "Count", "Remove", and "Update" to query pane - Added: multi-line query editor - Added: Update dialog to update selected documents, all documents, etc.. - Added: "Clear Collection" option to quickly remove all documents from a collection. - Added: Open and save queries from/to file in the shell tab. - Improved: menu structure - Improved: auto-completion in the shell: camel-case completion (e.g. type "ci" to get "createIndex") - Improved: Query builder now supports "$text" query operator - Improved: Shortcuts to navigate between tabs are now exposed in the View menu - Fixed: refreshing a connection no longer collapses the tree in the left pane - Fixed: missing refresh when adding new values in table view in embedded levels - Fixed: the "move tab to the front" feature didn't work for the shell-tab 1.9.0 (03-Dec-2014) =================== - Added: User management (2.6) - Added: Role management (2.6) 1.8.3 (27-Nov-2014) =================== - Fixed: replica set discovery didn't work for some configurations - Improved: task monitor 1.8.2 (26-Nov-2014) =================== - Added: Index Management (add, modify, view indexes) - Added: preferred time zone settings for dates - Added: auto-completion in the shell - Added: Rename tabs - Improved: Import/Export and JSON editor no longer escape non-Latin chars - Improved: Replica Set support - Fixed: settings validation around the shell configuration 1.8.1 (10-Nov-2014) =================== - Improved: Don't allow "." in field names (when adding individual fields) - Fixed: error when trying to open files in GridFS with file prefixes less than 3 characters wide 1.8.0 (29-Oct-2014) =================== - Added: Full MongoDB shell integration - Added: Server status info and server build info - Improved: Support for non-ObjectId GridFS file IDs 1.7.11 (17-Oct-2014) ==================== - Fixed: Mac OS only, Yosemite hotfix: search text box contents were hidden when focus was lost 1.7.10 (16-Oct-2014) ==================== - Added: Search functionality to JSON editor - Added: Undo support to JSON editor - Added: "Copy" and "Paste" to popup menu in JSON editor - Improved: F5 now also refreshes the tree and table view - Improved: Keypad enter key now also fires off a query - Fixed: properly update JSON collection view - Various UI improvements 1.7.9 (13-Oct-2014) =================== - Fixed: Column sorting for Date and Timestamp values 1.7.8 (09-Oct-2014) =================== - Added: Sort table view by clicking on column headers - Added: Set the default view (tree, table or JSON) to use when opening a collection - Improved: Table view handling (retain focus, top row, column widths when stepping in and out of embedded objects) - Improved: Table View performance on Windows - Various UI improvements 1.7.7 (30-Sep-2014) =================== - Added: Task Manager for MongoDB operations - Added: Show server build information - Improved: SSH with private key (key passphrase is not required) - Improved: JSON and JS code highlighting - Fixed: menu accelerators weren't showing on Linux - Varios UI improvements 1.7.6 (24-Sep-2014) =================== - Added: database and collection statistics - Improved: JSON editor and code highlighter - Various UI improvements 1.7.5 (22-Sep-2014) =================== - Added: renaming of collections - Added: show first/last page buttons - Improved: navigation in table view - Improved: show only valid data types to choose from in "Add Document" dialog - Various minor UI improvements 1.7.4 (17-Sep-2014) =================== - Added: multi-line editor for string values - Added: right-click on collection view tabs for tab closing and reordering options - Fixed: refresh issue after removing individual fields from documents - Fixed for Ubuntu 14.04: drag-and-drop and rendering issues in search pane - Various minor UI improvements 1.7.3 (09-Sep-2014) =================== - Data Manager becomes MongoChef - JSON source code tab in "Add Document" dialog - More consistent/responsive accelerators - Add key/field automatically applies to parent for non-object/non-array selections - Fixed: when adding/inserting docs, the new document index was lagging by 1 - Cmd+W / Ctrl+F4 to close the current tab - Fixed: error message when trying to edit value of top-level document in tree view - Various minor UI improvements (e.g. show number of documents found in the status bar) 1.7.2 (05-Sep-2014) =================== - Global property: specify initial number of documents to load when opening a collection view - Right click on collection in tree: option to specify initial number of documents to load - Fixed: Connection Manager didn't properly export replica set configuration to MongoDB URI 1.7.1 (01-Sep-2014) =================== - Fixed JSON parsing bug that required the user to always have to enter milliseconds for UTC dates (i.e. milliseconds no longer required now) - Minor UI improvements 1.7.0 (28-Aug-2014) =================== - Import/Export documents from/to files, the clipboard, and other collections (JSON formats: mongodb shell, mongoexport) - Copy and paste documents across collections and databases - Replica set support - Export connection settings as a mongodb URI - Improved JSON parser (escaped characters, ISO dates with time zone offset, disallow keys without values) - Various smaller UI improvements 1.6.0 (11-Aug-2014) =================== - Added connection support for SSL and SSH tunnels - Improved connection manager - Improved menu structure - Keyboard short-cuts for Windows - Fixed JSON parsing bug w.r.t. quotes in strings - Fixed hang-up bug on re-opening a GridFS tab - various minor UI improvements 1.5.1 ===== - Select multiple documents and fields / elements - Fixed bug when adding array element of type Object or Array - Preserve tree path or view levels in table view when refreshing an individual document - Use type of last array element as default field type when adding a new array element - Improved key short cuts - Put focus on input box upon activating value editor dialog - Expand connection and database nodes in open connections pane on double click - Various minor UI improvements 1.5.0 ===== - GridFS support and viewer - Improved JSON parser w.r.t. regexes, now honours escaped forward slashes - Improved query generator: - new operators "starts with" and "ends with" - put field names in " " - improved regex construction for "contains" operator - Improved connection management (w.r.t. various user roles) - Improved pagination UI 1.4.7 ===== - Allow input of binary (e.g. UUID) search values - Fixed: adding empty embedded documents didn't work for some configuration - Improved legacy UUID handling - More consistent Date representation - Minor UI improvements 1.4.6 ===== - Fixed issue that could prevent documents with a Legacy UUID as _id from being updated - Fixed potential JSON parsing issue with Legacy UUIDs 1.4.5 ===== - Make long-running, slow connection attempts cancellable - Minor UI improvements 1.4.4 ===== - feedback button - better license manager 1.4.3 ===== - fixed: connection to mongodb servers didn't succeed for some configurations 1.4.2 ===== - Connect via a connection URI - Fixed a bug that could lead to the clearing of persisted connection passwords - editor bug fix for certain types of binary arrays 1.4.1 ===== - Search UI now supports $and and $or - Show "null" as value (rather than blank) of Null fields - minor UI improvements - free for personal, non-commercial use now 1.4.0 ===== - New search UI - Improved text representation of regular expressions - Fixed parsing of values of type Symbol - Always check the live document in the DB before adding or renaming a field if field already exists - UI improvements 1.3.6 ===== - Show document count - Improved UI for host, database, collection info in the document view In the document editor: - Added support for Legacy UUID (0x03) subtype with Python, Java and .NET encoding - Improved the binary editor for UUID and MD5 subtypes Setup for Windows: - Upgrades from previous version didn't work for some users. It's recommended to uninstall the previous version before updating to 1.3.6 1.3.5 ===== - Keys/Values can be copied to clipboard from document view - minor improvements and fixes 1.3.4 ===== - minor improvements and fixes - proper icons for Mac OS .app files 1.3.3 ===== - minor improvements and fixes 1.3.2 ===== - first public release 0.9 - 1.3.1 =========== Internal releases only