So how does that SQL statement make it into the database in the first place?
Yeah, same kind of process in Oz.
AFAIK, it was triggered by doing an annual event called GovHack where people were encouraged to create "hacks" with government data. It included software developers like me, data mentors from many different government departments, people with an interest and several departments with questions.
Darwinian selection in progress ..
For anyone reading this.
From personal experience, have a shower daily, go for a walk, even if it's only to the end of your garden or street and drink plenty of water. Sleep if you need to.
This won't fix things, but it will give you an opportunity to give yourself a break.
In my experience, beating yourself up about everything you suck at is the single biggest thing that made it worse for me.
Finally, talk to someone, anyone. In the street, at the bus, at work, friends, family, online, anyone.
This too will pass.
You do know that the USA is also a signatory to the Christchurch Call?
It agreed to (among other things):
"Counter the drivers of terrorism and violent extremism by strengthening the resilience and inclusiveness of our societies to enable them to resist terrorist and violent extremist ideologies, including through education, building media literacy to help counter distorted terrorist and violent extremist narratives, and the fight against inequality."
Law works by mutual agreement. This is how our global system hangs together. Just because this is being spearheaded by an Australian process, doesn't make it apply only to Australia.
This same process happens every day across the world. The only difference here is that the person on the other end is pretending that this is about free speech.
Where's the hue and cry from all the other platforms who just took it down? Are they perhaps more aware of how this works?
Edit:
Perhaps this is stating the obvious, but the Christchurch Call came into existence after a terrorist massacre was livestreamed from Christchurch. It's not a random website, it's the New Zealand government response to that event.
Mutual obligations, agreements and treaties are what bind us together legally. Within the legal framework in Australia, CSE and terrorist video are the same, both considered Class 1. My reference to CSE was deliberate. From an Australian perspective they're one and the same. Different countries can argue that they're not, but that process is ongoing.
Finally, courts making decisions that affect others happens all the time. Just look at the abortion mess currently playing out across courts all over the USA, not just from the SCOTUS down, but between states as well.
This is the very same thing, it's just happens to be a country border, not a state one.
Edit 2:
It's not like the USA hasn't done this to others either. Right now it's making laws to force a company in another country to sell an asset, TicTok.
Well I've heard commentary here from at least half a dozen legal professionals and experts that the order made by the eSafety commissioner here is legal and appropriate.
One pointed out that this means that representatives of the organisation visiting Australia could end up behind bars.
Others point out that this could result in a ban of the platform.
Fortunately I'm not a lawyer and I don't pretend to be one on the internet. I guess we'll both see how this plays out..
In the same way as if your Windows Server on bare metal doesn't start after an update, via the console.
X (twitter) is a signatory to the Christchurch Call set-up by Jacinda Ardern. Signatories agree among other things to suppress the dissemination of terrorism. Nobody is talking about this.
Signatories: https://www.christchurchcall.com/our-community
I checked the Christchurch Call website which clearly shows Xitter as a member of the community that agreed to:
"Take transparent, specific measures seeking to prevent the upload of terrorist and violent extremist content and to prevent its dissemination on social media and similar content-sharing services, including its immediate and permanent removal, without prejudice to law enforcement and user appeals requirements, in a manner consistent with human rights and fundamental freedoms. Cooperative measures to achieve these outcomes may include technology development, the expansion and use of shared databases of hashes and URLs, and effective notice and takedown procedures."
Full text: https://www.christchurchcall.com/about/christchurch-call-text
Why did you need a bare metal anything?
I realise that with the enshitification of VMware, there's one less viable option for virtualisation, but it's not the only one around.
I've just advised the Australian Broadcasting Corporation, the national broadcaster here. No idea if it's going to do anything.
I sent this:
X (twitter) is a signatory to the Christchurch Call set-up by Jacinta Adern. Signatories agree among other things to suppress the dissemination of terrorism. Nobody is talking about this.
Signatories: https://www.christchurchcall.com/our-community
I checked the Christchurch Call website which clearly shows Xitter as a member of the community that agreed to:
"Take transparent, specific measures seeking to prevent the upload of terrorist and violent extremist content and to prevent its dissemination on social media and similar content-sharing services, including its immediate and permanent removal, without prejudice to law enforcement and user appeals requirements, in a manner consistent with human rights and fundamental freedoms. Cooperative measures to achieve these outcomes may include technology development, the expansion and use of shared databases of hashes and URLs, and effective notice and takedown procedures."
Full text: https://www.christchurchcall.com/about/christchurch-call-text
I'd be surprised if they didn't germinate inside the compost and share the love around the garden..