For Amusement Purposes Only

The High Corvid of Progressivity

Chance favors the prepared mind.

~ Louis Pasteur

  • 111 Posts
  • 104 Comments
Joined 2 years ago
cake
Cake day: June 20th, 2023

help-circle













  • Lotta smarter people than me have already posted better answers in this thread, but this really stood out to me:

    the thing is. my queries are not that complex. they simply go through the whole table to identify any duplicates which are not further processed then, because the processing takes time (which we thought would be the bottleneck). but the time savings to not process duplicates seems now probably less than that it takes to compare batches with the SQL table

    Why aren’t you de-duping the table before processing? What’s inserting these duplicates and why are they necessary to the table? If they serve no purpose, find out what’s generating them and stop it, or write a pre-load script to clean it up before your core processing queries access that table. I’d start here - it sounds like what’s really happening is that you’ve got a garbage query dumping dupes into your table and bloating your db.











  • Current context:

    RFK Jr. Set to Launch Disease Registry Tracking Autistic People

    Summary:


    Robert F. Kennedy Jr. is using private medical records to create a registry of people with autism in the United States.

    The National Institutes of Health is helping to collect private medical records from government and commercial databases to give to the secretary of health and human services, NIH Director Dr. Jay Bhattacharya said Monday. The records include prescription records from pharmacies, lab testing, and genomics records from the Department of Veterans Affairs and Indian Health Service, private insurance claims, and data from smartwatches and fitness trackers.


    Historical Context:

    8/18/1939

    German officials ordered the registration of all newborn babies and children under three years of age who showed signs of severe mental or physical disabilities. This order highlighted the participation of midwives. They were paid a small sum for each infant they reported. Parents were encouraged to surrender their children with disabilities to the care of state-run residential clinics. There, medical staff secretly murdered the children by starvation or lethal injection.

    As German policymakers shifted the country’s economy onto a war footing, they began to view people with disabilities as a financial, as well as genetic, burden. The so-called “racial hygiene” policies of Nazi Germany took a radical turn. Portrayed falsely in propaganda as “mercy deaths,” the secret, so-called “euthansia” program soon expanded to include adults with disabilities as well.


    Aktion T4 - September, 1939:

    Aktion T4 (German, pronounced [akˈtsi̯oːn teː fiːɐ]) was a campaign of mass murder by involuntary euthanasia which targeted people with disabilities in Nazi Germany. The term was first used in post-war trials against doctors who had been involved in the killings. The name T4 is an abbreviation of Tiergartenstraße 4, a street address of the Chancellery department set up in early 1940, in the Berlin borough of Tiergarten, which recruited and paid personnel associated with Aktion T4. Certain German physicians were authorised to select patients “deemed incurably sick, after most critical medical examination” and then administer to them a “mercy death” (Gnadentod). In October 1939, Adolf Hitler signed a “euthanasia note”, backdated to 1 September 1939, which authorised his physician Karl Brandt and Reichsleiter Philipp Bouhler to begin the killing.

    The killings took place from September 1939 until the end of World War II in Europe in 1945. Between 275,000 and 300,000 people were killed in psychiatric hospitals in Germany and Austria, occupied Poland and the Protectorate of Bohemia and Moravia (now the Czech Republic). The number of victims was originally recorded as 70,273 but this number has been increased by the discovery of victims listed in the archives of the former East Germany. About half of those killed were taken from church-run asylums, often with the approval of the Protestant or Catholic authorities of the institutions.








  • Side note for instance owners - the Turks are fucking insane about this shit. Twenty years ago I was hosting an artist’s website. One of the users was from Cyprus and posted pictures from the aftermath of a riot there - nothing extreme, just some graffiti and broken windows.

    I started receiving threatening messages (this was early 2000s, so before takedown notices) from someone claiming to be from the Turkish government. I ignored them, as they had no legal authority and fuck autocrats straigtht up Edrogan’s ass.

    So then, the site gets taken down by a hacking attack the next week. Some sort of Turkish bullshit appeared on the front page. I fixed it, thought I locked them out.

    It was hacked again. I thought I missed something, and when through an even more extreme lockdown process, banning the entire country’s IP.

    It was hacked a third time. That’s when I realized they weren’t hacking my site - they were hacking the hosting provider. I proved it by switching providers - the attacks stopped immediately.

    That’s how extreme they were about suppressing this stupid picture of a broken window from a riot no one remembered even a week after it happened.