Yes, it's geared toward reporting / analytics / data science workloads where the most common read operation is calculating aggregate metrics like count/min/mean/max and histograms. Statistics stuff.
Thank you very much for your patience :-)
Re:DuckDB: SQLite for Analytics
by nuclearnice1 on Sunday May 24, 2020 @12:08AM
(#23288992)
Taking stats on a collection of time-ordered set of sensor observations.
Do you have an example of a workload that benefits from this structure?