database schema available?

[Gilles Caulier]

No. github mirror is outdated since years ago.

The source code is in KDE gitlab :

https://invent.kde.org/graphics/digikam/-/tree/master/project/documents?ref_type=heads

Best

Gilles Caulier

Le lun. 4 nov. 2024 à 20:24, Tac Tacelosky <tacman at gmail.com> a écrit :

> Is this the right place to get it? That repo has been archived.
>
> https://github.com/KDE/digikam/blob/master/project/documents/DBSCHEMA.ODS
>
>
>
> On Mon, Nov 4, 2024 at 2:15 PM Tac Tacelosky <tacman at gmail.com> wrote:
>
>> yep, that's the one!  Thanks!!
>>
>> On Mon, Nov 4, 2024 at 2:11 PM Remco Viëtor <remco.vietor at wanadoo.fr>
>> wrote:
>>
>>> On lundi 4 novembre 2024 19:58:15 CET Tac Tacelosky wrote:
>>> > Hi, I've been working on something to read the database directly,
>>> using the
>>> > sql statements to map to an ORM, and was wondering if there was a
>>> schema
>>> > document available.
>>> >
>>> > In particular, something that describes the relationship between the
>>> > albumRoot key in Albums and AlbumRoots, imageid property to Images.id,
>>> > etc.  Obviously, I can figure it out by looking at it, but if there's a
>>> > formal definition somewhere (I have a vague recollection of a
>>> spreadsheet
>>> > with the tables and properties) it would help with my automated data
>>> > mapping.
>>> >
>>> > On a related note, there's no foreign key references in the sql, and
>>> sqlite
>>> > used to not support it.  But since recent versions do, might that
>>> someday
>>> > be included in the sql?
>>> >
>>> > Thanks,
>>> >
>>> > Tac
>>> In the source code: directory "project/documents", there's a file
>>> DBSCEMA.ODS. Perhaps that's useful?
>>>
>>>
>>>
>>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20241104/95ccded2/attachment-0001.htm>