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.

Plenty of books and blogs will tell you how to develop your functional programming skills or teach you algorithms. But if you’re already pretty good at that stuff, you might be better off trying to become a more virtuous human being: more in control of your emotions, more able to hold your nerve in times of crisis, and humbler about the institutional power your technical knowledge grants you.

Avoid these things:

• Asking the developer how things should work: It’s your responsibility to know how a feature should work; if you don’t, how can you test it?

• Reporting bugs outside of the ticket: Avoid informal bug discussions, as they waste time for you and your team.

• Using vague phrases like “This does not work properly”: ‘Properly’ is unclear—specify exactly what’s wrong.

Chats, emails, phone calls, mailing lists, issue tracking systems, face-to-face meetings, and other communication instruments for a software project.

In many other languages, you have to not only evaluate testing libraries, but also write your tests in a style that complies with that library’s expectations. Gophers are blessed to have a thoroughly adequate solution out-of-the-box, and even further blessed to have an active ecosystem where folks are making in-depth testing a walk in the park.

Instead of asking over and over again if she is working tomorrow. I just consult her very organised calendar — and when she wants to check if I'm free she looks at my very empty calendar.

Long daily commutes can leave little time around busy work days for commuters, who tend to be less physically active, overweight, drink more alcohol, and sleep poorly as a result.

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.

Игорь рассказывает, как делает заметки.

Вложенные теги не нужны

Do not try to create a hierarchy (taxonomy) for your notes. It is not scalable and only works for narrow domain. Prefer tags.

Не понимал, зачем раскрашивать буквы в книжках, но Игорь пишет, что это полезно, когда есть комментарии

It is not useful to highlight without commenting. Writing summary is mandatory, highlighting is optional 1.

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.

This huge collection of non-scary optical illusions and fascinating visual phenomena emphasizes interactive exploration, beauty, and scientific explanation.

Для всех, кто знал SQL, но подзабыл