Why Choose NoSQLBooster for MongoDB?

MongoDB Script Debugger
Still debugging your MongoDB script with  print  statements? Now, you can use NoSQLBooster's built-in debugging capabilities to set breakpoints and step through code.

To start debugging, click the editor's text margin to set a breakpoint  F9 , and run with debugger  F5 . When your breakpoint is hit, you can explore the call stack, watch and edit variables, and interact directly with the debugger.

True IntelliSense
NoSQLBooster for MongoDB offers true IntelliSense experience. The built-in language service knows all possible completions, methods, properties, variables, keywords, even the MongoDB collection names, field names, and operators. The IntelliSense suggestions pop up as you type. You can always manually trigger it with  Ctrl-Shift-Space . Out of the box,  Ctrl-Space ,  Alt-Space  are acceptable triggers.

• In the script editor, parameter hints pop up as you're typing a method invocation.
• We offer tons of built-in snippets, Handy date range snippets, SQL to MongoDB conversion snippets...
• The mouse hover show much useful information, such as types of symbols, function definition, type information, and document.
• Matching brackets is highlighted as soon as the cursor is near one of them.

Query MongoDB with SQL
With NoSQLBooster for MongoDB, you can run SQL SELECT Query against MongoDB. SQL support includes SQL JOINS, 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

You can query MongoDB by using old SQL, which you probably already know.

SQL Query Features

• Access data via SQL including WHERE filters, ORDER BY, GROUP BY, HAVING, DISTINCT, LIMIT
• SQL Functions (COUNT, SUM, MAX, MIN, AVG)
• Date, String, Conversion Functions (dateToString, toUpper, split, substr...)
• Aggregation Pipeline Operators as SQL Functions
• SQL Equi JOIN and uncorrelated sub-queries
• Provide a programming interface (mb.runSQLQuery) that can be integrated into your script
• Autocomplete for keywords, MongoDB collection names, field names, and SQL functions

Please note that MongoDB does not natively support SQL features. The SQL query is validated and translated into a MongoDB query and executed by NoSQLBooster for MongoDB. The Equivalent MongoDB Query can be viewed in the console.log tab.

Monitor and Tune for Performance
NoSQLBooster provides rich performance monitoring and analysis tools to help you keep your MongoDB environment running smoothly.

• Visual Explain Plan, transforms explain output into a hierarchical view, allowing for query tuning to enhance query and resolve performance issues.
• Server Real-Time Status (mongostat), view MongoDB real-time performance metrics as a chart or tabular form.
• In-progress Operations Viewer, find and kill long-running MongoDB operations quickly.
• MongoDB Log Parser, easier to parse, filter, and analyze MongoDB log information.
• Database Profiler, collects detailed information about Database Commands executed against a running mongod instance.
• GUI for mongotop, tracks the time required to read and write operations thoroughly.
• Troubleshoot Replica Sets

The following is a screenshot of Visual Explain, Click here to learn more about NoSQLBooster Performance Monitoring Tools.

Learn MongoDB with Free Interactive Samples
The "My Queries" tab is used to open user-saved query scripts quickly. By default, the user-saved query script is saved as a "connection -> database -> query name" directory structure. Double-click to open a saved query script will automatically connect to the appropriate database server and switch to the proper database.

The "Samples" tab includes several NoSQLBooster-Enabled tutorials. All samples are executable in NoSQLBooster already, with detailed descriptions. You can try these queries and change them to learn better.

Chaining Fluent MongoDB Query
NoSQLBooster for MongoDB supports mongoose-like fluent query builder API. A Query 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.

Shell Extensions, Using Node Modules, Lodash, Momentjs in Your Script
NoSQLBooster for MongoDB is an electron-powered desktop application that bundles Node.js and Chromium runtime. You can use any Node.js build-in global objects and modules (console, util, fs, path ...) and pure JS NPM packages in NoSQLBooster for MongoDB. It also adds mongoose-like fluent API, provides mb.runSQLQuery function, integrates a few utility modules (lodash, moment, bluebird, shelljs, mathjs) to global scope to make the life inside of the MongoDB script a little bit easier.

Here's how to install and use the npm package.

Launch NoSQLBooster for MongoDB. - Execute Main Menu -> Help -> Open User Data Directory - New Terminal at this folder

After successfully installing this package in the NoSQLBooster for MongoDB User Data Directory, you can require and access it in the NoSQLBooster for MongoDB script.

The following figure shows the use of lodash and Moment.js directly in mongodb shell scripts.

 完整比較表 可點擊此觀看  

Brief summary

• NoSQLBooster for MongoDB Free is free for personal/commercial use but with limited functions after 30 days trial expired.
• Personal licenses do not support Kerberos(GSSAPI) and LDAP(PLAIN) authentication, cannot run tasks in CLI, have no task scheduling, and cannot convert MongoDB query code to target languages, e.g., Java, c#, Python...
• There are no functional restrictions with the commercial, team, site, or corporate license.

 完整比較表 可點擊此觀看  

Mac OS X   OS X 10.8 and above

Windows   Windows 7 and above