Simon Willison’s Weblog

Subscribe

Entries tagged photos in 2020

Filters: Type: entry × Year: 2020 × photos × 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: Archiving coronavirus.data.gov.uk, custom pages and directory configuration in Datasette, photos-to-sqlite

I mainly made progress on three projects this week: Datasette, photos-to-sqlite and a cleaner way of archiving data to a git repository.

[... 1132 words]

7:41 pm / 29th April 2020 / git, http, matthewsomerville, photos, projects, datasette, weeknotes, covid19, gitscraping

Types

Years

Months

Tags