{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Programming Tech Brief By HackerNoon","title":"I Got 15K People to Practice SQL by Turning Them Into Detectives","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/ab5af19e\"></iframe>","width":"100%","height":180,"duration":673,"description":"\n        This story was originally published on HackerNoon at: https://hackernoon.com/i-got-15k-people-to-practice-sql-by-turning-them-into-detectives.\n             See how SQL Case Files became a top choice for anyone searching for free SQL games or challenging SQL puzzles.  \n            Check more stories related to programming at: https://hackernoon.com/c/programming.\n            You can also check exclusive content about #sql, #learn-sql, #gamifying-sql, #sql-practice, #sql-case-files, #practice-sql, #sql-puzzles, #challenging-sql-puzzles,  and more.\n            \n            \n            This story was written by: @hackstarky. Learn more about this writer by checking @hackstarky's about page,\n            and for more stories, please visit hackernoon.com.\n            \n                \n                \n                SQL practice is boring because you're querying meaningless data in a vacuum. I built SQL Case Files - a detective game where you solve crimes by writing real SQL queries. Your phone vibrates when you close a case. No badges, no streaks, just investigations that feel physical. 15K monthly users in 4 weeks. This is how I made it work technically: SQLite WASM for local execution, result-set validation instead of SQL text matching, mobile-first UX with sticky schemas and bottom-sheet drawers, and a rate-limited AI assistant (20 calls/day because I'm paying for it). The constraint accidentally made people better at SQL. Free to play, no signup, runs entirely in your browser.\n        \n        ","thumbnail_url":"https://img.transistorcdn.com/KhCapPSRkLGL2Xw8888yuChkNRWthaKapLYTvNdu4W4/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzQxMTY2LzE2ODM1/ODIzMzAtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}