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")
Citation
If you find this work useful, please cite it as:
@article{yaltirakli,
title = "DuckDB",
author = "Yaltirakli, Gokberk",
journal = "gkbrk.com",
year = "2024",
url = "https://www.gkbrk.com/duckdb"
} Not using BibTeX? Click here for more citation styles.
IEEE Citation Gokberk Yaltirakli, "DuckDB", December, 2024. [Online]. Available: https://www.gkbrk.com/duckdb. [Accessed Dec. 27, 2024].
APA Style Yaltirakli, G. (2024, December 27). DuckDB. https://www.gkbrk.com/duckdb
Bluebook Style Gokberk Yaltirakli, DuckDB, GKBRK.COM (Dec. 27, 2024), https://www.gkbrk.com/duckdb