trump puts a tariff on joins

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?"

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…

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!