Duckdb

Duckdb is an in-process analytics database. Sqlite for analytics

Created: Oct 20, 2022 by Pradeep Gowda Updated: Jul 22, 2024 Tagged: sqlite · duckdb · databases

davidgasquez/awesome-duckdb: 🦆 A curated list of awesome DuckDB resources

Papers

• Notes on the SQLite DuckDB paper

Articles

• Build a poor man’s data lake from scratch with DuckDB | Dagster Blog; Oct 2022.
• DuckDB as the New jq; Mar 2024.
• DuckDB isn’t just fast

Products

• Why We Built Rill with DuckDB; Apr 19, 2023
• MotherDuck
  • MotherDuck: Duck and Roll: MotherDuck is Open for All With $100M in the Nest

Videos

• DuckDB Tutorial For Beginners - YouTube

Tutorials

• Ducklicious DuckDB Cookbook
• mehd-io/pypi-duck-flow: end-to-end data engineering project to get insights from PyPi using python, duckdb, MotherDuck & Evidence

Tools

• DuckDB-Wasm Playground - Sekuel; lambda example

• Show HN: PretzelAI - Open-source, browser-local data exploration using DuckDB-WASM and PRQL | Hacker News

  • PretzelAI Playground
  • Can plugin your OpenAI code to use AI.
  • can generate charts against data
  • all in the browser
  • can load data from a URL.

Discussion

• who uses duckdb for real: reddit – examples of real world use cases. Excellent use cases.

Integration

• In-Memory Analytics for Kafka using DuckDB – Robert Yokota using kwak (Java).

–

See also: Parquet