• 0 Posts
  • 92 Comments
Joined 2 years ago
cake
Cake day: August 9th, 2023

help-circle

  • The question reads like an XY problem, they describe DB functions for data structures so unless there’s some specific reason they can’t use a DB that’s the right answer. A “spreadsheet for data structures” describes a relational database.

    But they need rectangular structure. How do they work on tree structures, like OP has asked?

    Relationships. You don’t dump all your data in a single table. Take for instance the following sample JSON:

    JSON
      "users": [
        {
          "id": 1,
          "name": "Alice",
          "email": "alice@example.com",
          "favorites": {
            "games": [
              {
                "title": "The Witcher 3",
                "platforms": [
                  {
                    "name": "PC",
                    "release_year": 2015,
                    "rating": 9.8
                  },
                  {
                    "name": "PS4",
                    "release_year": 2015,
                    "rating": 9.5
                  }
                ],
                "genres": ["RPG", "Action"]
              },
              {
                "title": "Minecraft",
                "platforms": [
                  {
                    "name": "PC",
                    "release_year": 2011,
                    "rating": 9.2
                  },
                  {
                    "name": "Xbox One",
                    "release_year": 2014,
                    "rating": 9.0
                  }
                ],
                "genres": ["Sandbox", "Survival"]
              }
            ]
          }
        },
        {
          "id": 2,
          "name": "Bob",
          "email": "bob@example.com",
          "favorites": {
            "games": [
              {
                "title": "Fortnite",
                "platforms": [
                  {
                    "name": "PC",
                    "release_year": 2017,
                    "rating": 8.6
                  },
                  {
                    "name": "PS5",
                    "release_year": 2020,
                    "rating": 8.5
                  }
                ],
                "genres": ["Battle Royale", "Action"]
              },
              {
                "title": "Rocket League",
                "platforms": [
                  {
                    "name": "PC",
                    "release_year": 2015,
                    "rating": 8.8
                  },
                  {
                    "name": "Switch",
                    "release_year": 2017,
                    "rating": 8.9
                  }
                ],
                "genres": ["Sports", "Action"]
              }
            ]
          }
        }
      ]
    }
    

    You’d structure that in SQL tables something like this:

    Tables

    dbo.users

    user_id name email
    1 Alice alice@example.com
    2 Bob bob@example.com

    dbo.games

    game_id title genre
    1 The Witcher 3 RPG
    2 Minecraft Sandbox
    3 Fortnite Battle Royale
    4 Rocket League Sports

    dbo.favorites

    user_id game_id
    1 1
    1 2
    2 3
    2 4

    dbo.platforms

    platform_id game_id name release_year rating
    1 1 PC 2015 9.8
    2 1 PS4 2015 9.5
    3 2 PC 2011 9.2
    4 2 Xbox One 2014 9.0
    5 3 PC 2017 8.6
    6 3 PS5 2020 8.5
    7 4 PC 2015 8.8
    8 4 Switch 2017 8.9

    The dbo.favorites table handles the many-to-many relationship between users and games; users can have as many favourite games as they want, and multiple users can have the same favourite game. The dbo.platforms handles one-to-many relationships; each record in this table represents a single release, but each game can have multiple releases on different platforms.


  • Usually no, unless I’ve left a reply disagreeing then someone else comes along and downvotes them, makes me look like an ass who downvotes anyone I disagree with. I also check my own comments to see if people agree with me but I’ll keep the comment up either way, if I do change my mind I’d rather leave a new comment or add stuff in an edit.

    It’s not too difficult to bot votes on lemmy so they’re even more pointless than they are on reddit.








  • I have never heard anyone claim returning something is “extreme” before. It’s so mild it should be one of the first options you consider, especially when you ordered online and didn’t get the chance to see the item before purchase. You shouldn’t get saddled with shit just because there’s some “feature” you hate which you weren’t aware of when you bought it. For that reason where I am you’d have a legal right to return almost any order within 14 days of receipt no questions asked, or longer if there’s a defect.



  • It’s called nazism. People who defend nazis are almost certainly nazis themselves. People who claim the nazi salute was used by Romans are wrong or lying, and also probably nazis; the earliest known record of the salute in a Roman context was created a millennium after the end of the Roman empire.

    Edit: It’s probably worth noting that Hitler was likely a fan of the Roman empire. Nazi Germany was known as the “third reich” where the first was the the Holy Roman Empire and the second was the German Empire. It’s likely they appropriated the gesture thinking it was a legitimate Roman salute.









  • I can kind of see their thought processes there. They’re sharing right-wing media so they’re likely already primed for those biases, plus that article title is intentionally misleading by suggesting asylum seekers will by default get priority over all other patients. It isn’t until the sixth paragraph that they admit it’s priority care for vulnerable people which is a group that happens to include asylum seekers and undocumented migrants (terms which this writer uses interchangeably, because of course they do). Very poor journalistic integrity even for a rag like this one, imo.

    This type of article is intentionally misleading and written primarily to rile up people with poor media literacy. Making people angry makes it easier to manipulate them, and vulnerable groups are naturally less able to fight back so they’re an easy target.

    In an ideal world after being challenged they would have reevaluated the source and their beliefs. In practice very few people do that and they just get more entrenched instead. Especially if it’s someone anonymous online just telling them they’re wrong.