.

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")

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", March, 2025. [Online]. Available: https://www.gkbrk.com/duckdb. [Accessed Mar. 12, 2025].

APA Style

Yaltirakli, G. (2025, March 12). DuckDB. https://www.gkbrk.com/duckdb

Bluebook Style

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

Comments

© 2025 Gokberk Yaltirakli