π¦ 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.