Such better political discussions here than on Reddit

I left and got two Sr SWE positions within 3 months. It’s like the 90’s down here

I’m actually removing this myself because the rule is no politics

I’m going to try. Could be:

1. A long running UPDATE which can temporarily lock all of the data that is being updated. Basically a lock is when the relevant data is frozen while the transaction executes. This can happen at the field or row or table level in most robust database management systems, but in SQLite, during the time when a create, update, or delete is actually being written to disk, the whole file (database) is locked while that happens, even for processes wishing to perform reads.

The solution is to wait for completion, but your query could take 7 million years to complete so… you might not have the patience. You could also just exhaust the compute/memory resources of the machine.

This feels bad when you expected it to be a simple transaction or when you only expected the update to apply to a small subset of data… it’s possible that you’re using a suboptimal query strategy (e.g. many JOINs, lack of indices, not using WITH) or that you’re running your UPDATE on a huge number of records instead of the three you expected to change.

And/or

2. A deadlock, meaning the same data is being operated on at the same time, but the operations can’t execute because there is a competing/circular lock.

The use of BEGIN means that the transaction has started. You usually use COMMIT to actually finish and complete the transaction. If you’ve got another query operating on the same data happening during this time, even if it’s data that is incidental and only used to make the JOIN work, there can be “overlap” which makes the transactions hang, because the DB engine can’t work out which lock to release first.

SQLite is single file based and has a more basic and broad lock vs Postgres or other DMBSes. This means that SQLite doesn’t deadlock because it processes each transaction one after another, but this paradigm may slow everything down vs. MariaDB, Postgres etc

Also see ACID compliance for further reading (https://en.wikipedia.org/wiki/ACID)

All my homies work at Lawrence Livermore

Oh gosh you’re right. I think I was confusing it with how I previously used the list() constructor, which I no longer use. Thanks for the clarification.

This is also necessary for lists in python with one member. Or was.

I believe you just described MCP

And Australia! And I am from both.

I imagine you are right

Feel free to repost

Eat my shorts, honky

Bang. That’s the way it could feasibly play out.

I’m trying to think of other possible justifications that the Supreme Court could use. Could they possibly nullify or neuter the 22nd Amendment? What justification could they use based on historical precedent, which the Heritage Foundation members cling to so tightly?

Could they just delay, delay, delay until making a decision after the election, then citing said election as precedent?

I am not familiar with the majority opinion in Trump v Anderson which must have laid out the legal reasoning why the Supreme Court was able to keep Trump on the ballot. It looks like it uses a clause in the fourteenth amendment to simply devolve the decision making power which seems to be an effective dodge and deflection to political winds.

True and well articulated.

There are plenty of trustafarians doing this in California, I assure you.

They get bored and travel and also go visit the doctor when they need to but many come back to this bucolic lifestyle.

Am also Aussie! I know that the Fair Work Commission and a bunch of unions negotiating award rates consider CPI but is that just one factor they consider or the whole enchilada?