Using SQLFiddle

Hi Guys, this is my second blog post of this month. The title is “Using SQLFiddle”. In this post I am going to explain about a very useful online tool SQLFiddle which I have been using for a while. As JSFiddle is used to run and test CSS, JQuery etc, using...

Setup node.js mongodb Development Environment on Ubuntu

Below are the step to setup the development environment of node.js using Mongodb: Open terminal and add the repo executing follwing command on console  sudo add-apt-repository ppa:chris-lea/node.js Execute sudo apt-get update Execute sudo apt-get install nodejs Once...

How to create MongoDB indexes ?

In simple words “indexes are used to speed up query performance”. Let’s say you have a query which takes around 120ms to execute without indexes i can assure you that with proper indexes you can reduce that time by at least 10 times. Let me show you...

How to delete MongoDB document ?

In this blog post i am going to explain how to delete MongoDB document. The are few ways which are illustrated below : If we execute remove on collection without any params then it will delete all records db.users.remove({}) // it will delete all documents along with...

How to drop a field from a MongoDb document ?

In this blog post we are going to see how to drop a field from a MongoDb document ? For people coming from RDBMS you must be remembering the alter table command for dropping/adding columns in a table. In MongoDB it is possible to do this operation on some of the...

Updating multiple documents in MongoDB

In this blog post we are going to learn the process of updating multiple documents in MongoDB. MongoDB provides us with update() function to achieve the same. Here are few use cases : db.users.find(); { "_id" : ObjectId("537da62d770359c2fb4668e2"),...

MongoDB : Difference between save and insert

MongoDB uses save and insert option for adding new records in the database. Let me explain the difference between two : Insert : insert is used to add a document in a mongodb collection Save : save is used to add as well as update a document in a mongodb collection....