Re: Dumping photos.db

["Thomas Van Machelen" <thomas vanmachelen gmail com>]

2007/1/12, Dotan Cohen <dotancohen gmail com>:
> The birth of my daughter has inspired my to get a photo album up on my
> site.

Why don't you use the the "export to folder" functionality.  Select
the standalone web gallery and you'll have something to upload
immediately.

Thomas.

To do that, I must export some info from F-Spot's database. I
> have STFW for a few hours now and can't seem to come up with the
> method of exporting SQL from the photos.db database. Note that sqlite
> does NOT recognize the photo.db database, so I am using sqlite3.
>
> I want to output to a text file these SQL commands:
>
> SELECT id, name FROM tags;
> SELECT id, time, directory_path, name FROM photos;
> SELECT photo_id, tag_id FROM photo_tags;
>
> Please, how on Earth do I do that?!? Thanks!
>
> Dotan Cohen
>
> http://lyricslist.com/lyrics/artist_albums/273/jackson_michael.html
> http://what-is-what.com/what_is/electromagnet.html
> _______________________________________________
> F-spot-list mailing list
> F-spot-list gnome org
> http://mail.gnome.org/mailman/listinfo/f-spot-list