Skip to main content

Creating a quick Todo listing app on Windows using IIS7, Node.js and Mongodb

As I mentioned in my last post, more and more organizations are leaning towards Web Oriented Architecture (WOA) which are highly scalable. If you were exploring cool, scalable options to build highly performing web applications, you know what Node.js is for.

After following the recent post from Scott Hanselman, I was up and running quickly with Node.js. In this post, I’ll explain step by step how I’ve setup Node.js and Mongodb to create a simple Todo listing application.

Setting up Node.js

This is what I’ve done.

1 – Goto http://nodejs.org/, scroll down and download node.exe for Windows, and place it in your c:\node folder

image

2 – Goto IIS Node project in Git at https://github.com/tjanczuk/iisnode, download the correct ‘retail’ link of IIS Node zip file (I downloaded the already built retail package, otherwise you can download and build from the source).

image

3 – Extract the zip file some where, and run the install.bat or install_iisexpress.bat depending on your IIS Version. If you don’t have IIS installed, try installing IIS 7.5 express here from MS download center.

image

4 – Make sure you have IIS URL rewrite module installed, so that some node.js samples with URL rewriting will work correctly. Install URL Rewrite module if you don’t have it, and restart IIS.

Verifying that all is well

Once Step 3 is over, this will configure the required modules and virtual directories, and you should be able to access the node virtual directory at http://localhost/node – which points to the www folder where you extracted the iisnode zip file.

image

Now, go to the end point http://localhost/node/helloworld/hello.js and see if everything works well. You can also open the hello.js file in the corresponding www\helloworld\ folder to have a look at the node hello world code.

var http = require('http');

http.createServer(function (req, res) {
    res.writeHead(200, {'Content-Type': 'text/plain'});
    res.end('Hello, world! [helloworld sample]');
}).listen(process.env.PORT);  

image

So as we’ve Node.js up and running, let us create a quick Todo listing application using Node.js and Mongodb by modifying this helloworld application.

Setting up Mongodb

Mongodb is a scalable, high performance, document database that goes well with node.js. See http://mongodb.org for more. In Mongodb, records are stored as JSON style documents, and documents are stored in collections. For now, consider that a collection is the NoSQL equivalent of a table, and a document is the NoSQL equivalent of a record.

1- First of all, you may need to install Mongodb. Goto http://www.mongodb.org/downloads, download the correct zip package, and extract it.

2- Create a folder ‘data’ in the path where you extracted Mongodb zip file. See the data folder.

image

3- Now, you should start mongod process. So, open command prompt, CD the folder where you extracted Mongodb, and start Mongod with data as the db folder using the command mongod –dbpath data

4- You should see the mongod process running, as shown below.

image

5- Now, let us insert few records to the todo collection of the database. For that, fire up mongo.exe client from the folder where you extracted the mongo db zip file, and insert few documents to the todo collection as shown below. Please note that

image

So, we have Mongodb running now, with a collection named todo with few documents in it.

Setting up Mongodb Module for Node.js

Normally, setting up packages/modules for Node.js is quite easy, it can be done using the Node package manager http://npmjs.org – How ever, I don’t think an NPM port is available for Windows right now. So, let us configure the Mongodb driver for Node.js manually.

1 – Goto https://github.com/christkv/node-mongodb-native and get the zip package. I downloaded v0.9.3 package, and extract it.

image

2 – Goto the  www\helloworld folder where you examined hello.js earlier. Now, create a folder node_modules under the helloworld folder and create the mongodb folder under this, and copy the contents of the package to the mongodb folder as shown below. It seems that the folder name under node_modules should match the package name defined in index.js.

image

 

Now let us write some code

Once you are through with installing Node.js, Mongodb and Mongodb module for Node.js, it is time to write some code. Fire up the hello.js file in the helloworld folder, and write some code to fetch the todo collection from Mongodb and return it as HTML.

GLOBAL.DEBUG = true;

//Load modules
var http = require('http');
var mongo = require('mongodb');
var sys = require("sys");
var test = require("assert");

var Db = require('mongodb').Db, Connection = require('mongodb').Connection,
  Server = require('mongodb').Server,
  BSON = require('mongodb').BSONNative;

//Default server and port
var host = process.env['MONGO_NODE_DRIVER_HOST'] != null ? 
			process.env['MONGO_NODE_DRIVER_HOST'] : 'localhost';
