News for hackers. Stuff that matters.
Re:DuckDB: SQLite for Analytics by cheez on Saturday May 23, 2020 @11:38PM (#23288880)
Ah yes, embarrassing not to remember basic DB architecture :-)

Do you have an example of a workload that benefits from this structure?

Re:DuckDB: SQLite for Analytics by kyllo on Sunday May 24, 2020 @12:09AM (#23289000)
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.
Re:DuckDB: SQLite for Analytics by cheez on Sunday May 24, 2020 @12:53PM (#23292788)
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.