I built an anime backlog calculator and broke my own app three different ways

I track what I watch. My backlog grew past 40 titles and I had no idea what So I built TokiWa — Next.js 15, Prisma, Postgres on remaining_episodes × episode_duration, Here's what actually went wrong while building it. Sorting the catalog by score, descending: \ts \ Titles with no score yet (unreleased anime) floated to the very top of the \ts \ Same bug had picked the homepage hero title too, via a separate query. orderBy: { score\ in the codebase to be sure I got them Catalog grew to 15k+ title


