Understanding mapping of tables in MediaDb.v1.sqlite for Microsoft Photos

Question

Hi, I'm trying to work on understanding artefacts left by Microsoft Photos app better and want to check how to understand the mapping of tables found in ~\AppData\Local\Packages\Microsoft.Windows.Photos_8wekyb3d8bbwe\LocalState\MediaDb.v1.sqlite files. My problem is that I can see almost 128 tables contained in that but I find it hard to map which table's which id/row correspond to which image in the Photos app since there seems to be no unique id making it hard to understand what information corresponds to what image.

Any kind of help will be greatly appreciated!

Thanks :)

Answer 1

Hello there,

This thread might throw insights

https://github.com/jnagykuhlen/WindowsPhotoAlbumExporter

The tool is command-line-only, there exists no GUI at the moment. Simply double-click WindowsPhotoAlbumExporter.exe and follow the instructions to select an album and set the export path. Alternatively, the tool can be called with optional parameters as follows:

WindowsPhotoAlbumExporter.exe [TargetPath] [AlbumName] [DatabasePath]

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--