Open
Description
The photos table stores data like this:
| id | createdAt | source | prefix | suffix | width | height | visibility | created ▲ | user |
|---|---|---|---|---|---|---|---|---|---|
| 5e12c9708506bc000840262a | January 06, 2020 - 05:45:20 UTC | Swarm for iOS 1 | https://fastly.4sqi.net/img/general/ | /15889193_AXxGk4I1nbzUZuyYqObgbXdJNyEHiwj6AUDq0tPZWtw.jpg | 1920 | 1440 | public | 2020-01-06T05:45:20 | 15889193 |
The photo URL can be derived from those pieces - define a SQL view which does that (using datasette-json-html to display the pictures)