# Duckdb

- Page: https://shared.btbytes.com/p/duckdb
- Date: 2022-10-20
- Tags: duckdb, database, sqlite

[davidgasquez/awesome-duckdb: 🦆 A curated list of awesome DuckDB resources](https://github.com/davidgasquez/awesome-duckdb)

## Papers

- [Notes on the SQLite DuckDB paper](https://simonwillison.net/2022/Sep/1/sqlite-duckdb-paper/)

## Articles

- [Why DuckDB is my first choice for data processing](https://www.robinlinacre.com/recommend_duckdb/); Mar 2025.
- [Build a poor man’s data lake from scratch with DuckDB | Dagster Blog](https://dagster.io/blog/duckdb-data-lake); Oct 2022.
- [DuckDB as the New jq](https://www.pgrs.net/2024/03/21/duckdb-as-the-new-jq/); Mar 2024.
- [DuckDB isn't just fast](https://csvbase.com/blog/6)
- [Why Semantic Layers Matter — and How to Build One with DuckDB - MotherDuck Blog](https://motherduck.com/blog/semantic-layer-duckdb-tutorial/); Aug 2025.

## Products

- [Why We Built Rill with DuckDB](https://www.rilldata.com/blog/why-we-built-rill-with-duckdb); Apr 19, 2023
- MotherDuck
	- [MotherDuck: Duck and Roll: MotherDuck is Open for All With $100M in the Nest](https://motherduck.com/blog/motherduck-open-for-all-with-series-b/)

## Videos

- [DuckDB Tutorial For Beginners - YouTube](https://www.youtube.com/watch?v=ZX5FdqzGT1E)

## Tutorials

- [Ducklicious DuckDB Cookbook](http://web.archive.org/web/20250127201739/https://sekuel.com/sql-courses/duckdb-cookbook/)
- [mehd-io/pypi-duck-flow: end-to-end data engineering project to get insights from PyPi using python, duckdb, MotherDuck & Evidence](https://github.com/mehd-io/pypi-duck-flow)

## Tools

- [DuckDB-Wasm Playground - Sekuel](https://sekuel.com/playground/); [lambda example](https://sekuel.com/playground/?q=U0VMRUNUIAogICAgU1VNKHNpemUpIEFTIHNpemUsIAogICAgRk9STUFUX0JZVEVTKFNVTShzaXplKTo6QklHSU5UKSBBUyBzaXplX2Zvcm1hdF9ieXRlcwpGUk9NIFJFQURfUEFSUVVFVCgKICAgICAgICBMSVNUX1RSQU5TRk9STSgKICAgICAgICAgICAgR0VORVJBVEVfU0VSSUVTKDAsNTUpLCAKICAgICAgICAgICAgICAgIG4gLT4gCiAgICAgICAgICAgICAgICAgICAgJ2h0dHBzOi8vaHVnZ2luZ2ZhY2UuY28vZGF0YXNldHMvdml2eW0vbWlkam91cm5leS1tZXNzYWdlcy9yZXNvbHZlL21haW4vZGF0YS8nIHx8CiAgICAgICAgICAgICAgICAgICAgRk9STUFUKCd7OjA2ZH0nLCBuKSB8fAogICAgICAgICAgICAgICAgICAgICcucGFycXVldCcgCiAgICAgICAgKQogICAgKTs=)

- [Show HN: PretzelAI - Open-source, browser-local data exploration using DuckDB-WASM and PRQL | Hacker News](https://news.ycombinator.com/item?id=39717268)
	- [PretzelAI Playground](https://pretzelai.github.io)
	- Can plugin your OpenAI code to use AI.
	- can generate charts against data
	- all in the browser
	- can load data from a URL.

- [duckdb proxy](https://www.goblgobl.com/demo/duckdb-proxy/)

## Discussion

- [who uses duckdb for real: reddit](https://redd.it/1ao16gb) -- examples of real world use cases. Excellent use cases.

## Integration

- [In-Memory Analytics for Kafka using DuckDB – Robert Yokota](https://yokota.blog/2024/07/11/in-memory-analytics-for-kafka-using-duckdb/) using [kwak](https://github.com/rayokota/kwack) (Java).

- [🚜 Query.Farm](https://query.farm/)  "is a product studio focused on extending DuckDB. We write DuckDB extensions, build developer tools, and help teams embed DuckDB into modern data systems."

[Greybeam](https://www.greybeam.ai/blog) as an alternative for expensive Snowflake workloads using DuckDB.
> * Greybeam provides compute infrastructure to automatically route each query to its optimal engine.
> * Greybeam caches your Snowflake data as Apache Iceberg tables in a bucket you own. Provision it with Terraform, CloudFormation, or any IaC tool you already use.
> * If your tool connects to Snowflake, it already works with Greybeam. Just replace your connection string and your analytics tools will work exactly as they do today.
> * Greybeam manages the query engines, translates your SQL, and automatically routes each query to the most efficient engine. You don't change a single query.

--

See also: [Parquet](https://shared.btbytes.com/p/parquet)