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, [email protected] <[email protected]> wrote: > From: [email protected] <[email protected]> > Subject: f-spot-list Digest, Vol 82, Issue 2 > To: [email protected] > Date: Thursday, February 3, 2011, 4:00 AM > Send f-spot-list mailing list > submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: documentation of past and current database > formats? > Message-ID: <[email protected]> > 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 <[email protected]> > To: Sven Utcke <[email protected]> > Cc: [email protected] > Subject: Re: documentation of past and current database > formats? > Message-ID: > <[email protected]> > 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 <[email protected]> > 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 > > [email protected] > > 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 <[email protected]> > To: [email protected] > Subject: Chronological bar wrong > Message-ID: <[email protected]> > 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." <[email protected]> > To: Tim Howard <[email protected]> > Cc: [email protected] > Subject: Re: adding a new exporter to F-spot ? (question > for F-spot > developers) > Message-ID: > <[email protected]> > 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. <[email protected]> > 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 <[email protected]>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 > [email protected] > http://mail.gnome.org/mailman/listinfo/f-spot-list > > > End of f-spot-list Digest, Vol 82, Issue 2 > ****************************************** > _______________________________________________ f-spot-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/f-spot-list
