Always fresh: Sql list of countires

Tagged: MySQL, Programming, Something Else Date: 5th, August 2008

Since my last post with updated list of countries in MySQL format was so well received I decided to go even further and write a parser script so you can always get fresh countries list.
Every time you download sql countries list it will be up to date for that very minute. This is because it [...]

Unrar recursively multiple archives (linux and mac)

Tagged: Database, Programming, Ubuntu Date: 1st, August 2008

It really is a drag when you download full season of your favorite show and see 20+ episodes in separate folders, every episode rared. It takes a bit of time to unpack one by one.
Here’s a little script that should help you with that (and with similar tasks). Download.
Install:

gunzip unrarr.gz
sudo cp unrarr /usr/bin/
sudo chmod +x [...]

Up to date sql list of countries – 31-07-2008

Tagged: MySQL, Programming Date: 31st, July 2008

Just collected list of countries and formatted it into MySQL form… well nothing much but I bet it will be useful to someone out there. Well enjoy: Countries List SQL download

Even fresher SQL Countries list… here.

Ubuntu: Mounting remote directory, ssh

Tagged: Ubuntu Date: 30th, May 2008

$sudo apt-get install sshfs

Will install fallowing: fuse-utils and libfuse2
When sshfs is installed:

$sudo mkdir /path/to/mount/point
$sudo chown your-username /path/to/mount/point
$sshfs ssh-username@ssh-server.com:/target/dir /path/to/mount/point

Thats it. To unmount just type

$sudo umount /path/to/mount/point

Recursively add files to CVS

Tagged: Programming Date: 4th, April 2008

Linux shell command, recursive cvs add:

cvs -qn update | grep -v CVS | xargs cvs add

or even

find . -type d -print | grep -v CVS | xargs cvs add
find . -type f -print | grep -v CVS | xargs cvs add