Simon Willison’s Weblog

Subscribe

Entries tagged sqlite, applephotos

Filters: Type: entry × sqlite × applephotos × Sorted by date


Using SQL to find my best photo of a pelican according to Apple Photos

According to the Apple Photos internal SQLite database, this is the most aesthetically pleasing photograph I have ever taken of a pelican:

[... 1937 words]

7:16 pm / 21st May 2020 / photography, photos, projects, sql, sqlite, datasette, dogsheep, weeknotes, applephotos

Weeknotes: Datasette 0.41, photos breakthroughs

Shorter weeknotes this week, because my main project for the week warrants a detailed write-up on its own (coming soon... update 21st May here it is).

[... 867 words]

5:02 am / 7th May 2020 / projects, sqlite, datasette, observable, dogsheep, weeknotes, applephotos

Types

Years

Tags