Blog

How to import data from a CSV file into a PostgreSQL database

April 19, 2011

I was working on my personal project last week and needed to import some data in CSV format to a PostgreSQL database. I wanted only certain fields to be imported so I had to specify this in the command. I’m new to PostgreSQL so it took me quite a bit of Googling to figure out exactly how to do this.

Here’s how I did it on Ubuntu 10.04 LTS, ‘glucosetracker’ is the name of my …

PyCon 2011 Atlanta

March 31, 2011

We attended the PyCon 2011 in Atlanta, GA early this month, which is the longest conference I’ve ever attended (March 9-17, 9 days total) but it was so worth it! We’re mainly a Java shop and we’re fairly new to Python so PyCon really showed us what we can do with Python and all these tools available for it that could really help us with our development. After the conference we’re pretty much convinced that …

How to log to multiple log files with log4j

March 6, 2011

Back to Java coding!

We have a Java application that calls an external application and since it gets called quite often we figured we should probably log its standard output and standard error streams to a separate log file so we could easily locate issues with it later. This would also allow us to create a different message format for it and different handlers.

Luckily, it turned out that this is pretty easy to do …

How to recalibrate your Dell Streak’s touchscreen

February 21, 2011

A few days ago I was trying to unlock the screen on my Dell Streak and I was having a hard time dragging the lock icon, it wouldn’t go all the way through and not responding well. I thought my Dell Streak was busy at first, maybe a process was using up a lot of resources in the background, but when I was finally able to drag it all the way and at the screen …

How to upgrade your AT&T locked Dell Streak (Baseband GAUSB1A111231 Build 6601) to Android 2.2 Froyo

January 23, 2011

I’ve been patiently waiting for Dell to release the 2.2 version of the Android OS for my AT&T locked Dell Streak but they just keep pushing it back and there’s currently no specific release date. They’ve already released it for the non-AT&T locked versions but it seems like AT&T is preventing them from releasing it to the AT&T-locked ones. The Dell update package seems to check the baseband version of the device so even if …