Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Show HN: I turned 18 Agatha Christie novels into SQL murder cases (querythemurder.com)
9 points by jenikashah07 12 days ago | hide | past | favorite | 4 comments
 help



This is a fire idea. Sorry you got flagged dead. I wish HN wasn't in such burn it all with fire mode. Neat idea. Hope it stands up, hope the go here is pretty good.

Great idea! Thank you for sharing.

Hi HN, I’m the maker. I got tired of SQL practice that felt like data entry, so I built a game where every exercise is a murder investigation.

There are 18 cases, each based on an Agatha Christie novel (Orient Express, Ackroyd, Death on the Nile and so on). Each case is a real database of suspects, alibis and timelines. You answer 5 questions to work out who did it. The early cases are SELECT and WHERE. Later ones need JOINs, GROUP BY, subqueries and window functions. It’s free with no signup. It works on a laptop or desktop.

A few things that were more interesting to build than I expected:

Answers are checked by comparing your result rows to the expected rows, not your query text, so any correct query passes whether you used a JOIN or a subquery. Postgres errors get translated for beginners. “column does not exist” gets a different hint depending on whether you typoed a column or used double quotes around a text value. Every query runs against Postgres as a read-only role with a 5 second timeout. Only a single SELECT or WITH statement is accepted.

Since I first shared it I’ve added table and column autocomplete, clearer messages when a query isn’t accepted, a case brief, progress steps and a “case closed” card when you solve one.

I’d love feedback on the difficulty curve and on any case where the question felt unfair. It was inspired by Knight Lab’s SQL Murder Mystery, which is a great single puzzle. This is my attempt at a longer path.


Hey, saw Query the Murder on Show HN and spent 10 minutes trying to break it: all seven nav pages, the Feedback widget, an empty query and a misspelled column on Case 1. Nothing; console clean, no failed requests. I build Snag, a report-a-bug button for your users: when something slips through, you get replay, console and network in a GitHub issue, not an "it's broken" DM. First 50 workspaces are free for life. Well done.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: