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