NoSQLBooster Changelog

What's new in NoSQLBooster 6.2.5

Dec 11, 2020

Bugfix:
Fixed, when querying a task, task manager(schtasks.exe) for non-English version of windows will raise an error.
Fixed, even if ignored, the renewal warning dialog box will be forced to pop up.
Improved, when using MongoDB URI for fast connection, duplicate name checking has been added to ensure that the connection name is unique.
Improved, enhanced document viewer and field value editor that allows you to maximize, drag, and limit the left and upper boundaries of the container
Changed, for non-registered users, the export function is limited to a maximum of 10000 documents

New in NoSQLBooster 6.2.4 (Dec 3, 2020)

New in NoSQLBooster 6.2.3 (Nov 26, 2020)

New in NoSQLBooster 6.2.1 (Nov 19, 2020)

New in NoSQLBooster 6.2.0 (Nov 11, 2020)

New in NoSQLBooster 6.1.8 (Oct 11, 2020)

New in NoSQLBooster 6.0.5 (Aug 2, 2020)

New in NoSQLBooster 6.0.4 (Jun 26, 2020)

New in NoSQLBooster 6.0.3 (Jun 26, 2020)

New in NoSQLBooster 6.0.2 (Jun 26, 2020)

New in NoSQLBooster 6.0.1 (Jun 9, 2020)

