Storing serial Data from arduino to database

[Soham_Bhalerao]

Hello,
I am really new to openhab and i am trying different things.
Right now i have successfully connected arduino(with 6 sensors) and displaying data on openhab.
Now i want to store this data in database, so that i can use it afterwards.
i have read about mysql persistence,but i am not understanding how can use to bindings at the same time(serial and mysql).
Please correct if i am worng.
Thank you

[Dim (Angelos)]

One of the best tutorials (if not the best) in this community forum is:

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…

If you want, you can use mysql persistence to store the item values over time. Then you would need a graphing “solution” to display the stored date. I am not sure if Grafana can link to a mysql db and query data from there… you could try that also.

In general: A persistence service will store the values from selected items on predefined intervals that you specify.
It doesn’t really matter what the items are bound to (they could be KNX binding based or serial binding based, etc, etc). The value of the item gets persisted, so if you get your item working, you will then be able to store that value in a db (and then, use or graph the data).

Check out these threads also:

InfluxDB + Grafana vs. MySQL + rrd4j

I’m novice with OpenHAB (2) and therefore would like to hear other opinions on persistence services. After read the tutorial of InfluxDB + Grafana: …in my mind raise a question why would somebody still use MySQL or rrd4j as a persistence service WITHOUT any burden of history? In other words, if you are completely new who would like to save item data for later analysis purposes but have clean table from start of, could InfluxDB/Grafana combo be all you need? Would MySQL or rrd4j give anythi…

and

Good Tutorial On Persistence (RRD4J and JDBC-MYSQL)?

It depends on what you want to do with the data. I use a three tiered rule of thumb. Tier 1- use MapDB with restoreOnStartup for everything. Tier 2 - use rrd4j for items I want to chart or need to check its previous state and the like in rules. Tier 3 - use a “real” database for Items I want to study or analyze or use outside of OH or want to keep accurate data for long periods of time. I actually do not use Tier 3 in my setup and only have a dozen or so items in Tier 2. MapDB is good for T…

[Soham_Bhalerao]

Thank you Dimitris for the suggestions.
I will go through it.