@tobi: Ducklake with duckdb is really really good. Tell your agent to use it if you ask it to import a lot of data ( like heal…
Summary
Tobi recommends using Ducklake with DuckDB for efficient data import, such as health data from Fitbit, and suggests telling agents to learn it.
Similar Articles
DuckDB: it's not quack science
DuckDB is an open-source embedded analytical database that supports direct querying of files, embedding into applications, and provides friendly SQL extensions. It is more efficient than traditional Unix pipes in data analysis scenarios.
DuckDB 1.5.2 – SQL database that runs on laptop, server, in the browser
DuckDB 1.5.2 adds production-ready DuckLake v1.0 lakehouse format, Iceberg extension improvements, Jepsen testing, and a revamped browser shell with file storage.
Quack: The DuckDB Client-Server Protocol
DuckDB introduces 'Quack', a new client-server protocol that enables DuckDB instances to communicate via HTTP, supporting concurrent writers and remote access while maintaining simplicity and performance.
Datasette Agent
Datasette Agent is a new extensible AI assistant for Datasette that lets users query their data conversationally and generate charts via plugins. It supports local models and cloud APIs like Gemini 3.1 Flash-Lite.
Statistics that live in your SQL
the-stats-duck v0.6.0 is an open-source DuckDB extension that brings statistical analysis and plotting directly into SQL, including regression, bootstrapping, and ggplot-like visualization.