Locate photos db?

[wickedsprout]

Hi, thank you so much for this script!
Do you think it's possible to locate the sqlite db that has Album tags and other metadata from the backup?

[joz-k]

@drunkinlove : This is quite complex question. I suggest that you start looking at SQLite file:
12/12b144c0bd44f2b3dffd9186d3f9c05b917cee25 (Media/PhotoData/Photos.sqlite).

The important table is ZASSET which lists all media. Then you want to familiarize with various other linked tables like:

• ZGENERICALBUM: The ZTITLE field contains album and folder names
• ZADDITIONALASSETATTRIBUES
• ZEXTENDEDATTRIBUTES
• ZMOMENT
• ZPHOTOSHIGHLIGHT

Again, these tables contain large amount of media info from the device. There is no easy answer on how to connect these data together. You need to reverse engineer a bit.

Hope this helps.