What is new in Studio 3T 5.0

Studio 3T is the new name of MongoChef and we are more excited than ever to announce the major release of Studio 3T 5.0.

In this release we focused on improving the experience for those that are discovering Studio 3T and downloading it for the first time. Of course, we also added plenty of improvements and new features to the application as well. For example, we introduced an important fix for the SSH connectivity (that will vastly improve the connection set-up speed for many users). You can now also import CSV directly from the clipboard and export selected documents via mongodump. With these updates, Studio 3T is not only getting better but also expanding the visibility over its rich set of tools and features.

A few words about the name change

Studio 3T is becoming more than a simple GUI. It is now a mature product which has become the most popular commercial IDE for MongoDB. We needed a bigger, roomier name to do justice to the growing capacity of the studio with each new release and this new name is Studio 3T. Visit this page to know more.

What changes in the download experience?

Everything is now in one app. Starting with Studio 3T 5.0, you no longer need to worry about making sure that you download the correct file corresponding to the right app edition (i.e. Core, Pro, Enterprise). While we used to have dedicated apps for each edition, we have now unified all editions under one download package. It is now the license key within the app that decides which tools and features are enabled and which ones require an upgrade.

We believe this is going to make things much easier for those discovering Studio 3T for the first time. Also, it is going to be much easier to move between various editions of Studio 3T as your needs grow over time. Please contact us if you are interested in our upgrade program. We will be happy to assist you in transitioning to one of our premium-feature software packages.

What is new in MongoChef 4.5

We are immensely excited to announce the release of MongoChef 4.5!

This is one of our largest releases ever. We would like to explicitly thank you, our users, for your plentiful feedback and feature suggestions that continue to make MongoChef so much better.

MongoChef 4.5 is chock-full of new features and improvements:

  • Full MongoDB 3.4 Compatibility
  • MongoDB Export to SQL
  • Improved Connections Tree
  • Integration of mongodump and mongorestore for Easy Backups

to name but the most high-level ones.

Full MongoDB 3.4 Compatibility

MongoDB 3.4 has brought many new high-level features such as read-only views, collation documents, and new aggregation operators. MongoChef 4.5 adds full support for these features.

Read-Only Views

MongoChef makes it super-easy to create MongoDB read-only views with its industry-leading aggregation builder. Build and debug your view with ease and then store it as a read-only view with just a click of your mouse.

mongodb create view

Collation Support

With MongoDB 3.4, you can now provide a collation document to specify language-specific rules for string comparison, such as rules for letter case and accent marks. MongoChef 4.5 allows you to specify a collation when you’re creating a collection, view, or an index and also when building an aggregation pipeline – and, naturally, wherever applicable in IntelliShell.

mongodb collation support

New Aggregation Operators

MongoDB 3.4 has also brought a number of new aggregation operators ($bucket, $bucketAuto, $facet, $graphLookup, $sortByCount). Of course, both MongoChef’s aggregation builder and IntelliShell have you covered here.

Export Your MongoDB Data to SQL

MongoChef Pro and Enterprise now let you export your MongoDB data directly to SQL and support the major SQL dialects: Oracle, MS SQL Server, MySQL, and PostgreSQL. Select your MongoDB data source and export to a SQL file that can then be safely imported into your SQL deployment.

1) Choose your SQL format options:

mongodb sql export options

2) MongoChef runs schema discovery on your MongoDB data to auto-select the most appropriate SQL target data types. You can of course also manually overwrite the mapping.

mongodb sql export mapping

3) View the resulting SQL file and safely import your MongoDB data into your SQL deployment.

mongodb sql file

Improved Connection Tree

We have introduced new meta-levels below the database level to make it even more comfortable to manage your various collections, views, system collections, and GridFS buckets.

connection tree metalevels

 

Integration of mongodump and mongorestore for Easy Backups

MongoChef now integrates with the mongodump and mongorestore backup and restore tools. You can now directly export (and of course import) your databases, collections or your query results to BSON folders or BSON archive files directly from within MongoChef. Backing up your data with MongoChef has never been easier.

1) Choose mongodump as export format:

export format mongodump

2) Configure your mongodump options:

mongodump configuration

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.4

MongoChef has just gotten even better! We are very pleased to announce that MongoChef 4.4 has been released!

For this release, we have particularly focussed on improving the overall user experience of MongoChef even further. Thanks a lot for all those suggestions!

Undocking tabs

Loads of you have requested this. And yes, this is a great productivity booster! You can now easily undock (and re-dock) any tab by just dragging the tab and dropping it off in a new location. Undocking tabs is especially useful in situations where you e.g. want to compare results or move a certain tab to a second monitor.

