{"id":93941,"date":"2020-05-22T09:54:41","date_gmt":"2020-05-22T13:54:41","guid":{"rendered":"https:\/\/www.macobserver.com\/?post_type=cool-stuff-found&p=93941"},"modified":"2020-05-22T09:54:41","modified_gmt":"2020-05-22T13:54:41","slug":"apple-photos-sqlite-database","status":"publish","type":"cool-stuff-found","link":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/","title":{"rendered":"How to Dig Into the Apple Photos SQLite Database"},"content":{"rendered":"

Now here\u2019s 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\u2019s acquisition of Regaind<\/a> contributed to this.<\/p>\n","protected":false},"author":3148,"featured_media":69920,"comment_status":"open","ping_status":"closed","template":"","format":"standard","tags":[9213,248,9212],"class_list":["post-93941","cool-stuff-found","type-cool-stuff-found","status-publish","format-standard","has-post-thumbnail","hentry","tag-apple-photos","tag-machine-learning","tag-photography"],"acf":[],"yoast_head":"\nHow to Dig Into the Apple Photos SQLite Database - The Mac Observer<\/title>\n<meta name=\"description\" content=\"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Dig Into the Apple Photos SQLite Database\" \/>\n<meta property=\"og:description\" content=\"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/\" \/>\n<meta property=\"og:site_name\" content=\"The Mac Observer\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MacObserver\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.macobserver.com\/wp-content\/uploads\/2019\/06\/workfeatured-photos-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@MacObserver\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/\",\"url\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/\",\"name\":\"How to Dig Into the Apple Photos SQLite Database - The Mac Observer\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.macobserver.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/workfeatured-photos-2.jpg\",\"datePublished\":\"2020-05-22T13:54:41+00:00\",\"description\":\"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.macobserver.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/workfeatured-photos-2.jpg\",\"contentUrl\":\"https:\\\/\\\/www.macobserver.com\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/workfeatured-photos-2.jpg\",\"width\":1200,\"height\":630,\"caption\":\"Apple photos logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/apple-photos-sqlite-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cool Stuff Found\",\"item\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/cool-stuff-found\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Dig Into the Apple Photos SQLite Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/#website\",\"url\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/\",\"name\":\"The Mac Observer\",\"description\":\"Apple iPhone, Mac, Watch and iPad News, Opinions, Tips and More\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.macobserver.com\\\/es\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Dig Into the Apple Photos SQLite Database - The Mac Observer","description":"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/","og_locale":"es_ES","og_type":"article","og_title":"How to Dig Into the Apple Photos SQLite Database","og_description":"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.","og_url":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/","og_site_name":"The Mac Observer","article_publisher":"https:\/\/www.facebook.com\/MacObserver","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.macobserver.com\/wp-content\/uploads\/2019\/06\/workfeatured-photos-2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@MacObserver","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/","url":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/","name":"How to Dig Into the Apple Photos SQLite Database - The Mac Observer","isPartOf":{"@id":"https:\/\/www.macobserver.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/#primaryimage"},"image":{"@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.macobserver.com\/wp-content\/uploads\/2019\/06\/workfeatured-photos-2.jpg","datePublished":"2020-05-22T13:54:41+00:00","description":"Simon Willison discovered the SQLite database used by Apple Photos, and it\u2019s an interesting glimpse into its machine learning.","breadcrumb":{"@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/#primaryimage","url":"https:\/\/www.macobserver.com\/wp-content\/uploads\/2019\/06\/workfeatured-photos-2.jpg","contentUrl":"https:\/\/www.macobserver.com\/wp-content\/uploads\/2019\/06\/workfeatured-photos-2.jpg","width":1200,"height":630,"caption":"Apple photos logo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/apple-photos-sqlite-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.macobserver.com\/es\/"},{"@type":"ListItem","position":2,"name":"Cool Stuff Found","item":"https:\/\/www.macobserver.com\/es\/cool-stuff-found\/"},{"@type":"ListItem","position":3,"name":"How to Dig Into the Apple Photos SQLite Database"}]},{"@type":"WebSite","@id":"https:\/\/www.macobserver.com\/es\/#website","url":"https:\/\/www.macobserver.com\/es\/","name":"The Mac Observer","description":"Apple iPhone, Mac, Watch and iPad News, Opinions, Tips and More","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.macobserver.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"}]}},"_links":{"self":[{"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/cool-stuff-found\/93941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/cool-stuff-found"}],"about":[{"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/types\/cool-stuff-found"}],"author":[{"embeddable":true,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/users\/3148"}],"replies":[{"embeddable":true,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/comments?post=93941"}],"version-history":[{"count":1,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/cool-stuff-found\/93941\/revisions"}],"predecessor-version":[{"id":93943,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/cool-stuff-found\/93941\/revisions\/93943"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/media\/69920"}],"wp:attachment":[{"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/media?parent=93941"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.macobserver.com\/es\/wp-json\/wp\/v2\/tags?post=93941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}