Tag Archive for 'tips'

Browser Buttons

Did some browser button organizing, thought I'd share.

Browser Buttons

Share your browser button bar, lets see if there are anymore important buttons to add.

Technorati Tags: , ,

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.

Technorati Tags:

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

Technorati Tags: ,

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 strange. I opened Firefox on Ubuntu to find no Internet either! With a quick glance at the back of the computer I saw the network cable was not plugged in. :)

I need to get another network cable for the mac. I keep switching between them.

Here is the Ubuntu Wiki page for Samba. Which has more details.

Technorati Tags: ,

Edit Last Chat Line in Skype

Skype Last Chat Line

I should lookup shortcuts in help. I use Skype most of the day. I just found out if you hit up arrow in chat you can edit your last chat line and enter to replace it.

Technorati Tags:

Ubuntu Update Manager Tip

I just re-installed Ubuntu 7.10 on my home computer. Although this version was just released in October there are almost 180MB of updates needed as soon as you do a clean install now.

Running all those updates at once was going to be a pain. So I started removing some bigger packages and I realized there are about 130 of them!

Luckily you can right click in the package list area and select "Uncheck All" and only select the packages you want to install.

Update: I'm adding the update manager screen shot. You can can right click on any of the items to get the "Uncheck all", "Check all" menu.

Ubuntu update manager

Technorati Tags: ,