News for hackers. Stuff that matters.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by doronlinder on Monday May 04, 2020 @03:39PM (#23072386)
The cases are randomly generated; It asks for unique values of a random column in a random table. Sometimes it asks for unique password hashes... It's an edge case I didn't account for.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by jonny_eh on Monday May 04, 2020 @05:13PM (#23073339)
Interesting, why not hand pick the questions?
Re:Show HN: SQL Police Department – Learn SQL while solving ... by doronlinder on Monday May 04, 2020 @06:31PM (#23074139)
For replay-ability. Each time you need to understand the problem and construct a query instead of remembering that the answer was X (when I prototyped this in some of the cases you needed to pick the right answer from a cell in the table, not submit the whole thing).