DuckDB is really for OLAP/Columnar (analytical workloads) whereas SQLite is more... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		chrisjc on May 30, 2024 \| parent \| context \| favorite \| on: DuckDB Doesn't Need Data to Be a Database DuckDB is really for OLAP/Columnar (analytical workloads) whereas SQLite is more for OLTP/Row-based (transactional). When you start running aggregations/windows over large amounts of data, you'll soon see the difference in performance.

zie on May 30, 2024 [–]

Sure, but the OP is using DuckDB as a way to export some smaller amount of data for someone. That's a great use-case for SQLite, from whatever your real DB is, which for the OP is also DuckDB.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact