News for hackers. Stuff that matters.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by oefrha on Monday May 04, 2020 @11:12AM (#23068980)
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.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by doronlinder on Monday May 04, 2020 @01:22PM (#23070757)
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.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by geddy on Monday May 04, 2020 @05:14PM (#23073345)
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 ... by greggyb on Monday May 04, 2020 @11:48AM (#23069409)
I agree. I work in Microsoft's SQL Server (incl. variations, e.g. Azure SQL DW) quite a bit. Based on my experience, I am the only person using semicolons in T-SQL.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by throwaway_pdp09 on Monday May 04, 2020 @01:04PM (#23070533)
I always try to use them. It's going to be mandatory says MS:

"Although the semicolon isn't required for most statements in this version of SQL Server, it will be required in a future version."

Re:Show HN: SQL Police Department – Learn SQL while solving ... by greggyb on Monday May 04, 2020 @01:26PM (#23070801)
That has been the guidance for a loooooong time.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by sonofaplum on Monday May 04, 2020 @12:30PM (#23070027)
I agree with this. I would much prefer if there was a freeform query mode, where I could just type the queries without the buttons or hints.
Re:Show HN: SQL Police Department – Learn SQL while solving ... by randlet on Monday May 04, 2020 @08:58PM (#23075203)
Yes! Part of learning a language, for me, is gaining muscle memory with my fingers and having to use a mouse is a turn off. Very cool site otherwise!
Re:Show HN: SQL Police Department – Learn SQL while solving ... by code_duck on Monday May 04, 2020 @01:01PM (#23070484)
I was trying to determine how to use a comma.