Clean Code doesn't work—not because the principles are wrong, but because the real world is dirty, chaotic, unpredictable, and asynchronous. The best code I’ve ever seen violated a good half of Clean Code’s commandments.

We backed up Spotify (metadata and music files). It’s distributed in bulk torrents (~300TB). It’s the world’s first “preservation archive” for music which is fully open (meaning it can easily be mirrored by anyone with enough disk space), with 86 million music files, representing around 99.6% of listens.

Это напоминает мне историю одной клиентки, которая как и многие другие пыталась контролировать терапевта. Она попросила ее не фрустрировать до тех пор, пока она не будет готова. Я и не фрустрировал (и не собирался). Спустя, скажем, год она сказала«ну всё, я теперь готова, давайте пожестче». А я продолжал не фрустрировать. Спустя какое-то время она возмутилась: как же так, я же просила меня фрустрировать, а вы этого не делаете.

И я такой:«фрустрирует, правда?».

Rewrite Git history with a single drag-and-drop.
Undo anything with ⌘Z. All speed, no bumps.

A specification for adding human and machine readable meaning to commit messages

Так уж случилось, что мы с женой занимаемся сортировкой мусора. Инициатива её, я выступаю скорее противовесом. Начинали с радикализма и это было неудобно. Сейчас быт чуть более обустроен, стало гораздо лучше.

Did you ever wake up in the middle of the night wondering what would happen if you applied JPEG-style lossy compression to text?

This idea is pretty simple, in principle: sometimes we miss a good-enough solution because a not-quite-good-enough solution is already out there and in use.

Если для придания уверенности в себе вам нужен карманный ствол — я рекомендую обратиться к психологу. Это дурной симптом.

from bouncepaw:

Alex tells us that, for him, baking and cooking are easier than programming and soldering, because the errors there average out. As for me, this is completely inverse.

In programming, an error never fixes itself. You can observe it and fix it, you can write tests. You can run the program multiple times. It's you who fixes it, and you can understand how it's done. It's measurable!

Meanwhile, cooking is a nightmare. Burning something is routine for me. Is that too much or too little oil? For how long do I fry? What do I do with these spices? Do they really affect the taste? And to observe something, I can't rely on symbolic things like text. No, I have to look (is this color good? No idea!), smell (as if I know the difference) and taste (nothing more inaccurate).

I'm happy when something can be cooked with a timer. 15 min for buckwheat? I'm in. I'm more happy when the time is short. 4 min for this thin kind of spaghetti? Already boiling water!

I mean, even boiling water is not simple. My parents told me to wait until the correct bubbles appear. I'm waiting for the scary ones. Also, salt is supposed to make it boil faster. How much salt do I add?

And I didn't even talk about plants, which Alex also considers easy. They're not 😭

Totally agree!

This belief is, for me, not some abstruse theoretical assertion, but a deeply felt belief that essentially any question I might care to ask (about computers) has a comprehensible answer which is accessible with determined exploration and learning.

Index the independent where predicates to improve hash join performance.

Indexing join predicates doesn’t improve hash join performance.

Indexing a hash join is independent of the join order.

Select fewer columns to improve hash join performance.

Hash joins do not need indexes on the join predicates. They use the hash table instead.
A hash join uses indexes only if the index supports the independent predicates.
Reduce the hash table size to improve performance; either horizontally (less rows) or vertically (less columns).
Hash joins cannot perform joins that have range conditions in the join predicates.

Философская концепция, которая объясняет, почему существует любая вселенная и что будет после смерти

I am a dad, and as a dad I watch a lot of kids TV. Some shows I think are actually pretty great (Hey Duggee, Bluey), and some shows are fine, not my thing, but inoffensive (Fireman Sam, Chuggington, Octonauts). There is, however, one show that I just really hate. Paw Patrol. It’s bad.