A lot of talk these days about NoSQL and particularly MongoDB.  While all signs point to broader adoption of NoSQL technologies in the coming years and a presumed decline in RDBMS technology for net new projects, to paraphrase Mark Twain…the reports of Oracles death have been greatly exaggerated.

So since we all agree that RDBMS and NoSQL (and who knows what else comes along in the near future, looking at you Block chain or something reverse engineered from UFO technology) will work side by side for years to come, it’s a great time to show you what we’ve been working on in Toad to support MongoDB

Fortunately for our users, there is a lot of content to share, so the best way is to break it out into a ‘Top 10 MongoDB features in Toad’ blog series. Keep checking back in, this is pretty cool and useful stuff as you explore what MongoDB can do that RDBMS can and can’t!

First feature is the familiar Toad-like UI.  This eases the transition to NoSQL for folks familiar with RDBMS and SQL.  In this example, I’ll create a connection and select a MongoDB collection.  In figure 1 below I’ve selected the ‘contacts’ collection (Get the Sakila sample schema for MongoDB here).  Immediately you get summary details of schema (tree view, object metadata, Quick Doc, Outline) that can often extremely complex and hard to interpret without a good tool like Toad.

1.png

Let’s drill down into each area in detail.  Again, with the ‘contacts’ collection selected, at a glance I am and am able to see important metadata about the collection including…

  • Doc Summary – The ‘contacts’ collection contains 599 documents and 11 GB of pre-allocated space for the data

1.1.png

  • Grid View of JSON Data (and JSON view to be discussed later) to provide insights into the underlying data)

1.2.png

  • Outline View does lots of things, but to introduce it, The previously mentioned Grid view shows column names on the x axis, and if the field names are wide, I am able to view the same column names in the Outline Tab displayed on they Y axis allowing me new insights into ‘width’ of collection as well as depth of nesting among fields only visible when shown with column names on a Y axis:

1.4

  • The Quick Doc view gives me all of the metadata associated with the selected collection (same as running db.<collectionName>.stats() in MongoDB shell), but the metadata is provided at a glance without actually running the query!

1.5

So, our first step into a larger world, pretty exciting!  If you’d like to learn more, check out our product pages to download trial version of Toad Extension for Eclipse if you are a Java user, and Toad Mac Edition for folks on Mac OS X that are interested in MongoDB.