DuckDB: The tiny but powerful analytics database
Most people assume that analytical databases, or OLAPs, are big, powerful beasts—and they are correct. Systems like Snowflake, Redshift, or Postgres involve a lot of setup and maintenance, even in their cloud-hosted incarnations. But what if all you want is "just enough" analytics for a dataset on your desktop? In that case, DuckDB is worth exploring.
Columnar data analytics on your laptop
DuckDB is a tiny but powerful analytics database engine—a single, self-contained executable, which can run standalone or as a loadable library inside a host process. There's very little you need to set up or maintain with DuckDB. In this way, it is more like SQLite than the bigger analytical databases in its class.