Channel Public Channel

There will be no singularity

@nosingularity

Smartface, technologies and decay
@antonrevyako

Open in Telegram

Subscribers: 1.96K
Photos: 258
Videos: 15
Links: 1K

Showing posts older than #1389 · Back to latest

Older Posts 20 shown

Post #1388 2.2K Jan 20, 2026, 21:57 UTC

https://hakibenita.com/postgresql-unconventional-optimizations

Hakibenita Unconventional PostgreSQL Optimizations Creative ideas for speeding up queries in PostgreSQL

🔥 6
❤ 2

Post #1387 1.86K Jan 20, 2026, 15:30 UTC

TIL: Why ALTER TABLE is such a problem for SQLite
https://www.sqlite.org/lang_altertable.html#why_alter_table_is_such_a_problem_for_sqlite

🔥 4
🤯 3

Post #1386 2.36K Jan 3, 2026, 18:29 UTC

https://bigdata.2minutestreaming.com/p/mongobleed-explained-simply

2Minutestreaming MongoBleed explained simply CVE-2025-14847 allows attackers to read any arbitrary data from the database's heap memory. It affects all MongoDB versions since 2017, here's a simple explanation:

👍 4
❤ 1

Post #1385 2.33K Jan 3, 2026, 11:41 UTC

👏 18
🥰 10
😁 6
💯 4
🌚 2
🔥 1

Post #1384 2.44K Dec 19, 2025, 14:28 UTC

https://tailwindsql.xyz

TailwindSQL Like TailwindCSS, but for SQL queries. A fun experiment!

🥰 6
🤮 2
🤬 1

Post #1383 2.74K Dec 9, 2025, 18:25 UTC

https://jepsen.io/analyses/nats-2.12.1

👍 12

Post #1382 3.18K Nov 26, 2025, 06:53 UTC

Forwarded from Oleg

https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/

CYBERTEC PostgreSQL | Services & Support Super fast aggregations in PostgreSQL 19 See how PostgreSQL 19 speeds up aggregations by aggregating before joins, with a benchmark showing over 5x faster execution.

Post #1381 2.76K Nov 21, 2025, 10:38 UTC

https://boringsql.com/posts/regresql-testing-queries/

boringSQL | Supercharge your SQL & PostgreSQL powers RegreSQL: Regression Testing for PostgreSQL Queries Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.

🔥 3

Post #1380 2.12K Nov 19, 2025, 16:33 UTC

https://www.linkedin.com/feed/update/urn:li:activity:7396948455069212672/

LinkedIn #snowflake #datalineage #datagovernance | Anton Revyako 💵 CTAS Cost Management in Snowflake: do you actually know how much your reports cost? Most companies confidently assume their analytics costs “almost nothing.” 💸 But the reality can be very different: a single CFO report can burn thousands of dollars per…

🔥 1
😁 1

Post #1379 1.69K Nov 18, 2025, 15:51 UTC

https://www.linkedin.com/posts/anton-revyako_snowflake-sql-database-activity-7396573628328448000-bYhB

LinkedIn ❄️ Schema Change Tracking in Data Lineage for Snowflake | Anton Revyako ❄️ Schema Change Tracking in Data Lineage for Snowflake How do data-lineage tools usually track Snowflake schema changes? The first idea that comes to mind is reading the current state from INFORMATION_SCHEMA or SNOWFLAKE.ACCOUNT_USAGE. This is exactly how…

🔥 2

Post #1378 1.94K Nov 3, 2025, 10:09 UTC

Forwarded from Oleg

https://vondra.me/posts/dont-give-postgres-too-much-memory/

Tomas Vondra Don't give Postgres too much memory Can it be harmful to set maintenance_work_mem and work_mem limits very high?

❤ 3
🤨 1

Post #1377 2.71K Oct 3, 2025, 11:47 UTC

Forwarded from Denis

❤ 22
👍 6
🔥 6
😁 5

Post #1376 2.59K Sep 29, 2025, 10:21 UTC

no time to explain, upvote please

https://productradar.ru/product/calendar-bookingtimeapp/

Лучшие стартапы и пет-проекты России – Product Radar Calendar | BookingTimeApp BookingTime App — календарь прямо в Telegram для малого бизнеса.

👎 17
🤔 4
👍 3
🤡 3
💊 2

Post #1375 2.07K Sep 27, 2025, 07:44 UTC

https://x.com/pthorpe92/status/1971659028414845114

X (formerly Twitter) Preston Thorpe (@PThorpe92) on X TIL SQLite will just let you name a column `rowid`, and it will just be a regular column (no unique constraint).. you then lose the ability to explicitly change/update the actual rowid (in the cas…

🆒 5
🐳 1

Post #1374 2.13K Sep 26, 2025, 16:20 UTC

postgresql18_ga_new_features_en_20250926-1.pdf1.5 MB

PostgreSQL 18 New Features With Examples

❤ 2

Post #1373 1.96K Sep 25, 2025, 06:27 UTC

http://www.cybertec-postgresql.com/en/postgresql-update-returning-made-even-better/

CYBERTEC PostgreSQL | Services & Support PostgreSQL: "UPDATE … RETURNING" made even better This blog lets you test the RETURNING clause with updates in PostgreSQL 18, and allows you to have a look at practical scenario.

🔥 4

Post #1372 1.83K Sep 13, 2025, 07:16 UTC

https://fixupx.com/crunchydata/status/1966544363304923242

FixupX Crunchy Data (@crunchydata) Postgres 18 will be out later this month. The biggest news is asynchronous I/O which will be turned on by default for clusters and expected to mean read performance gains for everyone. More features and details in our blog ⬇️ https://www.crunchydata.com/blog/get…

🔥 3

Post #1371 2.18K Sep 5, 2025, 06:43 UTC

https://fixupx.com/seattledataguy/status/1963834780551889100

FixupX SeattleDataGuy (@SeattleDataGuy) Head Of Data: "AI won’t save us until we fix our data infrastructure and quality" CEO: "Ok… but we still put ‘AI’ on our Q4 roadmap right?"

🥰 4

Post #1370 2.37K Aug 27, 2025, 10:53 UTC

https://fixupx.com/isamlambert/status/1960513282395267093

FixupX Sam Lambert (@isamlambert) trump puts a tariff on joins

😁 10
🤡 4
👏 1

Post #1369 1.93K Aug 24, 2025, 10:31 UTC

Another reason not to use PG as a queue:

fixupx.com/samokhvalov/status/1959468091035009245

FixupX Nik Samokhvalov (@samokhvalov) Here is a simple synthetic demo of NOTIFY hot spot, drastically slowing down COMMIT (in any @PostgreSQL version) on a 48-vCPU AMD machine: https://gitlab.com/postgres-ai/postgresql-consulting/tests-and-benchmarks/-/issues/67 (following up https://www.re…

👀 3

Older posts →