Telegram RegisterThe public register of Telegram
Telegram profile photo for Data Science. SQL hub

Channel

Data Science. SQL hub

@sqlhub

On this record: Growth · Engagement · What this channel posts · Reactions · Advertising · Posts · Polls · Citations · Handles named that no longer answer · Telegram's recommendations · Cite this entry

35,873subscribers

-7 since we began measuring on 6 August 2026

Risers and fallers across the register · movement among entries of 31,623–100,000.

Register entry

Telegram ID-1001434942369
TypeChannel
Username@sqlhub
DescriptionПо всем вопросам- @workakkk @itchannels_telegram - 🔥лучшие ит-каналы @ai_machinelearning_big_data - Machine learning @pythonl - Python @pythonlbooks- python книги📚 @datascienceiot - ml книги📚 РКН: https://vk.cc/cIi9vo #VRHSZ
CreatedBetween 1 April 2019 and 30 September 2021— estimated from Telegram’s id allocation, not measured. How this range is calculated.
First recorded6 August 2026
Last confirmed live21 August 2026
Measurements held16
Confirmed unchanged1 time, most recently 21 August 2026
On Telegramt.me/sqlhub

Growth

35,85435,89835,8766 August 2026 — 35,880 subscribers6 August 2026 — 35,886 subscribers7 August 2026 — 35,894 subscribers8 August 2026 — 35,892 subscribers9 August 2026 — 35,889 subscribers10 August 2026 — 35,888 subscribers11 August 2026 — 35,898 subscribers12 August 2026 — 35,886 subscribers13 August 2026 — 35,877 subscribers14 August 2026 — 35,881 subscribers16 August 2026 — 35,864 subscribers17 August 2026 — 35,870 subscribers18 August 2026 — 35,872 subscribers19 August 2026 — 35,854 subscribers20 August 2026 — 35,860 subscribers21 August 2026 — 35,873 subscribers35,8736 August 202621 August 2026
16 measurements spanning 16 days, net -7. 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 35,847–35,905 and does not start at zero.
Measurement log — every subscribers count we have recorded
Measured (UTC)SubscribersChange
21 Aug 2026, 22:2835,873+13
20 Aug 2026, 17:4235,860+6
19 Aug 2026, 16:2735,854-18
18 Aug 2026, 15:1335,872+2
17 Aug 2026, 18:4835,870+6
16 Aug 2026, 14:1735,864-17
14 Aug 2026, 21:2535,881+4
13 Aug 2026, 13:3635,877-9
12 Aug 2026, 14:0335,886-12
11 Aug 2026, 16:5335,898+10
10 Aug 2026, 15:2535,888-1
9 Aug 2026, 12:5135,889-3
8 Aug 2026, 15:1035,892-2
7 Aug 2026, 17:1035,894+8
6 Aug 2026, 17:3335,886+6
6 Aug 2026, 02:1835,880first reading

Engagement

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

ERR · 30 days
7.24%
avg views ÷ 35,873 subscribers
Avg views / post
2,600
29 posts measured
Reaction rate
0.518%
reactions ÷ views · ER floor
Posts in window
29
of 36 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.

What these figures were computed from
WindowRolling 30 days · latest post in window 22 August 2026
Posts held36 (15 July 202622 August 2026)
Views total75,341
Reactions total390
Forwards / commentsnot exposed by the public surface — not measured, not estimated
Readings taken22 Aug 2026, 16:31 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
1,150
Videos
95
Links
1,170

Lifetime counters from Telegram’s own channel header, read 22 August 2026 — not the date at the top of this page, which is when the subscriber count was last read. A count marked was rounded by Telegram before we ever saw it — t.me prints these counters in full below 1,000 and to three significant figures above, so ≈142,000 means somewhere between 141,500 and 142,499.

Video runtime
1m 37s
Average length
49s

Measured directly from 2 videos 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

480 reactions across 32 posts, in 12 distinct kinds. The most used accounts for 38.8% of them.

Every reaction kind recorded on the sample, most used first
ReactionCountShareShare, drawn
👍18638.8%
13327.7%
🔥12025.0%
👎142.92%
🥰102.08%
👏40.833%
😱40.833%
🤔30.625%
🎉20.417%
🤯20.417%
😁10.208%
🤬10.208%

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 36 of the 36 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 503reactions in total: the kind of figure the paragraph above means by “a reaction total printed elsewhere on the page”.

