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

[Dieter Probst <diprob yahoo com>]

Regarding database format documentation:

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.
Personally I am using F-spot for a kind of document management system. For this, I wrote a SQL-Script generating a table of content as csv-file.

During the last versions, there where no fundamental changes to the data model (afaik). Therefore it should be possible to make yourself familiar with the database regardless of the version as soon as you understand the basic principle.

best regards,
- diprob



--- On Thu, 2/3/11, f-spot-list-request gnome org <f-spot-list-request gnome org> wrote:

> From: f-spot-list-request gnome org <f-spot-list-request gnome org>
> Subject: f-spot-list Digest, Vol 82, Issue 2
> To: f-spot-list gnome org
> Date: Thursday, February 3, 2011, 4:00 AM
> Send f-spot-list mailing list
> submissions to
>     f-spot-list gnome org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
>     http://mail.gnome.org/mailman/listinfo/f-spot-list
> or, via email, send a message with subject or body 'help'
> to
>     f-spot-list-request gnome org
> 
> You can reach the person managing the list at
>     f-spot-list-owner gnome org
> 
> When replying, please edit your Subject line so it is more
> specific
> than "Re: Contents of f-spot-list digest..."
> 
> 
> Today's Topics:
> 
>    1. documentation of past and current
> database formats? (Sven Utcke)
>    2. Re: documentation of past and current
> database formats?
>       (Tim Howard)
>    3. Chronological bar wrong (Pierre
> Hanser)
>    4. Re: adding a new exporter to F-spot ?
> (question for F-spot
>       developers) (Petr H.)
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 2 Feb 2011 21:56:42 +0100
> From: Sven Utcke <sven utcke gmx de>
> To: f-spot-list gnome org
> Subject: documentation of past and current database
> formats?
> Message-ID: <20110202205642 GS12381 x60s fritz box>
> Content-Type: text/plain; charset=us-ascii
> 
> Hi,
> 
> is there a documentation of past and current database
> formats?  In
> case I want to access this from outside F-Spot (yes, I
> know...)?
> 
> Thanks?
> 
> 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
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 2 Feb 2011 16:06:35 -0500
> From: Tim Howard <timothy howard gmail com>
> To: Sven Utcke <sven utcke gmx de>
> Cc: f-spot-list gnome org
> Subject: Re: documentation of past and current database
> formats?
> Message-ID:
>     <AANLkTimdkoFpxvnG_zC3UL1L7nvuALSR_YHsN_SwbK1e mail gmail com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> To my knowledge, no. There is however the notion of
> converting/upgrading
> older versions of databases into the newer versions (when
> they changed). I
> don't have the code in front of me so I can point you at it
> right now but
> that may be helpful if you anticipate dealing with multiple
> versions.
> 
> 
> tim
> 
> 
> 
> On Wed, Feb 2, 2011 at 3:56 PM, Sven Utcke <sven utcke gmx de>
> wrote:
> 
> > Hi,
> >
> > is there a documentation of past and current database
> formats?  In
> > case I want to access this from outside F-Spot (yes, I
> know...)?
> >
> > Thanks?
> >
> > Sven
> > --
> >  __ _  _ __  __ __
> >  / _` || '  \ \ \ /
> >  \__, ||_|_|_|/_\_\
> > http://kogs-www.informatik.uni-hamburg.de/~utcke/Private/<http://kogs-www.informatik.uni-hamburg.de/%7Eutcke/Private/>
> >  |___/     Key fingerprint
> =  6F F8 55 1C F9 E3 A8 F7  09 DF F7 2C 25 0C 54
> > 53
> > _______________________________________________
> > f-spot-list mailing list
> > f-spot-list gnome org
> > http://mail.gnome.org/mailman/listinfo/f-spot-list
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mail.gnome.org/archives/f-spot-list/attachments/20110202/d1acc83d/attachment.html>
> 
> ------------------------------
> 
> Message: 3
> Date: Thu, 03 Feb 2011 11:47:28 +0100
> From: Pierre Hanser <hanser club-internet fr>
> To: f-spot-list gnome org
> Subject: Chronological bar wrong
> Message-ID: <4D4A87C0 9050000 club-internet fr>
> Content-Type: text/plain; charset=UTF-8
> 
> hello
> 
> the chronological bar is wrong: now (feb 2011) it is
> between 2011 and
> 2010 where it should be between 2011 and 2012
> it's off by 1 year and that's quite disturbing
> 
> best regards
> 
> 
> 
> ------------------------------
> 
> Message: 4
> Date: Thu, 3 Feb 2011 12:01:37 +0100
> From: "Petr H." <petr henych gmail com>
> To: Tim Howard <timothy howard gmail com>
> Cc: f-spot-list gnome org
> Subject: Re: adding a new exporter to F-spot ? (question
> for F-spot
>     developers)
> Message-ID:
>     <AANLkTi=EUgMcSzhGM_uLMussi2p8N132fMXByCas9Y1X mail gmail com>
> Content-Type: text/plain; charset="iso-8859-1"
> 
> Hello,
> promised temporary repository for that exporter (compatible
> with F-Spot
> 0.8.2) has been created at http://sourceforge.net/projects/f-spotrajcenet/.
> Provided zip file includes also all common makefiles
> updated. However,
> Monodevelop project and solution files are not included,
> because I was not
> able to get it working even for the latest f-spot source
> checked out by git
> (still problems with invalid references to "nunit",
> regardless of
> configuring project with or without --enable-tests
> option).
> Best regards
> Petr
> 
> 
> On Tue, Feb 1, 2011 at 10:16 PM, Petr H. <petr henych gmail com>
> wrote:
> 
> > Tim,
> > thank you for responding me. I'm really looking
> forward to F-Spot Community
> > Extensions project.
> > Meanwhile I'll try to create the repository compatible
> with the latest
> > F-Spot version (0.8.2.), as you suggested.
> > Best regards
> > Petr
> >
> >
> >
> > On Thu, Jan 27, 2011 at 5:00 PM, Tim Howard <timothy howard gmail com>wrote:
> >
> >> Petr,
> >>
> >> First off, that's excellent. Another popular
> exporter is fantastic news. I
> >> can't speak for F-Spot proper since Ruben
> **Vermeersch is the currrent
> >> maintainer but at the moment I am actively working
> on setting up a F-Spot
> >> Community Extensions project. My idea is to remove
> the exporters and editors
> >> from F-Spot and make them part of the community
> extensions. Then that can be
> >> released separately and as often as necessary to
> address necessary updates.
> >> It would also hopefully dramatically lower the bar
> for extension creation
> >> with some much needed automation (for reference
> the entirety of this idea
> >> and a lot of the initial set-up comes from the
> Banshee Community Extensions
> >> project). So, to me that would be an excellent
> place for this.
> >>
> >> However, I'm sure if you create a patch or put the
> code in a repository
> >> that can be pulled from then it could be included
> in the next release --
> >> whenever that is. You would need to create a
> repository based on the latest
> >> code from the GNOME git repository and make sure
> the new exporter is
> >> integrated at all levels including makefiles and
> Monodevelop solution. And
> >> be sure not to introduce any warnings, I'm
> counting. :)
> >>
> >> Additionally, you could check into making your
> own, online, controlled
> >> F-Spot repository for add-ins. Users could then
> add that repository to their
> >> F-Spot add-in manager and get the add-in directly
> from you. That gives you
> >> maximum control if you want to provide updates
> often.
> >>
> >> When I get the F-Spot Community Extensions project
> ready for developers to
> >> add extensions I will post here. Hope this helps.
> >>
> >>
> >>
> >> cheers,
> >>
> >>
> >> Tim
> >>
> >>
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mail.gnome.org/archives/f-spot-list/attachments/20110203/4130db76/attachment.html>
> 
> ------------------------------
> 
> _______________________________________________
> f-spot-list mailing list
> f-spot-list gnome org
> http://mail.gnome.org/mailman/listinfo/f-spot-list
> 
> 
> End of f-spot-list Digest, Vol 82, Issue 2
> ******************************************
>