Telegram RegisterThe public register of Telegram

Channel

SQL для тестировщика

@sql_for_qa

On this record: Growth · Engagement · What this channel posts · Reactions · Posts · Polls · Citations · Cite this entry

6,518subscribers

-47 since we began measuring on 7 August 2026

Risers and fallers across the register · movement among entries of 3,162–10,000.

Register entry

Telegram ID-1001895019126
TypeChannel
Username@sql_for_qa
DescriptionПрокачиваем SQL — must have skill для хорошего тестировщика. От создателей @godoftesting По всем вопросам: @anothertechrock
CreatedBetween 1 October 2022 and 30 September 2023— estimated from Telegram’s id allocation, not measured. How this range is calculated.
First recorded7 August 2026
Last confirmed live10 August 2026
Measurements held4
Confirmed unchanged1 time, most recently 10 August 2026
On Telegramt.me/sql_for_qa

Growth

6,5186,5656,541.57 August 2026 — 6,565 subscribers7 August 2026 — 6,565 subscribers7 August 2026 — 6,549 subscribers10 August 2026 — 6,518 subscribers7 August 202610 August 2026
4 measurements spanning 3 days, net -47. Dots are measurements; the straight line between them is drawn to join them, not to claim we know the path taken in between — snapshots are recorded only when a count changes, so gaps mean “no change observed”, never “interpolated”. The vertical axis spans 6,511–6,572 and does not start at zero.
Measurement log — every subscribers count we have recorded
Measured (UTC)SubscribersChange
10 Aug 2026, 16:416,518-31
7 Aug 2026, 22:566,549-16
7 Aug 2026, 08:456,565no change
7 Aug 2026, 08:386,565first reading

Engagement

20 posts held, back to 19 May 2026the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 9 pagesof Telegram’s post history, 20 posts per page.

ERR · 30 days
9.93%
avg views ÷ 6,518 subscribers
Avg views / post
647
3 posts measured
Reaction rate
0.384%
reactions ÷ views · ER floor
Posts in window
3
of 20 held

ERR is average views per post over the last 30 days divided by subscribers, the definition TGStat uses, so this figure is comparable with the one you will see elsewhere. It falls structurally as a channel grows: a high ERR on a small channel and a low one on a large channel describe reach mathematics, not quality. We publish the figure and the sample it came from and pass no verdict on it.

ER is defined industry-wide as (forwards + reactions + comments) ÷ views— note the denominator is views, not subscribers. Telegram’s public web preview carries views and reactions but not forward or comment counts, so the reaction rate above is the reactions term only and is therefore a floor: the true ER for this channel is higher by an amount we have not measured and will not estimate. It is computed over the 2 of 3 measured posts that carry a reaction reading, and over those same posts' views.

What these figures were computed from
WindowRolling 30 days · latest post in window 5 August 2026
Posts held20 (19 May 20265 August 2026)
Views total1,941
Reactions total6
Forwards / commentsnot exposed by the public surface — not measured, not estimated
Readings taken12 Aug 2026, 03:05 UTC

Views are a single reading per post, taken at the time above. A post published in the last day or two is still accumulating views, which pulls the 30-day average down slightly. That is a property of the standard definition rather than a fault in it, so we keep the definition rather than “correcting” the number into something nobody can reproduce.

Precision. Telegram publishes view counts on its public widget in short form — 8.12K, 3.7M — so any reading at or above 1,000 reaches us rounded to three significant figures, and only counts below 1,000 are exact. Averages and rates derived from them are shown to the same precision rather than to the unit: a figure like 3,701,250 would assert digits nobody measured.

Reaction counts are published per emoji and rounded the same way, so a total below 1,000 is exact and a larger one is a sum that may carry a rounded component from each emoji above 1,000. Because it is a sum, it does not look rounded — read a large reaction total as three significant figures per contributing emoji rather than as the figure it prints.

What this channel posts

Photos
424
Videos
16
Links
452

Lifetime counters from Telegram’s own channel header, read 12 August 2026 — not the date at the top of this page, which is when the subscriber count was last read. Below Telegram’s rounding threshold, so these counts are exact.

Video runtime
1m 08s
Average length
1m 08s

Measured directly from 1 video with a duration reading, out of the posts we hold for this channel — not this channel’s whole posting history, only the sample this register has actually read. An exact reading to the second, taken from the post itself rather than from Telegram’s own rounded chrome, so it carries no mark.

Reaction mix

64 reactions across 19 posts, in 4 distinct kinds. The most used accounts for 37.5% of them.

Every reaction kind recorded on the sample, most used first
ReactionCountShareShare, drawn
👍2437.5%
🔥1828.1%
1625.0%
🌚69.38%

No sentiment is inferred, and none should be read in. This table is ordered by count and by nothing else. Emoji do not carry stable meaning across languages or communities — 🙏 is thanks in one channel and mourning in another — so we publish which ones were pressed and how often, and pass no judgement on what an audience meant by them.

