ticktock
QuestDB
ticktock | QuestDB | |
---|---|---|
2 | 311 | |
71 | 13,520 | |
- | 1.0% | |
9.1 | 9.7 | |
7 days ago | 3 days ago | |
C++ | Java | |
GNU General Public License v3.0 only | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ticktock
-
ePaper-Weather: My own build of a weather monitoring display for my personal needs
Additionally, because I love building up data infrastructure, I've added a Grafana instance backed by an InfluxDB. I've tried TickTock instead of InfluxDB because I was afraid of performance issues on a Raspy, but I had stability issues with TickTock. Also InfluxDB doesn't seem to cause memory or CPU issues.
-
Help with timeseries data
TickTockDB is a new open-src TSDB. Although it is not rich in features, its write throughput can reach 3.2M data points/sec v.s. InfluxDB 74K in a 2c4g x86 (detail report here). It is enough for your case (79M data point/day = 914/sec). You may also have to consider max cardinality (i.e., number of time series supported) of TSDB. TickTockDB's max cardinality is 2M v.s. InfluxDB 150k in RaspberryPI4 (detail report here)).
QuestDB
-
How to Forecast Air Temperatures with AI + IoT Sensor Data
If your data lacks uniform time intervals between consecutive entries, QuestDB offers a solution by allowing you to sample your data. After that, MindsDB facilitates creating, training, and deploying your time-series models.
-
Normalizing Grafana charts with window functions
If you're interested in that functionality or have any other feedback, please drop by our open source repository or community Slack and let us know.
-
How to increase Grafana refresh rate frequency
QuestDB is a high-performance time series database with SQL analytics that can power through market data ingestion and analysis. It's open source and integrates well with the tools and languages you use. Check us out!
-
Building a faster hash table for high performance SQL joins
Looks like full keys are always compared if hash codes test equal, which is what I'd expect. For example: https://github.com/questdb/questdb/blob/master/core/src/main...
-
K3s Traefik Ingress - configured for your homelab!
But of course, I want to run a QuestDB instance on my node, which uses two additional TCP ports for Influx Line Protocol (ILP) and Pgwire communication with the database. So how can I expose these extra ports on my node and route traffic to the QuestDB container running inside of k3s?
-
Annotations in Kubernetes Operator Design
In this post, I will detail a way in which I recently used annotations while writing an operator for my company's product, QuestDB. Hopefully this will give you an idea of how you can incorporate annotations into your own operators to harness their full potential.
-
Is all data time-series data?
QuestDB is an open source, high performance time series database. With its massive ingestion throughput speeds and cost effective operation, QuestDB reduces infrastructure costs and helps you overcome tricky ingestion bottlenecks. Thanks for reading!
- questdb: NEW Data - star count:12960.0
What are some alternatives?
inkyWeather - A python script that draws weather conditions on an Inky-phat e-paper display
TDengine - TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.
epaper-weather - A small program to display weather data on a 2.13 inch epaper screen, with some monitoring
arctic - High performance datastore for time series and tick data
griddb - GridDB is a next-generation open source database that makes time series IoT and big data fast,and easy.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
e_paper_weather_display - Raspberry Pi weather display using Waveshare e-paper display and Open Weather Map API
SQLAlchemy - The Database Toolkit for Python
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
VictoriaMetrics - VictoriaMetrics: fast, cost-effective monitoring solution and time series database
machbase-neo - machbase-neo = time series database + mqtt + http + data visualization
tsbs - Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data