Measured over the 36 most recent posts we hold, published 15 July 2026 to 22 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.

Advertising

Ad load
11.1%
4 of 36 posts carry an ad marker
Regulatory tokens
4
posts carrying an erid · 4 distinct tokens
Median views · ads
1,720
over 4 measured posts
Median views · rest
3,070
over 32 measured posts

An ad marker, not a judgement about a post. A post is counted here because it carries one of two explicit markings: an erid token, which Russian law has required on paid placements since 2022 and which is issued against a specific advertising contract, or a #реклама / #ad hashtag in the body, which is the channel declaring it itself. The first is documentary; the second is a self-declaration and is weaker. No classifier reads the text and decides — nothing on this site guesses that a post is an advertisement.

This is a floor, and it can only ever be a floor.A channel that runs paid placements without marking them produces no marker for us to count, and an unmarked ad is indistinguishable from an ordinary post on the public surface. The ad load above therefore means “the share of posts that declared themselves”, never “the share of posts that were paid for”. A low figure is not evidence of a channel that runs few ads.

Both figures are medians, and no ratio between them is published. Each is a view reading that actually occurred on a post, picked by percentile_disc rather than averaged, so one viral post cannot move it and no interpolated value is invented between two readings. The sample on one side is under five posts, which is too thin to compare. The two figures are shown side by side with the count behind each, and deliberately not divided into a headline like “ads get x% fewer views” — an arithmetic that is easy to print and, at this sample size, means nothing.

Advertising tokens recorded on this entry
eridPostsFirst seenLast seen
2VtzquuHE37119 August 202619 August 2026
2Vtzqx3mtnf120 August 202620 August 2026
2W5zFGPtHER116 July 202616 July 2026
2W5zFJogLHX121 August 202621 August 2026

A token repeated across several posts is one advertising contract placed more than once, which is what the identifier is for. The strings are reproduced exactly as they appeared in the post or in its click-through URL and are not validated against any registry — we record the marker a channel published, and whether it resolves to a real contract is a question for the register that issued it.

Measured over the 36 most recent posts we hold, published 15 July 2026 to 22 August 2026. Views are the latest single reading held for each post, and any reading at or above 1,000 is rounded by Telegram to three significant figures.

Recent posts

22 Aug 2026, 14:01 UTC597 views6 reactionsread 22 August 2026

🔥 SQL-совет: `COUNT(*)` иногда можно вообще не считать Если в PostgreSQL тебе нужно не точное число строк, а быстрая оценка размера огромной таблицы, не запускай: SELECT COUNT(*) FROM events; На большой таблице это может читать миллионы строк. Для быстрой оценки можно взять статистику PostgreSQL: SELECT reltuples::bigint FROM pg_class WHERE relname = 'events'; reltuples хранит примерную оценку количества с

4👍2

22 Aug 2026, 12:00 UTC764 views6 reactionsread 22 August 2026
Video

☁️☁️☁️☁️☁️☁️☁️ 24 сентября Yandex Cloud проведёт ежегодную флагманскую технологическую конференцию Yandex Scale 2026. 🎨🎨🎨🎨🎨🎨🎨🎨🎨🎨 🎨🎨🎨🎨🎨🎨🎨🎨🎨🎨 🎨🎨🎨🎨🎨🎨🎨🎨🎨 В программе четыре продуктовых трека — AI, Data, Security и Hybrid Infrastructure & DevOps, — и отдельный углублённый технологический трек DeepTech, который пройдёт только онлайн. В треке Data расскажем, как Yandex Cloud развивает аналитику от отдельных сервисов к ед

👍31🔥1😁1

22 Aug 2026, 11:03 UTC785 views6 reactionsread 22 August 2026

