Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Show HN: SQL Police Department – Learn SQL while solving crimes

sqlpd.com

Post reply on HN
Print view View original

61–70 of 91 posts

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#61

Post by singlow »

doronlinder wrote: post #58
MattRix wrote: post #25

This is a cool idea but if you accidentally hit the back button or refresh it loses all your progress with no obvious way to skip ahead. Frustrating.

It can be solved with saving stuff to local storage, but I tried to not use it to be more GDPR compliant...

Isn't local storage pretty good for compliance? It doesn't automatically send the data to your server like a cookie would, so as long as you don't send it, you haven't collected it.

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#62

Post by hultner »

knight17 wrote: post #38

Here are some other SQL Learning resources I have collected in my note taking TiddlyWiki (mostly from HN itself). Interactive SQL Tutorials : ▪ Chartio Interactive PostgreSQL SQL Tutorial - https://chartio.com/learn/sql/ ▪ Select STAR SQL - https://selectstarsql.com/ ▪ SQL Bolt - Learn SQL with simple, interactive exercises - https://sqlbolt.com/ ▪ SQL Window functions - https://www.windowfunctions.com/ ▪ PostgreSQL…

Cool, must check out these

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#63

Post by mdaniel »

doronlinder wrote: post #58
MattRix wrote: post #25

This is a cool idea but if you accidentally hit the back button or refresh it loses all your progress with no obvious way to skip ahead. Frustrating.

It can be solved with saving stuff to local storage, but I tried to not use it to be more GDPR compliant...

I have a hard time imagining a GDPR complaint in which storing ones own data on their computer would constitute a privacy violation

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#65

Post by jonny_eh »

doronlinder wrote: post #60
jonny_eh wrote: post #35

The question where it asks for the list of unique download counts makes no sense.

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.

Interesting, why not hand pick the questions?

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#66

Post by geddy »

doronlinder wrote: post #45
oefrha wrote: post #19

Nice concept but I really hate clicking on the buttons to form my statements... Is it possible to allow typing? Also, not ending my statement with a semicolon feels incomplete.

Yeah, the semicolon bothers me too. I'll see how I can incorporate that in. The clicking around was meant to make life easier on mobile phone users. I'll see if I can add a keyboard support without undermining this.

This makes a lot of sense, actually. Definitely great for learning.

You could do it the way Duolingo does it - on desktop, it allows for "Hard Mode", where it lets you type the responses freely. On mobile however, it doesn't let you do that (unless you're using the app).

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#67

Post by geddy »

Really nice work. I had a lot of fun in that. Others have already mentioned the Backspace = page back issue where you could easily lose progress, but I played all the way through :) No need to purchase however as I already know SQL quite well. But really well done.

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#68

Post by rndgermandude »

doronlinder wrote: post #58
MattRix wrote: post #25

This is a cool idea but if you accidentally hit the back button or refresh it loses all your progress with no obvious way to skip ahead. Frustrating.

It can be solved with saving stuff to local storage, but I tried to not use it to be more GDPR compliant...

As long as you do not transmit the data ever, using localStorage isn't a GDPR concern other than that you should mention it (and the in-browser-only use, with data never leaving the users' systems) on your privacy policy page for the sake of transparency and to avoid users asking about it.

Re: Show HN: SQL Police Department – Learn SQL while solving crimes

#69

Post by doronlinder »

jonny_eh wrote: post #65
doronlinder wrote: post #60

Earlier quoted context omitted.

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.

Interesting, why not hand pick the questions?

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).
Post reply on HN