Notices by cyberpunklord420 (ehhh@varishangout.net), page 21

@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!

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

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