scottkjr3347/ios_local_pl_photos.sqlite_queries

iOS Photos.sqlite queries that may help with decoding data stored in Photos.sqlite. These queries are based on testing, research and some community published research. These queries were written to work for the Photos.sqlite database stored at: iOS: /private/var/mobile/media/PhotoData/Photos.Sqlite Mac OS: /Users//Pictures/PhotosLibrary.photoslibrary/database/Photos.sqlite

iOS Local Photo Library (PL) Photos.sqlite Queries

The queries within this repository have been updated and the updates can be found within PhotoData-Synd-Photos.sqlite_Queries repo.

ios_local_pl_photos.sqlite_queries's Issues

Trash State Conflict

When reviewing an asset within the photos.sql database the zAsset - Trashed State/LocallyAssetRecently had the value of "1 - Asset in Trash/Recently Deleted". The column zIntResou - Trash State had the value of "0 - zIntResou-Not In Trash/Recently Deleted".

I wondered if you knew what would cause this or just an explanation of the difference in columns so i know if the asset is within the recently deleted folder.

This was done on a Mac running macOS Big Sur so used the iOS14_LPL_Phsql_Basic.txt.
I also managed to get the Photos.sqlite from the iPhone which was running iOS15 so used the iOS15_LPL_Phsql_Basic.txt and got the same results. This was a cloud synced asset from the iPhone to the Mac