Monthly Archives: March 2008

Choosing Your Freelance Clients

Freelancers have this advantage over companies. You can choose who you want to work with on a personal level. Old school business types would tell you its not personal just business, that you should be able to work with anyone.

But when we work from home and get to know our clients first hand and see their software grow up with them, it becomes personal.

Choose your clients well. A few will stick with you for a long time. That one annoying client that pays more but gives you too much stress will take your attention away from your other, probably better clients.

Oh sometimes you get great clients that pay well too! :)

Update: similar articles

Top 10 Ways to Fire the Client From Hell – Inside CRM

SitePoint Blogs ยป How to fire a client

Internet on the Road with WIFI, 3G and JoikuSpot

I tried out JoikuSpot with my Nokia N80 and notebook. Its simple to setup and worked pretty well. This is definitely useful on the road.

This method can’t beat 3G modems since they can go up to 7.5Mbps. The Nokia N80 only supports 384 kbps. But its better than buying a dedicated 3G modem for me because I don’t need to use it often between ADSL points.

If you don’t already have a 3G phone it might be cheaper and faster to get a 3G modem.

I checked Mobitel and Dialog for 3G modems a few months ago. Back then I was on Linux only and they didn’t have drivers etc. This should work on Linux as well since its on WIFI.

JoikuSpot has a few limitations at this time. It only supports HTTP/HTTPS and the WIFI hotspot is not secure. They say other protocols and security is on the way.

Here is the introduction from the developers:

JoikuSpot is a free mobile software solution that turns a Nokia Smartphone to a WLAN HotSpot. You will carry internet in your pocket. Connect your laptop to web everywhere! FREE — INSTANT — EASY

SQLite Vacuum on F-Spot

I heard on FLOSS Weekly 26: SQLite the other day about the vacuum command in SQLite and how it rebuilds the database and makes Apple Mail faster.

I started F-Spot to check some old photos and it was getting stuck. Hmm wait F-Spot uses a SQLite database too, so I tried something like this.

Went to the F-Spot directory.

cd /home/dilantha/.gnome2/f-spot

Backed up the current SQLite database.

cp photos.db photos.db.20080326

Opened the database

sqlite3 photos.db

Then in SQLite I got some help, listed tables and ran vacuum on photos and photo_tags.


.help
.tables
vacuum photos;
vacuum photo_tags;
.quit

Now F-Spot is running smooth as ever.

Running Bash Scripts in Windows Scheduler

Normally you can run scripts in the Cygwin shell. But I wanted to run a bash script in Windows scheduler. Find the Cygwin.bat file probably located in C:\cygwin. It looks something like this.


@echo off

C:
chdir C:\cygwin\bin

bash --login -i

This batch file doesn’t let you run an external script with it. Add a %1 at the bash command’s end like this. What you are doing is passing the first parameter in Windows to bash.


@echo off

C:
chdir C:\cygwin\bin

bash --login -i %1

Now drag and drop the Cygwin.bat file into the Windows scheduler window and edit running time properties etc. Now add the script to run at the end of the Cygwin command. For example like

C:\cygwin\Cygwin.bat ./bin/mysql/db.dilantha.info.sh

Windows Scheduler