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

PS 0 Reputation points
2023-05-17T01:22:48.6833333+00:00

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 :)

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,140 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 44,101 Reputation points
    2023-05-18T13:33:37.9266667+00:00

    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--

    1 person found this answer helpful.