Android Question Best way to store time-series

Blueforcer

Well-Known Member
Licensed User
Longtime User
What is the best way to store and read massive volumes of time-stamped data produced by sensors?
It needs to be locally. As i know SQLlite is not that good for parallel reading and writing.
Is there a better solution?
 
Last edited:

thetahsk

Active Member
Licensed User
Longtime User

This is a typical task for a Time Series Database (TSDB), such as InfluxDB.
In combination with Telegraf and Grafana, the data from the sensor is collected and visualised.

Very easy installation on an Rasberry and there is also an InfluxDB client for Arduino


See for more information in this german tutorial.
 
Last edited:
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
Just found your post, will this help to manage my project?
[WebApp] Concurrent access to SQLite databases | B4X Programming Forum
This is relevant for server solutions where multiple threads will access the database at once.

It is not relevant for B4A apps.
You don't need to do anything special. Do you use the async methods and make sure that your database is designed efficiently.

It is impossible to say whether it will be fast or not for your requirements. You need to do some tests.
 
Upvote 0

Blueforcer

Well-Known Member
Licensed User
Longtime User
This is a typical task for a Time Series Database (TSDB), such as InfluxDB.
In combination with Telegraf and Grafana, the data from the sensor is collected and visualised.

Very easy installation on an Rasberry and there is also an InfluxDB client for Arduino


See for more information in this german tutorial.

Yes, im using InfluxDB for another project. But this time it needs to be locally on the device itself. And there is no influxDB server for android.
 
Upvote 0

Sandman

Expert
Licensed User
Longtime User
How about you describe your upcoming project a little more, with focus on the data flowing back and forth?
 
Upvote 0
Top