CTEs really tripped me up when I started using them professionally. My mental model was that they result in reusable objects in memory and thus could be used to improve performance as well as composition.
After discovering the truth, it was interesting to find out that almost everyone I knew who wasn't a snr db engineer shared the same incorrect assumption.
>Imagine a programming language without functions. You can only write code that operates on concrete values, i.e. variables or literals. So instead of writing a function and calling it anywhere you have to write these little code templates as comments and every time you want to “call” the “function” you copy the template and do a search/replace.
>This would be tiresome. But that’s what SQL is. The concrete values are the table names. The code is the queries. And the function templates you have to search replace are your business logic, which must be inlined everywhere it is used.
So long as you make your payments on time, the lienholder cannot confiscate your property to make the pie whole. The money might be theirs, but the property is yours.
yes, and in developed countries outside the US, healthcare is something covered by the state. neither of which has anything to do with the discussion at hand. you're comparing an apple to a kumquat.
The doomsday clock is closer to midnight than it’s ever been https://thebulletin.org/doomsday-clock/current-time/ and now we avoid another 1929 by inflating away the gains of the middle class and siphoning value off to the 1%
I don't understand how the doomsday clock is closer to midnight now than it was during the Cuban missile crisis. It makes me think that it's not an objective measure.
It's pretty opaque. My impression is that each shard (storage backend quorum) gets a roughly equal share of capacity you pay for, and items in the same partition tend to live on the same shard to keep range queries small (and local indices require one-shard partitions). They've made improvements in loaning cold shards' unused capacity to hot shards, but they still recommend avoiding hot partitions and keeping load roughly even.
