Simon Willison’s Weblog

Subscribe

Entries tagged sql in 2020

Filters: Type: entry × Year: 2020 × sql × Sorted by date


How much can you learn from just two columns?

Derek Willis shared an intriguing dataset this morning: a table showing every Twitter account followed by an official GOP congressional Twitter account.

[... 951 words]

6:46 pm / 15th June 2020 / derekwillis, politics, sql, twitter, datasette

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

Types

Years

Months

Tags