Duckflight: a DuckDB extension for Postgres — run SQL right in the DB

DuckDB has been the quiet engine for a lot of analytics work lately — fast columnar queries, in-process, no server. The new duckflight extension changes the game a little: it lets you run DuckDB commands directly inside Postgres. That means you can do heavy analytics on your production tables without shipping data to a separate warehouse or spinning up a new service.

The idea is practical. Instead of ETL pipelines, a staging database, and a BI tool talking to yet another endpoint, you write SQL against your actual data and let DuckDB crunch it in place. For a small team or a one-person shop, that cuts a whole layer of plumbing. It also means the extension sits inside whatever Postgres you already have, so there's no new infra to manage.

It's a real tool, not a demo. You install the extension and start querying. The tradeoff is obvious: heavy analytics on the same box will compete with your OLTP load, so you'll want to size it carefully and throttle the work. But for people who already run Postgres and need to do real work without the warehouse circus, it's a welcome addition.

Why this matters for us: if your shop's running Postgres and you've been shuffling data to a separate analytics stack just to get answers, this one extension might save you a whole layer of overhead.