DuckDB

Pandas Should Go Extinct

Eddie argues that Pandas forces data practitioners to adopt distributed compute infrastructure long before their data sizes justify it, and that DuckDB and Polars can fill the gap for workloads up to around 100 GB on a single machine. Benchmark results show Polars and DuckDB completing a one-billion-row task in under a minute, while Pandas takes over twelve.

Blog post · Python · Data Engineering · Pandas · DuckDB

Planet Labs' Open Satellite Feed

Mark Litwintschik surveys Planet Labs' satellite fleet and walks through practical use of the company's freely available Disaster Data feed, which publishes pre- and post-event imagery from natural disasters as DuckDB-friendly Parquet files hosted on Cloudflare.

Blog post · Satellites · Remote Sensing · DuckDB · Open Data