Some people plant four lettuces and water them whenever they remember, and then there’s Javier de la Torre, founder of CARTO, who plants four lettuces and ends up building a lakehouse, eight moisture probes, a …
Five months ago, PostHog rebuilt its data warehouse on DuckDB. Now Benjamin Knofe-Vider explains in Why we’re moving our warehouse off DuckDB why they’re leaving it. It caught my attention for two reasons: a …
The DuckDB team has released DuckDB 2.0.0 LTS “Cinnamon Teal”, named after a duck as always: the cinnamon teal, a reddish-brown duck from the western Americas. If 1.0 was the stability release, 2.0 is, …
When you work with geographic data at scale, sooner or later you end up using a global grid: splitting the planet into cells, each with a numeric identifier, and assigning every point, line or polygon to the cells it …
On August 26th, Mark Raasveldt and Hannes Mühleisen published a very short note on the DuckDB blog: DuckLabs, the company behind DuckDB, is becoming a subsidiary of Amazon Web Services. The deal closes in early …
The problem: httpfs ignores your environment variables If you work with DuckDB and the httpfs extension to read remote Parquet files, CSVs from S3, or any HTTP resource, you probably assume that the HTTP_PROXY and …
Lately I’ve been working quite a bit with DuckDB, and one of the things that interests me most is understanding how to optimize performance according to the file format we’re using. It’s not the same …
