Skip to content

Projects 2026 in progress

Movies

A film and TV catalogue that runs on your own machine - 12.7 million IMDb titles in SQLite, posters and where to watch from TMDB, every filter on one screen, and a watch log kept as plain files.

SvelteKit, SQLite

Movies is a film and TV catalogue that runs entirely on my own machine. About 12.7 million titles from IMDb's public datasets sit in a SQLite file, enriched from TMDB with posters, cast, summaries and where each title can be watched. Nothing leaves the machine except those requests to TMDB; there is no account and no sync.

Browsing is one screen and one query. Search is a filter rather than a separate page, so "science fiction I have not seen, matching 'star', newest first" is a single question, and any combination of text, genre, year, runtime, rating, cast and crew, streaming service and age range can be saved as a named view. Twenty-two genres in nine colour families tint the cards, so a wall of posters can be read by category before reading a word.

Where the data comes from: IMDb's datasets and TMDB feed a local SQLite catalogue, the watch log stays in plain files beside it, and one browse screen queries it all

What I write — the watch log, ratings, reviews, lists — lives as Markdown and JSONL files in git, readable without the app; the database only holds a derived copy. It reads in English or Turkish. The source is not public.