NoSQLBooster 5.0：enhanced connection tree/object explorer

Enhanced data viewer

 

Tooltip for array, object and ObjectId values

How to display the array, object values in the data view is often a bit of a hassle. In V5, we add a more friendly tooltip for the array, object, and ObjectId values.

Tooltip for array and object values

 

One-click Group-By

This handy feature allows grouping of the selected field in query results to calculate counts, totals, minimums, maximums, and averages with a single click.

The following example lists the total number and average weight of unicorns by gender.

 

One-click Group-By

Table view, show object value as a column group

Now, single-level, more straightforward object values are displayed as column groups within the table view. If an object value has many, complex fields, the object value is formatted as JSON text.

Object value as a column group

 

Other notable improvements for the data view

• More copy options, Copy value/key-value pair/document as plain JSON text or Mongo Shell JSON value.
• One-click save query results as MongoDB read-only view, Pop-up right-click menu, Click “Save This Query as MongoDB Read-only View”
• Table view, highlight selected field when view document, When you open the “View Document” dialog within table view, automatically scrolls and highlights to the selected field.
• JSON view, allow view, add, edit and remove document within JSON View.
• JSON view, add a new simple format for JSON view, it will displays all number values as plain text, no more NumberInt(123), NumberLong(“123456789”), NumberDecimal(“1234567.89”)

 

Enhanced script editor

 

Better code snippets

We offer tons of built-in snippets to help you writing MongoDB shell script effectively. In V5, We revised a large number of code snippets, better grouping, easy to find, easy to input. Typically, you only need to enter a few initial letters of the action, and you’ll get the sample template code you need.

• Find, findByObjectId, findTextSearch, findWhereEq, Insert, Update, Delete …
• SQL, SQL-JOIN, SQL-SUM, SQL-IN-SELECT …
• Handy date range snippets, e.g. TodayDateRange, LastNWeeksDateRange, LastNMonthsDateRange …
• Simplify complex MongoDB shell command, e.g. aggregate, createUser, rs.initiate, rs.conf …
• If you come from a SQL background, these handy SQL to MongoDB conversion snippets may give you some help,
• Create your snippets by hitting F8

Code snippets

 

Mark changed lines

The feature lets you see which lines have been changed since the last save operation, the new/modified lines are marked at the left margin.

Mark changed lines

 

Switch MongoDB connection and current database within the editor

Now, you can open and switch MongoDB connection within the editor, and you also can change the current database within the editor. It even allows you to view and run scripts without a database Connection. In this case, NoSQLBooster looks much like an ES2017 playground which integrated Lodash, Shelljs, Moment.js and Node.js runtime.

Switch connection and database

 

List opened tabs

“List Opened Tabs” feature let you list and switch to another tab. It’s handy if you opened a lot of tabs in a window.

List opened tabs

 

Enhanced connection tree/object explorer

 

Open MongoDB shell here

This feature allows you to open a new MongoDB Shell terminal via the context menu of the connection node. This is especially handy for SSH tunnel connections.

Open MongoDB shell here