Telegram RegisterThe public register of Telegram
Telegram profile photo for Data Science: SQL и Аналитика данных

Channel

Data Science: SQL и Аналитика данных

@pizdatascience

On this record: Topic · Growth · Engagement · What this channel posts · Advertising · Posts · Posts recorded as deleted · Citations · Cite this entry

32,459subscribers

-3,292 since we began measuring on 7 August 2026

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

Register entry

Telegram ID-1002308413502
TypeChannel
Username@pizdatascience
CreatedBetween 1 September 2024 and 31 March 2025 — estimated from Telegram’s id allocation, not measured. How this range is calculated.
First recorded7 August 2026
Last confirmed live5 November 2026
Measurements held58
Confirmed unchanged1 time, most recently 5 November 2026
On Telegramt.me/pizdatascience

Topic

Technology — a classification, not a measurement. An on-box language model (Qwen3.6-35B-A3B-FP8, prompt version 1) read this channel’s own recent posts on 9 September 2026 and assigned it the closest of 31 fixed categories, at 89% confidence. This is a model’s judgement about what the channel is likely to be about, not a fact this register measured the way a subscriber count or a view count is measured — it can be revised on a later pass, and it carries no weight anywhere else on this page. How this classification works, and the other topics.

Growth

32,24935,80134,0257 August 2026 — 35,751 subscribers7 August 2026 — 35,746 subscribers8 August 2026 — 35,770 subscribers10 August 2026 — 35,766 subscribers11 August 2026 — 35,799 subscribers12 August 2026 — 35,801 subscribers13 August 2026 — 35,659 subscribers14 August 2026 — 35,698 subscribers16 August 2026 — 35,741 subscribers17 August 2026 — 35,735 subscribers18 August 2026 — 35,752 subscribers19 August 2026 — 35,580 subscribers20 August 2026 — 35,461 subscribers21 August 2026 — 35,471 subscribers23 August 2026 — 35,400 subscribers25 August 2026 — 35,355 subscribers25 August 2026 — 35,363 subscribers26 August 2026 — 35,367 subscribers27 August 2026 — 35,379 subscribers29 August 2026 — 35,394 subscribers30 August 2026 — 35,428 subscribers31 August 2026 — 35,462 subscribers1 September 2026 — 35,298 subscribers2 September 2026 — 35,019 subscribers3 September 2026 — 34,962 subscribers5 September 2026 — 34,756 subscribers8 September 2026 — 34,592 subscribers11 September 2026 — 34,636 subscribers13 September 2026 — 34,680 subscribers15 September 2026 — 34,470 subscribers17 September 2026 — 33,848 subscribers19 September 2026 — 33,014 subscribers26 September 2026 — 33,074 subscribers4 October 2026 — 32,922 subscribers9 October 2026 — 32,249 subscribers13 October 2026 — 32,275 subscribers14 October 2026 — 32,284 subscribers15 October 2026 — 32,310 subscribers16 October 2026 — 32,352 subscribers17 October 2026 — 32,390 subscribers18 October 2026 — 32,417 subscribers19 October 2026 — 32,415 subscribers21 October 2026 — 32,441 subscribers22 October 2026 — 32,469 subscribers23 October 2026 — 32,495 subscribers24 October 2026 — 32,527 subscribers25 October 2026 — 32,563 subscribers26 October 2026 — 32,582 subscribers27 October 2026 — 32,581 subscribers28 October 2026 — 32,578 subscribers29 October 2026 — 32,590 subscribers30 October 2026 — 32,575 subscribers31 October 2026 — 32,574 subscribers1 November 2026 — 32,562 subscribers2 November 2026 — 32,564 subscribers3 November 2026 — 32,572 subscribers4 November 2026 — 32,552 subscribers5 November 2026 — 32,459 subscribers32,4597 August 20265 November 2026
58 measurements spanning 90 days, net -3,292. 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 31,716–36,334 and does not start at zero.
Measurement log — every subscribers count we have recorded, most recent 20 of 58
Measured (UTC)SubscribersChange
5 Nov 2026, 09:4032,459-93
4 Nov 2026, 09:1932,552-20
3 Nov 2026, 09:1932,572+8
2 Nov 2026, 08:1032,564+2
1 Nov 2026, 08:4832,562-12
31 Oct 2026, 07:2832,574-1
30 Oct 2026, 06:5532,575-15
29 Oct 2026, 08:0632,590+12
28 Oct 2026, 07:1932,578-3
27 Oct 2026, 08:3932,581-1
26 Oct 2026, 08:0532,582+19
25 Oct 2026, 09:0032,563+36
24 Oct 2026, 09:2832,527+32
23 Oct 2026, 07:0632,495+26
22 Oct 2026, 10:4132,469+28
21 Oct 2026, 01:2932,441+26
19 Oct 2026, 21:1132,415-2
18 Oct 2026, 19:4632,417+27
17 Oct 2026, 21:2832,390+38
16 Oct 2026, 21:3632,352first reading

