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

help-circle
  • There’s plenty of examples of software doing this right and displaying each language in the selector in that language, it’s hard to say why they’ve localised it here. Most likely they just didn’t consider how the user interacts with that element and localised it the same way they translate everything else, but that could be down to anyone from the developer habitually running everything through localisation to company policy where they couldn’t get an exception for that element.

    You’d have to ask support for whatever software you’re using for more detail, chances are you won’t get anything useful back but if you’re lucky they might fix it.


  • 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": "[email protected]",
          "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": "[email protected]",
          "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 [email protected]
    2 Bob [email protected]

    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.




  • This specific case isn’t really to do with the evolution of language, more just ineffective linguistic prescriptivism. Some guy 200 years ago decided they didn’t like how “less” had been used for the past millennium so they made up a guideline for what the preferred (like what you just said) then people decided to treat that as an actual rule. Obviously it’s still common to use “less” that way even after a couple of centuries of people trying to enforce that rule, it’s a good demonstration of how prescriptivism is a waste of time.

    Strangely enough, in my experience many prescriptivists who rely on etymological arguments are fine with language changing for this one rule. Makes me think they never really did care about historic usage of a word.






  • The important factor isn’t whether someone can be addicted (otherwise you’re banning nearly everything), it’s the harm that addiction causes. As a general rule of thumb physical dependencies like alcohol are more harmful than habitual addictions, but that obviously isn’t the whole story.

    Caffeine addiction is the same category as alcohol and tobacco but causes so little harm that I don’t think anyone is seriously opposed it. On the other end of that scale is something like meth or other hard drugs, generally understood as destructive and has few serious supporters encouraging use. Breaking these addictions is almost always hard and physically taxing, in some cases can even be lethal.

    Marijuana addiction is in the same category as most things that make you feel good or form habits so it’s harder to nail down a proper scale, but the lower end is probably something like video games; a debilitating addiction is possible but uncommon and most people would oppose a blanket ban on the basis of “can be addictive”. Gambling is on the other end can definitely ruin lives. I’d say that’s a little worse than coffee. Breaking these addictions is more like breaking a bad habit, it can feel hard for the addict but generally isn’t going to kill them.





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