A Simple MongooseJs Example

As my latest coding adventure I've decided to give node.js a try.  I read this short little tutorial name the Node Beginner Book.  I went through the entire book in one day.  The book provided me with enough knowledge to be able to produce simple website.   The good accomplished its goal but it did not cover database communications.  I can't think of any business application that does not communicate with some sort of database for storage.

 
I'd heard that a good choice for using for storage with node.js is MongoDb.  Being that I am totally unfamiliar with MongoDb I did a quick google search and found a driver that can be used to connect node source code to MongoDb.  That driver is called mongoosejs.

 
So now that I knew all the components to have a database with node I decided to try to connect all the pieces together.  I gotta say that it was not easy for various reasons.  The mongoosejs site was inadequate for me.  It may be totally appropriate for someone who knows the ins and outs of MongoDb, who knows, but for me it was difficult trying to save data and then reading it from their API documentaion.

 
Another quick google search and it lead me to this video on using mongoose.  That video was quite helpful and it allowed me to see what I was doing wrong.  It allowed me to see that besides installing the mongoose package I needed to install MongoDb, create a database and run it, duh!  How else can you run MongoDb without actually running it.

 
I am going to list the things that got this demo working and show the entire source code.

 
Here is a list of the things that I finally did right

 
1. Install MongoDb - to do this visit Mongo's Website download the appropriate version and install it.  On windows you must also set your PATH variable to point to the bin location for MongoDb.  In my case I had to add C:\Program Files (x86)\mongodb-win32-i386-2.0.6\bin to the PATH variable.  MongoDb downloads as a zip file so you can unzip it and drop it anywhere you want.

 
2. Installed the mongoose package - to do this visit the mongoose website for information on how to do that.  One thing I will note is that I installed the package in my original node location. Previously I tried doing this and installed the package in my projects root directory and had problems.  To install the package just make sure to open the command line console and navigate to the location where you originally installed node. In my case that is C:\Program Files (x86)\nodejs.  This will drop the package at the following location C:\Program Files (x86)\nodejs\node_modules\mongoose.

 
3. Run MongoDb.  To do this run the command  mongod -dbpath ./data/ (make sure to create the data directory first though).  This will create a database in wherever folder you are in the command line.  Once you do that you are up and running.

 
The example below is all you need to get a picture of what it takes to connect to the database, save some data.  Then later in the display it fetches that data.  Like I said this is the simplest example I could come up with to get me talking to the database.  Once you do that you can move on to real world scenarios like actually receiving data from user input and displaying in grids, possibly editing the data as well.

  I will do my best to give a short and quick description of what is going on in the code snippet above. I also plan to push the entire source up to https://github.com/fernandozamoraj so please look up there for the full running demo.

To run the full demo you must first startup the application by typing node index.js at the command line. Then just type http://localhost:8877/save and then http://localhost:8877/display. The first URL is to save the data and the second is to display it to the console. It does not display it to the browser so be warned.

The save function does the following :

  1. Connects to a database
  2. Creates a schema for the TodoModel
  3. Creates and item of the TodoModel
  4. Saves the item
  5. Disconnects from the database

The display function does the following:

  1. Connects to the database
  2. Creates a schema for the TodoModel - Not sure why we have to create it each time
  3. Queries the database by the key
  4. Displays the entire document to the console
  5. Displays the documents attributes: key, item, description
  6. Disconnects from the database

There you have it. If you have any questions please feel free to leave me a comment.

Comments

Decor said…
Really helpful thanks!
August 14, 2012 at 5:52 AM
Post a Comment

Popular posts from this blog

Putting Files on the Rackspace File Cloud

Recently, I’ve been playing around with Asp.Net MVC and I (along with some friends) am creating an Asp.Net MVC application that can access files from our website. This means that files must display on the site as well as provide a way to download/upload them. I won’t give away all the details of the project but I will say this: Sharing photos is one of the driving forces for our project.  The files are only image type files( jpg, etc) The files must be uploaded by the users and stored somewhere within our system.  We don’t necessarily know at this time how much storage space we need but we think that we will need a little at first but possibly a lot more down the road. This means that the storage of these files must be scalable. The uploading of files must be controlled by our system.  Right off the bat we started our application and were uploading files to the web server with no problem.  We only did it this way to kind of prove our system model. We were just basically writing
Read more

Simple Example of Using Pipes with C#

Image
So I decided to dig into understanding how Asp.net works under the hood, out of curiosity.  In the articles that I found the authors described the architecture in lower level details.  One of the things that caught my eyes was the use of named Pipes as a means of inter-process communications by the architecture.   So I decided to dig into that portion a little bit deeper.  I discovered that the .Net framework has a namespace for named pipes and it's quite easy to use. I intend to demonstrate a small example that I cooked up rather quickly by setting up a named pipe server and then connecting a pipe client to it.  Before I do that, I want to say as a disclaimer that I don't know that this example demonstrates the best way to use pipes.  What it does do is show the most straightforward way to use them.  Also, before you use pipes you should consider using something else like WCF instead if you need well defined interfaces, as using pipes is pretty raw.   Being the type of perso
Read more

Why I Hate Regular Expressions

I have a love-hate relationship with regular expressions.  I admire their power yet I hate the pain and agony they have caused on more than one occasion. Just recently one of my colleagues used a regular expression for validating passwords. It seems pretty fair to use regular expressions for validating character sequence patterns. After all it seems they were created exactly for that.  However when regular expressions fail they fail hard.  What I mean by that is that they usually fail in the production environment. In case you are wondering what a regular expression is take a look at the wikipedia explanation of regular expressions . So we go live and all of a sudden new users can't be created because the regular expression says that the password is not valid due to one of the complexity rules.  But how?  The regular expression passed all the unit tests.  In fact the application works fine in our development and test deployment.  So what happened? The validation works fine unti
Read more