heatpumpMonitor

Data storage architecture

Asked by Joao

Hello,

I am planning to use your application to retrieve data from my TECALOR THZ 303 SOL and for this, I plan to use a Raspberry Pi to collect the data.

If I understood correctly, your package reads/writes the data from a file, is that correct?

As the Raspberry uses an SD card, I need to limit the number of read/write cycles on the memory card in order to avoid damage.
So my idea was to have an SQL DB somewhere on the network where I could store the data taken from the heating pump.

Question:
Did you already use this kind of architecture with your library (collect data and send it to an SQL database)?
If so, can you send me some information/libraries used for this?

If not, I plan to start the development on this and I will be happy to share it with you.

regards
Joao

Question information

Language:
English Edit question
Status:
Answered
For:
heatpumpMonitor Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Robert Penz (robert-penz-name) said : 		#1

The software does use a rrd database to store the values. I would propose to create a ramdrive and put the rrd there and copy it one every hour to the sd card. so in case of the power failure you lose 1h ... buts that not a big problem as rrd compresses the value with time by itself. To copy I'll recommend to use rsync as only the blocks that are changed get written.

ps: rendering to the png files could be also done on a ramdrive .. and than copied to a webserver .. no need to copy it to the sd card

Can you help with this problem?

Provide an answer of your own, or ask Joao for more information if necessary.

To post a message you must log in.