DuckDB

Creator

Creator

Seonglae Cho

Created

Created

2023 Jun 6 4:59

Editor

Editor

Seonglae Cho

Edited

Edited

2025 Jul 6 1:22

Refs

Refs

Data Import


SELECT * FROM 'myfile.csv';
SELECT * FROM 'myfile.parquet';

CALL start_ui();


duckdb -ui

SQL engine

Huggingface official SQL engine for parquet

DuckDB as the New jq

Recently, I’ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.

https://www.pgrs.net/2024/03/21/duckdb-as-the-new-jq

Community extensions

DuckDB Community Extensions

DuckDB extensions can now be published via the DuckDB Community Extensions repository. The repository makes it easier for users to install extensions using the INSTALL ⟨extension name⟩ FROM community syntax. Extension developers avoid the burdens of compilation and distribution.

https://duckdb.org/2024/07/05/community-extensions.html

DuckDB Community Extensions

UI

The DuckDB Local UI

The DuckDB team and MotherDuck are excited to announce the release of a local UI for DuckDB shipped as part of the ui extension.

https://duckdb.org/2025/03/12/duckdb-ui.html

The DuckDB Local UI

Backlinks

Smallpond OTF AWS Aurora

Recommendations

/////