.

DuckDB

Reading time: less than 1 minute

DuckDB is a high-performance, in-process analytical database that lets you run SQL queries directly on your files.

Some similarities with ClickHouse, especially with clickhouse-local.

Example snippets

Parquet to CSV

duckdb -cmd '.mode csv' -c "select * from './validation.parquet'" > validation.csv

Extensions

https://duckdb.org/docs/extensions/overview

Python API

Segfault when importing

Sometimes when you import duckdb you get a segfault. If this happens, moving the duckdb import before your other imports can help.

Example

import duckdb

conn = duckdb.connect("test.duckdb")

Using with Ibis

You can use DuckDB with Ibis to perform DataFrame operations on your DuckDB tables and automatically generate SQL.

The following pages link here

pg mooncake

Citation

If you find this work useful, please cite it as:

@article{yaltirakli,
  title   = "DuckDB",
  author  = "Yaltirakli, Gokberk",
  journal = "gkbrk.com",
  year    = "2025",
  url     = "https://www.gkbrk.com/duckdb"
}

Not using BibTeX? Click here for more citation styles.

IEEE Citation

Gokberk Yaltirakli, "DuckDB", July, 2025. [Online]. Available: https://www.gkbrk.com/duckdb. [Accessed Jul. 14, 2025].

APA Style

Yaltirakli, G. (2025, July 14). DuckDB. https://www.gkbrk.com/duckdb

Bluebook Style

Gokberk Yaltirakli, DuckDB, GKBRK.COM (Jul. 14, 2025), https://www.gkbrk.com/duckdb

Comments

© 2025 Gokberk Yaltirakli