Varun's Weblog

Importing data into a database from a delimited file is perhaps one of the most common tasks that one might have to perform. SQL server gives us an imported utility which supports various data sources and has an intutive interface as well,however there is another utility which can be utilized to quickly get the job done, its called BULK INSERT

I am a big fan and user of python. one of the most popular ways to create quick web aps 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.

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.

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.

This is a quick port of auto complete implementation in ruby using Redis by antirez.

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.

Once done lets quickly setup a PYTHON_HOME environment variable which points to the python directory which contains python exe in my case its c:/Python27, to set up environment variable right click "My Computer " select "properties", "Advanced Tab" "Environment Variables" Button, add new environment variable and call it “PYTHON_HOME” and set path to whatever is in your case, to make sure every thing is proper ,open NEW dos prompt and type echo            %PYTHON_HOME% and you should see the path you have entered.

This post is basically a way of quick appreciation to the Google maps Team, they are   obviously a bunch of caring, loving people ,who make small (although surreptitious  ) tools for the betterment of Geek Kind.

I had been hosting this blog in the past  for an extremely competitive (read cheap) price here at Arvixe . I was using ASP.net based blogging software called BlogEngine. over and all I will describe my experience as pleasant. Arvixe is a great Hosting Provider, has good up time and has plans which are easy on the pocket, and does almost all the common stuff like emails and cpanel ,blah blah that other hosting provider do, but kinda does it on a low price. I was a happy blogger for an year although I could only manage close to 8 post and and few demos in that time.

After reading an excellent article by Kazi Manzur Rashid on setting up a development environment for Iron Ruby using Notepad++ , I was immediately struck with an idea of using the same excellent tool with Python 2.6.