duckdb

Package — DatabasePython 3.7+Intermediate

In-process analytical SQL database (like SQLite for analytics)

Quick Info

Documentation
Official Docs
Python Version
3.7+
Dependencies
None (C++ binary, self-contained)
Install
pip install duckdb

Learn by Difficulty

Easy2 examples
Examples|Playground
Intermediate1 example
Examples|Playground
Advanced1 example
Examples|Playground
Expert1 example
Examples|Playground

Quick Example

python
# Install: pip install duckdb
import duckdb

# Basic duckdb usage
print(f"Using duckdb")
# See documentation for detailed examples

duckdb is a third-party package. In-process analytical SQL database (like SQLite for analytics). Install with: pip install duckdb

Try in Playground

Tags

packagedatabaseanalyticssqlin-process

Related Items

sqlite3
Stdlib — Database
Built-in SQLite database interface; no server needed
pandas
Package — Data Science
Data manipulation with DataFrame and Series structures
polars
Package — Data Science
Lightning-fast DataFrame library written in Rust
pyarrow
Package — Data Science
Apache Arrow bindings: columnar data, Parquet I/O, zero-copy
sqlalchemy
Package — Database
SQL toolkit and ORM: engine, session, declarative models, query builder
ibis
Package — Database
Pandas-like API that compiles to SQL for multiple backends