What Is DuckDB and Why Are Data People So Excited About It?
Query CSV files, Parquet, JSON — even data straight from the web — without setting up a database. DuckDB runs anywhere and handles surprisingly large data on just your laptop.
What if you could run real SQL queries on a CSV file sitting on your desktop — no database server, no setup, no cloud account?
That’s DuckDB. It’s a fast, portable analytics database that runs right on your machine. It’s become one of the most talked-about tools in the data world, and for good reason: it makes working with data feel effortless.
Why DuckDB Is Worth Your Time
- Zero setup — Install it and start querying. No servers, no configuration, no Docker containers
- SQL on anything — Point it at a CSV, a Parquet file, a JSON blob, even a URL to a remote dataset, and query it with standard SQL
- Surprisingly fast — It can chew through millions of rows on a laptop that would make Pandas sweat
- Works everywhere — Python, R, the command line, even in the browser. It fits into whatever workflow you already have
What We’ll Do
- Install DuckDB and run our first query in under a minute
- Load a real dataset (no imports, no cleaning — just point and query)
- Write SQL to filter, aggregate, and explore the data
- See how DuckDB compares to tools like Pandas and SQLite for everyday data work
- Connect it to a remote dataset and query it without downloading anything
Who This Is For
If you know some basic SQL or have done any data analysis, you’ll get a lot out of this. If you’ve never written SQL, you’ll still be able to follow along — we’ll keep it approachable.
Date and time coming soon — join the Meetup group to get notified.