Based on our record, QuestDB seems to be more popular. It has been mentiond 5 times since March 2021. We are tracking product recommendations and mentions on Reddit, HackerNews and some other platforms. They can help you identify which product is more popular and what people think of it.
I'm writing docs for https://questdb.io/ which offers SQL-based analytics for time series. We have quite a few users already who use us for ML applications that rely on performance. Instead of writing an MQTT -> PostgreSQL bridge, you could use Telegraf to listen to MQTT topics and write data to QuestDB over InfluxDB line protocol when it meets certain criteria. One of our users shared the tooling they use in... - Source: Hacker News / about 1 month ago
Although Telegraf can collect an exceptional amount and variety of data, we need to store and visualize this information at some point. Considering that we collect the metrics over time, a convenient way to store time series data is using a time series database. We'll use QuestDB for ingestion and perform some basic visualization for this tutorial. - Source: dev.to / 2 months ago
I write the docs for QuestDB which is built for this, and we have users already using us for algotrading, so this might be interesting for you. From Python, the fastest inserts will be using InfluxDB line protocol. - Source: Reddit / 3 months ago
I write documentation for QuestDB which I can recommend if latency is a priority for your project. You can use postgres wire using psychopg2 for a quick start. Some types of queries are optimized more than others, but it's likely you can get the performance you're looking for. - Source: Reddit / 5 months ago
For showing financial data over time, a time series database is a good choice. I write the docs for QuestDB which is used a lot for this. Also, I'm curious why SQL is definitely out of the question. - Source: Reddit / 6 months ago
OpenTSDB - OpenTSDB is a distributed, scalable Time Series Database (TSDB) written on top of HBase.
TimescaleDB - TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.
RRDTool - High performance data logging and graphing system for time series data
InfluxData - Scalable datastore for metrics, events, and real-time analytics.
Beekeeper Studio - Open source SQL editor and database manager
Prometheus - An open-source systems monitoring and alerting toolkit.