💡 Канал для разработчиков баз данных: Oracle, PostgreSQL
📌 Интересные задачи, фрагменты кода, лучшие практики, архитектура, оптимизация
🔄 Присоединяйся к сообществу — развивайся вместе с нами!
#SQL #Oracle #PostgreSQL #PL/SQL #PL/pgSQL #DB
Created
Between 1 June 2025 and 30 September 2025— estimated from Telegram’s id allocation, not measured. How this range is calculated.
2 measurements taken within a single day. 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 788–790 and does not start at zero.
Measurement log — every subscribers count we have recorded
Measured (UTC)
Subscribers
Change
8 Aug 2026, 01:46
789
no change
7 Aug 2026, 20:51
789
first reading
Engagement
20 posts held, back to 4 April 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 1 pageof Telegram’s post history, 20 posts per page.
ERR · 30 days
28.6%
avg views ÷ 789 subscribers
Avg views / post
226
1 post measured
Reaction rate
0.442%
reactions ÷ views · ER floor
Posts in window
1
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.
What these figures were computed from
Window
Rolling 30 days · latest post in window 26 July 2026
Posts held
20 (4 April 2026 – 26 July 2026)
Views total
226
Reactions total
1
Forwards / comments
not exposed by the public surface — not measured, not estimated
Readings taken
8 Aug 2026, 01:46 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
2
Links
117
Lifetime counters from Telegram’s own channel header, read 8 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.
Reaction mix
71 reactions across 16 posts, in 9 distinct kinds. The most used accounts for 43.7% of them.
Every reaction kind recorded on the sample, most used first
Reaction
Count
Share
Share, drawn
👍
31
43.7%
❤
19
26.8%
❤🔥
10
14.1%
⚡
3
4.23%
🔥
3
4.23%
custom 5418133868475587618
2
2.82%
👏
1
1.41%
🤔
1
1.41%
🤝
1
1.41%
Custom emoji. One row above is a Telegram custom emoji, which the public preview renders as an element carrying only a numeric id — no character, and no image we can reach. The id is printed as-is rather than substituted with a look-alike glyph, because a stand-in would be our invention showing where a measurement should be. The count beside it isTelegram’s.
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 16 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 71reactions 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 4 April 2026 to 26 July 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.
🎵 «Там высоко, высоко
Кто-то пролил молоко,
И получилась млечная дорога,
А вдоль по ней, вдоль по ней,
Между жемчужных полей,
Месяц плывет,
Как белая пирога» — Юлий Ким.
🤔 Вот иногда простое становится сложным.
Разные варианты видел, как можно организовать доступ к таблице.
Логика простая: необходимо либо записать новое значение в таблицу, либо получить уже существующее.
Но многие не ищут простых путей. 🌀
Всё это…
🎵 «Да будет проклят правды свет,
Когда посредственности хладной,
Завистливой, к соблазну жадной,
Он угождает праздно! — Нет!
Тьмы низких истин мне дороже
Нас возвышающий обман...» — Александр Пушкин.
🧩 Курсоры, курсоры, курсоры…
или «обидная» ошибка ORA-01000: maximum open cursors exceeded.
Ведь всех же учат: если явно открыл курсор — явно его закрой. Думаю, это очевидно любому.
Но почему-то почти никто не учит за…
🎵 «Нечего играть с судьбою в прятки,
Так давай, кривая, вывози.
В общем, всё нормально, всё в порядке
И, как говорится, на мази.
Неважно, что не ты играл на скрипке,
Неважно, что ты бледный и худой,
Неважно, что побили по ошибке, —
Скажи ещё спасибо, что живой!» — Владимир Высоцкий.
Кривая сортировка! 🧩📊
Неудивительное дело, что правильный ответ почти никто не дал.
Я бы сам ответил, что сортировка не задана.
SELEC…
🎵 «За тобой тянулся из последней силы я,
До тебя уже мне рукой подать —
Вот долезу и скажу: «Довольно, милая!»
Тут сорвался вниз, но успел сказать.» — Владимир Высоцкий.
В регулярке даже ORACLE не уверен.
Удивлён такой обратной реакции, спасибо, друзья. «Есть ещё порох в пороховницах» ⚙️
С чего всё началось?
Увидел функциональный индекс на основе пользовательской функции:
CREATE OR REPLACE FUNCTION REGEXP_REPLACE…
Интересный кейс впереди. Затравка как всегда. Как вы думаете, можно ли создать функциональный индекс с REGEXP_REPLACE?
Да, можно51%
Нет, нельзя.10%
Не все так просто.39%
Мне все равно.6%
The shares total 106%, above 100: this poll accepts more than one answer per voter. No per-option vote count is published, so the number of voters who chose each option is not derivable and is not shown.
🎵 «Сижу, скучаю, денег нет на семена!
Давай уж хрен посадим.
Лучше хрен, чем нехрена!» — русская поговорка из Батуми
Про триггеры в Oracle 🧷
Как я не люблю триггеры… или: хочешь жить — умей вертеться.
Триггеры — это зло. Никогда не используйте триггеры, если можно без них обойтись!
Это первый постулат, и на этом можно заканчивать пост, но есть вещи, которые меня удивили 🧠
Мне выслали видео:
«Мутация таблиц и реку…
У меня нет большого опыт в триггерах. В текущее время начал глубоко исследовать эту тему. Например: тема COMPOUND vs REGULAR triggers наскольво Вам интересна?
Да. Интересно.76%
Сомнительно, но ок.10%
Нет. Не интересно.9%
Всё равно!5%
Shares as published. No per-option vote count is published by Telegram, so none is shown.
🎵 «Я вчера закончил ковку,
Я два плана залудил,-
И в загранкомандировку
От завода угодил.
Копоть, сажу смыл под душем,
Съел холодного язя,-
И инструктора прослушал -
Что там можно, что нельзя.» — Владимир Высоцкий
🟡 Таблица из одной строки.
Иногда есть потребность в создании таких таблиц и контроле того, что строка в них только одна.
Например, как метка для обозначения текущего состояния обработки или других време…
🎵 «Еще не вечер, еще не вечер,
Еще светла дорога и ясны глаза.
Еще не вечер, еще не вечер,
Еще иду я рядом с тобою безоглядно.
Пусть говорят, что приближается гроза.
Пусть говорят, что лгут и сердце и глаза.
Только не буду верить я таким словам.
Никому тебя я не отдам.»
— Илья Резник
Два движка парсера в ORACLE.
Прошлый опрос — это тизер к этому посту. Прошу прощения, что тизер затянулся — был занят.
Я удивлён, чт…
👍4❤1
Showing the 12 most recent of 20 posts we hold for @db_developers_channel. 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 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.
Интересный кейс впереди. Затравка как всегда. Как вы думаете, можно ли создать функциональный индекс с REGEXP_REPLACE?
Да, можно51%
Нет, нельзя.10%
Не все так просто.39%
Мне все равно.6%
The shares total 106%, above 100: this poll accepts more than one answer per voter. No per-option vote count is published, so the number of voters who chose each option is not derivable and is not shown.
У меня нет большого опыт в триггерах. В текущее время начал глубоко исследовать эту тему. Например: тема COMPOUND vs REGULAR triggers наскольво Вам интересна?
Да. Интересно.76%
Сомнительно, но ок.10%
Нет. Не интересно.9%
Всё равно!5%
Shares as published. No per-option vote count is published by Telegram, so none is shown.
Никогда такого не было и вот опять. Равны ли эти два значения в Oracle? TIMESTAMP '2026-05-13 15:00:00 -01:01' TO_TIMESTAMP_TZ('2026-05-13 15:00:00 -01:01', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
Да. Равны15%
Нет. Не равны51%
Не уверен.24%
Всё равно.10%
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 4 April 2026 to 26 July 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 — 888,965 of 1,480,975entries 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.
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.
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 8 August 2026 — this
entry's latest reading, not the date you are reading this.
“DB developers channel” (@db_developers_channel), 789 subscribers as measured 8 August 2026. Telegram Register, tgregister.com/channel/db_developers_channel.
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.