XMP metadata in database ?

Sylvain MONTAGNER <[email protected]> Tue, 2 Dec 2025 08:42:28 +0000 (UTC)
Newsgroups gmane.comp.kde.digikam.user
Message-ID <[email protected]>
Hi everyone,

I became a new digiKam user last week, and I would first like to congratulate all the developers who have given us this wonderful, incredibly efficient open source tool.

One of the many reasons I am so pleased with digiKam is that the SQLite database is accessible and I can run my own SQL queries to export data (it would be even better with PostGreSQL, but I see that this request has already been made and that it is not so easy to implement).

I have a question about accessing the XMP metadata of photos. Can you confirm that this metadata is not in the SQLite database?
I would have liked to query it in SQL, but I don't think that's possible.

To be more specific, I use a DJI drone that records this type of metadata in XMP:
 FlightPitchDegree : -9.20
FlightRollDegree : -1.60
FlightXSpeed : 5.0
FlightYawDegree : +0.00
FlightYSpeed : 0.0
FlightZSpeed : 0.0
FocusDistance : 5132
GimbalPitchDegree : -90.00
GimbalReverse : 0
GimbalRollDegree : +180.00
GimbalYawDegree : -179.80

They are clearly visible in the Metadata > XMP panel, but I couldn't find them in the database.
If this is not possible natively, is there a way to integrate this metadata into the digikam4.db database?

Thank you for your advice, and long live digiKam!

Sylvain M