var port = process.env['MONGO_NODE_DRIVER_PORT'] != null ? 
			process.env['MONGO_NODE_DRIVER_PORT'] : Connection.DEFAULT_PORT;

sys.puts("Connecting to " + host + ":" + port);


http.createServer(function (req, res) {

//Client connected
	res.writeHead(200, {'Content-Type': 'text/html'});    	
	res.write('<html><head><title>Todo List</title></head>');
	res.write('<body>');
	res.write('<h1>Todo list</h1>');
        var db = new Db('test', new Server(host, port, {}), {native_parser:false});
	db.open(function(err, db) {
	db.collection('todo', function(err, collection) {
	collection.find(function (err, cursor){
		res.write('<ul>');
		cursor.each( function (err, item) {                                   
				if (item == null) {
						res.write('</ul>');
						res.end('</body></html>');
						 db.close();
						}
				else 
				 res.write('<li>' + item.title + '</li>');
		});
	});
	});

	});	
}).listen(process.env.PORT);   

You may find that we are opening the database, and iterating through the collection and creating a list out of that and spitting out the html. This should work as long as you followed the steps I briefed above.

image

And yes, you just opened the Pandora’s box – start playing with various Node.js modules and samples on your Windows box. Follow some Node.js tutorials, and experiment further. It is important to note that the Node.js port for Windows is not yet perfect from a production point of view, but now Windows developers have a good way to start exploring options related to node.js and related modules.

And follow me in twitter @ http://twitter.com/amazedsaint for further updates, Keep in touch. Happy Coding!!

Popular posts from this blog

Top 7 Coding Standards & Guideline Documents For C#/.NET Developers

Some time back, I collated a list of 7 Must Read, Free EBooks for .NET Developers, and a lot of people found it useful. So, I thought about putting together a list of Coding Standard guidelines/checklists for .NET /C# developers as well.As you may already know, it is easy to come up with a document - the key is in implementing these standards in your organization, through methods like internal trainings, Peer Reviews, Check in policies, Automated code review tools etc. You can have a look at FxCop and/or StyleCop for automating the review process to some extent, and can customize the rules based on your requirements.Anyway, here is a list of some good Coding Standard Documents. They are useful not just from a review perspective - going through these documents can definitely help you and me to iron out few hidden glitches we might have in the programming portion of our brain. So, here we go, the listing is not in any specific order.1 – IDesign C# Coding StandardsIDesign C# coding stand…

5 Awesome Learning Resources For Programmers (To help you and your kids to grow the geek neurons)

Happy New Year, this is my first post in 2012. I’ll be sharing few awesome learning resources I’ve bookmarked, and will be pointing out some specific computer/programming related courses I've found interesting from these resources.Also, thought about saving this blog post for my kids as well - instead of investing in these Child education schemes (though they are too small as of today, 2 years and 60 days respectively ). Anyway, personally my new year resolution is to see as much videos from this course collections (assuming I can find some free time in between my regular job && changing my babies diapers).1 – Khan AcademyAs I mentioned some time back, you and your kids are missing some thing huge if you havn’t heard about Khan Academy.  It is an awesome learning resource, especially if you want to re-visit your basics in Math, Science etc.With a library of over 2,600 videos covering everything from arithmetic to physics, finance, and history and 268 practice exercises, th…

Hack Raspberry Pi – How To Build Apps In C#, WinForms and ASP.NET Using Mono In Pi

Recently I was doing a bit of R&D related to finding a viable, low cost platform for client nodes. Obviously, I came across Raspberry Pi, and found the same extremely interesting. Now, the missing piece of the puzzle was how to get going using C# and .NET in the Pi. C# is a great language, and there are a lot of C# developers out there in the wild who are interested in the Pi.In this article, I’ll just document my findings so far, and will explain how develop using C# leveraging Mono in a Raspberry Pi. Also, we’ll see how to write few minimal Windows Forms & ASP.NET applications in the Pie as well.Step 1: What is Raspberry Pi?Raspberry Pi is an ARM/Linux box for just ~ $30. It was introduced with a vision to teach basic computer science in schools. How ever, it got a lot of attention from hackers all around the world, as it is an awesome low cost platform to hack and experiment cool ideas as Pi is almost a full fledged computer.  More About R-Pi From Wikipedia.The Raspberry Pi