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

help-circle

  • Am I misreading this or are their arguments all complete nonsense? From what I can see in the article they have:

    1. They have to allow third-party headphones, i.e. the anti-monopoly policy prevents a monopoly.

    Among the requirements of the DMA is that Apple ensures that headphones made by other brands will work with iPhones. It said this has been a block on it releasing its live translation service in the EU as it allows rival companies to access data from conversations, creating a privacy problem.

    1. Other companies will “twist laws” to prevent competition, i.e. exactly what Apple is trying to do by removing regulation. I don’t see any way to interpret this other than an outright lie, anti-monopoly policies encourage competition.

    Apple said that under the DMA, “instead of competing by innovating, already successful companies are twisting the law to suit their own agendas – to collect more data from EU citizens, or to get Apple’s technology for free”.

    1. Porn exists? I don’t even know what they’re trying to say with this one?

    It said that rules under the act affected the way it provided users access to apps. “Pornography apps are available on iPhone from other marketplaces – apps we’ve never allowed on the App Store because of the risks they create, especially for children,” it said.



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