In my case, the typical scenario is running aggregation and analytical functions... | Hacker News

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

		scoresmoke on May 24, 2020 \| parent \| context \| favorite \| on: DuckDB: SQLite for Analytics In my case, the typical scenario is running aggregation and analytical functions over a small number of columns, while the number of rows is huge. The SQL syntax is the same, but the columnar storage model better fits this case. A good illustration is available in ClickHouse documentation: https://clickhouse.tech/docs/en/#why-column-oriented-databas....

stilisstuk on May 24, 2020 [–]

Thanks..reading the link.

Edit: really interesting. That makes sense. But also a very strict set of requirements.

Thanks.

scoresmoke on May 24, 2020 | [–]

Just as always, there is no silver bullet.

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