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.
[ Parent
| on HN ]
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.