News for hackers. Stuff that matters.
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.
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.