20 random bookmarks

Тут будут ссылки на всё-всё, что я найду интересным

2026-07-06

995.

Opinion | I’m a Therapist. Not Everyone Should Be in Therapy.

www.nytimes.com/2026/07/05/opinion/therapy-loneliness-friendship.html

Many patients misunderstand what therapy reliably provides.

2026-06-20

988.

Mediocrity is Death of the Soul - The Universe of Joshua Blais

joshblais.com/blog/mediocrity-is-death-of-the-soul

2026-04-11

956.

Someone Has to Fly the Plane

www.raptitude.com/2026/01/someone-has-to-fly-the-plane

When I want a thrill, I walk to the corner store without my phone.

2026-03-30

949.

Pure and impure software engineering

www.seangoedecke.com/pure-and-impure-engineering

2026-03-26

946.

Modern Code Review: A Case Study at Google

dl.acm.org/doi/pdf/10.1145/3183519.3183525

2025-12-20

918.

Don’t Speed Up Content

ajkprojects.com/dont-speed-up-content

2025-12-14

917.

The Do-Say Ratio

asnewman.github.io/do-say-ratio

2024-12-18

810.

Go Protobuf: The new Opaque API - The Go Programming Language

go.dev/blog/protobuf-opaque

We are adding a new generated code API to Go Protobuf.

2024-10-14

785.

БАР(биполярное): третий год лечения, полет нормальный

vas3k.club/post/26020

Моя знакомая Ульяна рассказывает про опыт с БАР

2024-07-05

704.

BRIN Indexes

www.postgresql.org/docs/current/brin-intro.html

BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns have some natural correlation with their physical location within the table.

2024-05-02

617.

Сортировка мусора

strizhechenko.github.io/2024/05/02/rubbish.html

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

2023-11-16

421.

Case-Insensitive Search in SQL

use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search

Using UPPER or LOWER for case-insensitive search is not a good practice. Prefer using a _CI collation if possible or at least add the right indexes to make your query fast.

2023-11-15

416.

Partial Objects in ORMs: loading a subset of properties

use-the-index-luke.com/sql/join/hash-join-partial-objects

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.

2023-11-04

393.

Progopedia

progopedia.com

Free Encyclopedia of Programming Languages.

2023-10-31

383.

Excalidraw — Collaborative whiteboarding made easy

excalidraw.com

2023-09-24

Reposted 338.

Writing safe-to-use Go libraries

blog.orsinium.dev/posts/go/safe-api

The Go standard library is full of bad design choices from the perspective of safety of use.

2023-06-21

212.

Media Objectivity and Bias in Western Coverage of the Russian-Ukrainian Conflict

urn.kb.se/resolve?urn=urn:nbn:se:sh:diva-51707

Исследование направлено на то, чтобы определить, нарушается ли журналистская объективность при освещении российско-украинской войны и как различные практики предвзятости СМИ используются в новостях.

Про peace journalism и war journalism.

2023-04-14

176.

David Rumsey Historical Map Collection

www.davidrumsey.com

Коллекция карт

2023-03-27

152.

Как найти место по фотографии — Вастрик

vas3k.blog/blog/388

2023-03-21

137.

Neal.fun

neal.fun