About consumption speed

Occasionally, you will see the opportunity to completely remove the worrying part of the system, which for me is one of the most satisfying things you can do as a software engineer. Removing things that cause your team stress has compounding benefits to your team, to the systems you work on, and to your engineering org in general

Если код работает, это не значит, что задачу пора закрывать. От двадцати минут, потраченных сверху, вреда не будет — прод не сгорит, менеджер подождет. Зато спасет день коллеги, который вкатывается в проект.

When a task you're working on is too big or you simply don't want to do it, you cut corners; here is how you can do it professionally.

Solving technical problems in a large scope which is difficult to understand is a very stressful activity; I suggest we behave professionally.

Коллекция интерактивных визуализаций данных

SQL Polyglot is a quick way to see if a particular SQL feature is supported in different database systems. Write a query and see it run anywhere from PostgreSQL to DuckDB without leaving your browser.

An index lookup requires three steps: (1) the tree traversal; (2) following the leaf node chain; (3) fetching the table data. The tree traversal is the only step that has an upper bound for the number of accessed blocks—the index depth. The other two steps might need to access many blocks—they cause a slow index lookup.

Fun fact: There is no limit clause in the SQL standard.

Everyone uses limit.
And yet, according to the standard, we should be using fetch

Free Encyclopedia of Programming Languages.

Ещё один сайт для ссылок

В лифте написано УП вместо ВВЕРХ.

Представьте, какой гемор был бы построить это в Экселе, Гугле или даже на языке программирования вроде Питона. Там с одним только парсингом дат и времени наешься, а тут все из коробки.

Cycling is the most sustainable form of transportation, but the bicycle is becoming increasingly damaging to the environment. The energy and material used for its production go up while its life expectancy decreases.

Переосмысление дорожных знаков от Ильи Бирмана

Online Vaporwave Radio