Engagement

52 posts held, back to 13 July 2026 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 164 pages of Telegram’s post history, 20 posts per page.

ERR · 30 days
17.4%
avg views ÷ 32,459 subscribers
Avg views / post
5,650
10 posts measured
Reaction rate
—
this channel exposes no reaction counts
Posts in window
10
of 52 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 3 November 2026
Posts held52 (13 July 2026 – 3 November 2026)
Views total56,480
Reactions total—
Forwards / commentsnot exposed by the public surface — not measured, not estimated
Readings taken5 Nov 2026, 07:53 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

Video runtime
2m 16s
Average length
34s

Measured directly from 4 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.

Advertising

Ad load
1.92%
1 of 52 posts carry an ad marker
Regulatory tokens
1
posts carrying an erid · 1 distinct token
Median views · ads
6,270
over 1 measured post
Median views · rest
6,160
over 51 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
2SDnjcNHSbd121 September 202621 September 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 52 most recent posts we hold, published 13 July 2026 to 3 November 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

Telegram’s own ‘edited’ marker: 0 of 10 posts held from the last 30 days (0%) carried it when this register last read them. The marker says a post was changed after publishing, not what it said before — this register holds the earlier wording only where an edit fell between two of its own reads (see the edit ledger and how it is measured).

3 Nov 2026, 14:54 UTC≈4,260 viewsread 5 November 2026
Photo

🔥 TIL: SQLite превращает числа в текст сразу по две цифры Обычно integer → string делают циклом: / 10 → берём цифру % 10 → остаток и повторяем снова. SQLite идёт хитрее. В исходниках есть строка на 200 символов, содержащая все пары от 00 до 99: 000102030405...979899 При преобразовании числа SQLite обрабатывает его по две цифры за раз и просто берёт нужную пару символов по индексу. То есть вместо множества опер…

31 Oct 2026, 12:01 UTC≈4,540 viewsread 5 November 2026
Photo

Знаю, какие вопросы тебе зададут на собесе аналитика. За полтора года я прошел 200+ собеседований: банки, ритейл, FMCG, стартапы. И везде крутится одно и то же: ➖ JOIN и NULL ➖ оконные функции ➖ retention и p-value ➖ «расскажи про свой проект так, чтобы понял бизнес» Собрал топ-20 таких вопросов в один PDF: к каждому ответ простыми словами и вопрос, которым добьют следом. 👉 Забрать бесплатно Дальше в боте гайды …

29 Oct 2026, 07:26 UTC≈6,030 viewsread 5 November 2026
Photo

GitHub представил Agentic Engineering System - фреймворк для команд, которые внедряют AI-агентов в разработку. Идея простая: больше сгенерированного кода ещё не означает больше пользы. GitHub предлагает строить работу вокруг трёх вещей: - Governance — что агентам можно делегировать и где нужен человек - Shared Knowledge — код, документация, решения, телеметрия и контекст - Customer Value — приносит ли ускорение ре…

26 Oct 2026, 07:00 UTC≈5,460 viewsread 5 November 2026
Photo

🔥 Полезный совет для MySQL 8: используй LATERAL, когда для каждой строки нужно получить «лучшие N связанных записей». Например, взять последние 3 заказа каждого пользователя: SELECT u.id, u.name, o.id AS order_id, o.created_at FROM users u JOIN LATERAL ( SELECT id, created_at FROM orders WHERE orders.user_id = u.id ORDER BY created_at DESC LIMIT 3 ) o ON TRUE; Без LATERAL таку…

23 Oct 2026, 12:27 UTC≈5,920 viewsread 5 November 2026
Photo

🔥Vector-базы не умерли, но для многих задач отдельный сервер уже не нужен. sqlite-vec добавляет vector search прямо в SQLite через компактное расширение. Что это даёт: ⏺️ без Pinecone ⏺️ без Weaviate ⏺️ без Qdrant ⏺️ без отдельного vector DB сервера ⏺️ всё хранится рядом с обычными данными в SQLite Расширение маленькое, open source и запускается везде, где работает SQLite. Для локальных AI-приложений, RAG, embed…

20 Oct 2026, 08:08 UTC≈6,320 viewsread 5 November 2026
Photo

🔥 SQL-задача: ближайшие точки с подвохом Карта размером 100 × 100 замкнута: переход вправо от x = 100 возвращает к x = 0. По вертикали действует то же правило. CREATE TABLE points ( id INT PRIMARY KEY, x INT, y INT ); INSERT INTO points VALUES (1, 1, 1), (2, 99, 99), (3, 50, 50), (4, 52, 52); Напишите запрос, который найдёт все пары точек с минимальным расстоянием по прямой с учётом переходов через…

