Live data from Hacker News

Viewing profile — doronlinder

doronlinder

HN member
Joined
Mon, Apr 23, 2012, 7:57 PM UTC
HN karma
265
Public activity
29 items

About doronlinder

No profile information was provided.

Recent public activity

  1. comment
    Comment #23078929

    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 (w…

  2. comment
    Comment #23078883

    Deployed a fix. Backspace is captured now.

  3. comment
    Comment #23074170

    I'm missing it. Where's the typo?

  4. comment
    Comment #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…

  5. comment
    Comment #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…

  6. comment
    Comment #23072341

    Thanks for the feedback! I was wondering the same thing.

  7. comment
    Comment #23072329

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

  8. comment
    Comment #23072279

    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 so…

  9. comment
    Comment #23070894

    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 fee…

  10. comment
    Comment #23070860

    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 O…

  11. comment
    Comment #23070800

    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.…

  12. comment
    Comment #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 keyboar…

  13. comment
    Comment #23070734

    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.…

  14. comment
    Comment #23070327

    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. comment
    Comment #23068466

    Good call. I will.

  16. comment
    Comment #23068456

    This was certainly an inspiration.

  17. comment
    Comment #23068442

    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. D…

  18. story
  19. comment
    Comment #3886734

    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. comment
    Comment #3886723

    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 V…

  21. comment
    Comment #3886693

    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 ema…

  22. comment
    Comment #3880892

    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 …

  23. comment
    Comment #3880875

    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 necess…

  24. comment
    Comment #3880844

    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 …

  25. comment
    Comment #3880823

    Thanks! I'm at a loss for words. It's very kind of you.