Re: f-spot-list Digest, Vol 82, Issue 2

[Sven Utcke <sven utcke gmx de>]

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