biggerfisch

you can also flip these keyboard shortcuts around, which I did for the cmd-shift-4, as I almost always want it to the clipboard without persisting as a file

Wasn't this a MacBook feature at one point? That behavior sounds quite familiar to me.

I'm the OP of the DBA StackExchange post, and while yes, it does technically work in this case, you do lose some abilities. For one, its much harder to `count(*)` rows with `DISTINCT`. Also, `DISTINCT` uses a totally different mode in planning that requires first retrieving all the rows and then finally filtering them. This is _much_ slower and generally not very fun to deal with!

L4 and L5 are stable (see Jupiter's asteroid collection), but the others involve essentially trying to balance on a infinitesimal pinpoint, with any perturbation causing one to "fall off" and move away.

Sure, but automating this requires a lot more tooling. In the case described with multiple, widely spread instances, you'll need to be able to

a) Reliably determine which step you are on - this includes both migration steps and application deployments b) Fully automate your deployments from a list of staged code changes ("normal" CD will have issue with this) c) Fully automate migrations _after_ all deployments are complete

Those are all totally possible steps, but they are all going to vary based on your setup, making a drop in solution for this process unlikely to be easy.

Additionally, these are only the steps if everything works! What happens if there's a bug halfway through? You probably want to stop the deployment process and either revert or quickly hotfix. A human-based system can handle this quite easily, but an automated system will need to be able to measure errors and reliably determine if an issue exists.

So its not that this can't be automated, in fact, I know that it has for several large organizations, but the hurdle to get to the full level of automation is rather high and fraught with secondary issues to consider.

The sticky part is the social network effect. Its by FAR the dominant messaging app in much/most of Europe. Some switch to Signal/others has occurred... but if you have _one_ friend who doesn't switch that you want to continue to communicate with... you're stuck too.

Not to mention, the alternatives aren't great. I'm sure others will provide a better breakdown, but at a high level:

- Signal is the best alternative but missing features like crazy that really do matter to "normal" people (can't change your phone number! Stickers only can be added from the desktop app)

- Telegram a) has a poor reputation in my greater social circle b) doesn't actually encrypt by default

- Matrix is simply not accessible to anyone who isn't highly computer literate

I'm curious to see how this compares in real life to TimescaleDB hypertables with compression - which to me, reads as much the same thing. I'm wondering if Citus is bringing a lower level implementation of idea possibly?

Not defending/attacking the phrase "disastrously bad", but I'm not sure its a fair argument to say "the docs explain it", if the behavior isn't what a "reasonable" person would expect. Writing software that deletes your files (when you expect, say, the weather report) isn't excused if they write in the docs "oh this weather software randomly deletes files for no reason".

In this specific case though, even those docs do not explain what happens if the value is "invalid"!

Did the toolchain you were working on support both GCC and Clang? I ask because I was recently trying to work on a ESP32 project in vim and got stuck hard on YouCompleteMe only using a clangd-based completer while the project was only compileable with a GCC-based toolchain, leading to annoying things like headers not being found due to things like `#if GCC...` (or the like), and also not all cli switches matching up.

Any tips on getting completion working in vim for GCC-only CXX projects is highly appreciated...

Usually acetone doesn't work so well on the PLA the author is printing the keycaps in. There are other sprays or things you can apply to PLA for a good effect though - I'm betting any of the things used to make PLA food-safe would work here.