Precision. Telegram publishes reaction counts per emoji and short-forms each one — 4.34K, 1.2M — so any single kind at or above 1,000 reaches us at three significant figures, and only counts below 1,000 are exact. The shares above are ratios of those figures and carry the same error. This is also why the total here can differ slightly from a reaction total printed elsewhere on the page: both are sums of the same rounded parts, taken over samples with different edges.

Coverage. Reactions were read on 19 of the 20 sampled posts in this sample. Summed by Telegram’s own count on each post — not by adding up the per-emoji breakdown above — those same posts carry 64reactions in total: the kind of figure the paragraph above means by “a reaction total printed elsewhere on the page”.

Measured over the 20 most recent posts we hold, published 19 May 2026 to 5 August 2026, using the newest reading held for each. Telegram Stars are excluded: they are a payment, not a reaction, and they have their own section.

Recent posts

5 Aug 2026, 09:42 UTC377 viewsread 12 August 2026
Photo

SQL HowTo: ускоряем запрос в 32 раза #почитать Не читайте, пока хотите решить задачу самостоятельно. ✅Читать статью

29 Jul 2026, 09:42 UTC706 views3 reactionsread 12 August 2026
Photo

Ускорение планирования JOIN’ов — до 16 раз быстрее #почитать Если раньше алгоритм сравнения частых значений (MCV) работал за O(N²), и при target=10k само планирование запроса могло занимать десятки миллисекунд, то теперь вместо квадратичного перебора будет использоваться хеш-таблица, а это снижает сложность до O(N). Изменение особенно оценят те, кто работает с неравномерными данными и поднимает default_statistics_t

👍3

15 Jul 2026, 09:52 UTC858 views3 reactionsread 12 August 2026
Photo

Как ИИ помогает проектировать базы данных #почитать Многие кто уже успел попробовать Cursor и подобные инструменты, восхищаются как ИИ способен писать код. ✅Читать статью

👍2🔥1

8 Jul 2026, 04:02 UTC961 views5 reactionsread 12 August 2026
Photo

И снова про алгоритмы и структуры данных #почитать За годы разработки приходит понимание, что происходит в тех или иных сервисах, когда они тормозят, лагают, выдают «неожидаемое» поведение. В данной статье хочу рассмотреть проблему неправильного использования алгоритмов и архитектурных решений с бытовой, общечеловеческой стороны. ✅Читать статью

2👍2🔥1

2 Jul 2026, 10:35 UTC731 views4 reactionsread 12 August 2026
Forwarded from @qa_IivePhoto

🟢Подборка полезностей для тестировщиков 🐞 Июнь 💡 Теория ▫️Руководство по имитаторам для тестировщиков ▫️Бюджетное тестирование облачных приложений: Testcontainers и LocalStack ▫️Какие задачи в тестировании пора отдать ИИ, чтобы получить результат, а не новые проблемы ▫️От вебинаров до биллинга: что нужно тестировать в EdTech ▫️6 ошибок в метриках дефектов, из-за которых QA теряет контроль над качеством ▫️Аудит нагру

2👍1🔥1

24 Jun 2026, 04:04 UTC746 views4 reactionsread 12 August 2026
Photo

PostgreSQL Antipatterns: отказ от агрегатных функций = кратное ускорение #почитать Иногда в архиве нашего сервиса анализа планов запросов к PostgreSQL встречаются примеры не очень эффективных, мягко говоря, запросов. Сегодня на примере одного из них, вызванного простой бизнес-задачей, посмотрим, как отказ от использования агрегатных функций может ускорить запрос в разы. ✅Читать статью

2👍1🔥1

16 Jun 2026, 09:42 UTC896 views4 reactionsread 12 August 2026
Photo

Как организовать тестовую среду, сохраняя покой владельца данных #почитать Хочу поделиться опытом с коллегами - как мы решили одну из наболевших проблем нашей команды разработки – отсутствие полноты данных для тестирования реализованного функционала в условиях ограниченного доступа к реальным данным компании. Если вы работаете с персональными данными, то наверняка сталкивались с такой проблемой. ✅Читать статью

2👍1🔥1

10 Jun 2026, 09:42 UTC954 views5 reactionsread 12 August 2026
Photo

Разбираемся в функциональных зависимостях БД #почитать Возможно вас, как и меня, первое знакомство с функциональными зависимостями в базах данных повергло в легкий ступор. Длинные определения, которые не давались даже после третьего прочтения, излишняя абстрактность, когда на простые и понятные примеры поскупились, и прочее прелести «научного» подхода к объяснению сложных тем. Пора раз и навсегда разобраться во вс

3👍1🔥1

2 Jun 2026, 04:04 UTC951 views2 reactionsread 12 August 2026
Photo

ACID-свойства транзакций в SQL #почитать Для чего существуют принципы ACID? Можно ответить по бумажке, сказать, что это нужно для того, чтобы каждая транзакция обрабатывалась надежно, данные оставались в безопасности и системы работали предсказуемо. Все это в свою очередь должно гарантировать целостность данных. Но что это вообще такое и на что влияет? А ответ очень простой. Обеспечивая целостность данных, мы пред

