robinLord

34 ms·

1. 1.▲
   I made a HTML and CSS platforming game(divided-we-fall.therobinlord.com)

   3 points by robinLord 2y ago|1 comments
2. 2.▲
   by robinLord 2y ago

   For a while I've had the idea in the back of my head, of a game where someone can learn HTML and CSS by actually jumping across/ interacting with the things they are creating and changing. Normally I'm sure that using canvas
3. 3.▲
   by robinLord 3y ago

   Update! - Have made spec for "Case" clearer and added difficulty ratings in the challenge listing page - Have fixed some silly typos (thanks for that) including calling the captain Sir regardless of name/profile pic chosen -
4. 4.▲
   by robinLord 3y ago

   Thanks! Adding to the list of updates
5. 5.▲
   by robinLord 3y ago

   Yea sorry, unfortunately not something the SQL library I used supports, select * is the best for now but I'm adding "table preview" to the list for future updates!
6. 6.▲
   by robinLord 3y ago

   Thank you! I'm pushing a fix for this shortly!
7. 7.▲
   by robinLord 3y ago

   Thank you! Really appreciate the kind words! Funnily enough I did something kind of like this a while back, WAY less involved; https: https://www.therobinlord.com/projects/slash-escape I have been thinking SQL is gettin
8. 8.▲
   by robinLord 3y ago

   Erk, the most frustrating of bugs - an inconsistent one! I think you're hitting errors because in the background I'm adding the queried together in "with" statements and "with" can't have a ; at the end in
9. 9.▲
   by robinLord 3y ago

   That's wonderful news! So glad you've had fun. I've tried to hit a bit of a balance between english-sounding instructions and being clear on table columns, will definitely note this down to think more about
10. 10.▲
    by robinLord 3y ago

    A charitable read! Just a screw up on my part. A lot of this ended up quite hard-coded so when I updated tables sometimes I missed updating some instructions. Thanks for spotting! And very glad you've been enjoying it aside from that!
11. 11.▲
    by robinLord 3y ago

    Definitely open to feedback in that regard! Somewhat embarrassingly In both English and have a degree in English... but I had massive scope creep on this and was usually smashing out bits on planes, trains, and automobiles so tried to catch
12. 12.▲
    by robinLord 3y ago

    Thanks very much! Should have caught that
13. 13.▲
    by robinLord 3y ago

    Yea I totally get it - I face a similar challenge when it's something I'm more clued up on. That is brilliant news that you gave it a try and enjoyed it, even better that you learned something! Thanks again for the time you took t
14. 14.▲
    by robinLord 3y ago

    Yep! I have put a bit of thought into why this still matters and I'm not attempting to plug a twitter thread but I laid out a lot of my logic for why we should still bother to know this stuff here; https://twitter.com/R
15. 15.▲
    by robinLord 3y ago

    Thanks! Really appreciate that! Hmm that is frustrating, you can't just tap the text area? I think I do need to have another look about how the autosuggest places the cursor back in the box. Good feedback I'll add it to the list!
16. 16.▲
    by robinLord 3y ago

    Hey all! Thanks so much for giving the game a try and for the feedback! This was a big learning project for me and I really appreciate the time. Quick things that might help anyone who is yet to give it a go; - You can switch off/speed
17. 17.▲
    by robinLord 3y ago

    Thanks, yea as you say this was a matter of having a library that could reliably/realistically handle the SQL. I found some other libraries but they were a facsimile of SQL rather than behaving like any specific standard. Thanks for th
18. 18.▲
    by robinLord 3y ago

    This is a great thread! As you might imagine I put in a lot of thought about whether Chat GPT made learning this stuff obsolete. Conclusion I came to is that those tools make this all more accessible (in terms of helping people to avoid thi
19. 19.▲
    by robinLord 3y ago

    Thanks for the kind words! All good points about the clunkiness, most of the UX improvements I added came from my frustrations just while developing the game and testing correct answers but I agree it's far from fluid. TBH eventually t
20. 20.▲
    by robinLord 3y ago

    Thank you! Appreciate that :-) Really good point, I should have caught that! Adding it to the list to update
21. 21.▲
    by robinLord 3y ago

    Thanks for the feedback! This was a definite learning project for me (main motivation was to learn something about JS web dev) so I've clearly missed that - will have a look at fixing it or as you say at least giving a more informative
22. 22.▲
    by robinLord 3y ago

    Thanks for the feedback! Yea I wanted to give people a way to select columns from a table (or see columns in a table) if they didn't know them or couldn't remember them but I think as a few people have said I probably need to thin
23. 23.▲
    by robinLord 3y ago

    Thanks yea Midjourney was a game changer for this! Really opened up the option to double down on a theme. If I had more time I would have liked to do more prompt engineering to have specific characters reoccur but as is it I already had wil
24. 24.▲
    by robinLord 3y ago

    Thank you so much! Really appreciate it :-) Funnily enough I got that feedback with the last game I made (regex one called Slash\Escape) so I added in the option to switch off the typewriter or change the speed in the menu :-)
25. 25.▲
    by robinLord 3y ago

    Thanks for this! My broad aim was that people who want to learn could do story mode and the people who already know it can do the challenges. "Pudding" in particular is designed as a PITA test. Yea maybe I add something that allow
26. 26.▲
    by robinLord 3y ago

    Thanks for this! Hmm might be something odd coming in with the way I'm smushing together the steps using with. Could you share what you wrote for step 1? I thought I had a fix in place for anything ending in ; but there could be other
27. 27.▲
    by robinLord 3y ago

    Thanks very much! I'll definitely have a look!
28. 28.▲
    by robinLord 3y ago

    Thanks! TBH I'm specifying all columns because the output will be expecting certain columns and even if the where clause is correct the test will fail unless the columns are right :-)
29. 29.▲
    by robinLord 3y ago

    Thanks for the feedback! Will have a look!
30. 30.▲
    by robinLord 3y ago

    Thanks so much!