Hi,
I am looking at the best way in capturing the following in my B4J app.
There is 500+ locations sending incoming data to my B4J app.
Each location has 40 temperature sensors.
As the temperature changes it will send the new temperature value to my B4J app.
I am trying to work out the best way in saving this temperature in a SQLite database in my B4J app.
I would need to know:
- Timestamp
- Temperature received
- Which sensor it was
- The location
I then need to receive the data and display it to the user based on the location.
So I was planning on having 1 single database table, and have 4 columns: Timestamp, temp, sensor, location.
Then I could do a SQL request like, Select all temp from location, then somehow make a JSON message with the temp, sensor and timestamp for each record.
I plan to only capture 10,000 temps per location and then begin to overwrite old temperatures.
What would be the best way in doing this ?
Open to suggestions.
I am looking at the best way in capturing the following in my B4J app.
There is 500+ locations sending incoming data to my B4J app.
Each location has 40 temperature sensors.
As the temperature changes it will send the new temperature value to my B4J app.
I am trying to work out the best way in saving this temperature in a SQLite database in my B4J app.
I would need to know:
- Timestamp
- Temperature received
- Which sensor it was
- The location
I then need to receive the data and display it to the user based on the location.
So I was planning on having 1 single database table, and have 4 columns: Timestamp, temp, sensor, location.
Then I could do a SQL request like, Select all temp from location, then somehow make a JSON message with the temp, sensor and timestamp for each record.
I plan to only capture 10,000 temps per location and then begin to overwrite old temperatures.
What would be the best way in doing this ?
Open to suggestions.