MongoDB JQuery Browser using JQueryFiletree running on Sinatra.

This application allows you to browse your Mongo database in hierarchical tree view. This makes it easy to quickly glance over all the databases, collections and open individual documents. By default the last 20 inserted documents are shown from each collection.

This application doesn't try to be a complete MongoDB Manager, it's just a simple fast easy browser! It is also a good example of using Sinatra and JQueryFiletree.

It can browse:

• databases
• collections
• objects in collection (the _id's of the last 20 greatest _id's are shown by default)
• fields

The values refesh everytime you open the folder. So if you collection is updated, if you close and repoen the folder the updates will be seen.

Installation

This Is is a standalone project, and doesn't really require anything much except sinatra. It runs with Ruby > 1.9.2 and Sinatra.

gem install mongo
gem install sinatra

Open up the config.ru file and set the database configuration parameters

 set :mongo_connection, 'localhost'

Running

rackup config.ru

Notes

Browsing mongo is harder than I expected!

Most Web based UI's don't handle all the fun things that can happen with naming datbaases, collections, and fields. See the screenshot for some examples.

The basic idea is that the path can be like below (but it is actually more complicated):

/
/database_name/
/database_name/collection/
/database_name/collection/_id
/database_name/collection/_id/field

This is a bit convoluted but here goes: JQueryFiletree requires '/' as the delimiter. So mongo has some issues with this.

• database names can't have / so we are ok there
• collection names can have '/', but not $, so we use the $ to escape the /'s in the collection name
• The _id can be String or BSON::ObjectId which is stripped by to_s, so I added an extra path $String or $BSON::ObjectId
  • The _id is assumed to be everything after the type match (which is the 4th '/')
• Finally the field_name can have everything except '.' in it's name so I surround it with '.''s
  • then take /1/2/3/type_of_id/this is the _id/.key.
  • take 4 slashes down to get start of _id
  • work updwards removing the .key.
  • all you got left is the id. wheh

Tests