Filter connections

Over time, your connection list will likely grow to a substantial size. In order to quickly find a certain connection, we have added a filter box to the connection manager. As you type, it will show only those connections that match your input. MongoChef will search all relevant connection fields (name, database, connection type, etc):

mongochef connection filter

Read-only JSON document viewer

This is a seemingly minor addition to MongoChef – after all MongoChef has always had a full-blown JSON document editor. Nonetheless, this a very useful new feature, and an oft-requested one, as it will prevent you from inadvertently making changes to a document when just viewing it.

mongodb-json-document-viewer

Dark editor theme

We have implemented another very popular feature request: make the background of the editors in MongoChef dark. And, so, here it is (you can set it in the Preferences):

mongochef dark editor theme

We will be further fine-tuning this over the next iterations. So, please send us your feedback :-)

Import empty CSV fields as empty strings

We have added an option to our CSV import. You can now specify to import empty CSV fields as empty strings.

mongodb csv import empty strings

 

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.3.0

We have just released MongoChef 4.3.0!

This release brings many improvements and new features you have asked for, for example:

Schema Documentation

You can now generate beautiful schema documentation for MS Word:

mobgodb schema documentation

 

mongodb schema documentation word overview

 

mongodb schema documentation word

 

Explore documents missing a certain field

When you spot a field in the schema explorer that does not occur in all documents, you can now easily explore the documents that do not have that field.

mongodb schema discovery explore missing field

 

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What is new in MongoChef 4.2.0

Today we are very excited to announce that we have just released MongoChef 4.2.0!

This release brings many improvements and new features you have asked for, for example:

Improved SSH/SSL support

We have significantly expanded our SSH/SSL support. We now support most ciphers, key exchange protocols, message authentication codes (MACs) as well as DER-encoded private keys.

Option to remove a field from matching documents

When you select a field in document and you choose to remove the field, you can now also specify in the ensuing dialog to remove the field only from those fields matching the current query.
remove field from matching documents

Parse “connect-to” database from connection URI

When connecting to the mongo shell, one can pass the shell a connection URI in the following form

mongodb://user:pwd@host:port/my_db?authSource=admin

which will connect the user (who is defined in database “admin”) directly to the database “my_db”. This concept of course doesn’t directly translate to MongoChef where you see all available databases at once. MongoChef will now parse that connect-to database directly from the URI and add it to the list of manually defined visible databases for the user:

mongodb connection uri

mongodb manual database list

Save binary blob field to file

We have added an option directly to a binary field’s pop-up menu to save the binary blob to file (and to load from a file into the field).

save mongodb binary field to file

Scan entire collection for all fields for CSV export

When exporting documents to CSV, MongoChef by default scans only a subset of documents (usually the documents currently showing in the query result) for field names to suggest as CSV column names. Due to the schema-less nature of MongoDB, this could miss desired fields that in the past had to then be added manually. Now, MongoChef offers a new option to force a scan of the entire collection – which will continuously update the field name list as they are discovered.

Discover all fields for CSV export

Quick feedback when two compared collections are identical

We have added quick and obvious visual feedback to show the user in case the source and target collection during a comparison analysis were found to be identical.

Compare MongoDB collections - identical

Wait, there’s more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What’s new in MongoChef 4.1.1

Today we are very excited to announce that we have just released MongoChef 4.1.1!

This release brings many improvements and new features you have asked for, for example:

Disabling of aggregation pipeline stages

In the aggregation tab, it is now super-easy to disable certain stages temporarily from your aggregation pipeline. This is a very convenient feature when debugging complex aggregations.

MongoDB disable aggregation stage

Paging through collection statistics

We have added paging to the “Collection Statistics” tab of a database – in case you have many, many collections in your database.

mongodb collection statistics

Wait, there is more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.

 

What’s new in MongoChef 4.1.0

Great news everyone! Today, we just released MongoChef 4.1.0!

This release brings many improvements and new features you have asked for, for example:

Refresh GridFS view automatically after sort-by option selection has changed

Previously, when you changed the sort-by option in your GridFS view, seemingly nothing would happen – because MongoChef waited for an explicit, user-triggered refresh of the view for the new sort-by option to take effect. This was of course a bit silly – as many of you rightly pointed out to us. So, with this new release, that’s all gone and the GridFS view is automatically refreshed after you change your sort-by option.
GridFS auto refresh sort

Improved UTF-8 handling

IntelliShell now uses UTF-8 consistently through-out and we fixed an issue around loading persisted aggregation queries.

Wait, there is more!

See our full change log http://downloads.3t.io/mongochef-pro/changelog.txt for all the details.