Re: Bookmark/History DB SoC project

[Jamie McCracken <jamiemcc blueyonder co uk>]

Christian Persch wrote:
> I think we should add more metadata, not just track the last visit but
> all visits (so you can search for the site by date even if you've been
> there afterwards), and also the referrer (if you know where you came
> from to that site, but don't remember the site itself).

yes a Bookmark.Referer is fine. Please let me know if you need more.

For the "all visits" case, this is really a separate history object 
rather than metadata on a bookmark (we could store it as metadata as an 
array of dates but this would not be efficient database wise for 
retrieving all bookmarks visited on a given day - in general, one to 
many relationships should be stored in separate tables for speed).

I expect a history object in tracker to look something like:

history://2006-31-05
history://2006-30-05

so each history object represents a given day. History objects would 
probably not have any metadata attached to them but would contain links 
to one or more chronologically ordered bookmarks.

In tracker's database we have the following tables:

Services - stores the basic details for a service object like its uri

ServiceMetadata - stores extensible list of metadata for a service object

ServiceLinks - stores relationships between service objects

The history object would use the ServiceLinks table to specify which 
bookmarks were visited on that day.

--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/