We're so proud to release NoSQLBooster for MongoDB 8.1 today. This version includes official support for MongoDB 7.0, Visual explain for Slot-Based Query Execution along with some useful improvements and bugfix. For more information on MongoDB Server 7.0 , see Release Notes for MongoDB 7.0.
MongoDB 7.0 support
NoSQLBooster for MongoDB 8.1 added support for all the new mongosh methods, aggregation stages and operators of MongoDB 6.1-7.0. Aggregation Pipeline (db.xxx.aggregate().xxxx()) and Operator helper ($.) also add these helper methods.
New Aggregation Operators
MongoDB 6.3 introduces the following aggregation operators:
| Name | Description | NoSQLBooster Helper method |
|---|---|---|
| $bitAnd | Returns the result of a bitwise and operation on an array of int or long values. |
$.bitAnd() |
| $bitNot | Returns the result of a bitwise not operation on a single argument or an array that contains a single int or long value. |
$.bitNot() |
| $bitOr | Returns the result of a bitwise or operation on an array of int or long values. |
$.bitOr() |
| $bitXor | Returns the result of a bitwise xor (exclusive or) operation on an array of int and long values. |
$.bitXor() |
New MongoDB 7.0 mongosh Methods
| Name | Description |
|---|---|
| db.collection.createSearchIndex() | Creates an Atlas Search index on a specified collection. |
| db.collection.dropSearchIndex() | Deletes an existing Atlas Search index. |
| db.collection.getSearchIndexes() | Returns information about existing Atlas Search indexes on a specified collection. |
| db.collection.updateSearchIndex() | Updates an existing Atlas Search index. |
New MongoDB 7.0 Aggregation Stages.
| Name | Description | NoSQLBooster Helper Method |
|---|---|---|
| $listSampledQueries | Lists sampled queries for all collections or a specific collection. |
db.coll.aggregate().listSampledQueries(); $.pipelineBuilder.listSampledQueries(); |
| $listSearchIndexes | Returns information about existing Atlas Search indexes on a specified collection. |
db.coll.aggregate().listSearchIndexes(); $.pipelineBuilder.listSearchIndexes(); |
Visual explain for Slot-Based Query Execution
NoSQLBooster 8.1 supports visual the explain results of the slot-based execution engine. Click here to see MongoDB official information on slot-based execution engine.
Other Improvements
New Tooltip Show Event Option (ATL+MouseMove)
The tooltip message displayed with a delay of 1 second is sometimes quite annoying, and its inappropriate pop-up can sometimes cause unnecessary interference to the input. In 8.1 we added a new tooltip showevent option, you can use Alt+mousemove (hold alt key) to trigger the display of tooltip instead of the original mousemove event. When you press the alt key, the tooltip will be displayed immediately instead of being delayed for a second.
Use Menu -> Options -> Tooltip (Mouse Hover) to turn on this "ALT+MouseMove" option, default value is "Mouse Move".
Minor Improvements and Bugfix
- Fixed, Collection JSON import cause: E11000 duplicate key error when id policy is "overwrite_with_same_id" and the imported _id field is UUID.
- Improved, Log Viewer - Use EJSON.parse instead of JSON.parse.
Patch Releases
Version 8.1.1
- Improved, MongoDB AWS Authentication - add a "From Credential Process" option. More about it.
- Fixed, a mongosh command
sh.status. output result compatible issue. - Fixed, an export error where the export option did not take effect. The error occurs when the export format is "Simple JSON Text" and the line separator is "\n,".
Version 8.1.2
- Improved, Add Mongodump to the context menu of the database/collection tree node. Connection Tree -> Database/Collection Node -> Context Menu -> Export Collection -> Mongodump...
- Improved, Add MongoRestore to the context menu of the database/collection tree node. Connection Tree -> Database/Collection Node -> Context Menu -> Import Collection -> Mongorestore...
- Improved, Add "Add/Edit User Snippet..." item to the command palette.
- Fixed, a bug where the tooltip could not pop up when the mouse hovered over the script history menu item.
Version 8.1.3
- Fixed, a bug where console.log data was out of order when importing JSON file to collection.
Version 8.1.4
- Fixed, an error where the license information in the status bar was displayed incorrectly.
Thank you!
Please visit our feedback page or click the “Feedback” button in the app. Feel free to suggest improvements to our product or service. Users can discuss your suggestion and vote for and against it. We’ll look at it too.