Tip 1: Importing DBF Files
shp2pgsql command is mainly to import shapefiles. However, it does come with an optional parameter -n that allows to import dbf files. You might need to install postgis in order to have shp2pgsql command.
> shp2pgsql -n filename > outfile.sql
> pgsql -h hostname -U username -d database -f outfile.sql
The above two commands [...]
Filed under: General | Leave a Comment »
Shell scripting is a powerful way to automate things. However, writing a shell script to automate interactive shell commands can be tricky. For instance, I weekly download log files from the server to my local machine. For this, I use scp command. While I had written shell script to automate this process, it wasn’t really [...]
Filed under: General | 3 Comments »
17th June 2009
In an unfortunate event of mugging and assault, I severely damaged my left knee.There are four ligaments in and around a knee: ACL, PCL, MCL, and FCL. ACL and PCL corss each other and are at the center of the knee. They help prevent excessive forward and backward movement of the knee. MCL and FCL are [...]
Filed under: General | Tagged: acl reconstruction, Health, Knee, Orthopedic, surgery | 3 Comments »
Wow, finally got my Internet connection started. I have been waiting for it for quite sometime, as I wanted to share my ‘Urban Shock’ experience.
Image Source: Amazon
was modified by the author
Last month was terrible as I moved from State College, a small university town and home of Nittany Lion and Joe Paterno, to Bay Area [...]
Filed under: General | Tagged: Urban Shock | 1 Comment »
One of the challenges in developing ajax application using CakePHP is to figure out how to load ajax view (interface) for first time and request only data (json or XML) in subsequent ajax calls. Luckily, with CakePHP this is simple and you really don’t need to write many different functions. The trick is to use [...]
Filed under: CakePHP, General | Tagged: Ajax, CakePHP | 4 Comments »
ragrawal