What's new in NoSQLBooster (formerly MongoBooster) 5.2.4

Oct 14, 2019
  • Add “New UUID” button to UUID/LUUID value editor:
  • Clicking the “New UUID” button to create new unique UUID value.
  • Add “URI Formats” button to “Import External Database” dialog:
  • Clicking the “URI Formats” button to go to the detailed help page for the Connection String URI formats.
  • Bugfix:
  • Improved, Notarize macOS NoSQLBooster Apps to be accepted by Gatekeeper after MacOS Mojave 10.14.5 update.

New in NoSQLBooster (formerly MongoBooster) 5.2.3 (Oct 4, 2019)

  • Bugfix:
  • Fixed, Export to JSON, BSON, CSV fails with Mlab MongoDB hosting. ref#

New in NoSQLBooster (formerly MongoBooster) 5.2.0 (Sep 19, 2019)

  • We’re so proud to release NoSQLBooster for MongoDB 5.2 today. This version includes official support for MongoDB 4.2 along with some useful improvements and bugfix. For more information on MongoDB 4.2 , see Release Notes for MongoDB 4.2.
  • MongoDB 4.2 support
  • NoSQLBooster for MongoDB 5.2 upgrades embedded MongoDB Shell to 4.2.0, adds support for all the new shell methods and operations of MongoDB 4.2.
  • Merge and Other New Aggregation Stages
  • MongoDB 4.2 adds a few new aggregation pipeline stages, $merge, $planCacheStats, $replaceWith, $set and $unset. NoSQLBooster 5.2 adds these chain methods to AggregationCursor and provide the appropriate code snippets and mouse hover information to support code completion.
  • NoSQLBooster 5.2 also enhanced mouse hover for all aggregation chain methods. In addition to method and type definitions, hover is now able to display document and example for these aggregation clain methods.
  • Mouse hover for Aggregation Chain MethodsMouse hover for Aggregation Chain Methods:
  • Press “F1” to view the online help
  • Press “Shift+F1” to copy the example section to the clipboard
  • MongoDB 4.2 New Expressions as SQL Functions:
  • NoSQLBooster 5.2 allows all new Mongodb4.2 aggregation expressions to be used as SQL function in SQL statements. Aggregation Trigonometry Expressions, Aggregation Arithmetic Expressions and Aggregation Regular Expressions (regex) Operators.
  • Aggregation Trigonometry Expressions:
  • Other Improvements:
  • Import/Export Improvements:
  • In this version, we thoroughly reviewed and refactored the code for the export function and greatly improves the execution performance of the export function. This version also adds a display of the progress of the export.
  • As for import and replication capabilities, we have added a new insertion policy that allows the original collection to be dropped before import.
  • Drop collection first policyDrop collection first policy
  • Tree/Table View Cell Formatter Improvements
  • Now, single-level, more straightforward object/Array values are displayed as JSON text within the tree/table view. If an object/array value has many, complex fields, the value is still formatted as “{n attributes}”. This friendly UI enhancement can save you a few times to press the “+” button.
  • Format simple object as JSON textFormat simple object as JSON text
  • New Fluent Query Methods:
  • db.items.find().jsonSchema(myschema); //find all documents in the collection that satisfy the schema
  • db.items.find().nor(qb.jsonSchema(myschema)); //find all documents in the collection that do not satisfy the schema
  • Visualizing Legacy Coordinate Pairs:
  • In addition to visualize the MongoDB GeoJSON Objects, this feature now also allows you to visualize legacy coordinate pairs.
  • Visualize Legacy Coordinate PairsVisualize Legacy Coordinate Pairs
  • Add “Reload” Button to the Document Viewer
  • This ne “Reload” button allows you to manually reload the contents of the current object in the document viewer.
  • Reload ButtonReload Button
  • Minor Improvements and Bugfix:
  • Fixed, kill operation in monitoring is not allowed when op has no “host” field. ref#
  • Fixed, export to JSON, BSON, CSV with large result set won’t work. ref#
  • Fixed, Kerberos authentication connections where hostname is not the canonical name. ref#
  • Fixed, return the result in object directly when the aggregate option “explain” is true. ref#
  • Fixed, SRV connections with special characters in the password.

New in NoSQLBooster (formerly MongoBooster) 5.1.14 (Aug 16, 2019)

  • Support for connecting to mongodb 4.2 server

New in NoSQLBooster (formerly MongoBooster) 5.1.13 (Aug 16, 2019)

  • Bugfix:
  • Improved, provided a work-around solution for Replica Set connection via SSH tunnel. ref#
  • Fixed, Error on open GridFS File with string ID. ref#
  • Fixed, Moment.js typing definition issues.

New in NoSQLBooster (formerly MongoBooster) 5.1.12 (Jul 29, 2019)

  • Bugfix
  • Fixed, serious regression error, “copy database” and “copy collection” does not work.

New in NoSQLBooster (formerly MongoBooster) 5.1.11 (Jul 29, 2019)

  • Bugfix:
  • Fixed, an crash error when importing a large JSON file.
  • Fixed, Copy -> Text/JSON - Paste only contains a portion of results.
  • Fixed, an error when updating indexes when partialFilterExpression has the $exists condition.
  • Improved, when you switch connections within the editor, update its tab title, color and read-only status synchronously.

New in NoSQLBooster (formerly MongoBooster) 5.1.10 (Jul 5, 2019)

  • Bugfix:
  • Fixed, export CSV with new Date() ref#
  • Fixed, Object.bsonsize() returns invalid value (> 16MB). ref#
  • Improved, the interface of the connection editor, added “isSrvRecord” check-box, added “edit member” action in Replica Set Members list, added more Mongo_Uri_Options, authMechanismProperties, appName…

New in NoSQLBooster (formerly MongoBooster) 5.1.9 (Jun 24, 2019)

  • Bugfix:
  • Fixed, export CSV with new Date() ref#
  • Fixed, Object.bsonsize() returns invalid value (> 16MB). ref#
  • Improved, the interface of the connection editor, added “isSrvRecord” check-box, added “edit member” action in Replica Set Members list, added more Mongo_Uri_Options, authMechanismProperties, appName…

New in NoSQLBooster (formerly MongoBooster) 5.1.8 (May 20, 2019)

  • Bugfix:
  • Fixed, code-complete Interface type definition issue (Promise, Array …)
  • Fixed, writing out from aggregates in a loop does not work. ref#
  • Fixed, problem with sort in default code template when the option “Show Database/Collection Stats Tooltip” is enabled. ref#

New in NoSQLBooster (formerly MongoBooster) 5.1.7 (May 16, 2019)

  • Bugfix:
  • Fixed, an crash error when exporting a large query result set.
  • Fixed, an error saving last switch mode When the script fails.

