[Digikam-devel] What do we want to store in the database?

[Gilles Caulier]

2007/8/31, Marcel Wiesweg <marcel.wiesweg at gmx.de>:
>
> Am Freitag 31 August 2007 schrieb Gilles Caulier:
> > 2007/8/31, Marcel Wiesweg <marcel.wiesweg at gmx.de>:
> > > > I think Multiple Comments is essential. But also comments need to be
> > > > qualified more than just a simple text stream. Gilles mentioned 4
> > > > strings to be stored but I'm not sure what they all are. My
> suggestion
> > > > would be:
> > > >  * Source
> > > >  * Who/Author
> > > >  * Language
> > > >  * Comment
> > >
> > > Gilles, was that what you meant with 4, a table for multiple comments
> > > with four columns like the ones above?
> >
> > I thinking 4 (more if you want) different comments as UTF-8 strings.
> > Nothing special about that. We can use like we want, for example to
> store
> > text in many language, or text come different photographers.
> >
> > You course this still to define more. What the advantage to use a table
> we
> > host all strings against 4 separate strings ?
>
> Ok, in this case we will store each comment in its own row in a table like
> this:
> imageid INTEGER
> description TEXT
> value TEXT


This is what i think in a first time

Colin suggested to store (instead of "description" above) source, author and
> language for each comment.


This is different. It's a Comments with properties. We need to check if
something exist in XMP schema to get inspiration. No need to re-invent the
wheel.

Gilles




_______________________________________________
> Digikam-devel mailing list
> Digikam-devel at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20070831/b11fd71c/attachment.html>