How to Dig Into the Apple Photos SQLite Database

How to Dig Into the Apple Photos SQLite Database

Now here’s a cool article I found last night. Simon Willison found the SQLite database that Apple Photos uses. It contains photo metadata as well as the aesthetic scoring system that the machine learning uses. Further, there are numeric categories used to label content within photos. For example, Category 2027 is for Entertainment, Trip, Travel, Museum, Beach Activity, etc. I think the quality scores are particularly interesting. There are scores for noise, composition, lively color, harmonious color, pleasant lighting/pattern/perspective, and a bunch more. I bet Apple’s acquisition of Regaind contributed to this.

Check It Out: How to Dig Into the Apple Photos SQLite Database

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.