New in NoSQLBooster (formerly MongoBooster) 5.1.5 (Mar 19, 2019)

  • SSL option “allow invalid hostnames”:
  • Added an “Allow invalid hostnames” SSL option to disable the validation of the hostname in the TLS/SSL certificates.
  • Bugfix:
  • Added, “Cancel” action in dialog box for connection open confirmation.
  • Fixed, background SSH tunnel processes remains after shutting down NoSQLBooster.
  • Fixed, a bug in renaming field names in all documents.
  • Improved, update “tunnel-ssh” package to the latest version.
  • Improved, update “lodash” and “moment” package to the latest version.

New in NoSQLBooster (formerly MongoBooster) 5.1.2 (Feb 8, 2019)

  • “Remove Fields” Improvement:
  • In addition to remove the select fields of the select document, the newly added option allows you to remove the selected fields of all documents in this collection.
  • Bugfix:
  • Added, do not show hidden files and directories (e.g. .git) in my queries tree view.
  • Fixed, an incorrect sorting parameters bug in code generator.
  • Fixed, unnecessary conversion of localhost to 127.0.0.1 bug. ref#
  • Fixed, left arrow does not jump to parents in the tree views. ref#

New in NoSQLBooster (formerly MongoBooster) 5.1 (Feb 8, 2019)

  • Visualizing GeoJSON Objects:
  • The most significant enhancement of version 5.1 is to allow users to visualize the MongoDB GeoJSON Objects quickly. The GeoJSON is a format for encoding geographical data structures, using the JavaScript Object Notation (JSON).
  • Mouse Hover Improvement:
  • NoSQLBooster 5.1 greatly enhanced mouse hover in the code editor. In addition to method and type definitions, hover is now able to display document and example for MongoDB operators.
  • Use Keyboard Shortcuts to Switch Views:
  • In version 5.1, you can use keyboard shortcuts to quickly switch between the editor, the results view, the database object explorer, and my queries panel.
  • Database Rename Operation:
  • MongoDB doesn’t have a built-in way to rename a database, unlike renaming collection, renaming a database is cumbersome. NoSQLBooster 5.1 adds a handy “rename database” operation. This simple UI operation makes renaming the database less painful.
  • “Rename Field” Improvement:
  • In addition to renaming the field name of the select document, the newly added option allows you to rename the field names of all documents in this collection.
  • Minor Improvements and Bugfix:
  • New, added update$addToSet$each and update$push$each code snippets.
  • Fixed, bring back shortcut “F5” to execute current statement. #ref
  • Fixed, Keyboard friendly my queries and samples tree views #ref
  • Fixed, incorrect sort when viewing the oplog.rs collection #ref
  • Fixed, a regressive “collection name code-completion” bug
  • Fixed, only JSON view is available bug #ref
  • Fixed, incorrect array JSON format issue #ref

New in NoSQLBooster (formerly MongoBooster) 5.0.0 (Nov 23, 2018)

  • We’re happy to mark another significant milestone for the NoSQLBooster for MongoDB with the final release of the 5.0. It brings a number of new features to increase MongoDB’ers productivity, comprehensive server monitoring and diagnostics tools, visual explain plan, MongoDB log parser, enhanced SQL Query to support SQL JOIN and uncorrelated sub-queries, more friendly display of object and array values, One-click Group-By, better code snippets, mark changed lines and NoSQLBooster-enabled live tutorials…
  • Full changelog here: https://www.nosqlbooster.com/blog/announcing-nosqlbooster-50/

New in NoSQLBooster (formerly MongoBooster) 4.7.2 (Sep 11, 2018)

  • Modify Default Code Template for Opening Collection:
  • NoSQLBooster 4.7.2 changed the default code template for opening a collection.It also added an option that allows the user to customize the code template
  • Bug Fixes and Improvements:
  • Improved, speed up the opening of the Script editor
  • Changed, append running script indicator to output panel
  • Added, option: “AutoExecute Script When Collection Node is Double-Clicked”, toggle this option to enable/disable auto-execute script when collection/view node is double-clicked.
  • Fixed, connect mongodb+srv URI using SSH tunnel
  • Fixed, UUID function without arguments returns an error
  • Fixed, table view header breaks the columns of the table when column name contains commas.

New in NoSQLBooster (formerly MongoBooster) 4.7.1 (Aug 18, 2018)

  • Fixed, Cut/Copy/Paste in editor context menu doesn’t work with MacOS. #ref
  • Fixed, the ability to increase the paging size does not work correctly.

New in NoSQLBooster (formerly MongoBooster) 4.7.0 (Jul 27, 2018)

  • Optimizes connection management, making the new shell open more smoother, enhanced Object Explorer (Users and Roles node, Collection Schema and validator), watch Collection/Database/Deployment data changes, new SQL Functions(type conversion, string operations,date operations) and MongoDB ObjectId ↔ Timestamp Converter.

New in NoSQLBooster (formerly MongoBooster) 4.6.1 (Jul 13, 2018)

  • Fixed, a serious bug that prevented the query builder and aggregate method from working.

New in NoSQLBooster (formerly MongoBooster) 4.6 (Jul 5, 2018)

  • MONGODB 4.0 SUPPORT:
  • NoSQLBooster for MongoDB 4.6 upgrades embedded MongoShell to 4.0, adds support for all the new shell methods and operations of MongoDB 4.0. Multi-Document Transactions and New Type Conversion Operators.
  • WARNING: MongoDB 2.4 reached end of life in March of 2016, MongoDB Node.js 3.x driver dropped support for MongoDB 2.4 or below. Beginning in NoSQLBooster for MongoDB 4.5, versions of MongoDB server prior to version 2.6 are no longer supported.
  • MINOR IMPROVEMENTS:
  • Allows saving and editing DNS Seeds Connections.
  • Add first/last navigation buttons #ref.
  • Added more options for formatting numbers.
  • Connection troubleshoot:
  • Added connection log console to show debugging data when a “test connection are being established.
  • BUG FIX:
  • Fixed, no context menu in the “connection editor” text boxes #ref
  • Fixed, tree view arrays within documents won’t expand after changing output panel option #ref
  • Fixed, Closing a tab right after running a script make the program freeze #ref
  • Fixed, unable to start local mongo instance when connected via ssh to a remote instance #ref

New in NoSQLBooster (formerly MongoBooster) 4.5.5 (Jun 6, 2018)

  • Fixed, AppImage icon does not show up in Ubuntu GNOME #ref
  • Fixed, sorting a table by Int or Double column sorts them as a string #ref
  • Added, two new items to context menu of “table” view. ‘Copy Document(s) to Clipboard - Tab-Separated Values’ and ‘Copy Document(s) to Clipboard - Comma-separated Values’
  • Improved, identifying a long-running or stuck query and killing it#ref
  • Improved, “showIndex” code template for MongoDB sharded cluster

