.

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

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