searching my old keyword hierarchy

[Gruhler at netic.de]

Hi Mike,

maybe https://dbeaver.io/ will help,
but I don't know how you can read the keyword hierarchy.

Perhaps this SQL:

WITH RECURSIVE tag_tree AS (
     -- Anchor (Level 0)
     SELECT
         id, pid, name, icon, iconkde,
         0 AS level,
         name AS path
     FROM Tags
     WHERE pid = 0  -- Roots
     UNION ALL
     -- Recursive (Level 1+)
     SELECT
         t.id, t.pid, t.name, t.icon, t.iconkde,
         tt.level + 1,
         tt.path || ' / ' || t.name
     FROM Tags t
     JOIN tag_tree tt ON t.pid = tt.id
)
-- Insert HERE: Levels!
SELECT * FROM tag_tree WHERE level <= 2
ORDER BY level, path;

Best regards,
Paul



Am 08.02.2026 um 17:59 schrieb nshdhh at gmx.de:
> Hello, dear experts,
> I used digikam almost 20 years ago and built up a very well 
> thought-out keyword hierarchy. Unfortunately, I haven't used digikam 
> in recent years, but would now like to continue using the keyword 
> hierarchy.
>
> I have some backups of digikam.db from back then. But when I open them 
> with the new installed current version of digikam, the old keywords 
> are not displayed.
>
> Unfortunately, I have not been able to install the SQLite browser, 
> which is supposed to allow you to read data.
> Do you have any idea how I can find my old keyword hierarchy? And then 
> import it into the new digikam4.db?
> Many thanks, Mike

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20260208/c34e3eab/attachment-0001.htm>