Hello Dieter, > f-spot uses a sqlite database consisting of only a few > tables. E.g. there is one table called photos with one line for each > picture. There is another table called "tags" where all tags are > registered. Which photos belong to what tag shows a table called > photo_tags. So the data model is pretty obvious and with little SQL > knowledge it is possible to extract information from the database.
Oh yes, no problem there. Only then I noticed that f-spot 0.4.3 was already using database version 14.0, and now we are up to 18.0. Which store paths (uris) in a different way. And there is the matter of photo_versions, which I consider broken (they all share the same id, and deleting the original means we need to make the first version the new original, moving it from photo_versions to photo, and more nastiness like that...) > During the last versions, there where no fundamental changes to the > data model (afaik). Well, there was a mayor change in how URIs are stored between database version 16.5 and 17. Also, the handling of md5sums has changed quite a bit. > Therefore it should be possible to make yourself familiar with the > database regardless of the version as soon as you understand the > basic principle. Oh, the thing I wrote worked just fine for me (another database cleaner, you can find a version that ought to work on database version 7 to 16.5, but only for images without versions, in http://svenutcke.de/sw/f-spot/cleanup/) --- but I though it would be nice to know for which versions it wouldn't work, and how to fix that (I guess I do know now, but it might be nice to have a look at a real database with version 6 and 18 respectively to be sure --- and then I still need to code this :-)... Sven -- __ _ _ __ __ __ / _` || ' \ \ \ / \__, ||_|_|_|/_\_\ http://kogs-www.informatik.uni-hamburg.de/~utcke/Private/ |___/ Key fingerprint = 6F F8 55 1C F9 E3 A8 F7 09 DF F7 2C 25 0C 54 53 _______________________________________________ f-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
