• 118 Posts
  • 3.81K Comments
Joined 3 years ago
cake
Cake day: October 4th, 2023

help-circle





  • Plans To Ban Kids From Watching YouTube

    As well as:

    https://www.npr.org/2024/11/28/g-s1-36142/australia-social-media-ban-children

    The law will make platforms including TikTok, Facebook, Snapchat, Reddit, X and Instagram liable for fines of up to 50 million Australian dollars ($33 million) for systemic failures to prevent children younger than 16 from holding accounts.

    https://en.wikipedia.org/wiki/Online_Safety_Amendment

    It sounds like, from my quick skim, that their criteria would also apply to the Threadiverse, as I don’t see any sort of userbase size or revenue restrictions on their definition of its scope. Here’s the bill text:

    (1) For the purposes of this Act, age-restricted social media platform means:
    (a) an electronic service that satisfies the following conditions:
    (i) the sole purpose, or a significant purpose, of the service is to enable online social interaction between 2 or more end-users;
    (ii) the service allows end-users to link to, or interact with, some or all of the other end-users;
    (iii) the service allows end-users to post material on the service;
    (iv) such other conditions (if any) as are set out in the legislative rules; or
    (b) an electronic service specified in the legislative rules;but does not include a service mentioned in subsection (6).
    Note 1: Online social interaction does not include (for example) online business interaction.
    Note 2: An age-restricted social media platform may be, but is not necessarily, a social media service under section 13.19
    Note 3: For specification by class, see subsection 13(3) of the Legislation Act 2003.

    Subsection (6):

    (6) An electronic service is not an age-restricted social media platform if:
    (a) none of the material on the service is accessible to, or delivered to, one or more end-users in Australia; or
    (b) the service is specified in the legislative rules.

    I’m sure that there will be more discussion on this that will probably clarify it.

    For the moment, I’m pretty confident based on past case law that the US legal system won’t consider a US-based Threadiverse instance that isn’t actively doing something like advertising to users specifically in Australia or selling products to Australia to be within the legal jurisdiction of Australia, as it won’t be doing business in Australia, so the US legal system will not enforce Australian law against it. Australia might block a node but shouldn’t be able to fine someone, so blacklisting Australian IP addresses or the like probably isn’t necessary. One notable issue: I don’t know off the top of my head whether instances accepting donations from Australian users could be affected.

    I don’t know what the EU’s position on Internet jurisdiction is.

    That might be a much more substantial problem for Australia-based instances, like — to name one that comes to mind — aussie.zone.












  • Oh, we can’t take all the credit.

    https://en.wikipedia.org/wiki/Eurasian_brown_bear

    Brown bears could once be found across most of Eurasia, compared to the more limited range today. General habitats included areas such as grassland, sparsely vegetated land, and wetlands.

    Although included as of Least Concern on the 2006 IUCN Red List of Threatened Species (which refers to the global species, not to the Eurasian brown bear specifically), local populations, specifically those in the European Union, are becoming increasingly scarce.[16] As the IUCN itself adds: “Least Concern does not always mean that species are not at risk. There are declining species that are evaluated as Least Concern.”

    The brown bear has long been extinct in Britain (at least 1,500 years ago, possibly even 3,000 years ago),[17][18] Denmark (about 6,500 years ago),[19] the Netherlands (about 1,000 years ago, although later singles rarely wandered from Germany),[20] Belgium and Luxembourg, with more recent extinctions in Germany (in the year 1835, although singles wandering from Italy were recorded in 2006 and 2019),[21][22] Switzerland (in 1904, although a single was seen in 1923 and since 2005 there has been an increasing number of sightings of wanderers from Italy),[23][24] and Portugal (in 1843, although a wanderer from Spain was recorded in 2019).[25]

    The largest brown bear population in Europe is in Russia, where it has now recovered from an all-time low caused by intensive hunting.


  • https://en.wikipedia.org/wiki/Flag_of_California

    The Bear Flag is the official flag of the U.S. state of California.[2] The precursor of the flag was first flown during the 1846 Bear Flag Revolt and was also known as the Bear Flag.

    The 1911 statute stated:

    The bear flag is hereby selected and adopted as the state flag of California. … The said bear flag shall consist of a flag of a length equal to one and one-half the width thereof; the upper five-sixths of the width thereof to be a white field, and the lower sixth of the width thereof to be a red stripe; there shall appear in the white field in the upper left-hand corner a single red star, and at the bottom of the white field the words ‘California Republic,’ and in the center of the white field a California grizzly bear upon a grass plat, in the position of walking toward the left of the said field; said bear shall be dark brown in color and in length, equal to one-third of the length of said flag.

    https://en.wikipedia.org/wiki/California_grizzly_bear

    Grizzly bear meat became a mainstay on restaurant menus in the San Gabriel area; according to Mike Davis, “The paws from adult bears and the flesh from young cubs were deemed particular delicacies.”[39]

    In 1866, a grizzly bear described as weighing as much as 2,200 pounds (1,000 kg) was killed in what is present-day Valley Center, California, in the north-central area of San Diego County. The incident was recalled in 1932 by Catherine E. Lovett Smith, who witnessed the bear’s killing on her family’s ranch when she was just six years old. If its measurements are accurate, this particular bear was the biggest bear ever found in California and one of the largest specimens of any bear species ever recorded.

    Extinction

    The last hunted California grizzly bear was shot in Tulare County, California, in August 1922, although no body, skeleton or pelt was ever produced. Less than 75 years after the discovery of gold in 1848, almost every grizzly bear in California had been tracked down and killed. In 1924, what was thought to be a grizzly was spotted in Sequoia National Park for the last time and thereafter, grizzlies were never seen again in California.

    Apex predators tended not to have evolved the instinct to hide, which served them poorly when Earth’s superpredator decided that they were delicious.


  • goes looking for the issue

    PostgresSQL has a limit of 65,535 parameters, so bulk inserts can fail with large datasets.

    Hmm. I would believe that there are efficiency gains from doing one large insert rather than many small — like, there are probably optimizations one can take advantage of in rebuilding indexes — and it’d be nice for database users to have a way to leverage that.

    On the other hand, I can also believe that DBMSes might hold locks while running a query, and permitting unbounded (or very large) size and complexity queries might create problems for concurrent users, as a lock might be held for a long time.

    EDIT: Hmm. Lock granularity probably isn’t the issue:

    https://stackoverflow.com/questions/758945/whats-the-fastest-way-to-do-a-bulk-insert-into-postgres

    One way to speed things up is to explicitly perform multiple inserts or copy’s within a transaction (say 1000). Postgres’s default behavior is to commit after each statement, so by batching the commits, you can avoid some overhead. As the guide in Daniel’s answer says, you may have to disable autocommit for this to work. Also note the comment at the bottom that suggests increasing the size of the wal_buffers to 16 MB may also help.

    is worth mentioning that the limit for how many inserts/copies you can add to the same transaction is likely much higher than anything you’ll attempt. You could add millions and millions of rows within the same transaction and not run into problems.

    Any lock granularity issues would also apply to transactions.

    Might be concerns about how the query-processing code scales.


  • Consumer acceptability is key, acknowledges Mr Eiden. Most people don’t want to look like cyborgs: “We need to make our products actually look like existing eyewear.”

    looks dubious

    I can believe that most people want something that they consider stylish. However, I’m skeptical that most people specifically want something to look like existing stuff. Clothing has shifted a lot over the years and centuries; it’s not as if every person putting something on their body said “it has to look like the stuff that’s come before”, or present-day vision equipment would look like this:

    Or this: