Bookmarks

295 bookmarks saved.

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

Все жертвы Сталина

www.demoscope.ru/weekly/2003/0103/analit01.php

— О чем вы подумали, впервые открыв секретный архив ГУЛАГа и узнав, что число репрессированных значительно меньше, чем считалось и говорилось?

Земсков о репрессиях

history,interview,politics

godocs.io

godocs.io
go,programming

Преступление, которое потрясло автомобильный мир

www.youtube.com/watch?v=7N0C8jH-utE

Про автомобили, химию, эксперименты, скандалы, историю, политику, сферы влияния, махинации, войны итд итп.

3 часа восторга!

crime,documentary,economics,history,politics,video

Как писать о своих союзниках и оппонентах

maximilyahov.ru/blog/all/dictator-leader

Я начитался историй об оппозиционной ботферме и подметил закономерность: для союзников и противников у них разные слова, которые обозначают одни и те же явления

text

Z-Library

z-library.se

Z-Library – the world’s largest e-book library. Your gateway to knowledge and culture.

book,collection,ebook

Таймтрекинг: польза и вред

www.youtube.com/watch?v=TvJwopF_QtY
talk,video

Gripes With Go

peppe.rs/posts/gripes_with_go
go,haskell,programming,rust

Programming On 34 Keys

peppe.rs/posts/programming_on_34_keys

Minimizing your keyboard layout is a slippery slope.
34-keys has been reasonably comfortable to use, for both prose and program. My palms do not move across the desk at all, as I reach for keys. I mostly write Rust and Bash, and my layout has evolved to accomodate special characters from their grammars (angled brackets and hyphens, specifically). If you are on a similar journey, I would suggest focusing on accuracy and comfort over speed. Speed comes with time.

keyboard

Почему обучение — это новая прокрастинация

habr.com/ru/companies/productivity_inside/articles/322980
essay,life

Miniflux

miniflux.app

a minimalist and opinionated feed reader.

rss,software

Qi Reader

www.qireader.com
rss,software

SQL indexes on user-defined functions

use-the-index-luke.com/sql/where-clause/functions/user-defined-functions

Функции должны быть чистыми, чтобы по ним работал индекс

sql

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.

sql

The right column order in multi-column indexes

use-the-index-luke.com/sql/where-clause/the-equals-operator/concatenated-keys

The most important consideration when defining a concatenated index is how to choose the column order so it can be used as often as possible.

Например, поиск по имени без фамилии бесполезен. Значит, составной индекс должен начинаться с фамилии, а потом уже будет имя.

sql

Slow Indexes in RDBMS

use-the-index-luke.com/sql/anatomy/slow-indexes

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.

sql

Modern SQL: A lot has changed since SQL-92

modern-sql.com

SQL has evolved. Beyond the relational model. Discover it now.

sql

Sort-Merge Join in SQL databases: Oracle, SQL Server, PostgreSQL

use-the-index-luke.com/sql/join/sort-merge-join

Sort-merge joins do not need indexes on the join predicates.
MySQL does not support sort-merge joins at all.

sql

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.

sql

Tuning SQL LIKE using indexes

use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning

Avoid LIKE expressions with leading wildcards (e.g., '%TERM').

sql

Indexing SQL range conditions less than, greater than and between

use-the-index-luke.com/sql/where-clause/searching-for-ranges/greater-less-between-tuning-sql-access-filter-predicates

Rule of thumb: index for equality first—then for ranges.

sql

My Summer Car глазами новичка в 2023 году | Симулятор бати

www.youtube.com/watch?v=cBvsHHIqAcg

Офигенно

car,game,video

LIMIT vs. FETCH in SQL

antonz.org/sql-fetch

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

sql

An Engineer's Formula for Software Estimation

blog.bonnieeisenman.com/blog/a-software-engineers-guide-to-estimation

A rough formula for tshirt-sizing estimates for software projects.

programming,work

More than Coding: What is Exploratory Work?

blog.bonnieeisenman.com/blog/senior-work

Implementation versus exploration. Who is expected to do what. Being glue.

programming,work

Think real hard

www.benkuhn.net/thinkrealhard
essay,life

To listen well, get curious

www.benkuhn.net/listen

When I’ve listened the most effectively to people, it’s because I was intensely curious—I was trying to build a detailed, precise understanding of what was going on in their head.

essay,life

Valetudo

valetudo.cloud

Valetudo is an opinionated software solution for cloud-free vacuum robots installed on thousands of robots.

iot,software

Псевдо-Феминизм в Барби | ANOIR

www.youtube.com/watch?v=0M7MOk67yC4
economics,politics,video

Яндекс.Музыка + Winamp

yaamp.ru

Yaamp — aудио-плеер Winamp с интегрированным сервисом Яндекс.Музыка

music,software

Centering in CSS: A Complete Guide

css-tricks.com/centering-css-complete-guide

Centering things in CSS is the poster child of CSS complaining. Why does it have to be so hard? They jeer. I think the issue isn't that it's difficult to do,

css,web

git rebase: what can go wrong?

jvns.ca/blog/2023/11/06/rebasing-what-can-go-wrong-
git

