So happy to release MongoBooster 3.5 today. This version distributes Linux application in the AppImage format, add Azure DocumentDB support along with some useful minor improvements and bugfix.

Hotfix in MongoBooster 3.5.7

• improved: SSH connection config UI
• fixed: a "use db" bug in copying collection
• fixed: missing "," issue when exporting collection to MySQL as SQL format
• fixed: throw subCollection.getCollection is not a function error while executing script "db.getCollection("xxxx.group.xxxx").find({})"
• fixed: A Javascript JSON.parse error occurred in the main process while reading "window-state-main.json"
• fixed: connection close issue when calling discoverReplicaSet

Hotfix in MongoBooster 3.5.6

• 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

Hotfix in MongoBooster 3.5.5

• 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.

Hotfix in MongoBooster 3.5.4

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

Hotfix in MongoBooster 3.5.3

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

Hotfix in MongoBooster 3.5.2

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

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

1

$ chmod a+x mongobooster*.AppImage

and run!

Read More

So happy to release MongoBooster 3.3 today. 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.

For example:

Run the following Fluent query script in MongoBooster:

1
2
3
4
5
6

db.user.where('age').gte(18).lte(65)
       .select('name age -_id')
       .sort("-age name")
       .limit(5)
       .skip(100)
       .getShellScript()

We got the following MongoDB shell find script

1
2
3
4
5
6
7
8
9
10
11
12
13

db.user.find({
            "age" : {
                "$gte" : 18,
                "$lte" : 65
            }
        }, {
            "name" : 1,
            "age" : 1,
            "_id" : 0
        })
       .sort({  "age" : -1,  "name" : 1 })
       .limit(5)
       .skip(100)

Read More

We're so proud to release Mongobooster 3.2 today. This version includes official support for MongoDB 3.4 along with some useful minor improvements and bugfix. For more information on MongoDB 3.4 , see Release Notes for MongoDB 3.4.

Hotfix in MongoBooster 3.2.3

• 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

Hotfix in MongoBooster 3.2.2

• Fixed: missing edit icon in the dark theme
• Fixed: windows freezes or stops responding when SSH connection lost (Windows platform only)

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.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

db.employees.aggregate()
      .graphLookup({
         from: "employees",
         startWith: "$reportsTo",
         connectFromField: "reportsTo",
         connectToField: "name",
         as: "reportingHierarchy"
      })
db.artwork.aggregate()
     .bucketAuto({
         groupBy: "$price",
         buckets: 4
     })
db.scores.aggregate()
    .addFields({
       totalHomework: { $sum: "$homework" } ,
       totalQuiz: { $sum: "$quiz" }
     })
    .addFields({ totalScore:
       { $add: [ "$totalHomework", "$totalQuiz", "$extraCredit" ] } 
   })
db.exhibits.aggregate().unwind("$tags").sortByCount("$tags")
db.people.aggregate()
   .match(qb.where("pets").exists(true))
   .replaceRoot("$pets")
db.scores.aggregate()
      .match(qb.where("score").gt(80))
      .$count("passing_scores")////why not count? MongoBooster already has a method called count which return number

Read More

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 bugfix.

Hotfix in MongoBooster 3.1.5

• 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

Hotfix in MongoBooster 3.1.3

• Changed, In order to keep the behavior consistent with mongodb shell, MongoBooster will insert/update number as double type.

1
2
3

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: int32,   b: int32,   c:double, d: int32,  e:double
//now   (>=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

Hotfix in MongoBooster 3.1.2

• 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.

what's new in MongoBooster 3.1

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.

Read More

We're so proud to release Mongobooster 3.0 today. In this brand new version, it gets more and more useful with our full-featured shell and several new tools.

New free edition added with Mongobooster 3.0, this free edition is free for personal/commercial use but limited function.

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. Sample file

Read More

Today, we're thrilled to announce the release of MongoBooster 2.3. This release includes significantly improved console.log/print tab, JSON view format options, bug fixes and a few minor improvements.

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.

Read More

Today, we're happy to announce the release of MongoBooster 2.2. 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.

Read More

It's time to update MongoBooster again :) This is a smaller update in terms of raw added features – but this release includes better Quick Find, bug Fixes and a few minor improvements.

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. In this release, there are a few minor improvements for Quick Find with connection tree.

• add a close "x" button in the right corner of the Quick-find input box.

• Press "Mod+F" will focus to input-box rather than closing it.

• Press "ESC" will close Quick-find input box and focus to connection instead of focusing script editor.

  

Read More

Today, we're happy to announce the release of MongoBooster 2.1. 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.

Although we are showing screenshots of MongoBooster for Mac OS X all these new features are available for Windows,and Linux as well.

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.

Read More

Today, we're thrilled to announce the release of MongoBooster 2.0. 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.

Although we are showing screenshots of MongoBooster for Windows, all these new features are available for Mac OS X and Linux as well.

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.

Read More About It

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

// instead of writing:
db.user.find({age:{$gte:18,$lte:65}},{name,1,age:1,_id:-1}).sort({age:-1, name:1});
// we can write:
db.user.where('age').gte(18).lte(65).select('name age -_id').sort("-age name");
    // passing query conditions is permitted too
db.collection.find().where({ name: 'mongobooster' })
// chaining
db.collection
    .where('age').gte(18).lte(65)
    .where({ 'name': /^mongobooster/i })
    .where('friends').slice(10)
// aggregation
db.companies.aggregate(qb.where('founded_year').gte(2000).lte(2010)) //qb:querybuilder
  .group({_id:"$category_code",count:{$sum:1}})
  .sort('-count')
  .limit(100)

Read More