DuckDB is a fast in-process analytical database DuckDB supports a feature-rich SQL dialect complemented with deep integrations into client APIs. DuckDB v1.0.0 was released in June 2024. Installation Documentation -- Get the top-3 busiest train stations SELECT station_name, count(*) AS num_services FROM train_services GROUP BY ALL ORDER BY num_services DESC LIMIT 3;
![An in-process SQL OLAP database management system](https://cdn-ak-scissors.b.st-hatena.com/image/square/1d4536e82d2c50028ba77fc10a6adbd1ddd9bf99/height=288;version=1;width=512/https%3A%2F%2Fduckdb.org%2Fimages%2Fsharingduckdb.jpg)