Skip to content
master
Switch branches/tags
Go to file
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

phace

Reverse engineering OSX/macOS *.photoslibrary format. Primary goal is to export face tagging data from the embedded databases.

Status

This project is very much a work in progress. Additionally, Apple appears to have made significant changes to the *.photoslibrary structure in macOS 10.15 Catalina (maybe 10.14?). Phace has not been updated for these newer versions.

$ sqlite3 ./database/photos.db .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE LiGlobals (modelId integer primary key, keyPath varchar, value varchar, blobValue blob);
INSERT INTO LiGlobals VALUES(1,'metaSchemaVersion','3',NULL);
INSERT INTO LiGlobals VALUES(2,'libraryVersion','6000',NULL);
INSERT INTO LiGlobals VALUES(3,'libraryCompatibleBackToVersion','6000',NULL);
CREATE TABLE LiLibHistory (modelId integer primary key, modDate timestamp, eventType varchar, metaSchemaVersion integer, libraryVersion integer, comment varchar);
INSERT INTO LiLibHistory VALUES(1,466369847.60223102568,'deprecate',3,6000,'metaSchema.db and photos.db replaced by Photos.sqlite');
COMMIT;

Specifically that last comment: metaSchema.db and photos.db replaced by Photos.sqlite

About

Reverse engineering Mac photos library for data export

Topics

Resources

Releases

No releases published

Packages

No packages published