really tenacious guy

F-Spot: Changing Directory From /Photos to /Pictures/Photos

While testing Ubuntu One issue with data being wiped out from the server I had to do a clean install of Karmic Koala in VM. So in the end I confirmed the issue and started exploring the fresh installation that was not affected by previous upgrades.

It turned out that Downloads directory is now the default folder for file downloads out of the box (I hate seeing files going to the Desktop) so a tiny tweak was needed on my main PC in ~/.config/user-dirs.dirs file:

 XDG_DESKTOP_DIR="$HOME/Desktop"
-XDG_DOWNLOAD_DIR="$HOME/Desktop"
+XDG_DOWNLOAD_DIR="$HOME/Downloads"
 XDG_TEMPLATES_DIR="$HOME/Templates"

Another directory change affected F-Spot which started using ~/Pictures/Photos as a default location.

F-Spot database is sqlite3, so it will be trivial to change base URI for a file

  1. Copy original photos.db to photos-backup.db
    cp ~/.config/f-spot/photos.db ~/.config/f-spot/photos.db.bak
  2. Open sqlite3 database shell:
    sqlite3 ~/.config/f-spot/photos.db
  3. Update photos and photo_versions tables changing base_uri: 
    update photos set base_uri = replace(base_uri, "file:///home/rtg/Photos", "file:///home/rtg/Pictures/Photos");
update photo_versions set base_uri=replace(base_uri, "file:///home/rtg/Photos", "file:///home/rtg/Pictures/Photos");
  4. Quit sqlite3 shell: 
    .quit

Now you can start f-spot. Please note that thumbnails are stored separately, in ~/.thumbnails with the name being the hash of the filename. It is possible to move them as well but since thumbnails can be regenerated, I decided not to do this at the moment.

See also

Comments