DuckDB Flashcards

πŸ¦† DuckDB Flashcards
πŸ” What is DuckDB?
DuckDB is an in-process SQL OLAP database management system optimized for fast analytics on small to medium-sized datasets.

πŸ› οΈ Where does DuckDB run?
DuckDB runs directly within applications β€” like Python, R, or even a browser β€” without a separate server process.

πŸš€ What makes DuckDB unique?
It’s lightweight, embeddable, and designed for lightning-fast analytical queries with zero configuration.

πŸ“¦ What data formats does DuckDB support?
DuckDB can read Parquet, CSV, JSON, Arrow, and more β€” often without any loading or import steps.

πŸ“Š What is DuckDB ideal for?
It’s perfect for local analytics, notebooks, prototyping, and fast exploration of datasets in-memory.

🀝 Can DuckDB integrate with Pandas?
Yes, DuckDB has tight integration with Pandas β€” allowing fast SQL queries on dataframes.

🧬 Does DuckDB persist data?
Yes, DuckDB can write to disk-based databases or query in-memory, based on your needs.

πŸ§ͺ Is DuckDB good for data science?
Absolutely β€” it supports quick experimentation and analysis in Jupyter notebooks and scripts.

πŸ”Œ What are extensions in DuckDB?
DuckDB supports extensions like HTTPFS, spatial queries, or even working inside web environments.

πŸ“š What SQL dialect does DuckDB use?
DuckDB is largely compliant with PostgreSQL-like SQL syntax, making it easy to pick up.