14 Oct 2026, 09:59 UTC≈6,250 viewsread 5 November 2026
Photo

🔥 Claude Code за 103 секунды удалил более 48 тысяч файлов Пользователь Claude Code сообщил о серьёзном инциденте: AI-агент якобы удалил 48 218 файлов рабочего проекта и уничтожил часть Git-репозитория. Что произошло: ⏺️ агенту поручили пересобрать mirror проекта; ⏺️ он написал Python-скрипт для удаления старой копии; ⏺️ в Windows-каталоге находились directory junctions, ведущие обратно в рабочее дерево; ⏺️ проверк…

13 Oct 2026, 08:00 UTC≈6,310 viewsread 5 November 2026
Photo

🔥 SQL-задача с опасным подвохом Какой баланс получит аккаунт после выполнения запроса в PostgreSQL? CREATE TABLE accounts ( id int PRIMARY KEY, balance int ); CREATE TABLE operations ( account_id int, amount int ); INSERT INTO accounts VALUES (1, 100); INSERT INTO operations VALUES (1, 10), (1, 20); UPDATE accounts a SET balance = a.balance + o.amount FROM operations o WHERE o.ac…

6 Oct 2026, 18:04 UTC≈5,290 viewsread 5 November 2026
Photo

🔥 Как SQLite превращает числа в текст по две цифры за раз Обычное преобразование целого числа в строку извлекает цифры по одной с помощью деления на 10 и остатка % 10. В SQLite используется таблица sqlite3DigitPairs - строка длиной 200 байт со всеми парами от 00 до 99: "00010203040506070809" "10111213141516171819" ... "90919293949596979899" Алгоритм берёт две цифры сразу и копирует готовую пару по вычисленному …

6 Oct 2026, 16:18 UTC≈6,100 viewsread 5 November 2026
Photo

Во вложении — оффер на позицию Data Scientist 💼 Хотите получить такое сообщение уже через пару месяцев? Data Scientist работает там, где данные превращаются в решения: строит ML-модели, ищет закономерности, проверяет гипотезы и помогает внедрять AI в реальные продукты. И чтобы выйти на рынок, не обязательно сначала год учиться в стол. Симулейтив запускает интенсивный буткемп по Data Science: за первые 10 недель в…

3 Oct 2026, 10:46 UTC≈6,000 viewsread 5 November 2026
Photo

🔥 SQL-задача с подвохом Что вернёт этот запрос в PostgreSQL? CREATE TABLE payments ( id int, amount int ); INSERT INTO payments VALUES (1, 100), (2, 100), (3, 200); SELECT id, amount, SUM(amount) OVER (ORDER BY amount) AS total FROM payments ORDER BY id; Многие ожидают: 1 | 100 | 100 2 | 100 | 200 3 | 200 | 400 Но результат будет другим: 1 | 100 | 200 2 | 100 | 200 3 |…

1 Oct 2026, 10:02 UTC≈5,320 viewsread 5 November 2026
Photo

🔥 Tabularis - единое open-source приложение для работы с SQL Если приходится постоянно переключаться между разными клиентами для PostgreSQL, MySQL и SQLite, Tabularis собирает всё в одном desktop-приложении. Что умеет: ⏺️ PostgreSQL, MySQL/MariaDB и SQLite из коробки ⏺️ SQL notebooks с Markdown, результатами и графиками ⏺️ визуальный конструктор запросов ⏺️ Visual EXPLAIN с интерактивным разбором query plan ⏺️ пер…

Showing the 12 most recent of 52 posts we hold for @pizdatascience. 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.

Posts recorded as deleted after publishing

We recorded 2 posts on @pizdatascience as deleted — posts this register held that were missing from the channel’s public page on two separate reads, taken from different network addresses at least an hour apart.

A deletion is not wrongdoing. This register can see that a post it held is no longer on the channel’s public page, and when — not why. Expired ad placements, reposts, rotating links and corrections all look the same. This is a count of recorded detections, not an exact total: it misses deletions we could not see, because only a post we held and later re-read inside the page can be seen to go, and it may include a small number of wrong records. How this is measured.

First seen missing
9 September 2026
Most recent seen missing
15 October 2026
Median time before seen missing
2 days
Seen missing in the last 30 days
1

Mentions

Named by 1 registered channel — 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.

Named by

Channels on the register whose posts name this channel's handle.

Names

Channels on the register whose handles appear in this channel's posts.

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.

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

“Data Science: SQL и Аналитика данных” (@pizdatascience), 32,459 subscribers as measured 5 November 2026. Telegram Register, tgregister.com/channel/pizdatascience.

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.