🔥 SQL-запрос внезапно стал медленным? Проверь не только индексы, но и статистику Оптимизатор выбирает план запроса на основе статистики по данным. Если она устарела, база может решить, что строк мало, выбрать Nested Loop и в итоге прогнать миллионы сравнений. В PostgreSQL быстро обновить статистику можно так: ANALYZE users; А проверить, насколько оценки оптимизатора отличаются от реальности: EXPLAIN (ANALYZE,

👍42

22 Aug 2026, 09:42 UTC805 views6 reactionsread 22 August 2026
Photo

🔥 Хочешь быстрее расти в IT? Хватит учиться в одиночку Окружение решает больше, чем кажется. Собрал папки и каналы, где можно быстрее влиться в нужное направление, следить за трендами и не вариться в своём пузыре. AI: t.me/ai_machinelearning_big_data Python: t.me/pythonl Linux: t.me/linuxacademiya Хакинг: t.me/linuxkalii DevOps: t.me/DevOPSitsec Docker: https://t.me/+90Z5TAyfuNU5YmRi Golang: t.me/Golang_google Rus

2👍2🔥2

21 Aug 2026, 11:03 UTC≈1,390 views11 reactionsread 22 August 2026
Photo

У SQLite один writer. И иногда это не ограничение, а очень удобная архитектура. Работал с SQLite и увидел необычную схему: база работала сразу на нескольких машинах, но запись всё равно шла только через одну. За это отвечал LiteFS. Он не пытается превратить SQLite в полноценную distributed database. Вместо этого одна машина выбирается primary через distributed lease и получает право писать. Остальные работают как

5👍3🔥3

21 Aug 2026, 09:09 UTC≈1,480 views0 reactionsread 22 August 2026
Advertisementerid 2W5zFJogLHX

SQL как ремесло и SQL как инструмент бизнеса — разные навыки Владеть SQL — значит написать корректный запрос под любую задачу. Работать продуктовым аналитиком — значит понять, какую задачу решает заказчик, и превратить выгрузку в ответ на его вопрос. Первое проверяется тестом на соединениях таблиц, второе — на реальных проектах. 25 августа karpovꓸcourses проводят бесплатный вебинар про этот второй пласт. На реальны

20 Aug 2026, 21:13 UTC≈1,590 views12 reactionsread 22 August 2026

🚀 SQL: индекс есть, но база специально его игнорирует Есть индекс: CREATE INDEX idx_users_status ON users(status); И запрос: SELECT * FROM users WHERE status != 'active'; Кажется, что индекс должен ускорить поиск. Но если условие возвращает большую часть таблицы, индекс может оказаться дороже обычного Seq Scan. Например, если 'active' — только 10% строк, то: status != 'active' вернёт примерно 90% табли

👍6🔥51

20 Aug 2026, 14:00 UTC≈1,630 views6 reactionsread 22 August 2026
Photo

Успейте подать заявку на E-CUP 2026 Students от Ozon Tech до 30 августа E-CUP 2026 Students — ежегодное соревнование от Ozon Tech. В этом сезоне — для студентов, которые интересуются ML, Data Science, Big Data и аналитикой данных. Вас ждут три трека: поиск дубликатов товаров, ИИ-модерация карточек маркетплейса и прогнозирование поведения пользователей. Все задачи основаны на реальных обезличенных данных Ozon. Учас

👏32🔥1

20 Aug 2026, 12:02 UTC≈1,680 views6 reactionsread 22 August 2026
Video

DELETE не удаляет строку. Кто на самом деле освобождает место в PostgreSQL DELETE только ставит строке метку, физически она остаётся в файле. Старую версию держит MVCC: пока её могут читать другие транзакции, трогать её нельзя. Мёртвые кортежи убирает уже VACUUM, и только после этого место реально возвращается.

👍6

20 Aug 2026, 10:01 UTC≈1,750 views3 reactionsread 22 August 2026
Advertisementerid 2Vtzqx3mtnfPhoto

Вырастили целое дерево из агентов 🌳 Мы в Авито разработали единую платформу для процессов. Самые лучшие и популярные становятся агентами. В итоге каждый сотрудник может создать свой процесс или воспользоваться готовым. Классно? Не то слово! Поэтому мы написали статью, как создавали это решение. О чём узнаете, если прочитаете: 🔸как устроена архитектура платформы, 🔸как процесс становится агентом, 🔸как измерять качест

2👍1

19 Aug 2026, 09:01 UTC≈2,060 views9 reactionsread 22 August 2026
Photo

⚡️ Harness Engineering - полный курс на русском Как заставить AI-агента писать код надёжно. Не «какую модель выбрать», а как спроектировать вокруг неё рабочую систему: инструкции, инструменты, среду, состояние и верификацию. Курс - от нуля до продвинутых тем: теоретическая база из 11 блоков, 14 модулей, 8 практических проектов, 14 лабораторных работ, диагностический протокол «как починить агента», библиотека готовы

3🔥3🥰2👍1

19 Aug 2026, 07:03 UTC≈1,720 views6 reactionsread 22 August 2026
Advertisementerid 2VtzquuHE37Photo

PostgreSQL: архитектура и тюнинг SQL-запросов Погрузись в архитектуру и прокачай оптимизацию запросов одной из самых популярных open source СУБД – PostgreSQL. 🌐 В программе курса: 🤩 Разберём, как работают СУБД вообще и PostgreSQL в частности: что такое MVCC, ACID, WAL, LRU, PPC/TPC и другие фундаментальные понятия архитектуры баз данных 🤩 Получишь теорию и практику EXPLAIN и EXPLAIN ANALYZE на разных типа запросо

👍42

Showing the 12 most recent of 36 posts we hold for @sqlhub. 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 poll we hold for this entry, as Telegram rendered it when we read the post. A poll’s figures keep moving after that, so each one is dated.

16 Jul 2026, 16:03 UTCAnonymous Quiz523 voters

Какой параметр в postgresql.conf задает объем общей памяти, используемой сервером для кэширования блоков данных?

  1. shared_buffers53%
  2. temp_buffers22%
  3. work_mem21%
  4. max_connections4%

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 36 most recent posts we hold, published 15 July 2026 to 22 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.

Citation-graph rank

Citation-graph rank — 104,665 of 1,584,142entries in the measured graph. A weighted position computed from the forward and mention edges below — republished posts weigh more than named mentions — and recomputed periodically, over the whole graph. Published only as this ordinal position, never as a score: a position is a fact, and a score printed beside one channel’s name would read as a verdict this register does not make. The two counts beneath stay separate for the same reason mentions are never summed with forwards anywhere else on this page — a named-by count costs nothing to manufacture. The top 100 by this measure, or how it is computed.

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.

Mentions

Named by 35 registered channels — every channel on the register whose own posts have named this one, by its current username or any other username it currently holds, merged from two separately captured readings of the same fact so a namer caught by only one of them is not missed and a namer both caught is not counted twice. A username this channel has since dropped is not matched — that handle may belong to someone else now, and crediting today’s namer to yesterday’s owner would misattribute it. The 24 listed below are the most frequent namers; the rest are counted above but not each listed.

A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.

Appears in Telegram’s recommendations for other channels

The reverse of the list above, and a different kind of signal. This does not require this channel to have ever been asked about directly — each row below is a channel we DID ask Telegram about, whose Telegram-generated list happened to include this one. A channel can appear here with an empty list above it, because being named by someone else’s query is independent of having been queried itself.

Python/ django
@pythonl · 58,935
Telegram ranks this channel #6 of 84 here — alongside 83 others — read 22 August 2026
Искусственный интеллект. Высокие технологии
@vistehno · 72,222
Telegram ranks this channel #7 of 94 here — alongside 93 others — read 20 August 2026
Machinelearning
@ai_machinelearning_big_data · 284,523
Telegram ranks this channel #30 of 95 here — alongside 94 others — read 10 August 2026
Библиотека программиста
@proglibrary · 78,409
Telegram ranks this channel #66 of 82 here — alongside 81 others — read 19 August 2026
Простой Python | Программирование
@python_piton_javascript · 128,051
Telegram ranks this channel #68 of 84 here — alongside 83 others — read 13 August 2026
Google Таблицы
@google_sheets · 60,766
Telegram ranks this channel #92 of 98 here — alongside 97 others — read 22 August 2026

This channel appears in 6 seed channels' Telegram-generated recommendation lists in total. Each is Telegram’s list for THAT channel, not this one — see how this is measured.

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 21 August 2026 — this entry's latest reading, not the date you are reading this.

“Data Science. SQL hub” (@sqlhub), 35,873 subscribers as measured 21 August 2026. Telegram Register, tgregister.com/channel/sqlhub.

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.