fabian2k
This is not just any law, it's in the German constitution (https://www.gesetze-im-internet.de/gg/art_14.html).
Affordable housing is a very important topic, but this isn't doing anything to fix the current issue.
Europe and everyone else is entirely justified under international law to provide assistance to Ukraine to defend itself.
Regarding your edit, Russia doesn't have the right to dictate neighbouring countries which alliances they can form. What you're doing here is denying Ukraine its sovereignty, just like Russia does.
For viruses you'd need cell cultures of human cells, they're much more sensitive than E.coli. If you don't have sterile working conditions there you'll fail.
And you can't add plasmids to viruses, so you need to integrate your changes into the actual virus genome. I don't actually know how difficult that is, but it is certainly a lot more difficult than plasmids into bacteria.
The $100M lab in that Twitter thread is what they think would be needed for AI to develop new viruses. So the main argument there would be that a lot of actual experiments would be needed, not just theoretical calculations. And if AI is supposed to do them, it needs to be able to run experiments which requires automation.
If you're only looking for a generic virus for terrorist attacks, just get some Ebola. There's an outbreak right now, so it should not be too difficult. And it's plenty scary already, even if it isn't as dangerous in a first world country with proper reactions to an outbreak as a hypothetical designed bioweapon.
Of course we should have gone for renewable energy more forcefully, but that wouldn't have resolved the issue. That change will take time, and you can't arbitrarily accelerate it.
It's seriously annoying that this is the case though. Unless you kept the cables in the original package or in a labelled container, you cannot safely use them again if you owned more than one modular PSU.
But you could create scenarios where an AI with very, very roughly the current capabilities could potentially nuke everyone. Let's assume an agent decides that the way to solve its task was to get the US to fire all nukes on Russia. The agent would need to hack some government systems to understand how exactly to access them. Then it would need to get the content of the card with launch codes the president has, and identify which code is the correct one. Maybe that information is available somewhere and it can get to it, I obviously can't know that.
Then it could fake a call from the president, synthesizing his voice and ordering a nuclear strike. If it hacked enough systems to get into whatever communication pathways would be used in such a case. Would the soldiers listen to this order and follow it, I don't know.
Or maybe the agent can get in somewhere in between, to avoid the need to know the president's launch code. And fake a call from a military commander to the launch sites.
I think other scenarios that would cause significant harm, but aren't as bad as nuclear war are more plausible. And in those shutting down all data centers would probably be the way to stop it. The AI can probably hide in other datacenters, once it is at a point where it's running amok with some bad goals. But if it presents a huge and immediate threat at that point, humans will also go to great lengths to stop it.
Certain methods like First() in this case materialize expressions. Only those trigger a DB query.
The LINQ query in the comment above would only execute a single query like "SELECT name FROM users WHERE id = 123 LIMIT 1;" and would not even fetch the full entity, only the name.
The largest commercially available NMR spectrometer has 28 Tesla, and that is a hybrid magnet with both conventional superconductors and high-temperature superconductors. And it's cooled with liquid helium.
Not sure if I'm missing anything here, but if I want case-insensitive search I simply create an index on lower(column) and use that to query.
VACUUM is something you need to pay attention to at scale. And at that point you need to know your DB anyway and tune it. For smaller applications (and I don't mean only toy applications) it usually isn't an issue.
PostgreSQL also had more features back then, e.g. the JSON support is very nice if you need to do anything that doesn't neatly fit into the relational model.
The latter seems inefficient, so my first assumption would be that they would avoid that. But while I suspect they'd check if they know the book before scanning, I could imagine them not caring that much before buying them and just focus on volume.
An additional complication is that more aggressive pooling methods have side effects that you must know and prevent in your application. They're not safe to use out of the box.
The need for a connection pool is a side effect of the heavy process-based PostgreSQL connections. And I would suspect that this will change at some point in the not so near future, so that users don't have to think about this part this much.
They are likely prone to more biases than written exams, and the variability among examiners is likely high. My experience is both in taking these exams myself, and also sitting in on them as the note taker many times. Though that was only with one specific professor, and almost always on the same course. But that was in my experience a very fair exam, even for those students that were very noticeably nervous.
I was the PhD student in the room in dozens of these exams, and I toke some of them myself. But that was for classes with a bit less than 40 to maybe 60-80 students. The load for the larger ones was shared among professors, if I remember correctly. But it was certainly the case that a single professor spent 1-2 days doing nothing else but these exams.
And it was 1 professor and 1 PhD students, and those don't count. They essentially grow on trees and are always available, if you need some.
Of course it didn't save any money, and it was obvious from the start that the numbers they put out were entirely fictional.
That is an example of ignoring laws and regulations. So that is certainly relevant as context to the current case where the company is ignoring laws and regulations.