In this post we are going to manage MongoDB visually. MongoDB has many admin UIs for many platforms, you can visit http://www.mongodb.org/display/DOCS/Admin+UIs to choose your suitable client UI.
We are going to setup one of these admin UI , as we are using windows platform I preferred to use MongoVUE.
Brief about MongoVUE
MongoVUE is an innovative MongoDB desktop application for Windows OS that gives you an elegant and highly usable GUI interface to work with MongoDB. Now there is one less worry in managing your web-scale data.
After installing MongoDB on your machine you noticed that each time you have to run the server mongod shell and it must be running along your work with the database. For a better solution you can run MongoDB as a service behind the seen. First open your cmd and locate your MongoDB directory (for Win 7 run as an administrator) and type :
mongod --logpath d:\mongo\logs\logfilename.log --logappend --dbpath d:\mongo\data --install
lets explain each parameter :
|–logpath||Specify the log file path which will log every transaction on mongo server.|
|–logappend||So that restarts of the service append to the existing log file.|
|–dbpath||Specify the database saving path.|
now you can find MongoDB service installed in your computer services
make sure it’s started and then try to connect by shell without running the mongod again.
Now we have to add a user to admin db so that we can connect from our server client and manage our databases.
every thing is now ready to install MongoVUE.
Download MongoVUE installer from the official website and follow the wizard. Run MongoVUE from start menu.
When you run MongoVUE a window will show you the available connections so you can add/edit/delete connections to the server.
click on the green button to add a new connection, a window appears asking for basic settings.
|Name||Choose any name to save the connection with.|
|Server||the localhost server IP for local connection is 127.0.0.1 otherwise put online address.|
|Port||MongoDB default port is 27017|
|Username||user can authenticate|
|Database||specify database or leave it blank so you can see all databases.|
now you can test your connection and save it.
choose your connection and click connect , now you r running the server.
the left side bar shows the databases.
the admin database which holds the admin users, default system db local , and test db.
Now create new database let’s name it treenodesdb , right click on databases add database.
now you can add collections to treenodesdb , let’s create employees collection , right click on the database and add collection.
To add a document (record) on employees collection , right click on the collection and click insert document , will show dialogue to write the insert statement in BSON form
After adding some records you can see all the records by clicking on View menu.
There are three types of view Tree View, Table View and Text View
This is the simplest actions you can do it on the Admin UI MongoVUE but there are advanced transactions will talk about it later.