i’m looking for links and pointers to learn how to get a decent persistence dB up and running. (I’m already reading the persistence section of the manual) and I’m currently using mapdb for restore on startup functions that @unixe helped me with thanks again for that.
What’s my options for storing values for on/off & numbers like temp?
I dont realy care about file sizes but it can’t be stupid big like above 10GB so i would most probably not store all values like socket signal strengths ect but I would begin with just storing every value too make it simple
Other persistance service as you like. mapdb from my point of view is mandetory for restoreonstartup because other databases starts to late on OH start to do this job.
jdbc can store every kind of datas because there is a sql database in backgroud.
Only problem, as said, to trustable for restoreonstartup. driver starts to late.
You can say why use rrd4j too? If you need it only for graphs, the database does not grow up. It stays on a very little kByte.
that was my next question yes graphs would be nice. I just thought it would be useful to get up and running and i was looking at videos on youtube and saw that another HA system had a nice feature that could be useful
this timeline veiw (having problems with a motion sensor and checking the log is impossible)
i think i will give what you said a try and just run the 3 databases
what sort of size can the other DB grow too?
If you are looking to do all (except RestoreOnStartUp ) in one NONGROWING Database, you could use proxy items to store 9 for On and 1 for Off. That way you could use rrd4j.
There is no limit to how big the DBs can grow and how quickly they grow depends on how often one saves values to it.
I’ve been running OH with InfluxDB on about a dozen Items which get updated at rates of every couple minutes to a couple times an hour. A little more than 6 months worth of data takes up 52MB.
ok so i have got the rrdj4 DB up and running thanks for the help on that i just need a little more work
here is a snip from the log
19:29:04.068 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'LRGoogleHome_Online' with state '1' in rrd4j database
19:29:04.158 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HueBridge_Online' with state 'ON' in rrd4j database (again)
19:29:04.158 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HueBridge_Online' with state '1' in rrd4j database
19:29:04.228 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Motion' with state 'OFF' in rrd4j database (again)
19:29:04.228 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Motion' with state '0' in rrd4j database
19:29:04.267 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Temp' with state '17.28' in rrd4j database
19:29:04.307 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Light' with state '0.9997697679981565' in rrd4j database
19:29:04.328 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Battery' with state '100.0' in rrd4j database
19:29:04.353 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Motion2' with state 'OFF' in rrd4j database (again)
19:29:04.353 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Motion2' with state '0' in rrd4j database
19:29:04.393 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Temp2' with state '12.41' in rrd4j database
19:29:04.424 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Light2' with state '0.9997697679981565' in rrd4j database
19:29:04.451 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'HUE_Battery2' with state '100.0' in rrd4j database
19:29:04.475 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'Plug1_Online' with state 'OFF' in rrd4j database (again)
19:29:04.475 [DEBUG] [sistence.rrd4j.internal.RRD4jService] - Stored 'Plug1_Online' with state '0' in rrd4j database
it looks like stuff is being written to the db successfully i have created a graph and that seems too be working aswell.
it also looks like rrd4j db can actuall store an on and off value and converts it itself as seen in the log
All nice links @rlkoshak but I cannot get influx to work (and due to DST rrd crapped out as well)… so I am stuck as no manual seems to work for my setup.