Linux server admin, MySQL/TSQL database admin, Python programmer, Linux gaming enthusiast and a forever GM.

  • 1 Post
  • 29 Comments
Joined 2 years ago
cake
Cake day: June 8th, 2023

help-circle



  • Read their comment and I’m left scratching my head. Their role in security with the straight android phone (not the /e/OS version) is simply pushing security patches as/when they get them from the Android team, as they’re using straight Android. Security is handled by Google for Android, not them. When it comes to /e/OS, no idea how good/bad it is, but apparently Graphene has some beef with Murena (the people who make it), at least according to their comment.

    Not at all knowledgable about mobile kernels and drivers to comment on the rest of it. I do know Fairphone 5 uses an unusual CPU normally used for SoC as that was the only CPU that was both good enough to run Android reasonably while simultaneously providing very long-term driver updates (they’re aiming for a minimum of 8 years of updates).




  • If you’re interested, the short version is that instances (A.K.A servers) are run by different people in different places. A reason to move instances might be:

    1. My admin, the owner of the instance, has been doing things I heavily disagree with (bans, blocks, etc)

    2. I don’t agree with the rules on my instance.

    3. The instance is run in a country which criminalizes something that I care about, and so has to ban discussion of that thing (piracy, porn, etc).

    4. I want to run a community on a specific instance for whatever reason, and so need an account there





  • In Uni I ran Gentoo as my daily driver. It was stupid, but I learned a lot.

    Trying and failing to get a working desktop environment, using IRC on the command line to get help from people who knew what they were doing and could advise a dumb kid like me, following their advice and getting a working DE after a reboot was the most hackerman I ever felt. I was convinced I was real hot shit. In actuality, I’d followed the advice to tweak the kernel config to get working drivers :))


  • Please don’t lump trademarks with the rest. Makers have stamped their goods with their mark since ancient times, both as advertising and to signify quality products (and not knockoffs). Swords were especially commonly marked with the smith’s trademark.

    It was illegal to sell bread in ancient Rome without a trademark, for example. The punishments for doing so were harsh, as they wanted to be able to track down the baker if someone sold tainted bread.

    In modern days, they’re useful for customers to know what company they’re buying from.





  • It’s necessary to split it out into different tables if you have a one-to-many relationship. Let’s say you have a list of driver licenses the person has had over the years, for example. Then you’d need the second table. So something like this:

    SSN_Table

    ID | SSN | Other info

    Driver_License_Table

    ID | SSN_ID | Issue_Date | Expiry_Date | Other_Info

    Then you could do something like pull up a person’s latest driver’s license, or list all the ones they had, or pull up the SSN associated with that license.


  • Theoretically, yeah, that’s one solution. The more reasonable thing to do would be to use the foreign key though. So, for example:

    SSN_Table

    ID | SSN | Other info

    Other_Table

    ID | SSN_ID | Other info

    When you want to connect them to have both sets of info, it’d be the following:

    SELECT * FROM SSN_Table JOIN Other_Table ON SSN_Table.ID = Other_Table.SSN_ID

    EDIT: Oh, just to clear up any confusion, the SSN_ID in this simple example is not the SSN itself. To access that in this example query, it’d by SSN_Table.SSN




  • There’s another factor that nobody mentioned: the sales tax in EU countries is different for different products. This allows countries to incentive or disincentivize different classes of products by ramping the sales tax up or down. Higher tax on junk food, cigarettes and/or alcohol, low or nonexistent sales tax for basic ingredients and medicine.

    Interestingly, France and the Czech republic tax wine and beer respectively like basic food.