sorry not sorry but you gotta know this cursed SQLite fact too

A launchpad for dev tools, built by developers for developers, open source, and fair.

Amazon S3 Vectors is a new cloud object store that provides native support for storing and querying vectors at massive scale, offering up to 90% cost reduction compared to conventional approaches while seamlessly integrating with Amazon Bedrock Knowledge…

Postgres LISTEN/NOTIFY can cause severe performance issues under high write concurrency due to a global lock during commit. Learn why it doesn't scale and how to avoid outages.

Published a new post: "PSA: SQLite WAL checksums fail silently and may lose data"

This is a follow up to my previous posts. When SQLite encounters checksum failures in WAL, instead of raising an error, it drops all subsequent frames; even if they are not…

As an respectable unemployed person must do, I tried to make Postgres as slow as possible

Top 5 Database Popularity (Aug 2025)

📉MySQL tanking!

Highlight: % growth last 4 years:
🔻 Oracle: -3,83 %
🔻 MySQL: -26,07 %
🔻 Microsoft SQL Server: -22,52 %
🔼 PostgreSQL: +16,33 %
🔻 MongoDB: -20,33 %

GPT-5 achieves 94.6% accuracy on AIME 2025, suggesting near-human mathematical reasoning.

Yet ask it to query your database, and success rates plummet to the teens.

The Spider 2.0 benchmarks reveal a yawning gap in AI capabilities. Spider 2.0 is a comprehensive…

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…

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.