DuckDB Just Hit 25K Stars — And It Deserves Every One

DuckDB crossed 25,000 GitHub stars this month. For a database, that's insane. PostgreSQL has 17K. SQLite doesn't even have a GitHub repo. Why is an in-process analytical database this popular? Because it solves a problem every data person has: analyzing data locally without setting up a server . What DuckDB Does DuckDB is an in-process OLAP database. Think SQLite, but for analytics instead of transactions. import duckdb # Query a CSV file directly — no import needed result = duckdb . sql ( """ SELECT category, SUM(revenue) as total FROM ' sales_data.csv ' GROUP BY category ORDER BY total DESC LIMIT 10 """ ) print ( result ) That's it. No server. No Docker. No connection strings. Just pip install duckdb and query files. Why Developers Love It 1. Query Any File Format -- CSV SELECT * FROM 'data.csv' ; -- Parquet SELECT * FROM 'data.parquet' ; -- JSON SELECT * FROM 'data.json' ; -- Even remote files SELECT * FROM 'https://example.com/data.csv' ; 2. Faster Than Pandas On a 10M row dataset: