3,969 karma · joined February 4, 2017
ACQUIRE ACCESS SHARE TABLE LOCK ON my_table ALTER TABLE my_table ALTER COLUMN my_column TYPE bigint
This way I _know_ that if the operation needs a stronger lock than I thought or than I'm willing to give it, it will just fail rather than locking up my database and causing unexpected downtime.
because it works? That's the only real benchmark at the end of the day
> Seems like an inefficient waste of resources and time to me.
why? For any given goal you got no proof that a more efficient strategy even exists, let alone that it can be found with less resources & time
Maybe reverse mortgages are the answer, I'm not sure, I'll admit I'm not very knowledgable about this.
I don't _want_ $1M, I want to live in my house that I bought and lived in for years. Getting money I don't need and having to live in a place I don't want to live in is _not_ a positive situation.
super tangential, but makes me think I never realised that "quota" can either be a lower or an upper bound depending on context
And hate it, as "dub" does not contain (let alone start with) the sound it refers to
Usually :) But plenty of cases where you can't, the most common one being silent letters: while you can guess silent letters pretty consistently, some words have unusual silent letters ("asthme", "oignon") or usually-silent letters that aren't silent in this case ("huit").
Some words are also homographs: spelled the same, but not the same word and might be pronounced differently ("content": is it someone happy or multiple people counting?).
Some letters silentness change depending on plurality of the word: œuf and bœuf, the F is pronounced in the singular but not the plural.
Also, I'm not a particularly frequent/experienced driver but 4th gear at 30kmh on a roundabout doesn't seem very safe, it does not leave you much control to react to something unexpected (some car coming up that you didn't see, a car who changed their mind last minute about exiting, a car changing lane poorly...). Being able to decelerate or accelerate quickly is pretty important on a roundabout. Not such a big deal on a very big roundabout with excellent visibility where there's no-one, but that's pretty rare in europe at least.
Yeah, I think about that often when deciding on what to buy. It's often "what would I actually use" rather than "have on me".
For example, a corded vacuum is better on every metric than a cordless, but my house will be cleaner with a cordless because I'll actually use it.
Or, I really wanted a fully analog hi-fi amp, but realistically I knew I'd use it a lot more if it has bluetooth and airplay built-in and I can control it remotely.
And obviously airpods: I much prefer sound from headphones, but I just wouldn't take them with me most of the time whereas my airpods live on my keyring.
How is it not? it's not a change to the actual distance (well, it is for a sufficient precision), but a change to the definition of the metre is exactly what it is. It's defined relative to the speed of light rather than a random platinum bar length, with the constant picked so that the actual measurement stay the same (up to a certain level of precision).
The US earned themselves very little goodwill from the world (and many of their own citizen), to the point that people even in the West are happy seeing China challenging the US on the AI front. Whether China is wielding AI for better or worse outcomes than the US is up for hindsight.
I'd be interested to hear more about why? because my experience with Go has been the opposite, I found it pretty bad for "making illegal states unrepresentable". In fact, its zero-values system often makes illegal states the _default_
Absolutely no way. Like, it's not even comparable, sweaty smelly feet are infinitely cleaner than a shoe that stepped outside just once.
Even if we only talk about visible dirtiness (which is probably the least of the uncleanliness), I've hosted dinner parties in my flat where people kept shoes one and others where they didn't, and the difference is very very obvious: disgusting floors after the former and normally-clean-looking floors after the latter
I'll make an educated guess that you mean "objects and methods" instead of "subject and action" or "noun and verb" respectively. But it's really the "utter" and "transfer" terminology that I have no idea what it might mean
Try searching "bike" in google image :)
Most bike images are from the right side, as that's where the mechanism is (gears, chain etc), so not surprising that LLMs reproduce this
- Query planner is much worse (just yesterday I had to USE INDEX to sped up a query by 300x, I'm near-certain postgres would just have gotten it right) - Indexes are much more limited: no GIST, no GIN - No transactional lock (`pg_advisory_xact_lock` in postgres). This one was very surprising, it's a really useful thing and I had to implement it myself as a lock table
A bit of an extraordinary belief to hold, to be honest