Tool

DuckDB

DuckDB is an in-process SQL OLAP database management system for analytical workloads. It uses a PostgreSQL-inspired SQL dialect, can run from edge devices to servers, and reads and writes formats including CSV, JSON, Parquet, Iceberg, and Vortex both locally and in object storage. Extensions add functions and format support, while native clients provide APIs for Python, Go, Java, Node.js, C, C++, R, Rust, and ODBC. DuckDB is open source and MIT-licensed, with governance by the independent DuckDB Foundation.

Visit site Mentioned in 5 videos ↓

What DuckDB is used for

4 uses taken from transcripts — each links to the moment in the video.

  • Database engine supported by Vortex, including direct handling of compatible constant-array representations.

  • Referenced via the author's article on distributed architectures; sets the framing that compute has become cheap relative to storage

  • Small local database suggested for keeping only ~30 days of recent data instead of a beefy database

    unverified InfoQ24:00
  • Database CLI cited for shipping an agent mode: humans get a nicely drawn table while agents get a plain one listing how many rows were left out and how to get them, huge queries stop early with a notice, and errors return as JSON — cutting the output the model read by 59%.

Videos mentioning DuckDB

5 in the library.