👍2

1 Jun 2026, 10:52 UTC616 views3 reactionsread 12 August 2026
Forwarded from @qa_IiveVideo

🟢Подборка полезностей для тестировщиков 🐞 31 мая 💡 Теория ▫️Новости тестирования за февраль-май 2026 ▫️Как оценивать ИИ‑агентов в проде: нижняя планка, трассы и кодовые проверки ▫️Peer testing на основе Закона Линуса ▫️Испытание временем — как тестировать цифровой двойник, если физического объекта ещё не существует ▫️Вы неправильно тестируете асинхронный код: тест проходит раньше, чем выполняется проверка ▫️Не прост

🔥2👍1

29 May 2026, 04:15 UTC652 views3 reactionsread 12 August 2026
Poll

Для чего используется команда ANALYZE в PostgreSQL?

  1. Для проверки целостности файлов21%
  2. Для удаления неиспользуемых индексов9%
  3. Для дефрагментации таблиц8%
  4. Для сбора статистики о распределении данных62%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

3

28 May 2026, 09:42 UTC662 views4 reactionsread 12 August 2026
Poll

Какое ключевое слово используется в оконных функциях PostgreSQL для определения группы строк, к которым применяется функция?

  1. GROUP BY55%
  2. PARTITION BY30%
  3. ORDER BY6%
  4. RANGE BETWEEN9%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

🌚3🔥1

Showing the 12 most recent of 20 posts we hold for @sql_for_qa. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.

Polls

The 6 most recent of 8 polls we hold for this entry, as Telegram rendered them when we read the post. A poll’s figures keep moving after that, so each one is dated.

29 May 2026, 04:15 UTCAnonymous Quiz90 voters

Для чего используется команда ANALYZE в PostgreSQL?

  1. Для проверки целостности файлов21%
  2. Для удаления неиспользуемых индексов9%
  3. Для дефрагментации таблиц8%
  4. Для сбора статистики о распределении данных62%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

28 May 2026, 09:42 UTCAnonymous Quiz110 voters

Какое ключевое слово используется в оконных функциях PostgreSQL для определения группы строк, к которым применяется функция?

  1. GROUP BY55%
  2. PARTITION BY30%
  3. ORDER BY6%
  4. RANGE BETWEEN9%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

27 May 2026, 03:50 UTCAnonymous Quiz77 voters

Какой объект в PostgreSQL используется для нормализации слов (удаления окончаний) при создании поискового индекса tsvector?

  1. Parser29%
  2. Dictionary27%
  3. Lexer38%
  4. Tokenizer6%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

25 May 2026, 09:41 UTCAnonymous Quiz102 voters

Какой тип данных в PostgreSQL следует использовать для хранения UUID (Universally Unique Identifier)?

  1. TEXT4%
  2. VARCHAR23%
  3. SERIAL10%
  4. UUID64%

Shares as published, totalling 101%. No per-option vote count is published by Telegram, so none is shown.

22 May 2026, 03:59 UTCAnonymous Quiz108 voters

Какой оператор используется для получения строк, которые есть в первом результате запроса, но отсутствуют во втором?

  1. UNION23%
  2. INTERSECT24%
  3. MINUS11%
  4. EXCEPT42%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

21 May 2026, 09:41 UTCAnonymous Quiz80 voters

Как в PostgreSQL называется специальный столбец, который содержит физический адрес версии строки (ID блока и смещение)?

  1. ctid56%
  2. tableoid28%
  3. xmin10%
  4. cmax6%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

Percentages only — there are no per-option vote counts here, because Telegram publishes none.The public post preview gives each option’s share and a single voter total, and nothing else. Multiplying one by the other would produce a per-option tally that looks measured and is not: the shares are rounded to whole numbers before we ever see them. We print what was published and leave the column that does not exist empty.

The shares need not add up to 100.Rounding alone puts many polls at 99 or 101. A poll that allows more than one answer per voter runs well past 100 by design, and several here do. The bars are drawn against a fixed 100% track at each option’s own percentage rather than normalised to the total, so a poll that exceeds it shows that it does instead of being quietly rescaled.

Read from the 20 most recent posts we hold, published 19 May 2026 to 5 August 2026. Telegram labels each poll by kind — an anonymous poll, a quiz, a closed set of final results — and that label is reproduced rather than paraphrased.

Forward network

Republishes

Channels on the register whose posts this channel has forwarded.

Built only from forwarded posts we have actually read, on both sides. Coverage is early and deliberately incomplete: a missing link means we have not read the post that would prove it, never that the relationship does not exist. Counts are distinct forwarded posts observed, so they only ever go up as we read more.

Cite this entry

A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 10 August 2026 — this entry's latest reading, not the date you are reading this.

“SQL для тестировщика” (@sql_for_qa), 6,518 subscribers as measured 10 August 2026. Telegram Register, tgregister.com/channel/sql_for_qa.

Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.