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

  • 6 Posts
  • 267 Comments
Joined 2 years ago
cake
Cake day: June 8th, 2023

help-circle

  • Here’s the long version.

    Short version is that in WW1, the UK conquered Palestine from the Ottoman empire. 1922-1948, the British ran the territory, getting shot at regularly by both native Arabs, the tiny number of native Jews, and the comparatively much larger group of immigrant Jews. In the 1940s, the UK asked for and got US help with counterterrorist operations, especially against Jewish ones. Arabs and Jews pinky promised to play nice with each other if the UK left, so rather than continue getting shot by everyone in the region, they left. They immediately started a war as soon as the UK army left. Then, every single neighbouring country attacked the newly formed Israel, which they somehow survived.

    (Missing HUGE amounts of context and nuance here, obviously)



  • 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



  • 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










  • Technically yes, but I don’t mean technology as phones/laptops/tablets/etc. Imho, the biggest factor in social isolation is atomization due to bad urban planning. When everything and anything is only accessible by car, you lose any connection with your local neighbourhood and local stores/cafes/etc.

    In environments where people walk around the neighbourhood, doing small daily shops, going to local businesses and taking mass transit to work/school/restaurants/bars, then you’re much more likely to interact with people rather than driving around in your social isolation-mobile.

    Urban planning can be considered a form of technology, which is why I said technically yes.

    EDIT: Oh, another big factor here is the loss of the third place. It still exists in some places (local pubs in British towns, local coffee shop in Portugal, etc), but in places without a socially normal “hangout spot” that is separated from both home and work/school, it’s much harder to meet acquaintances which may in time become friends.