New in NoSQLBooster (formerly MongoBooster) 4.5.4 (May 21, 2018)

  • Hot fix:
  • Added, auth option: Always ask for password when connecting to MongoDB database #ref
  • Improved, export to CSV, Add a BOM character at the beginning of the csv to make Excel displaying special characters correctly
  • Fixed, a minor UI bug in displaying recent history scripts

New in NoSQLBooster (formerly MongoBooster) 4.5.3 (Apr 29, 2018)

  • Fixed, east asian language input does not work properly #ref
  • Fixed, $unwinds, cannot select middle item on the tree #ref
  • Fixed, instanceof keyword is not working as intended bug #ref
  • Fixed, mongo.NumberInt(${record[key]}) throws an error when record[key] = 10004743968 #ref
  • Fixed, Int64 truncated as Int32 bug in table & tree view #ref
  • Fixed, out of range bug when importing a table-view from MSSQL with more than 1000 rows #ref
  • Fixed, convert ObjectId to hexadecimal string bug #ref

New in NoSQLBooster (formerly MongoBooster) 4.5.2 (Apr 2, 2018)

  • New, “New Shell Tab…” and “New SQL Query Tab…” buttons to main toolbar
  • New option, Menu->Options-> Output Panel-> Keeping Input Focus on the Editor After Running (default false)
  • Improved, If the script does not need to be executed immediately, the editor window is maximized by default
  • Improved, Using IndexedDB instead of local storage to store history scripts
  • Changed, Export features will be disabled after the trial period

New in NoSQLBooster (formerly MongoBooster) 4.5.1 (Feb 26, 2018)

  • New, SQL Query: add RegExp Constructor Function e.g. select * from table where name = RegExp(‘^hai’,’i’)
  • Fixed, a bug when storing history script ref
  • Fixed, a shell and C# generator bug ref
  • Fixed, NoSQLBoooster runs out of Memory with Big BSON Documents => blank screen. ref
  • Enabled MongoDB Enterprise Connection in free edition

