Re:The uses and abuses of Cloud Data Warehouses
by RyanHamilton on Friday August 18, 2023 @04:33AM
(#37172819)
For real-time and large historical data, open source there's tdengine/questdb, commercial DolphinDB and kdb+. If you only need fast recent data and not large historical embedding is a good solution which means h2/duckdb/sqlite if open source, extremedb if commercial. I've benchmarked and ran applications on most these databases including running real-time analytics.
[ Parent
| on HN ]
Re:The uses and abuses of Cloud Data Warehouses
by qoega on Friday August 18, 2023 @04:55AM
(#37172967)
Open-source ClickHouse also allows both real-time and large historical data.
Re:The uses and abuses of Cloud Data Warehouses
by nhourcard on Friday August 18, 2023 @06:00AM
(#37173486)
QuestDB, kdb+ and others mentioned are more geared toward time-series workloads, while Clickhouse is more toward OLAP. There are also exciting solutions on the streaming side of things with RisingWave etc.