Help with Persistence DB config

[rlkoshak (Rich Koshak)]

@HomeAutomation

There is a good post from rich here. I cannot find it but look for it.

Design Pattern: Group Based Persistence

Edit: Updated for OH 4 See Design Pattern: What is a Design Pattern and How Do I Use Them for an explanation of what a DP is and how to use them. Problem Statement There are several reasons why a home automation enthusiast would want to use openHAB persistence: charting, using historical Item states in rules logic, restore previous values on openHAB restart, detailed analysis, access to the data with external tools, etc. By default, a persistence add-on will implement a default strategy which…

Other useful links:

InfluxDB+Grafana persistence and graphing

Store your openHAB item states in an InfluxDB time-series datastore and create highly customizable diagrams with Grafana. These diagrams can in return be included in your sitemap as images. [image] Following this guide, you will install InfluxDB and Grafana, make openHAB store data in an InfluxDB database, make Grafana fetch data from the InfluxDB database and draw diagrams. Finally you can include these diagrams in your openHAB sitemap. Table of Content Starting Point InfluxDB Installation …

https://docs.openhab.org/configuration/sitemaps.html#element-type-chart

@Sharpy

what sort of size can the other DB grow too?

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.