This blog lets you test the RETURNING clause with updates in PostgreSQL 18, and allows you to have a look at practical scenario.

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 case you don't have a rowid alias/PK)

BookingTime App — календарь прямо в Telegram для малого бизнеса.

Can it be harmful to set maintenance_work_mem and work_mem limits very high?

❄️ 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…

💵 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…

Stop deploying broken SQL queries. RegreSQL provides regression testing for PostgreSQL queries with performance baselines and automated warnings.

This blog talks aggregations in PostgreSQL version 19. Read in, check use cases and learn more about the feature.

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

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: