doronlinder

6 ms·

1.
by doronlinder 6y ago
Thank you for the feedback. The SQL parsing is home made and I assumed fields in the order by clause is also a part of the SELECT. I collect a window of failed queries in memory (without knowing who sent what) to find cases like this and fi
2.
by doronlinder 6y ago
Deployed a fix. Backspace is captured now.
3.
by doronlinder 6y ago
I'm missing it. Where's the typo?
4.
by doronlinder 6y ago
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, n
5.
by doronlinder 6y ago
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.
6.
by doronlinder 6y ago
Thanks for the feedback! I was wondering the same thing.
7.
by doronlinder 6y ago
It can be solved with saving stuff to local storage, but I tried to not use it to be more GDPR compliant...
8.
by doronlinder 6y ago
The first two are cases of selecting the whole table. Since it's (completely) randomised, there is a chance of getting the same table twice. I didn't account for that :-P If you solve it again, you'll get a new case following
9.
by doronlinder 6y ago
I was aiming for a feeling of dealing with real data (even though it's not). Changing the email domain names to fictitious ones will solve this, but I think would undermine the feeling of real-ness.
10.
by doronlinder 6y ago
Thanks! The game is still in development. It covers SELECT, DISTINCT, FROM (with one table), ORDER BY, LIMIT in the free part. After buying a license, WHERE, IN, BETWEEN, AND and OR are also covered. Check out the guide tab in the game - i
11.
by doronlinder 6y ago
Currently the first rank is 11 cases, and the second rank is 20 additional cases. The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR. Check out the guide tab in the game - it covers everything
12.
by doronlinder 6y ago
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.
13.
by doronlinder 6y ago
Currently the first rank is 11 cases, and the second rank is 20 additional cases. The second rank covers WHERE with numbers, strings, dates and timestamps, IN, BETWEEN, AND and OR. Check out the guide tab in the game - it covers everything
14.
by doronlinder 6y ago
Yes, the instructions as well as the levels and the data are auto generated. If something sounds off, please email me and I'll fix it.
15.
by doronlinder 6y ago
Good call. I will.
16.
by doronlinder 6y ago
This was certainly an inspiration.
17.
by doronlinder 6y ago
Everything is randomised, nothing is based real data. It's auto generated from popular first names, last names, changing patterns and random years or numbers attached at the end. Domains are real, but randomised as well.
18.
Show HN: SQL Police Department – Learn SQL while solving crimes(sqlpd.com)
550 points by doronlinder 6y ago|86 comments
19.
by doronlinder 14y ago
It wasn't meant to work on mobile devices. It can and everything work as expected besides the fact that you must have a fully functional keyboard to use it and learn VIM.
20.
by doronlinder 14y ago
Your fingers should stay on JKL;. Going left involves lifting your index finger and moving it the the left, pressing H, and returning it back to J. When you're more proficient in VIM, you usually don't use h much, but ^ or 0 or T or F or b,
21.
by doronlinder 14y ago
I fixed the 30 characters issue to allow up to 70 characters. And you may also use + signs in emails. The SMTP error doesn't occur anymore, and even when there was an error the email was still subscribed so no need to resubscribe again.
22.
by doronlinder 14y ago
The only reason I can think of is that the browser didn't download the images from the server due to extream load on the server. I'm experiencing some server problems and opened a support ticket with my hosting company. If the problem persi
23.
by doronlinder 14y ago
Thanks. I agree that a .vimrc level will be a stretch. I had some ideas on how to incorporate that to, but I think I'll leave it out. Once you get modal editing and know all necessary commands, motions, and operators to use, tweaking your .
24.
by doronlinder 14y ago
The target of the first level was to cover hjkl. I know it's a pain and when you're proficient enough you usually don't use them but use tf*#/ and such, but it's the basics... The motions are working only on text areas (There are some on th
25.
by doronlinder 14y ago
Thanks! I'm at a loss for words. It's very kind of you.
26.
by doronlinder 14y ago
Nice catch! Actually, that's one of the places where a B would come in handy, but it's only collected in level 3 so the chest can't be accessed yet :)
27.
by doronlinder 14y ago
I managed to crash chrome once, but couldn't reproduce it. I'm an indie developer so I don't have enough people QAing the product yet :/ My first gut feeling is the audio, but didn't have a chance to prove it yet. It would be great if you'l
28.
by doronlinder 14y ago
I'm happy that you loved the game and finished the first two levels! Thank you for your feedback. That kind of feedback is what I'm looking for in this stage. The project is intended as an educational game, but for a price. The first stages
29.
by doronlinder 14y ago
Thank you very much for mentioning my site here! The problem with the email signup is that I exceeded the maximum 500 mails that google outgoing mail server allows per day (500). All emails are entered to the list first, even if the confirm