DuckDB


Reading time: less than 1 minute

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", October, 2024. [Online]. Available: https://www.gkbrk.com/duckdb. [Accessed Oct. 10, 2024].
APA Style
Yaltirakli, G. (2024, October 10). DuckDB. https://www.gkbrk.com/duckdb
Bluebook Style
Gokberk Yaltirakli, DuckDB, GKBRK.COM (Oct. 10, 2024), https://www.gkbrk.com/duckdb

Comments

© 2024 Gokberk Yaltirakli