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 #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 #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 #1376 2.59K Sep 29, 2025, 10:21 UTC no time to explain, upvote pleasehttps://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