2 ms·
How does Timescale compare to other extensions like Citus and Hydra/DuckDB?
by whitepoplar 2y ago
How does Timescale compare to other extensions like Citus and Hydra/DuckDB?
- mdaniel 2y agofor one thing, depending on your licensing contraints: - Citus is AGPLv3 https://github.com/citusdata/citus/blob/v13.0.1/LICENSE https://github.com/citusdata/citus/blob/v13.0.1/LICENSE - Hydra is Apache 2 https://github.com/hydradatabase/columnar/blob/v1.1.2/LICENSE https://github.com/hydradatabase/columnar/blob/v1.1.2/LICENS... - Timescale is mostly Apache 2 https://github.com/timescale/timescaledb/blob/2.18.2/LICENSE https://github.com/timescale/timescaledb/blob/2.18.2/LICENSE
- jascha_eng 2y agoI'm not an expert on either of those, but this is my take anyway: Citus is distributed and afaik just eventually consistent, for a lot of folks that's simply not an option as their application relies on ACID compliance. As far as I understand Hyda + DuckDB it is a higher level add-on onto postgres than timescale is. This is on the one hand nice since you can just put it into an existing database without any migration effort whatsoever. But this also means they likely don't really interact with systems like the storage engine. For example Timescales deeper integration allows us to actually store the data differently on disk which allows for saving space via compression.