Tasks and task scheduler:
NoSQLBooster tasks allow you to define, save, and perform different tasks, including query scripts, imports, exports, data migration, and backup and restoration. Task Scheduler lets you define tasks that execute on a one-time basis or a recurring schedule that you specify. It supports tasks that perform daily, weekly, or monthly, and you can choose the day(s) of the week or month when you want each task to execute.
NoSQLBooster does not need to run at the scheduled time to run any scheduled tasks. In windows systems, NoSQLBooster uses the Windows Task Scheduler to perform routine tasks automatically. While in MacOS and ubuntu, cron is used to manage and execute scheduled tasks.
NoSQLBooster supports the following types of tasks.
Run MongoDB Script File (As NoSQLBooster allows you to use 3rd party node modules, the functionality of this script is extensible and flexible)
Import from JSON and BSON files…
Import Tables from MySQL, PostgreSQL, and MSSQL…
Restore MongoDB Databases (mongorestore)
Export Collection/Query to JSON, BSON, CSV|TSV and SQL
Export Database to JSON, BSON, CSV|TSV, and SQL
Backup MongoDB Databases (mongodump)
For Windows User, You can find the tasks generated by NoSQLBooster in the URI “Task Scheduler(local)Task Scheduler LibraryNoSQLBoosterMongoDB“.
NoSQLBooster command-line interface (nbcli):
This nbcli is a simple command-line interface for NoSQLBooster. It allows you to run javascript or SQL query statement, javascript file, and NoSQLBooster tasks in terminal or integrate NoSQLBooster into your continuous development. This nbcli supports all NoSQLBooster shell extensions, SQL Query, fluent Query API, 3rd party library (lodash, momentjs …) and Node.js modules installed under user data directory (Menu-> Help-> Open User Data directory)
To start nbcli, click “Menu -> Tools -> Open NoSQLBooster Command Line …”, you can use “Menu -> Options -> Add Command Line to path…” to add nbcli to user’s PATH.
To be clear, nbcli is not a REPL (Read Evaluate Print Loop) tool.
ESNext features, optional chaining, and nullish coalescing:
NoSQLBooster embraces the new features of ESNext. Version 6.0 adds two new features, optional chaining and nullish coalescing, which are very handy.
Optional chaining:
The optional chaining (?.) lets us write code where we can immediately stop running some expressions if we run into a null or undefined. You might find yourself using ?. to replace a lot of code that performs repetitive nullish checks using the && operator.
// Before
if (foo && foo.bar && foo.bar.baz) {
// ...
// After-ish
if (foo?.bar?.baz) {
// ...
Nullish coalescing:
The nullish coalescing operator (??) is a logical operator that returns its right-hand side operand when its left-hand side operand is null or undefined and otherwise returns its left-hand side operand.
The ?? operator can replace uses of || when trying to use a default value.
const foo = null ?? 'default string';
console.log(foo);
// expected output: "default string"
const baz = 0 ?? 42;
console.log(baz);
// expected output: 0
Golang, PHP and Ruby added to query code converter:
The MongoDB query converter now supports Golang, PHP, and Ruby in addition to Node.js, Java, Python, C #, and mongo shell languages.
Enhanced data view:
Mark types with colors:
Give different colors to different types, making the data easier to identify and view. If this looks a little too flashy, you can use the option “Menu -> Options -> Output Panel -> Mark Types with Colors” to turn it off.
Greatly improved table view:
Table-View | In-place edit:
In addition to the tree open view, you can now double-click to open the edit-in-place text control to edit and submit content in the table view.
Edit-in-place table viewEdit-in-place table view
Table-View | Column chooser:
The newly designed column chooser can easily select fields or embedded fields. You can also see that more functions have been added in the header context menu of the table.
After selecting the fields, you can also use the right-click menu to save the query results view as a MongoDB read-only view (Include Visible Columns or Exclude Hidden Columns)
Table-View | Column-moving and freeze columns:
To move a column, just drag the column’s header to the desired position. You can also drag the column to the frozen zone to freeze some fields so that they do not scroll out of view. The _ id field is located in the frozen zone by default.
Column-moving and freeze columnsColumn-moving and freeze columns
One-click projection and One-click sorting:
In addition to one-click filtering and one-click grouping, one-click projection and one-click sorting have been added in version 6. One-click projection allows you to easily select several fields in the results view and form a new query. One-click sorting can re-sort the chosen fields in ascending and descending order. All one-click features support embedded fields.
Tooltip Improvements:
Informative tooltips are getting better now. You can press the “p” key to view JSON array and objects, multiple lines of text, URL pages, pictures, and geographic location information.
Press "p" to view objectPress "p" to view object
Favorites Feature:
The favorites feature is used to tag database objects and bookmark scripts, providing you with one-click access. Favorites can be accessed through the favorites item in the main menu.
To add a database object to the favorites, select the item in the Databases object tree, click Menu->Favorites, or use the “Add to Favorites” right-click menu operation for the database object.
To add a query script to the favorites, please double-click to open this script from the “My Queries” tree, then click Menu->Favorites to bookmark query script or use the “Add to Favorites” right-click menu operation for the query script from the “My Queries” tree
Add database object to favoritesAdd database object to favorites
SQL query improvements:
In this version, we removed the restrictions on SQL JOIN and subquery statements in the free version and added a dozen SQL snippets. For example, SQL-like, SQL-GroupBy, SQL-DateRange, SQL-Between, etc.
SQL SnippetsSQL Snippets
Other Notable Improvements:
Add date time to export file path:
When exporting MongoDB collection or backing up the database regularly, you may want to add the DateTime to the export file path (e.g.,/exports/backup_yyyy_mm_dd.csv) ). The DateTime variable (e.g., %%YYYY_MM_DD%%%) has been added to NoSQLBooster 6, so you can easily append DateTime to the export path. NoSQLBooster uses moment.js to format date and time. For more formatting, see the moment.js website.
Append Date to export pathAppend Date to export path
Export non-cursor objects:
NoSQLBooster V6 allows you to export non-cursor data, includes normal javascript arrays or objects. e.g: db.xxx.find().toArray() or db.xxx.findOne().
Save/Restore Workspace Improvements:
In previous versions, only one connection and one tab could be restored. There is no such restriction in V6. NoSQLBooster V6 can ultimately save and restore the working space, including all connections and tabs.
New AggregationCursor.pushStage method:
NoSQLBooster supports mongoose-like fluent query builder API that enables you to build up a query using chaining syntax. All aggregation stage operators in the current version of MongoDB (4.2) have corresponding chainable methods. Considering that MongoDB continues to add aggregation stage operators, we have added this “pushStage” method in this release to be compatible with the possible future stage operators.
db.movieDetails.aggregate()
.match({type:"movie"})
.pushStage({$limit:5}) //pushStage() method appends the given stage in the last of the pipelines
//equal to
db.movieDetails.aggregate()
.match({type:"movie"})
.limit(5)
//or, the equivalent MongoDB JSON-like Query
db.movieDetails.aggregate([
{ $match: {type:"movie"}},
{$limit: 5}
Minor improvements and bugfix:
Upgrade MongoDB Node.js driver to 3.5
Upgrade major dependencies electron to 7.x, Chrome v78, Node v12.8, and V8 v7.8
Support Ed25519 keys for SSH tunnels authentication
Support MySQL 8 default authentication (caching_sha2_password)
In the tree/table view, press “CMD+PageDown” to go to the next page and “CMD+PageUp” to go to the previous page
Add “Tools” item to the main menu which is quickly linked to a bunch of built-in tools
Bugfix:
Added, an option to adjust the maximum number of sub-columns allowed by the column group in the table view, and when the subfield exceeds the threshold, it will be displayed as a normal object field. Menu Options-> Output Panel -> Table View: Max Column Len of the Column Group.
Improved, prompts the user to save unsaved tab contents when closing the tab. Menu Options ->Warning Message -> Prompt User to Save Unsaved Tab Content.
Fixed, an error in parsing MongoDB+Srv URI authSource default values.
Fixed, SQL parsing error when SQL like included the special character “/“.
Fixed, a bug that caused the export dialog to be obscured and inoperable when the main window was too small.

New in NoSQLBooster 5.2.5 (Nov 18, 2019)

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.
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.
Wildcard Index:
MongoDB 4.2 introduces wildcard indexes for supporting queries against unknown or arbitrary fields. This version also adjusts UI to provide support for wildcard index.
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.
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.
New Fluent Query Methods:
NoSQLBooster 5.2 adds the following new fluent query methods
Visualizing Legacy Coordinate Pairs:
In addition to visualize the MongoDB GeoJSON Objects, this feature now also allows you to visualize legacy coordinate pairs.
Add “Reload” Button to the Document Viewer:
This new “Reload” button allows you to manually reload the contents of the current object in the document viewer.
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 5.0.3 (Dec 7, 2018)

New in NoSQLBooster 4.7.2 (Sep 7, 2018)

New in NoSQLBooster 4.7.0 (Jul 30, 2018)

New in NoSQLBooster 4.5.3 (May 1, 2018)

New in NoSQLBooster 4.5.2 (Apr 3, 2018)

New in NoSQLBooster 4.5.1 (Feb 22, 2018)

New in NoSQLBooster 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<=10) will be translated as “quantity”: { “$gt”: 2, “$lte”: 10 }. This syntax is more concise and expressive.
Other Notable Improvements:
Improved tooltip of Index Node
Statistics on the index use will be displayed in the tooltip of index node.
Index TooltipIndex Tooltip
Auto-Detect MongoDB URI
Starting with version 4.5, NoSQLBooster can detect whether you have a MongoDB URI in your clipboard and auto-populate the connection dialog from the URI.
Detect MongoDB URIDetect MongoDB URI
Show the Recent Access Time of the Connection
Recent Access TimeRecent Access Time
Minor Improvements and Bugfix:
Improved, Humanize Array values in the table view, show as “(3) [1, 2.0 ,’3’]”
Changed, the default sample size of schema analysis increases from 100 to 1000
Changed, default database name of test data generator dialog from “test” to the current db
Added, “View Index Statistics ($indexStats)” menu item to indexes sub items of the collection node
Upgraded from Chrome 58.0.3029.110 to 59.0.3071.115
Upgraded from Node 7.9.0 to 8.2.1
Enabled SSL connection in free edition

New in NoSQLBooster 4.3.1 (Jan 9, 2018)

MongoDB 3.6 support:
NoSQLBooster for MongoDB 4.3 upgrades dependent MongoDB Node.js driver to 3.0, adds support for all the new shell methods and operations of MongoDB 3.6. DNS-constructed Seedlist mongodb+srv, Change Streams, Sessions, JSON Schema , New Query Operators and New Aggregation Stages and 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.3, versions of MongoDB server prior to version 2.6 are no longer supported.
DNS-constructed Seedlist mongodb+srv:
In addition to the standard connection format, NoSQLBooster for MongoDB 4.3 quick connect (connect from URI…) support a DNS-constructed seedlist.
To use it, Click Menu -> File -> Quick Connect … (Enter mongodb+srv://) or Click Connect -> From URI .. in the main toolbar.
Change Streams (db.collection.watch):
NoSQLBooster for MongoDB 4.3 adds shell method and code snippet “db.collection.watch” to open and watch a change stream.
To use it:
Method1: Enter “db.collection.watch”, pop-up code complete dialog (Ctrl-Shift-Space), select “watch” snippet.
Method2: Right-click collection node in the connection tree, and click -> Watch Collection.
Sessions:
NoSQLBooster for MongoDB 4.3 adds all session related methods to its embeded Mongo Shell. It also provides a few code snippets to manage sessions.
New Query Operators:
NoSQLBooster for MongoDB 4.3 adds the following new query operators and code snippets:
The new $jsonSchema operator matches documents that validate against the given JSON Schema.
The $expr allows the use of aggregation expressions within the query language.
New Aggregation Stages and Operators:
NoSQLBooster for MongoDB 4.3 adds “db.aggregate(), to perform aggregations that do not rely on an underlying collection, adds the new MongoDB 3.6 aggregation pipeline stages and new Aggregation Operators.
New Node.js 3.x Driver Query Code Generator
In addition to Node.js 2.x driver, Java , Python, C# and the mongo shell language, you can also now generate Node.js 3.x driver API code from all queries find, aggregate and SQL Query.
Minor Improvements and Bugfix:
Improved, Humanize numbers, show 4918360.53 as “4,918,360.53 (4.9M)”
Fixed, High memory usage crashs machine on Linux
Fixed, Cut/Copy/Paste in editor context menu doesn’t work on Mac

New in NoSQLBooster 4.2.0 (Nov 30, 2017)

New in NoSQLBooster 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.
Bugfix 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 4.0.1 (Aug 28, 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.
For example:
function delay(ms) {
return new Promise((resolve)=> {
setTimeout(resolve, ms);
});
async function go() {
await delay(1000);//wait 1s
return db.orders.find().limit(5);
go();
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.
The above example can be written with the MongoBooster await function.
function delay(ms) {
return new Promise((resolve)=> {
setTimeout(resolve, ms);
});
await(delay(1000));
db.orders.find().limit(5);
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.
Consider the following example which uses the pattern match expression //:
db.inventory.where("item").not(/^p.*/)
//the equavalent MongoDB JSON-like Query
db.inventory.find( { item: { $not: /^p.*/ } } )
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.
The following queries return all documents where zipCode is the BSON type string:
db.addressBook.where("zipCode").type(2);
db.addressBook.where("zipCode").type("string");
//the equavalent MongoDB JSON-like Query
db.addressBook.find( { "zipCode" : { $type : 2 } } );
db.addressBook.find( { "zipCode" : { $type : "string" } } );
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 3.5.7 (Aug 13, 2017)

New in NoSQLBooster 3.5.6 (Jun 23, 2017)

New in NoSQLBooster 3.5.4 (Apr 5, 2017)

New in NoSQLBooster 3.5.3 (Mar 22, 2017)

New in NoSQLBooster 3.5.1 (Mar 2, 2017)

New in NoSQLBooster 3.3.1 (Jan 24, 2017)

New in NoSQLBooster 3.2.3 (Jan 6, 2017)

New in NoSQLBooster 3.2.2 (Jan 2, 2017)

New in NoSQLBooster 3.1.3 (Nov 1, 2016)

New in NoSQLBooster 3.1.1 (Oct 10, 2016)

New in NoSQLBooster 3.0.5 (Oct 3, 2016)

New in NoSQLBooster 3.0.4 (Oct 3, 2016)

New in NoSQLBooster 3.0.3 (Oct 3, 2016)

New in NoSQLBooster 3.0.2 (Sep 15, 2016)

Schema Analyzer:
Schema Analyzer is a very useful build-in tool. Due to schema-less feature, collections in MongoDB do not have a schema document to describe field's datatype, collection structure and validations. With our brand new Schema Analyzer Tool, you will get a document to describe the schema of certain collection from sampled(random, first, last) N or all records.
The document shows the probability of sampled objects, different types percentage, you could get a brief of certain collection's schema. If you want more accurate result, you could sample more records or analyze whole collection, but it may took a long time to finish if the collection has millions records or thousands fields.
It also shows document validation of the collection, which is a new feature in MongoDB 3.2. There will be a validator window showing below the document. If you click the link, field will be highlighted in the window.
You could export this document to most popular document file types, like MS Word, PDF, HTML, along with JSON, TXT and CSV. Mongoose.js schema file supported as well.
Test Data Generator:
Create a large collection with random but "real data" is available in Mongobooster 3.0. We now provide more than 100 templates to create random faked "real" data, and you can use this tool to create test data with incredible large size. You could also define how much data is blank too, and how many docs to create. All settings will generate a script in the shell, and you could customize it with more complex business logic.
Test Data Generator:
Import Data from RDBMS:
In case you want to transform a project's database from MySql to MongoDB, or need to import data from 3rd party database., now you could do it through our RDBMS data import tool. We now support MySql, PostgreSql and MSSQL. Like test data generator, you could just config it on UI or write more complex business logic in the shell.
Import Data:
Read-only Status Lock:
You do have full access to a production database, but usually you don't want to change anything by mistaken, you could use the read-only status lock. There are two ways to use it:
Set an entire connection read-only, edit the config make it read-only
Set any tab read-only temporarily, use the lock button on the tab toolbar
You could unlock temporarily of a locked config by using the unlock button too. The temporary lock/unlock only affects current tab.
Your browser does not support the video tag.
Export to SQL file:
We added import RDBMS to MongoDB, on the other hand, we also provide export MongoDB database/collection to .sql file. Supported dialect includes MySql, MSSQL, PostgreSql and Oracle.
New Export/Import/Copy Progression:
Like test data generator and import RDBMS to MongoDB, we put all the export/import/copy logic in the shell, you could review the code to make your changes. The progression is shown in the console.log/print tab.
Auto Refresh on result dataview:
Under the dataview setting menu, a dataview auto refresh setting list is added. Whichever view you use, the dataview will refresh automatically in certain seconds.(Note: if you want to change your shell code, you need to pause the auto refresh which is besides the countdown)
MINOR ENHANCEMENTS:
Transpile to ES5:
Mongobooster's code is written in ES6 as default, but Mongo shell hasn't supported it yet. If you want to use the code we created in that, you could transpile the code to ES5, it's in the context menu of the shell editor(you could find any command using Ctrl(Command)+Shift+P)
Support SSH key format: ECDH and ECDSA
Validator node on connection tree:
Under collection node, a new validator node is added. Document validation is a new feature of MongoDB 3.0, you could double click the node to view it.
Add clear dataview button on the rightest dataview toolbar
BUG FIX AND OTHER IMPROVEMENTS:
Added, show capped:true in collection stats tooltip.
Improved, reduce memory leak
Improved, enlarge editor as default when "Edit Document"
Improved, transform $ to $ when add snippet(favorite script) from shell
Improved, add ordered row number in dataview, e.g. the 2nd page's record number starts with 21 if page size is 20
Fixed, mongotop with locks can choose database
Fixed, adminCommand("top") show duplicated data in tree view(MongoDB 2.6)
Fixed, "Edit Field/Value" dialog opened without focus in editor
Fixed, auto complete shows fields from other collections
Fixed, after add key in "Edit Field/Value", tree view shows wrong data structure
Fixed, not all databases show in mongotop
Fixed, connection tree filter not showing when the window's width is less than 896px
Fixed, in JSON view with mongoexport format, Double show as an empty Object
Fixed, treeview pagination internal issue(somethings after change page size, no record shows)
Fixed, if db's name contains "-", use db not working properly
Fixed, long titles of dialog not show properly
Fixed, after editing favorite, the edited script not selected
Fixed, a rarely happened treeview row cannot be selected issue
Fixed, after dragging some dialog, its height will decrease every time when reopen it

New in NoSQLBooster 2.3.3 (Jul 13, 2016)

New in NoSQLBooster 2.1.2 (Jun 13, 2016)

New in NoSQLBooster 2.0.1 (Jun 2, 2016)

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 1.6.2 (Apr 28, 2016)

New in NoSQLBooster 1.6.1 (Apr 12, 2016)

New in NoSQLBooster 1.5.1 (Mar 25, 2016)

New in NoSQLBooster 1.3.3 (Mar 9, 2016)

New in NoSQLBooster 1.3.2 (Mar 4, 2016)

New in NoSQLBooster 1.3.1 (Feb 27, 2016)

New in NoSQLBooster 1.2.1 (Feb 20, 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".
MongoDump GUI tool
MongoRestore GUI tool
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 1.1.0 (Jan 15, 2016)