SQL миграции в Postgres. Часть 1 Как обновить значение атрибута для всех записей таблицы? Как добавить первичный или уникальный ключ в таблицу? Как разбить таблицу на две?.. На эти и другие вопросы, возникающие при проведении миграций схемы и данных в PostgreSQL, автор статьи дает ответы в виде практических советов. Базы данных

Channel
Базы данных | Access, SQL, Big Data
@databases_secrets
On this record: Growth · Engagement · What this channel posts · Posts · Citations · Telegram's recommendations · Cite this entry
30,158subscribers
+12 since we began measuring on 6 August 2026
Risers and fallers across the register · movement among entries of 10,000–31,623.
Register entry
| Telegram ID | -1001247460025 |
|---|---|
| Type | Channel |
| Username | @databases_secrets |
| Description | Всё о базах данных простым языком. Сотрудничество: @max_excel РКН: vk.cc/cHhG5h |
| Created | 19 October 2018 — measured — cross-checked against a third-party dataset (ext.tg_channel) |
| First recorded | 6 August 2026 |
| Last confirmed live | 12 August 2026 |
| Measurements held | 6 |
| Confirmed unchanged | 1 time, most recently 12 August 2026 |
| On Telegram | t.me/databases_secrets |
Growth
| Measured (UTC) | Subscribers | Change |
|---|---|---|
| 12 Aug 2026, 02:02 | 30,158 | -8 |
| 10 Aug 2026, 00:29 | 30,166 | -2 |
| 9 Aug 2026, 02:37 | 30,168 | +29 |
| 8 Aug 2026, 01:25 | 30,139 | -7 |
| 6 Aug 2026, 09:00 | 30,146 | no change |
| 6 Aug 2026, 08:54 | 30,146 | first reading |
Engagement
29 posts held, back to 12 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 18 pagesof Telegram’s post history, 20 posts per page.
- ERR · 30 days
- 5.72%
- avg views ÷ 30,158 subscribers
- Avg views / post
- 1,720
- 26 posts measured
- Reaction rate
- —
- this channel exposes no reaction counts
- Posts in window
- 26
- of 29 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.
| Window | Rolling 30 days · latest post in window 12 August 2026 |
|---|---|
| Posts held | 29 (12 July 2026 – 12 August 2026) |
| Views total | 44,838 |
| Reactions total | — |
| Forwards / comments | not exposed by the public surface — not measured, not estimated |
| Readings taken | 12 Aug 2026, 21:35 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
- 253
- Videos
- 95
- Links
- 392
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
- 3h 35m
- Average length
- 30m 51s
Measured directly from 7 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.
Recent posts
Posted without readable text
Big Data В этом ролике авторы обсуждают следующие вопросы: что такое большие данные, кто такие data scientist специалисты, как управлять data специалистами, зачем каждой компании нужно задуматься о больших данных и др. 00:00 Вступление 00:50 Почему большие данные — это важно 03:25 Магия и Big data 06:42 Как сейчас большие данные помогают в ритейле 13:20 Про историю взаимодействия с клиентом 14:49 Кто такие da…
Posted without readable text
Финансовая арифметика в PostgreSQL Иногда перед разработчиком, аналитиком или даже бизнес-пользователем встает задача выполнить какие-то финансовые расчеты, соблюдая два строгих требования. Во-первых, даже для миллиардных сумм необходимо обеспечить точность до копейки, во-вторых, перекрестные итоги тоже должны сходиться до копейки. Базы данных
Через месяц Россию ждут колоссальные изменения. Нефть продолжает лететь вверх, мировой интернет запрещают, а военный конфликт с Украиной сдвинется с мертвой точки. Это затронет всех россиян. И большинство в панике потеряют половину нажитого, как в феврале 2022г. Самое важное сейчас — не терять рассудок и читать аналитику опытных экономистов, которые опираются только на факты. Например, почитайте канал «Инвестиции С…
Вся база SQL для начинающих В этом ролике автор расскажет вам всё, что нужно знать про основы SQL. 0:00:00 Вступление 0:01:45 БД и SQL 0:07:58 Таблицы 0:11:52 Создание таблиц 0:21:48 INSERT/UPDATE/DELETE 0:34:26 SELECT 0:39:50 FOREIGN KEY 0:46:22 JOIN 1:01:00 Агрегатные функции, GROUP BY 1:09:20 HAVING 1:13:09 Изменение таблиц Смотреть это видео на youtube: youtu.be/5sG9kmXYsKU
Ищете где скачать Excel? Хватит мучиться, воспользуйтесь интернет-магазином с оригинальными ключами KeySoft. Вы сможете приобрести лицензионный продукт, в котором будут доступны все функции без каких-либо ограничений: • Лицензионная подписка для Office 365 Pro+ • Лицензионный ключ активации для Office 2021 Professional Plus Преимущества KeySoft: ✔️ широкий ассортимент ✔️ только официальные продажи ✔️ разнообразие…
Выбираем СУБД по новым правилам — в какую сторону смотреть С недавних пор в России появились обязательства и рекомендации об использовании исключительно сертифицированных программных продуктов. В связи с этим был создан реестр отечественного ПО, и в него бурным потоком полились наши (и не очень) разработчики. Карнавал импортозамещения затронул и сферу СУБД. Разработчики смело выкатили для широкой публики СУБД под н…
Вопросы и задачи по SQL на собеседованиях Вопросы и тестовые задания на собеседованиях не потеряли своей актуальности и продолжают вызывать огромный интерес у соискателей. В этом материале автор рассмотрит некоторые из новых вопросов и задач, которые реально задаются на собеседованиях в различных командах. Базы данных
Схема базы данных В этом ролике автор подробно и наглядно рассматривает процесс построения схем баз данных. 00:00 Схема базы данных 00:48 Таблицы на схеме 01:20 Столбцы и типы данных 02:26 Связи между таблицами 02:49 Типы связей между таблицами 04:42 Примеры таблиц базы данных 06:11 Пример SQL запроса с JOIN для извлечения данных 08:07 Пример использования для объединения трех таблиц 10:38 Итоги 12:05 Инс…
8 книг по PostgreSQL: от баз данных с «нуля» для самоучек до руководства про БД в облаках Автор подготовил подборку полезных книг для тех, кто только начал или собирается начать работать с PostgreSQL. В нее вошли актуальные руководства на русском и английском языках. Базы данных
Showing the 12 most recent of 29 posts we hold for @databases_secrets. 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.
Citation-graph rank
Citation-graph rank — 244,876 of 1,151,006entries 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
Republished by
Channels on the register that have forwarded this channel's posts into their own feed.
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 3 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.
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.
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.
@hacks_excel · 285,000
Telegram ranks this channel #4 of 85 here — alongside 84 others — read 10 August 2026
This channel appears in 1 seed channel's Telegram-generated recommendation list 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 12 August 2026 — this entry's latest reading, not the date you are reading this.
“Базы данных | Access, SQL, Big Data” (@databases_secrets), 30,158 subscribers as measured 12 August 2026. Telegram Register, tgregister.com/channel/databases_secrets.
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.