Hacker News new | ask | show | jobs
by mgaunard 27 days ago
How does it compare to DuckDB?
3 comments

It doesn't really, except I suppose that both are called "databases". DuckDB is intended for OLAP, while Gorilla is specifically designed for time series data. You would never do something like "INSERT INTO users ..." with Gorilla.
DuckDB also has as-of joins

https://duckdb.org/docs/current/guides/sql_features/asof_joi...

Are there workloads time series databases can do where DuckDB would be a bad fit?

To me it sounds like a fancier RRD (as produced and manipulated by RRDtool)
afaiu DuckDB doesn't do delta of delta for timestamps

but it can do delta and bitpacking which is also kinda neat