forked/osxphotos
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Page: Changes in Photos 6 Big Sur
Pages
Changes in Photos 6 Big Sur Database changes from 16.0 to 16.0.1 Developer Tools Home Logs of shared images Machine Learning Photo Classification in Photos 5 Motivation for this project Photos 4 database schema Photos 5 database schema Photos 6 database schema (Big Sur) Photos 6 to Photos 7 Diff (Big Sur to Monterey 12.0.1) Photos 7 (Monterey) Schema Photos 7 to Photos 8 (Monterey to Ventura developer preview) Diff Photos 7 to Photos 8 diff Photos 8 Ventura 13.0 dev preview to Ventura 13.0.0 release diff Photos 8 schema (Ventura MacOS 13.0 developer preview) Photos 8 schema (Ventura MacOS 13.0.0) Photos 8 to Photos 9 schema diff (Ventura to Sonoma) Photos 9 (Sonoma) schema Photos Behavior Photos search data (psi.sqlite) diff Monterey to Ventura Photos version 4 database Photos version 5 database Related projects Schema changes from Photos 2 to Photos 3 Schema changes from Photos 3 to Photos 4 Schema changes from Photos 5 to Photos 6 Setting up a new development environment Steps to create sql diff of two database versions Structure of the code Understanding the Photos database iPhoto DataModelVersion.plist format iPhoto database schema psi.sqlite (search database) changes from Photos 5 to Photos 6 psi.sqlite schema (Photos 5) psi.sqlite schema (Photos 6) psi.sqlite schema (Photos 7, Monterey, macOS 12.0.1) psi.sqlite schema (Photos 8, Ventura, macOS 13.0)
Clone
5
Changes in Photos 6 Big Sur
Rhet Turnbull edited this page 2021-01-03 19:31:36 -08:00
Table of Contents

Changes in Big Sur Photos from Catalina

  • Full diff of schema changes

  • Non-jpeg files (.heic, .png, etc) that are edited are saved as .heic

    • /Users/rhet/Pictures/Test-10.16.0.photoslibrary/resources/renders/7/7783E8E6-9CAC-40F3-BE22-81FB7051C266_1_201_a.heic

  • ZGENERICASSET table is now ZASSET

  • Tables/columns for album join to find album details are now:

    • "ALBUM_JOIN": "Z_26ASSETS.Z_3ASSETS"
    • "ALBUM_SORT_ORDER": "Z_26ASSETS.Z_FOK_3ASSETS"

  • Version in photos.db:LiGlobals.libraryVersion remains at 6000 (same version as Photos 5) so instead look at Photos.sqlite to find model version:

    • SELECT MAX(Z_VERSION), Z_PLIST FROM Z_METADATA then look for PLModelVersion in the plist data.
      • _PHOTOS_5_MODEL_VERSION = [13000, 13999]
      • _PHOTOS_6_MODEL_VERSION = [14000, 14999]

See also changes from 16.0 to 16.0.1.