Gus Cuddy

Picture a Day

A film a day from the They Shoot Pictures, Don't They lists. Work through the greatest films one at a time and keep a record of what you watched.

Software
2024–
Stack
React, Cloudflare Workers, Cloudflare D1, Alchemy
Link
pictureaday.club
Screenshot of Picture a Day

Picture a Day grew out of the TSPDT Movie Explorer I built in 2024.

The first version

One of my favorite sources for cinephilia is the wonderful greatest films compilation website They Shoot Pictures, Don’t They?. They provide a CSV of their starting list of 24,000 films, as well as the films’ historical rankings. It was a fun data spelunking project to turn it into a beautiful and fast movie explorer.

I started with the CSV, transformed and parsed it into a SQLite Database, and then ran some scripts to look up all the movies in TMDB and extract text embeddings and insert them into a vector database.

From there, I built out a UI using Next.js App Router and React Server Components, and a Hono Cloudflare Worker for the API (this allowed easier integration with Cloudflare Services).

I relied on D3 and the React Nivo library for data visualization.