BORSCHT - Full Classic Russian Restaurant Recipe

www.youtube.com/watch?v=7obedUwIK68

Мой любимый рецепт борща

food,video

культура en masse

ambment.cat/posts/2007-5-23-2.html

Сегодня публике нужно быть впереди соседа. Увидеть Париж первым — и умереть. Важен не процесс — но атрибутика вокруг.

life

Pagefind

pagefind.app

Pagefind is a fully static search library that aims to perform well on large sites, while using as little of your users’ bandwidth as possible, and without hosting any infrastructure.

software,web

OpenSwitchMaps

addons.mozilla.org/ru/firefox/addon/openswitchmaps

Расширение, которое позволяет открыть текущее место в соответствующем сервисе карт.

map,software

Felt

felt.com

Felt lets you create maps collaboratively. For team projects or epic adventure with friends.

Следующие поездки буду иллюстрировать с помощью этого сервиса!

map,software

Wikipedia Is Badly Biased

larrysanger.org/2020/05/wikipedia-is-badly-biased
wiki

Visual Phenomena & Optical Illusions

michaelbach.de/ot

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

collection

Web Links | num's soda page

soda.privatevoid.net/num/links
collection,site

Progopedia

progopedia.com

Free Encyclopedia of Programming Languages.

programming,wiki

Lobsters

lobste.rs

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

bookmarking

/g/'s Based Sites

based.coom.tech

Большая коллекция сайтов по разным темам.
Кажется, он будет источником для этого экземпляра бетулы на ближайшее время!

collection,site

Inbox Zero - Björn Wärmedal

Reposted warmedal.se/~bjorn/posts/2022-02-19-inbox-zero.html

Now I use my inbox as a to do list of sorts. Emails are only there as long as they're relevant. Confirmation of a table reservation at a restaurant? It's at most relevant until the date of the booking has past. Archive it.

email

Ancient Earth

dinosaurpictures.org/ancient-earth

Earth looked very different long ago. Search for addresses across 750 million years of Earth's history.

DinosaurPictures.org - Awesome Dinosaur Pictures

dinosaurpictures.org

Best dinosaur images and info on the internet. Curated high quality database of dinosaurs

animals,collection

Праздношатание

ru.wikipedia.org/wiki/Праздношатание

Уже нельзя просто постоять на улице.
Благо, в России такой дичи нет.

Дрю также пишет про специальные устройства, которые должны своим писком мешать просто так находиться в общественном месте.

legal

AdNauseam

adnauseam.io

Просто напоминаю про прекраснейший блокировщик рекламы, который не только — внезапно — скрывает рекламу от любимого пользователя, но и старательно засерает статистику рекламным площадкам ("все кликают ВСЁ"), сводя на нет самый смысл персонифицированной слежки.

software

Luxury Beliefs are Status Symbols

Reposted www.robkhenderson.com/p/status-symbols-and-the-struggle-for

Luxury beliefs have, to a large extent, replaced luxury goods.

Luxury beliefs are ideas and opinions that confer status on the upper class, while often inflicting costs on the lower classes.

economics,sociology

Excalidraw — Collaborative whiteboarding made easy

excalidraw.com
software

Реклама из телефонного справочника Челябинска 1975 года

Reposted nobelfaik.livejournal.com/263962.html
design,history

Contradictory class locations and the prevalence of depression and anxiety in the United States

www.ncbi.nlm.nih.gov/pmc/articles/PMC4609238

Anxious? Depressed? You might be suffering from capitalism

economics,study

ПОЯСНЯЮ ЗА АВТОСИМУЛЯТОРЫ

www.youtube.com/watch?v=y0qCQU8JLyc
game,racing,video

Situation Ukraine Refugee Situation

data.unhcr.org/en/situations/ukraine

Статистика по беженцам из Украины

map,statistics

CodePhoto

code.xxut.ru

Генерирует фотку экрана с кодом, который вставит пользователь

humour,programming

Based Cooking

based.cooking

The fast-loading recipe site with cooking only and no ads.

collection,food

Людские пробки в метро у эскалаторов. Как с ними бороться?

habr.com/ru/articles/733438

О том, почему важно занимать обе стороны на эскалаторе в метро.

Постоянно об этом задумывался, а тут мне скинули статью.

metro,transport

Finnix

www.finnix.org

Hundreds of utilities available for recovery, maintenance, testing and more

Живой диск линупса для починки поломанных систем. Не содержит графического интерфейса, голая консоль и куча утилит.

backup,boot,software

banging errors in go

Reposted flak.tedunangst.com/post/bango

Tedu wrote a tool that lets you handle errors in Go like this:

func decomp(filename string) ([]byte, error) {
        fd := ^os.Open(filename)
        defer fd.Close()
        zd := ^gzip.NewReader(fd)
        data := ^io.ReadAll(zd)
        return data, nil
}

Funky!

go

Text Rendering Hates You

faultlore.com/blah/text-hates-you

Rendering text, how hard could it be? As it turns out, incredibly hard! To my knowledge, literally no system renders text “perfectly”. It’s all best-effort, although some efforts are more important than others.

text
1 3 4 5