New in NoSQLBooster (formerly MongoBooster) 4.5.0 (Feb 13, 2018)

  • SQL Query Improvements
  • The “toJS” SQL Function and named parameter
  • NoSQLBooster 4.5 supports named parameter in SQL function. The new “toJS” helper function transforms the named parameters and arithmetic operator to a JSON object, also transforms an ordinary parameter list into an array.
  • With named parameter and “toJS” helper function, you can query complex objects or pass JSON-object parameter to a SQL function.
  • Mixed use of SQL and Chainable Aggregation Pipeline:
  • This feature already existed in previous versions, but in 4.5, mb.runSQLQuery returns AggregateCursor instead of DBCursor. This allows NoSQLBooster Intellisense to know all AggregateCursor’s chainable stage methods. (sort, limit, match, project, unwind…)
  • Querying Special BSON Data Types, UUID, BinData, DBRef…:
  • NoSQLBooster 4.5 supports all MongoDB build-in Data Types functions. To query values of these special BSON Data types, just write the values as you would in the MongoDB shell.
  • Date Functions with Optional Timezone:
  • NoSQLBooster 4.5 adds the timezone support for all SQL Date functions(Aggregation Operators), this feature requires MongoDB 3.6 or later.
  • Improved GROUP BY Clause:
  • The improved GROUP By clause supports MongoDB Pipeline Operators and SQL Aliases.
  • The following is equivalent MongoDB Aggregation Pipelines. Compare these two statements, it is clear that the SQL SELECT is simpler and easier to write and read than the MongoDB JSON-LIKE aggregation pipelines.
  • Better Error Handling in SQL Query:
  • All exceptions thrown when running a SQL Query have associated location information.
  • SQL Error ReportSQL Error Report:
  • SQL Editor Mouse Hover:
  • The mouse hover will show many useful information, such as document and example.
  • SQL Token TooltipSQL Token Tooltip:
  • Press F1 will lead you to MongoDB online document as the cursor is over a valid MongoDB function or aggregation operator.
  • Lots of New SQL Snippets:
  • NoSQLBooster 4.5 includes a lot of SQL-specific code snippets to save you time, Date Range, Text Search, Query and Array, Existence Check, Type Check and so on. You can always manually trigger it with Ctrl-Shift-Space. Out of the box, Ctrl-Space, Alt-Space are acceptable triggers.
  • SQL SnippetSQL Snippet
  • SQL Date Range Snippets
  • Text Search Snippets
  • The equivalent MongoDB Text Search
  • Query an Array ($all and $elemMatch) Snippets:
  • The $elemMatch operator matches documents that contain an array field with at least one element that matches all the specified query criteria.
  • Element Match with Embedded Documents:
  • The elemMatch query criteria (quantity>2, quantity

New in NoSQLBooster (formerly MongoBooster) 4.1.2 (Oct 31, 2017)

  • Fixed, Query Builder, correct db.group.find() to db.getCollection(“group”).find().
  • Fixed, Query Builder, rules ordering bug.

New in NoSQLBooster (formerly MongoBooster) 4.1.0 (Oct 30, 2017)

  • Visual Query Builder:
  • MongoBooster 4.1 comes with visual query builder. The two-way query builder could help you construct and display complex MongoDB find statements even without the knowledge of the MongoDB shell commands syntax.
  • To use query builder:
  • Use the Query Builder button in the editor toolbar.
  • Right-click the collection node in the connection tree, execute “Show Query Builder…”
  • Popup Command Palette (Ctrl-Shift-P), enter “Query Builder”
  • Scripts History Search:
  • This release provides a more friendly scripts history search. I strongly believe, this might be your most frequently used feature of history. When you’ve already executed a very long shell script, you can simply search history using one or a few keywords and re-execute the same command without having to type it fully. Press Ctrl-F7 and type the keyword. In default, MongoBooster will filter history that contains the current database and collection.
  • Tip: to match multiple words, please enter more keywords into the search box with + sign.
  • MINOR ENHANCEMENT:
  • Maximizing and Restoring Script Editor and Output Panel:
  • Editor/Ouput panel can be maximized (other panel is minimized at the same time) to provide more space for editing your script or seeing the result. When panel is maximized, you can simply restore its original size. To maximize or restore panel, simply use the maximize/restore button in the toolbar or press Ctrl-0 | Ctrl-9.
  • The cursor.select(arg: string|Object): ICursor method specifies which document fields to include or exclude. In addition to separating the field lists using spaces, the new version 4.1 also allows you to separate the fields using commas. The advantage is that the comma in the field list can popup Field Auto-complete list.
  • BUG FIX AND OTHER IMPROVEMENTS:
  • Improved, Editor: after you comment a line (ctrl + / ), advance cursor to next line. link
  • Fixed, Windows line endings should present when coping to clipboard. link
  • Fixed, Data view, shift multi-select ordering bug. link
  • Fixed, GUID/LGUID CSV export issue. link

New in NoSQLBooster (formerly MongoBooster) 4.0.2 (Oct 12, 2017)

  • Query MongoDB with SQL:
  • With MongoBooster V4, you can run SQL SELECT Query against MongoDB. SQL support includes functions, expressions, aggregation for collections with nested objects and arrays.
  • Let’s look at how to use the GROUP BY clause with the SUM function in SQL.
  • Instead of writing the MongoDB query which is represented as a JSON-like structure
  • db.employees.aggregate([
  • $group: {
  • _id: "$department",
  • total: { $sum: "$salary" }
  • You can query MongoDB by using old SQL which you probably already know
  • mb.runSQLQuery(`
  • SELECT department, SUM(salary) AS total FROM employees GROUP BY department
  • `);
  • Open a shell tab, enter the above script. MongoBooster also offers a “runSQLQuery” code snippets. Just type a snippet prefix “run”, and enter “tab” to insert this snippet, then press “Command-Enter” to execute it and get the result.
  • Query MongoDB with SQL Result TabQuery MongoDB with SQL Result Tab:
  • Just Click on the “console.log/print” tab to show the equivalent MongoDB query
  • The build-in SQL language service knows all possible completions, SQL functions, keywords, MongoDB collection names and field names. The IntelliSense suggestions will pop up as you type. You can always manually trigger the auto-complete feature with Ctrl-Shift-Space.
  • MongoBooster supports in-place editing in result tree view. Double-click on any value or array element to edit. Pressing shortcut “Esc” will return the previous value and exit the editor.
  • If you want the results not to be edited directly, you can enable the “read-only” mode by clicking the lock button in the toolbar.
  • SQL features are not natively supported by MongoDB. The SQL query is validated and translated into a MongoDB query and executed by MongoBooster. The Equivalent MongoDB Query can be viewed in console.log tab.
  • SQL Query Features:
  • Access data via SQL including WHERE filters, ORDER BY, GROUP BY, HAVING, DISTINCT, LIMIT
  • SQL Functions (COUNT, SUM, MAX, MIN, AVG)
  • Aggregation Pipeline Operators as SQL Functions (dateToString, toUpper, split, substr…)
  • Provide a programming interface (mb.runSQLQuery) that can be integrated into your script
  • Autocomplete for keywords, MongoDB collection names, field names and SQL functions
  • ES7 Async/Await support:
  • Within this release, we have also added support for ES7 Async/Await in MongoBooster shell.
  • As a comparison, MongoBooster has a build-in function await which is a common js method, not a keyword. It can await a promise or a promise array. Note this await function is different from es7 await, this await function may be used in functions without the async keyword marked.
  • Intellisense for Node.js Required Packages:
  • Within this release, MongoBooster also offers Intellisense experience for Node.js required packages. The IntelliSense suggestions will pop up as you type and automatically complete Javascript method names, variables, etc. You can always manually trigger it with Ctrl-Shift-Space. Out of the box, Ctrl-Space, Alt-Space are acceptable triggers.
  • For example:
  • Intellisense for Node.js Required PackagesIntellisense for Node.js
  • Minor Enhancement
  • More Useful MongoDB Shell Extensions
  • Global fetch() method
  • MongoBooser integrates node-fetch to bring window.fetch to MongoDB Script.
  • Global scope: fetch
  • console.log(await(await(fetch('https://github.com')).text()));
  • console.log(await(await(fetch('https://api.github.com/users/github')).json()));
  • cursor.not() method
  • The cursor.not(operator-expression) method performs a logical NOT operation on the specified “operator-expression” and selects the documents that do not match the “operator-expression”. This includes documents that do not contain the field.
  • The query will select all documents in the inventory collection where the item field value does not start with the letter p.
  • cursor.type() method
  • The cursor.type( BSON type number | String alias ) method selects the documents where the value of the field is an instance of the specified BSON type. Querying by data type is useful when dealing with highly unstructured data where data types are not predictable.
  • Group History Scripts by Date:
  • In the previous version, only up to 30 scripts can be saved. We got feedback from users, they say this value is too small. In the new version, we allow to save up to 1000 history scripts. Histrory entries can be grouped by date, which is easier to retrieve and query.
  • Hide/Show System Objects in Object Explorer:
  • The Databases node of Object Explorer contains system objects such as the admin databases.
  • To hide system objects in Object Explorer:
  • Click Options Menu
  • Click Explorer/Connection Tree
  • Toggle “Show System Object” on/off to hide/show system object
  • This change will take effect immediately.
  • Bugfix and other improvements:
  • Added, Menu -> Options-> Options That May Affect Performance -> Enable Fields/Collection Auto Complete, default value:true
  • Added, Menu -> Options-> Output panel -> Result JSON View Format -> Show Int32 as NumberInt(“xxx”), default value:false
  • Added, a new SSH config option to ask for SSH password each time
  • Improved, adjust sub-items of options menu
  • Improved, enable “Query by example” action for AggregationCursor
  • Improved, enable in-place-edit feature for AggregationCursor
  • Improved, SSL connection configuration
  • Fixed, Try finally connection close issue in discovering ReplicaSet action

New in NoSQLBooster (formerly MongoBooster) 3.5.6 (Jun 1, 2017)

  • added: Short cut "Mod+0" - "toggle Output Panel" to maximize the script editor.
  • added: Short cut "Mod+9" - "toggle Editor Panel" to maximize the output panel.
  • improved: Update node version to 7.4.0
  • fixed: Create new shell tab button is not visible in dark theme
  • fixed: Missing icons in dark theme
  • fixed: Can see HTML source in Replica Set Members header

New in NoSQLBooster (formerly MongoBooster) 3.5.5 (Apr 27, 2017)

  • fixed: should not sort by property name on a getIndex
  • fixed: "Query by example" doesn't work with nested array
  • fixed: can't add double/integer value into the nested array.
  • fixed: import JSON file which only contain single JSON object doesn't work.

New in NoSQLBooster (formerly MongoBooster) 3.5.4 (Apr 5, 2017)

  • fixed: shell tab can't be closed when the tab name includes space char
  • fixed: mongotools 3.4.2 compatibility issue

New in NoSQLBooster (formerly MongoBooster) 3.5.3 (Mar 22, 2017)

  • fixed: Kerberos Library is not installed issue.
  • fixed: database with name "" maked problems
  • improved: add bluebird Promise typings

New in NoSQLBooster (formerly MongoBooster) 3.5.2 (Mar 22, 2017)

  • fixed: Error connecting to Mongodb Atlas replicaset.
  • improved: Upgrade MongoDB driver to the latest version 2.2.24

New in NoSQLBooster (formerly MongoBooster) 3.5.1 (Mar 1, 2017)

  • This version distributes Linux application in the AppImage format, add Azure DocumentDB support along with some useful minor improvements and bugfix.
  • Linux AppImage format:
  • This version packages desktop applications as AppImages that run on common Linux-based operating systems, such as RHEL, CentOS, Ubuntu, Fedora, debian and derivatives. An AppImage is a downloadable file for Linux that contains an application and everything the application needs to run (e.g., libraries, icons, fonts, translations, etc.) that cannot be reasonably expected to be part of each target system.
  • To run an AppImage, simply: Make it executable ($ chmod a+x mongobooster*.AppImage )and run!
  • Azure DocumentDB Support:
  • Microsoft’s NoSQL document database service DocumentDB now supports drivers for MongoDB. So if you were using existing MongoDB tools and libraries, you can now use them with DocumentDB and take advantage of Microsoft’s cloud architecture. We have tested the MongoBooster with DocumentDB. It works well.
  • Minor UI Improvements:
  • Hold SHIFT key to bypass auto-exec - This version added a new handy "Hold SHIFT key to bypass auto-exec ..." collection action to disable automatic execution when opening a large collection
  • Save shell history log to file - This version also added a "save to file" button to shell log window to export shell log.
  • Minor Improvements and Bugfix:
  • Fixed, Missing add icon in the black theme.
  • Fixed, URI option not saving when add the `authMechanism` custom URI option
  • Improved, remove some code template's redundant comment.
  • Improved, update dependencies

New in NoSQLBooster (formerly MongoBooster) 3.3 (Jan 23, 2017)

  • This version includes a few useful shell script extensions (cursor.getShellScript, cursor.saveAsView...) along with some useful minor improvements and bugfix.
  • shell script extensions:
  • cursor.getShellScript() - Cursor.getShellScript() method return the MongoDB find shell script produced by the MongoBooster Fluent Query Builder.
  • cursor.saveAsView() - Cursor.saveAsView() save find/aggregate cursor as a MongoDB readonly view. The method requires MongoDB 3.4 and above.
  • cursor.getAggregationPipeline() - Cursor.getAggregationPipeline() return the aggregation pipeline produced by the MongoBooster Fluent Query Builder..
  • Minor UI Improvements:
  • Aggregation ... - This version added a new handy "aggregate..." collection action to generate fluent aggregate template script.
  • Update View ... - This version also added a new handy "Update View..." view action to drop and recreate MongoDB view.
  • Minor Improvements & Bugfix:
  • New, add "Copy Key/JSON Path(s) to Clipboard" item to the context-menu of tree/grid view. This action will return the full JSON path of the selected item. e.g. "object.array[0].subObj.field"
  • Fixed, Property 'xxx' does not exist on type '{}' warning.
  • Fixed, typings for ISODate constructor.
  • Fixed, Replica Set connection error with Kerberos
  • Improved, add more display page size options [5, 10, 20, 50, 100, 200, 500, 1000, 2000]
  • Improved, resize app icon (the app icon on macOS is too large)

New in NoSQLBooster (formerly MongoBooster) 3.2.3 (Jan 5, 2017)

  • Improved: add "Current Query Result" export option for non-cursor collections (plain collections)
  • Changed: default "Tab Name Format" to "Database:Collection"
  • Changed: loosen the restriction - Test Data Generator restricts to test database.
  • Changed: loosen the restriction - Read-only status lock restricts to localhost:27017 connection

New in NoSQLBooster (formerly MongoBooster) 3.2.2 (Dec 23, 2016)

  • Fixed: missing edit icon in the black theme

New in NoSQLBooster (formerly MongoBooster) 3.2 (Dec 8, 2016)

  • Includes official support for MongoDB 3.4 along with some useful minor improvements and bugfix.
  • MongoDB 3.4 support:
  • MongoBooster 3.2 adds support for all the new shell methods and operations of MongoDB 3.4. Sharding Zones, Linearizable Read Concern, Decimal Type, New Aggregation Stages, Views, and Collation.
  • New Aggregation Stages:
  • MongoDB 3.4 adds a few aggregation stages for Recursive Search, Faceted Search, Facilitate Reshaping Documents, Count and Monitor. In MongoBooster 3.2, all new aggregation stages can be used as the chainable methods, rather than specifying a JSON object.
  • Decimal Type:
  • MongoDB 3.4 adds support for the decimal128 format with the new decimal data type.
  • Views:
  • MongoDB 3.4 adds support for creating read-only views from existing collections or other views. MongoBooster 3.2 adds related shell method and GUI functions to make it easier to explorer and create.
  • Minor Improvements & Bugfix:
  • Added, a "Query By Example" icon button to the tree view toolbar
  • Improved, auto-complete feature for object property and field
  • Changed, auto-complete feature restricts to "test" or "demo" database after 60 days trial expired.
  • Fixed, not able to connect SSL enabled(self-signed ) ReplicaSet connection.

New in NoSQLBooster (formerly MongoBooster) 3.1.5 (Nov 20, 2016)

  • Changed: Bind shortcut F5 to “Run/Execute Current Statement”, replacing F4.
  • New: CTRL+F5 to execute the current statement into a new tab sheet.
  • New: CTRL+F6 to execute the entire/selected script into a new tab sheet.
  • Improved: Sort exported fields by name in the export dialog
  • Improved: Auto-fetch all fields for the small-size collection (< 2M)
  • Fixed: An autocomplete malfunction bug for the local connection after trial expired

New in NoSQLBooster (formerly MongoBooster) 3.1.3 (Nov 1, 2016)

  • Changed, In order to keep the behavior consistent with mongodb shell, MongoBooster will insert/update number as double type.
  • db.test.insert({a:1, b:1.0, c: 1.1, d: NumberInt("1.0"), e:Double("1.0")}) //or update
  • //before(=3.1.3): a: double, b: double, c:double, d: int32, e:double
  • Improved, execute current statement(F4) improved even focus on the commented line or empty line;
  • fixed, local timezone didn't show in json view;
  • fixed, collection export cannot change filename;
  • fixed, collection cannot export to mongoShell format.
  • fixed, closing tab with mouse middle button closes the active one instead of the aimed one

New in NoSQLBooster (formerly MongoBooster) 3.1.2 (Oct 25, 2016)

  • Added, Ctrl(Cmd)+D added as a new “duplicate selection” shortcut in editor
  • Improved, table view column autosize for Date/Number type performance improved;
  • Improved, run current line(F4) now can run a complete script statement even it split into multiple lines;
  • Improved, custom snippets(favorite) now can be used in the middle of a script;
  • Improved, Ctrl(Cmd)+Enter can be used to save in Type/Value Editor;
  • Fixed, value contains scripts execute when using find.

New in NoSQLBooster (formerly MongoBooster) 3.1.1 (Oct 8, 2016)

  • This version includes query by example, ReplicaSet discover members, export query and selected documents can choose fields and export to sql, improved connection config other options editor along with some useful minor improvements and bug fix.
  • Query by Example:
  • It's more easy to get a query via this small but very useful feature. Multiple fields supported, nested object/array supported.
  • Your browser does not support the video tag.
  • ReplicaSet Improvement:
  • We add a new "discover members" button in the Replica Set Members Grid, add a valid member, you'll get all existed members.
  • Discover Replica Set Members
  • In addition to this, after connect to a replica set connection, you'll get the new node under connection node, shows all replica set members and their , if you double click one of this nodes, you can connect to any member directly.
  • Connection Config's Other Options Enhancement:
  • Editor is more friendly now, we provide a useful keys list and default value.
  • Query Result & Selected Documents Export Enhancement:
  • Now, query and selected documents(include aggregation and vanilla array) support choose fields and export to sql like export database/collection.
  • Minor improvements & bug fix:
  • Improved, add more useful snippets (groupBy, createCappedCollection, convertCollectionToCapped...)
  • Improved, index creation now use shell to run just like export
  • Improved, keep SSH connection alive after network lost
  • Changed, set socketTimeoutMS to 0 as default
  • Fixed, auto refresh didn't remember first expand status
  • Fixed, copy document from tableview without _id showed undefined
  • Fixed, read-only status of connection configuration did't properly export
  • Fixed, bsonType parameter in export template didn't work correctly(Only effect export to Oracle .sql file)
  • Fixed, authMechanism SCRAM-SHA-1 and MONGODB-CR didn't save in the Other Options Tab. (Other 3 are supported in Authentication Tab)
  • Fixed, one member replica set connection after export/import lost replica set connection type

New in NoSQLBooster (formerly MongoBooster) 3.0.5 (Sep 27, 2016)

  • Fixed, connectTimeoutMS and socketTimeoutMS not working properly.

New in NoSQLBooster (formerly MongoBooster) 3.0.4 (Sep 27, 2016)

  • Changed, enterprise connection can be tried in Free Edition for 21 days

New in NoSQLBooster (formerly MongoBooster) 3.0.3 (Sep 27, 2016)

  • Fixed, connect mongos throw error
  • Fixed, create index throw error with successful message
  • Fixed, treeview/tableview's long string tooltip doesn't wrap
  • fixed, long "show profile" doesn't fold as default
  • fixed, "show collections" doesn't work after use another database
  • fixed, Ubuntu new version link doesn't work

New in NoSQLBooster (formerly MongoBooster) 2.3.2 (Jul 12, 2016)

  • Improved console.log/print tab:
  • The brand-new, improved console.log/print Tab collects all output messages in only one tab, instead of showing them in separated tabs. You can find and view these messages much easier than before. The elapsed time shows when the message occurs during the whole script execution.
  • JSON view format options:
  • A new setting button is added to the toolbar of the result view. It allows you to more easily customize results view. And now, the JSON view can switch between the two formats,mongoshell and mongoexport.
  • Bug fixes and minor updates:
  • New, remember Edit Field/Type Dialog size
  • New, add a option to disable showing db stats and collection stats
  • Improved, show custom fields in DBRefs(e.g. Doctrine add "_doctrine_class_name" in the DBRef)
  • Fixed, NumberInt does not work

New in NoSQLBooster (formerly MongoBooster) 2.2.2 (Jul 2, 2016)

  • REAL-TIME LOG VIEWER:
  • Instead of showing a simple loading spinner, this release add a new log viewer to show the real-time console log/ print info. When the shell script execution time exceeds 2 seconds, the log window will be popped up and monitor script logs at real-time.
  • RESULT VIEW SORTING OPTIONS:
  • This release adds sorting options to tree view/table view fields. (Menu->Options->Result TreeView/TableView Sort Type):
  • Nature (default value, as they are in the JSON view)
  • Ascending Order
  • Descending Order
  • SHELL TAB TITLE FORMAT OPTIONS:
  • This release adds options to form a tab name of the editor window in the following format list. (Menu->Options->Editor Tab Name Format):
  • Database:Collection@Connection
  • Database:Collection
  • Database@Connection
  • BUG FIXES AND MINOR UPDATES:
  • New, add "choose custom fields" feature to build-in export utility
  • New, add "insertOneAndFetchIt" snippet
  • New, add "expand whole tree menu item" to tree view right-click menu
  • New, add "add more" button to replica set editor
  • Improved, result view toolbar responsive resize.
  • Improved, Mongodump: disable invalid dumpDbUsersAndRoles option when dump all databases
  • Improved, auto focus to new node after clicking right-click menu item "create database"
  • Fixed, throw error when print([null,undefined]) in JSON View
  • Fixed, GridFS: right-click menu item "add files..." does not work
  • Fixed, save as... extension issue. (file.js_copy -> file_copy.js)

New in NoSQLBooster (formerly MongoBooster) 2.2 (Jun 23, 2016)

  • This release includes Real-Time log viewer, tree/table view sorting options, shell tab title format options, bug fixes and a few minor improvements.
  • Real-Time log viewer:
  • Instead of showing a simple loading spinner, this release add a new log viewer to show the real-time console log/ print info. When the shell script execution time exceeds 2 seconds, the log window will be popped up and monitor script logs at real-time.
  • Your browser does not support the video tag.
  • Result view sorting options:
  • This release adds sorting options to tree view/table view fields. (Menu->Options->Result TreeView/TableView Sort Type)
  • Nature (default value, as they are in the JSON view)
  • Ascending Order
  • Descending Order
  • Shell tab title format options:
  • This release adds options to form a tab name of the editor window in the following format list. (Menu->Options->Editor Tab Name Format)
  • Database:Collection@Connection
  • Database:Collection
  • Database@Connection
  • Bug fixes and minor updates:
  • New, add "choose custom fields" feature to build-in export utility
  • New, add "insertOneAndFetchIt" snippet
  • New, add "expand whole tree menu item" to tree view right-click menu
  • New, add "add more" button to replica set editor
  • Improved, result view toolbar responsive resize.
  • Improved, Mongodump: disable invalid dumpDbUsersAndRoles option when dump all databases
  • Improved, auto focus to new node after clicking right-click menu item "create database"
  • Fixed, throw error when print([null,undefined]) in JSON View
  • Fixed, GridFS: right-click menu item "add files..." does not work
  • Fixed, save as... extension issue. (file.js_copy -> file_copy.js)

New in NoSQLBooster (formerly MongoBooster) 2.1.2 (Jun 13, 2016)

  • This release includes Quick Find for the connection tree, ShellJS integration, support mongo Shell Native Methods, auto load `.mongorc.js`, export user-defined fields and a few minor improvements and bugs fix.
  • Quick Find:
  • Quick find to symbol with (⌘+F|CTRL+F) provides the possibility to get to any database and collection object in the connection tree view.
  • ShellJS Integration:
  • ShellJS (version: 0.7.0) is a portable (Windows/Linux/OS X) implementation of Unix shell commands. It is a fantastic tool for integrate MongoDB Shell Script with the external shell environment in a cross-platform way. ShellJS Commands can send their output to another command in a pipe-like fashion. sed, grep, cat, exec, to, and toEnd can appear on the right-hand side of a pipe. Pipes can be chained.
  • Mongo Shell Native Methods:
  • MongoBooster V2.1 implemented all MongoShell native methods except for those described for internal use. Now, you can use "load" method to load and run a JavaScript file in the shell or use "cat" to return the contents of the specified file.
  • Load "~/.mongorc.js":
  • MongoBooster V2.1 add an option to auto load "~/.mongorc.js".
  • Copy collection with indexes:
  • Add an option, When copy/pasting one or more collections, copy the indexes as well.
  • Bug fixes and minor updates:
  • New, add "mongorestore..." to import submenu in main toolbar
  • New, add "mongodump..." to export submenu in main toolbar
  • Improved, upgrade shell deps to latest version
  • Fixed, remove duplicated snippets
  • Fixed, semver check issue, support mongodb 3.2.6-atlas
  • Fixed, manually list database, uncheck button does not work
  • Fixed, tile window does not work in multiple screens

New in NoSQLBooster (formerly MongoBooster) 2.1 (Jun 7, 2016)

  • This release includes Quick Find for the connection tree, ShellJS integration, support mongo Shell Native Methods, auto load `.mongorc.js`, export user-defined fields and a few minor improvements and bugs fix. Free for non-commercial use.
  • Quick Find:
  • Quick find to symbol with (⌘+F|CTRL+F) provides the possibility to get to any database and collection object in the connection tree view.
  • ShellJS Integration:
  • ShellJS (version: 0.7.0) is a portable (Windows/Linux/OS X) implementation of Unix shell commands. It is a fantastic tool for integrate MongoDB Shell Script with the external shell environment in a cross-platform way. ShellJS Commands can send their output to another command in a pipe-like fashion. sed, grep, cat, exec, to, and toEnd can appear on the right-hand side of a pipe. Pipes can be chained.
  • The following example use shelljs and json2csv to export a MongoDB collection to a CSV file.
  • //prepare, install json2csv command cli
  • //npm i -g json2csv
  • let users=db.users.find({}).toArray();
  • shelljs.echo(JSON.stringify(users)).to("~/tmp/test.json"); //save as a json file
  • shelljs.exec("json2csv -i ~/tmp/test.json -o ~/tmp/out.csv") //convert json file to csv
  • Mongo Shell Native Methods:
  • MongoBooster V2.1 implemented all MongoShell native methods except for those described for internal use. Now, you can use "load" method to load and run a JavaScript file in the shell or use "cat" to return the contents of the specified file.
  • Mongo Shell Native Methods Reference
  • MongoBooster Native methods will convert a tilde path to an absolute path.
  • load("~/dev/mongodb/myscript.js");
  • cat("~/dev/mongodb/myscript");
  • ls("~/dev/mongodb/");
  • Load "~/.mongorc.js"
  • MongoBooster V2.1 add an option to auto load "~/.mongorc.js".
  • Export User-Defined Fields
  • Copy collection with indexes: Add an option, When copy/pasting one or more collections, copy the indexes as well.
  • Bug fixes and minor updates:
  • New, add "mongorestore..." to import submenu in main toolbar
  • New, add "mongodump..." to export submenu in main toolbar
  • Improved, upgrade shell deps to latest version
  • Fixed, remove duplicated snippets
  • Fixed, semver check issue, support mongodb 3.2.6-atlas
  • Fixed, manually list database, uncheck button does not work
  • Fixed, tile window does not work in multiple screens

New in NoSQLBooster (formerly MongoBooster) 2.0 (May 24, 2016)

  • This major release includes fluent query builder, GUI for mongotop and mongostat, dark theme, user-defined snippets, restore last working state , auto-update and a few minor improvements. Even better now, MongoBooster, the smartest and most feature rich MongoDB Admin GUI is free for non-commercial use.
  • Fluent Query Builder:
  • MongoBooster supports mongoose-like fluent query builder API which enables you to build up a query using chaining syntax, rather than specifying a JSON object. The aggregation framework is now fluent as well. You can use it as currently documented or via the chainable methods.
  • GUI for mongotop:
  • For MongoDB, mongotop do pretty much the same job as the Unix command top, it is used to monitor the Mongo instance.The output of mongotop indicates the amount of time the mongod process spend reading and writing to a specific collection during the update interval. mongotop provides statistics on a per-collection level.
  • MongoBooster offers a build-in GUI tool for MongoTop. No external MongoTop command line tools dependence and works for MongoDB 2.2-3.2.
  • GUI for mongostat:
  • The mongostat utility provides a quick overview of the status of a currently running mongod or mongos instance. mongostat is functionally similar to the UNIX/Linux file system utility vmstat, but provides data regarding mongod and mongos instances.
  • MongoBooster offers a build-in GUI tool for MongoStat too. No external MongoStat command line tools dependence.
  • Dark theme:
  • MongoBooster V2 offers two themes, light and dark. The Dark theme provides a high-contrast visual theme (black background with brighter text). You can switch the theme by click "theme" button in the right corner of the main toolbar.
  • User-Defined Snippets:
  • Having a collection of pre-defined code snippets is handy, but code snippets become much more useful when you make your own. Now, you can add your self-defined code snippets by clicking "add favorite script..." button in the editor toolbar.
  • Snippets work in a similar way as those for Ace editor and sublime
  • Ace editor help manual: create a new snippet
  • Restore last working state:
  • MongoBooster add a new option to remember the last working state, so when you restarted MongoBooster all of your last working connection, database , collection, editor script got restored to last working view.
  • Use Menu->Options->Restore last working state to toggle the feature.
  • Recognize ~/.ssh/config:
  • When add new ssh connection, MongoBooster will recognize SSH config file and auto fill SSH connection fields from ssh config file.
  • Auto-updates:
  • The auto-updates feature enable MonoBooster to automatically update itself, so your copy will always be up-to-date. The auto-updates module is based on Squirrel framework.
  • Note: For Mac and Windows users, we have enabled the auto-update channel. Auto-updates are not supported for Linux.
  • Bug fixes and minor updates:
  • Improved, upgrade lodash to 4.12.0
  • Improved, Show all fields in GridFS documents
  • Improved, speed up history scripts and favorite snippets menu show deplay time
  • Improved, speed up new editor tab show delay time
  • Improved, allow to copy text from MongoDump or MongoRestore log window
  • New, set the initial view in preferences, Options->Default view mode
  • New, add more snippets, Javascript lang, QueryBuilder and 3rd lib sample
  • New, use Standard Tab Switching Shortcut (cmd+shift+] ,cmd+shift+[), Mac Only
  • New, let the middle mouse button click close the tabs on the top
  • New, integrate moment timezone. Use "moment.tz" to access it
  • New, add "to URI" button to connection editor dialog
  • New, add "Use own Root CA File" option to SSL connection
  • New, add "cancel" button when refresh connection tree
  • New, add context-menu to JSON viewer
  • Fixed, ensure command-palette input box get focus when it is visible

New in NoSQLBooster (formerly MongoBooster) 1.6.1 (Apr 12, 2016)

  • Favorite Scripts Management:
  • Now you can save any script fragments as favorite script. You can use the "add favorite" button on the right top of the editor or through Command Palette to open the dialog to add or edit your favorite.
  • We also provide a management dialog to add/edit/delete/export/import your favorite scripts.
  • Bug fixes and minor updates:
  • Improved, copy LUUID text instead of Bin data(Idea from Carl)
  • Fixed, sh.status() show error on a sharded cluster

New in NoSQLBooster (formerly MongoBooster) 1.5.1 (Mar 21, 2016)

  • This release includes MongoDB Enterprise connection options(Kerberos & LDAP) and a few minor updates.
  • MongoDB Enterprise Authentication:
  • MongoBooster now officially fully supports MongoDB Enterprise Edition by adding two new authentication mechanisms Kerberos(GSSAPI) & LDAP(PLAIN), in addition to already supported regular username/password(SCRAM-SHA-1(added in MongoDB 3.0)/MONGODB-CR) & X.509.

New in NoSQLBooster (formerly MongoBooster) 1.3.3 (Mar 10, 2016)

  • Fixed: a SSL connection issue with "compose.io" SSL enabled mongodb server.
  • Fixed: can not export "aggregate" query result if the "auto-fetch count" feature is enabled.
  • Fixed: can not export query result after canceling "choose fields" dialog.
  • Improved: polish UI for Mongoexport.

New in NoSQLBooster (formerly MongoBooster) 1.3.2 (Mar 4, 2016)

  • Fixed: can not export "aggregate" query result if the "auto-fetch count" feature is enabled.
  • Fixed: can not export query result after canceling "choose fields" dialog.
  • Improved: polish UI for Mongoexport.

New in NoSQLBooster (formerly MongoBooster) 1.3 (Feb 26, 2016)

  • Aggregation UI performance improved:
  • In the older version of MongoBooster, if I you exec a MongoDB aggregation which will get large number of result, the GUI will just hang or freeze for a while. The 1.3 release addressed the annoying issue, it speeds up the aggregation operation significantly. We strongly recommend you upgrading to version 1.3 to improve the aggregation performance if you ever experienced this.
  • Mongoexport and Mongoimport GUI:
  • In addition to the original built-in import and export tools, this release adds a new import and export method by utilizing Mongoexport and Mongoimport of MongoDB client.
  • Notable bug fixes and minor updates:
  • New, client-side paging for non-cursor result data.
  • New, add storageEngine name on tooltip of connection.
  • Improved, handle uncaught exception to avoid crashes.
  • Improved, rearrange connection tree context menu.
  • Fixed, a date to JSON string convert issue.
  • Fixed, the GridFs viewer cannot open file with an unknown file extension.

New in NoSQLBooster (formerly MongoBooster) 1.2 (Feb 19, 2016)

  • Show history of previous scripts:
  • Press [F7] to pop up history scripts list. Use the up and down key's to scroll through previously typed scripts. Press [Enter] to send it to the code editor shell.
  • Show the total number of rows:
  • By default, MongoBooster will show the total number of rows in result view if the query time is less then 300 ms. You can disable the feature or adjust the setting in "Options -> Auto fetch cursor count".
  • New Hack font:
  • MongoBooster adapts a new typeface designed for source code - Hack. Hack is hand groomed and optically balanced to be your go-to code face.
  • Notable bug fixes and minor updates:
  • New, support authentication mechanism x.509(authMechanism=MONGODB-X509)
  • New, a few new code snippets, insertOne, insertMany, updateOne, updateMany, deleteOne, deleteMany, replaceOne, findTextSearch, findnearLegacy2d and findnear$geometry
  • New, use ObjectId.getTimestamp() method to get "createAt" field and show it in JSON View.(screenshot)
  • New, add a "View Document..." right-click menu item in GridFS tree view
  • New, add "Options->Legacy UUID Encoding", allow LUUID encoding as Raw data, Java, C# or Python
  • New, add "Help -> MongoDB Aggregation Pipeline Quick Reference" menu item
  • New, add a "Feedback/Support" button to bottom-right of home screen
  • Improved, new "To URI" dialog, hide password/include extra parameters(eg. SSH connections)
  • Improved, allow you to export the query result set in GridFS bucket
  • Improved, allow select item when importing connection configs
  • Improved, can export aggregation result direct to the .csv file
  • Improved, add "Current query result" source to export aggregation query
  • Improved, create Database now enabled in all supported MongoDB versions
  • Improved, manually list visible databases when use any authentication
  • Fixed, cannot copy database between two MongoBooster windows
  • Fixed, a sorting issue in method auto-complete
  • Fixed, a UI refresh issue after changing editor theme
  • Fixed, In-place editor can not save string when it contains double quote
  • Fixed, PageUp and PageDown Keypress bug in tree view and table view

New in NoSQLBooster (formerly MongoBooster) 1.1.1 (Jan 18, 2016)

  • GridFS Support:
  • MongoBooster fully supports MongoDB’s GridFS. With our GridFS Viewer, you can read and write to GridFS collections. Files can be added easily with drag and drop.
  • Dark Editor Theme:
  • MongoBooster offers a new dark editor theme with improved syntax highlighter.
  • Mark Connection with Color:
  • When working on dev/prod databases at the same time you may unintentionally delete or update something on prod instead of dev. Now you could mark prod ones in red and dev in green. It would help you prevent this kind of mistake.
  • Drog and Drop Tabs Re-ordering:
  • MongoBooster allow moving of tabs via drag and drop reordering.
  • Improve Connection Tree:
  • Add "Server Current operations" and "Server Build Info" Right-Click Menu items in Connection node.
  • Add "Create GridFS Bucket ...", "View Users", "Add User..." , "Server Status", "Server BuildInfo" and "Database Current Operations" Right-Click Menu items in Database node
  • Add "Current Operations" Right-Click Menu item in Collection Node
  • Add "Add User ..." Right-Click Menu item in Users Node
  • Notable Minor Updates:
  • Connections Config Export and Import
  • Use "Ctrl+Alt+N" to open a new window, it is handy to analyze the results of the same query side-by-side.
  • Keep SSH connection alive and improve performance
  • Enable F5 for refresh tree nodes(Win+Linux)
  • Improve Syntax Highlighter
  • Improve field auto-complete
  • Add "show in tab shell" button on JSON View Dialog
  • Upgrade Moment.js to 2.11.1
  • Several minor bugs fixed