Archive for the ‘Open Source’ Category

SQL Play with Firefox 3 Places

I heard good things about Firefox 3. Now that I’ve got Ubuntu 8.04 I thought I’d try a few commands.
1. Get the places database
2. open with sqlite
3. query the bookmarks table

cp .mozilla/firefox/xxxxxxxx.default/places.sqlite .
sqlite3 places.sqlite
sqlite> .tables
moz_anno_attributes moz_favicons moz_keywords
moz_annos [...]

Make Windows Shortcuts with Cygwin

Did you know that you can make Windows shortcuts with Cygwin and ln? I did not know this, just tried it out today and it works!
This is probably the smallest thing I’m blogging about, but read on you might get some new ideas (like I did) about file organization in Windows. I swear some days [...]

Sinhalen FOSS

Listening to Sinhalen FOSS. Sounds good! This is probably the first Sinhala podcast!
Some people couldn’t read the Sinhala text. Get the fonts at www.fonts.lk. Kottu will also start to look better.

Technorati Tags: podcast

A better ssh-copy-id | smithii.com

I wanted to authorize my web host with my Cygwin shell to do some backups. I’m used to ssh-copy-id but Cygwin doesn’t have it. I found this script that does the trick.
A better ssh-copy-id | smithii.com
I put this code in a ssh-copy-id.sh file.
#!/bin/sh
# $Id$
SSH=”${HOME}/.ssh”
if [ ! -f "${SSH}/identity.pub" ]
then
PASSPHRASE=
read -p “Enter ssh passphrase for ${HOSTNAME}:” [...]

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 [...]

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 [...]

PHP for Developers

I like to follow up on Why You should learn PHP by rumblinglankan.com which talks about PHP for bloggers and extend it for programmers in general.
I was a full blown Java developer back in the day. I knew many developers who stuck to their guns and did one thing like Oracle, Java or .NET [...]

File Sharing Between Linux and Windows

I wanted to backup from my work (Windows) box to my personal (Linux) box. I found these useful videos on setting up Samba file sharing. This first guy was right I didn’t know about the extra configuration changes.

http://screencasts.ubuntu.com/SAMBA_Filesharing
Funny story. I did all this and didn’t see the Linux box on the network. Hmm that’s [...]

Drag and Drop from Eclipse Navigator

My primary editor is Eclipse, EasyEclipse for PHP flavor to be exact. I usually open another few Windows Explorer windows to move files around.
Today out of shear laziness I dragged a file from Eclipse Navigator to my open WinSCP tab in the task bar and into the remote site. It worked! That’s my tip.

Configure Pidgin for Google Talk

Still on Pidgin in case you didn’t know already you can use it to chat with your Gmail buddies as if you are logged onto the Gmail website or using Google Talk.
How do I configure Pidgin for Google Talk?

Technorati Tags: google, im