I am a big fan and user of python. one of the most popular ways to create quick web app in python is via using mod wsgi. The aim of mod_wsgi is to implement a simple to use Apache module which can host any Python application which supports the Python WSGI interface. The module would be suitable for use in hosting high performance production web sites, as well as your average self managed personal sites running on web hosting services.

I absolutely love SQLite, be it windows, linux or mac, this light weight database never stops to amaze me. Few days ago I wanted to import a chunk of CSV data, which was 4 GB in size into a table in SQLite. I generally use Firefox ’s sqlite-manager plug-in for usual tasks with SQLite database ,hence decided to use the import interface . I have had a very good experience with this GUI tool and it has rarely failed me, but this time I was disappointed.

In this post,I am going to write about OpenShift, which is Red hat’s free, auto-scaling Platform as a Service (PaaS) for applications. OpenShift to me is very similar to Google’s app engine in some ways,but openshift’s offerings are quite diverse, for instance support for ruby, php, Perl, node.js, etc.. Openshift is not like a traditional VPS hosting , although once registered with them, user does get a shell access,but its quite limited , instead OpenShift has a concept of gears and cartridges.

If one has been using python, then installing various libraries and modules is basically a breeze using easy_install utility, however for folks using windows, easy_install utility has to be setup properly before using it. First lets make sure that python is properly installed and PYTHON_HOME environment variable is configured: Install Python on Windows If not already installed download python installer from here. After it’s done downloading, double click to run the installer, and select default options (unless you have other custom needs of course ).