Welcome to the Ultimate DuckDB List! This repository compiles various resources, tools, and libraries for DuckDB, making it easier for developers to find the right tools for their DuckDB needs.
- Official DuckDB Documentation - Comprehensive guide and reference for DuckDB.
- DuckDB GitHub Repository - Source code and releases.
DuckDB supports various extensions to enhance its functionality:
-
Official Extensions - List of officially supported extensions, including:
- Arrow: Zero-copy data integration between Apache Arrow and DuckDB.
- Parquet: Support for reading and writing Parquet files.
- JSON: Functions for handling JSON data.
- HTTPFS: Read and write files over HTTP(S) or S3 connections.
- Spatial: Geospatial functions for spatial data analysis.
- FTS: Full-Text Search capabilities.
- Autocomplete: Adds support for autocomplete in the shell.
- AWS: Provides features that depend on the AWS SDK.
- Azure: Adds a filesystem abstraction for Azure blob storage.
- Delta: Adds support for Delta Lake.
- Excel: Adds support for Excel-like format strings.
- Postgres: Adds support for reading from and writing to a PostgreSQL database.
- SQLite: Adds support for reading from and writing to SQLite database files.
- VSS: Adds support for vector similarity search queries.
- ICU: Adds support for time zones and collations using the ICU library.
- INET: Adds support for IP-related data types and functions.
- Jemalloc: Overwrites system allocator with jemalloc.
- TPCDS: Adds TPC-DS data generation and query support.
- TPCH: Adds TPC-H data generation and query support.
- Substrait: Adds support for the Substrait integration.
- Autoloadable Aliases: Provides autoloadable aliases for extensions.
-
Community Extensions - Extensions contributed by the community.
DuckDB offers client APIs for various programming languages:
- Python: Integration with Pandas, Apache Arrow, and Polars.
- R: R API for DuckDB.
- Java: Java API implemented using JNI.
- C/C++: Native APIs for C and C++.
- Go: Go API for DuckDB.
- Node.js: Node.js API for DuckDB.
- Julia: Julia API for DuckDB.
- Rust: Rust API for DuckDB.
- Swift: Swift API for DuckDB.
- Wasm: WebAssembly support for DuckDB.
Enhance your DuckDB workflow with these tools:
- DuckDB SQL Tools for VS Code - Adds DuckDB SQL support to Visual Studio Code.
- DuckDB Playground Tutorial - A collection of DuckDB queries for beginners.
- DuckDB Pro Tools - Advanced DuckDB tools for data professionals.
- My First Billion (of Rows) in DuckDB - An in-depth exploration of DuckDB's capabilities with large datasets.
- DuckDB Tutorial For Beginners - A comprehensive guide to getting started with DuckDB.
- Hands-On Exploratory Data Analysis with DuckDB - A practical tutorial on using DuckDB for data analysis.
- Getting Started with Modern GIS Using DuckDB - Learn how to use DuckDB for geospatial data analysis.
- 15+ Companies Using DuckDB in Production: A Comprehensive Guide - Insights into how various companies leverage DuckDB.
- A Guide to Data Analysis in Python with DuckDB - Learn how to perform data analysis in Python using DuckDB.
- DuckDB: The Indispensable Geospatial Tool You Didn't Know You Were Missing - Explore DuckDB's geospatial capabilities.
- Learning DuckDB - YouTube Playlist - A series of tutorials covering various aspects of DuckDB.
- DuckDB Tutorial For Beginners - A beginner-friendly introduction to DuckDB.
- Dive into DuckDB with this new tutorial! - An in-depth tutorial on DuckDB's features and usage.
Feel free to contribute to this list by submitting a pull request or opening an issue!
- Fork the repository.
- Create a new branch (
git checkout -b feature/your-feature). - Commit your changes (
git commit -am 'Add some feature'). - Push to the branch (
git push origin feature/your-feature). - Create a new Pull Request.
We appreciate your contributions to making this the ultimate resource for DuckDB!
This project is licensed under the MIT License. See the LICENSE file for details.
Thank you for using the Ultimate DuckDB List! Happy data processing!