Varun's Weblog

A short post which explains Importing and exporting CSV to or from a postgreSQL server, and highlights common errors ,their fixes and work arounds.

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

In this tutorial ,I intend to introduce basics of this library and help you get started.

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.

Generally, when I am in  a middle of prototyping a concept or in a need of quickly executing Ajax requests or using browser features which would  need the page to be hosted on a web server, I use Python's SimpleHTTPServer module.

I love JavaScript and code a lot in it .Since I code, I also encounter problems and bugs from time to time and therefore need a Debugger and a debug mechanism to view whats going on.

In good old days when I learned this language, I used JavaScript's inbuilt alert mechanism to view the value of a variable or a property of an object. This was a terrible mechanism, calling alert was blocking, one had to press OK to continue and if you had to take a look inside an array then well it was emotionally an overwhelming task is all I would say here.

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.

When I first started web programming, creating a center aligned div was one of the most common task that I saw myself doing.

since div is a block element, i.e. it takes up the full width available, and has a line break before and after it, it can easily be centered using relative styling

Cassandra is an Open Source Distributed Data Persistence system which is designed for storing and managing large amounts of data across servers.

To quote elevator pitch by Eben Hewitt

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.