DuckDB: An OLAP Query Engine Inside Your Process
DuckDB is an in-process columnar OLAP database for Parquet, CSV, and DataFrames, not a conventional multi-user OLTP server for web applications.
#olap
2 postsClickHouse: When PostgreSQL Analytics Queries Start Slowing Down, You Need OLAP
ClickHouse is a column-oriented OLAP database that scans hundreds of millions of rows in seconds. DaoDao uses it to record user behavior events for the AI recommendation engine's feature engineering, letting PostgreSQL focus on transactional data.