How to map an ID generated by 'darktable-generate-cache' binary to a file name?

I can easily derive an ID from a filename by looking in the 'image information ’ panel. But how do I go from an ID - as presented by darktable-generate-cache - to a filename ?

See ~/.config/library.db table images. You need to use a SQLite database browser to have a look into the database.

Hmm, that seems to be a bit beyond my capability this year …

A database consists of several tables, and (unique) IDs are used to link information from different tables together. Those IDs are usually not supposed to be used by the end-user, they are only for internal use within the database. I’m not sure why dt’s image information panel provides them (other than for debugging purposes).

Yes, I understand this. However I did install an sqlite database browser, and was able to find the images which invoked errors in the darktable-generate-cache output, and was able to correct those errors. So, all in all, running the darkatbel-generate-cache binary was helpful