Conversation

Notices

1. cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:33 JST cyberpunklord420

   in reply to

   • cyberpunklord420
   • hazlin

   @hazlin Honestly, SQL is “deceptively simple” for a visual learner like me; I’ve had fewer trip-overs with Javascript because it visually displays animations to me in a way that makes sense, for the most part. :awoo_think:

   SQL is not supposed to be that hard because it’s just a way of querying data, so it has limited commands. But for some reason, I’ve been struggling in this course a lot by myself.

   This is Unit 3 Lesson 2 Project of Khan Academy, I’m using this data to practice: https://gist.github.com/pamelafox/26b9357c6120d3d0d27c2b90c950e8c6

   In the first picture, it’s just max, min, and average. Simple enough.

   The second one, was difficult and I couldn’t write it by myself - my husband wrote it and explained it to me instead. Basically, I have to think about what I want displayed in my columns, and write them first, then write where to get the data from, and THEN write any additional filters last. It’s… A different sequence of logic than what I’m used to, so because of that I also had a really difficult time of knowing what goes where.

   And the last one I did by myself - with how you use CASE in SQL, ppl structure it in a way that makes it easier for me to understand, so that overall wasn’t too hard.

   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:33 JST cyberpunklord420

     in reply to

     • Phantom Palladium

     @hazlin For my next project, I am creating an app database where people raise a Tamagotchi, and I will directly modify this SQL data. The initial values are as follows:

     CREATE TABLE tamagotchi (id AUTOINCREMENT PRIMARY KEY, username TEXT, tamagotchi TEXT, hunger TEXT, happy TEXT, money INTEGER, generation INTEGER, alive TEXT); INSERT INTO tamagotchi VALUES (1, "TamaStar", "Mametchi", 4, 2, 200, 1, "yes"); INSERT INTO tamagotchi VALUES (2, "GolemPrincess", "Memetchi", 3, 4, 1500, 4, "yes"); INSERT INTO tamagotchi VALUES (3, "Kira", "Kuchipatchi", 0, 0, 100, 3, "yes");

     SELECT * FROM tamagotchi; (image 1)

     Here is where my database started tracking its users. You can see their id which auto increments based on who signed up first, their username, the specie of Tamagotchi that they have, the tamagotchi’s health (hunger and happiness), how much money they have, the current generation of their pet, and if it is presently dead or alive.

     Uh-oh, it looks like Kira’s Kuchipatchi has died, so I will update it accordingly. (image 2)

     UPDATE tamagotchi SET alive = "no" WHERE id = 3; SELECT * FROM tamagotchi;

     Kira has now decided to deactivate his account, and with that, his id and all relevant data will be erased from the database: (image 3)

     DELETE FROM tamagotchi WHERE id = 3; SELECT * FROM tamagotchi;

     Updating and deleting data was a lot easier to learn than aggregating and merging data. Funnily enough, it is also the most dangerous operation.

   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:33 JST cyberpunklord420

     in reply to

     • Phantom Palladium
     @hazlin UNIT 4:
     
     For this unit, the lessons aren't holding your hand anymore. I dunno if they ran out of budget to make videos but the articles are not as helpful to me.
     
     Here's the assigned project: https://www.khanacademy.org/computing/computer-programming/programming-games-visualizations/side-scroller/pp/project-hoppy-beaver-extreme
     
     I chose to add in inverted collision which - was kinda weird that it was suggested in the first place because it was never taught, so I had bae help me with that. But, collision just sucks in general when you're doing it from scratch, it's just too much math.
     
     Anyways, you can play my version of the minigame by copy/pasting my .js contents into Khan Academy or whatever.
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:34 JST cyberpunklord420

     in reply to

     • hazlin
     @hazlin Uhhh so I'm on Unit 2 now and I guess I'm relearning some html/css basics
     
     Some things I learned were what ids and classes are. Yes I didn't figure out what #s and .s meant when I was playing with stylebot on different sites or crafting my own website. 😂 Anyways this is my project where I've utilized classes. And please don't laugh at me I know that the page looks dumb and silly but I couldn't think of anything else..
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:34 JST cyberpunklord420

     in reply to

     • hazlin
     @hazlin Learning SQL now!! It's a little confusing honestly, you have to declare the commands in a specific order.
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:35 JST cyberpunklord420

     in reply to

     • hazlin
     @hazlin This one was hard. It's just rainbow rain but in code it was actually complicated. I had to revisit previous lessons and even got help from my bf to help me figure things out. This is also a good place where I should start writing notes for my own code. ^^'
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:35 JST cyberpunklord420

     in reply to

     • hazlin
     @hazlin Some books (1 book) and anime. The project was to build a bookshelf. But since I don't read books and I've only published one, I just put some animes at the bottom.
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:36 JST cyberpunklord420

     in reply to
     A magic 8 ball! This section is pretty fun. What will you ask the 8 ball?
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:36 JST cyberpunklord420

     in reply to

     • hazlin

     @hazlin I’m learning loops now. It’s kind of confusing but I’m getting the hang of it. This was fun to make tbh!

   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:37 JST cyberpunklord420

     in reply to

     • Gold (hazlin)
     @hazlin lol damn... animation was significantly more challenging 😂 I think I've spent a stupid amount of time on the triangles (too many positions) really have to make use of vars a lot too because you don't want everything moving at once.
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:37 JST cyberpunklord420

     in reply to
     @hazlin@squid.kids I drew a funny tadpole. You can control his mouth size by moving your cursor (he is very hungry)
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:37 JST cyberpunklord420

     in reply to
     @hazlin@squid.kids
   • cyberpunklord420 (ehhh@varishangout.net)'s status on Saturday, 16-Sep-2023 15:04:38 JST cyberpunklord420

     • Gold (hazlin)

     @hazlin 🦴 BONE 🍎 SNAPPLE 🦷 TEETH 💥💥💥💥