<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">
<p>Hi Mike,</p>
<p>maybe <a class="moz-txt-link-freetext"
href="https://dbeaver.io/" moz-do-not-send="true">https://dbeaver.io/</a>
will help,<br>
but I don't know how you can read the keyword hierarchy.</p>
<p>Perhaps this SQL:<br>
<font size="1"><br>
</font></p>
<p><font size="1">WITH RECURSIVE tag_tree AS (<br>
-- Anchor (Level 0)<br>
SELECT<br>
id, pid, name, icon, iconkde,<br>
0 AS level,<br>
name AS path<br>
FROM Tags<br>
WHERE pid = 0 -- Roots<br>
UNION ALL<br>
-- Recursive (Level 1+)<br>
SELECT<br>
t.id, t.pid, t.name, t.icon, t.iconkde,<br>
tt.level + 1,<br>
tt.path || ' / ' || t.name<br>
FROM Tags t<br>
JOIN tag_tree tt ON t.pid = tt.id<br>
)<br>
-- Insert HERE: Levels!<br>
SELECT * FROM tag_tree WHERE level <= 2<br>
ORDER BY level, path;</font><br>
</p>
<p>Best regards,<br>
Paul</p>
<br>
<br>
Am 08.02.2026 um 17:59 schrieb <a
class="moz-txt-link-abbreviated moz-txt-link-freetext"
href="mailto:nshdhh@gmx.de" moz-do-not-send="true">nshdhh@gmx.de</a>:<br>
</div>
<blockquote type="cite"
cite="mid:trinity-1c2c56de-805d-4e1c-9f92-12e1c17b3651-1770569987627@trinity-msg-rest-gmx-gmx-live-ff44cccdb-jn5rc">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="font-family: 'verdana'; font-size: 12px; color: #000;">
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;">Hello,
dear experts,</div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;"> </div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;">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. </div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;"><br>
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.</div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;"><br>
Unfortunately, I have not been able to install the SQLite
browser, which is supposed to allow you to read data. </div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;"> </div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;">Do
you have any idea how I can find my old keyword hierarchy? And
then import it into the new digikam4.db?</div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;"> </div>
<div
style="font-family: 'verdana'; font-size: 12px; color: #000;">Many
thanks, Mike</div>
</div>
</blockquote>
<br>
<br>
</body>
</html>