# \#database **URL:** https://community.openhab.org/tag/database/101.md [Latest](https://community.openhab.org/latest.md) · [Categories](https://community.openhab.org/categories.md) · [Tags](https://community.openhab.org/tags.md) --- ## [What persistence for most stable setup?](https://community.openhab.org/t/what-persistence-for-most-stable-setup/165325)
**Author:** [@djoope](https://community.openhab.org/u/djoope)\ **Replies:** 3\ **Last updated:** [August 7, 2025, 2:03pm UTC](https://community.openhab.org/t/what-persistence-for-most-stable-setup/165325 "2025-08-07T14:03:38Z")
Hi Without going into details, I have on several occasions and versions of openHAB (on RPI 3, 4, and 5) tried to achieve a stable and self-sustaining database and history. However, I have not been able to get it to work… --- ## [Use case: How to delete or change item values in openHAB's influxDB](https://community.openhab.org/t/use-case-how-to-delete-or-change-item-values-in-openhabs-influxdb/142452)
**Author:** [@Cplant](https://community.openhab.org/u/Cplant)\ **Replies:** 1\ **Last updated:** [January 2, 2023, 12:45pm UTC](https://community.openhab.org/t/use-case-how-to-delete-or-change-item-values-in-openhabs-influxdb/142452 "2023-01-02T12:45:48Z")
Important Changing data directly in influxDB is risky. Only proceed after you’ve created a backup and successfully tested whether you could safely restore from this backup in case something went wrong. 0) Setup The foll… --- ## [OH GUI based configuration - DB connection fail](https://community.openhab.org/t/oh-gui-based-configuration-db-connection-fail/139618)
**Author:** [@backflip](https://community.openhab.org/u/backflip)\ **Replies:** 13\ **Last updated:** [December 2, 2022, 8:03am UTC](https://community.openhab.org/t/oh-gui-based-configuration-db-connection-fail/139618 "2022-12-02T08:03:40Z")
Hi I noticed some DB connection issues after I rebuilt a new Raspi4 with OH3.3. After checking DB configuration and permission, I searched for other hints, but I only found some older posts which are file based configur… --- ## [Upgrading in place to OH3 on Windows](https://community.openhab.org/t/upgrading-in-place-to-oh3-on-windows/120600)
**Author:** [@auzick](https://community.openhab.org/u/auzick)\ **Replies:** 2\ **Last updated:** [April 16, 2021, 11:56am UTC](https://community.openhab.org/t/upgrading-in-place-to-oh3-on-windows/120600 "2021-04-16T11:56:12Z")
After much wringing of hands an gnashing of teeth, I’ve given up on setting up a brand new OH3 instance in Ubuntu under either Docker or HyperV on a Windows 10 WSL2 instance. Just too many roadblocks. Instead, I’m going… --- ## [Modify a zwave binding jar to add/change a zwave device while waiting for a build](https://community.openhab.org/t/modify-a-zwave-binding-jar-to-add-change-a-zwave-device-while-waiting-for-a-build/47326)
**Author:** [@5iver](https://community.openhab.org/u/5iver)\ **Replies:** 37\ **Last updated:** [February 12, 2021, 1:47pm UTC](https://community.openhab.org/t/modify-a-zwave-binding-jar-to-add-change-a-zwave-device-while-waiting-for-a-build/47326 "2021-02-12T13:47:26Z")
\*\*PLEASE don’t use this without also updating the device database! As a community, we make the most progress when everyone contributes!\*\* I’ve seen several posts where people have made changes to the device database and… --- ## [Feature Request - Store Things/Items/Rules in Textfiles instead of database](https://community.openhab.org/t/feature-request-store-things-items-rules-in-textfiles-instead-of-database/106440)
**Author:** [@bf8392](https://community.openhab.org/u/bf8392)\ **Replies:** 6\ **Last updated:** [October 14, 2020, 12:20pm UTC](https://community.openhab.org/t/feature-request-store-things-items-rules-in-textfiles-instead-of-database/106440 "2020-10-14T12:20:19Z")
Hi =), I want to discuss new way of storing things/items and Rules in openhab =) . Maybe this is already implemented yet, but it would be nice to store everything in textfiles instead of database, or provide some kind of… --- ## [OH2 crashed, deleted Things and Things backups](https://community.openhab.org/t/oh2-crashed-deleted-things-and-things-backups/93495)
**Author:** [@bigal83](https://community.openhab.org/u/bigal83)\ **Replies:** 12\ **Last updated:** [February 28, 2020, 3:45pm UTC](https://community.openhab.org/t/oh2-crashed-deleted-things-and-things-backups/93495 "2020-02-28T15:45:04Z")
Hi, OH2 stopped working so I did a reboot and after that all Things are gone. Items are still there.. I found a thread of how to restore from a backup but found that ALL backups for Things was 0 bytes. Is their anyway … --- ## [How to change database table persistence gets written to?](https://community.openhab.org/t/how-to-change-database-table-persistence-gets-written-to/89380)
**Author:** [@StefanMUC](https://community.openhab.org/u/StefanMUC)\ **Replies:** 6\ **Last updated:** [January 3, 2020, 6:03pm UTC](https://community.openhab.org/t/how-to-change-database-table-persistence-gets-written-to/89380 "2020-01-03T18:03:23Z")
Hi there, OpenHAB uses CoC (Convention over Configuration) for reading and writing persistence data to database (e.g. InfluxDB). If an item is named My\_Item it gets saved to database table / time series My\_Item. How do… --- ## [Database browser](https://community.openhab.org/t/database-browser/72733)
**Author:** [@Selter](https://community.openhab.org/u/Selter)\ **Replies:** 5\ **Last updated:** [April 18, 2019, 8:11pm UTC](https://community.openhab.org/t/database-browser/72733 "2019-04-18T20:11:37Z")
Hi there, I’m looking for a database browser for rrd4j and mapdb like “heidisql” or “mySQL workbench” for mySQL. Thanks, Selter --- ## [OH2 database or files](https://community.openhab.org/t/oh2-database-or-files/20104)
**Author:** [@MrBoggi](https://community.openhab.org/u/MrBoggi)\ **Replies:** 8\ **Last updated:** [April 14, 2019, 8:34am UTC](https://community.openhab.org/t/oh2-database-or-files/20104 "2019-04-14T08:34:33Z")
Hi I’m currently going over to Openhab2 from Homeseer. I have a simple question and would like to know if I should go for using database (PaperUI) or files (.things, .items and so on). As far as I understand, not everyt… --- ## [Graph from independent data points](https://community.openhab.org/t/graph-from-independent-data-points/70437)
**Author:** [@wjaceh](https://community.openhab.org/u/wjaceh)\ **Replies:** 19\ **Last updated:** [March 26, 2019, 6:39am UTC](https://community.openhab.org/t/graph-from-independent-data-points/70437 "2019-03-26T06:39:39Z")
Hi, I need to graph some datapoints to sitemap or grafana, but I have the data values in 48 separate items. So I can’t use one persisted item to plot it over time. I get today’s and tomorrows energy prices in-front an… --- ## [Jython and (Postgre)SQL](https://community.openhab.org/t/jython-and-postgre-sql/65577)
**Author:** [@erniemur](https://community.openhab.org/u/erniemur)\ **Replies:** 0\ **Last updated:** [January 26, 2019, 11:27am UTC](https://community.openhab.org/t/jython-and-postgre-sql/65577 "2019-01-26T11:27:34Z")
Which Database driver do you use for connecting to postgreSQL from a Jython JSR223 script? Does anybody use psycopg2? Info: I want to query data from a postgreSQL database from Jython scripts and/or modules. I already … --- ## [Z-wave Everspring Motion Sensor HSP02-0 showing as unknown device](https://community.openhab.org/t/z-wave-everspring-motion-sensor-hsp02-0-showing-as-unknown-device/23630)
**Author:** [@Steven\_Reimer](https://community.openhab.org/u/Steven_Reimer)\ **Replies:** 7\ **Last updated:** [December 21, 2018, 7:37am UTC](https://community.openhab.org/t/z-wave-everspring-motion-sensor-hsp02-0-showing-as-unknown-device/23630 "2018-12-21T07:37:34Z")
This motion sensor has initialized but is showing as unknown. I’m guessing that it’s not in the device database. In Things it shows However there is no corresponding item. Is there anything else required to have this… --- ## [Read Write from/to MySQL Database!?](https://community.openhab.org/t/read-write-from-to-mysql-database/28735)
**Author:** [@siod](https://community.openhab.org/u/siod)\ **Replies:** 8\ **Last updated:** [December 7, 2018, 3:13pm UTC](https://community.openhab.org/t/read-write-from-to-mysql-database/28735 "2018-12-07T15:13:44Z")
Hi all, I started to build a power consumption measurement sensor following this project (german, how to sense a reflective disk of the Ferraris meter): Infrarot Lichtschranke mit Arduino zum Auslesen des Stromzählers … --- ## [\[MongoDB\] Persistence Service cannot connect to MongoDB Atlas (DBaaS)](https://community.openhab.org/t/mongodb-persistence-service-cannot-connect-to-mongodb-atlas-dbaas/57307)
**Author:** [@nikhil1983](https://community.openhab.org/u/nikhil1983)\ **Replies:** 15\ **Last updated:** [November 20, 2018, 9:30am UTC](https://community.openhab.org/t/mongodb-persistence-service-cannot-connect-to-mongodb-atlas-dbaas/57307 "2018-11-20T09:30:13Z")
Hello everyone, I am currently using mongodb database to store my openhab items values. here is my mongodb.cfg file: url=mongodb://localhost:27017 database=openhab collection=serial I am able to access the Local Mo… --- ## [RDD4J on NAS](https://community.openhab.org/t/rdd4j-on-nas/54823)
**Author:** [@rubliexpress](https://community.openhab.org/u/rubliexpress)\ **Replies:** 2\ **Last updated:** [October 26, 2018, 7:42pm UTC](https://community.openhab.org/t/rdd4j-on-nas/54823 "2018-10-26T19:42:38Z")
Hello community Is it possible to store the RDD4J database on a network NAS instate local on my raspberryPI? How? What is the best way? The background is that i want to mount my raspberryPi in a read-only mode. thank… --- ## [Unknown device - I'm lost!](https://community.openhab.org/t/unknown-device-im-lost/41776)
**Author:** [@Rob\_Haynes](https://community.openhab.org/u/Rob_Haynes)\ **Replies:** 14\ **Last updated:** [March 17, 2018, 5:16pm UTC](https://community.openhab.org/t/unknown-device-im-lost/41776 "2018-03-17T17:16:31Z")
I am currently making Amazon rich by ordering Zwave devices. But so far 3 of them come up undefined. I’ve been searching the documentation here and am as confused as h.||. There is an infamous database. I found it on… --- ## [Using exec binding to create custom SQL queries and question about interrupts](https://community.openhab.org/t/using-exec-binding-to-create-custom-sql-queries-and-question-about-interrupts/36024)
**Author:** [@newHere](https://community.openhab.org/u/newHere)\ **Replies:** 4\ **Last updated:** [November 10, 2017, 5:37pm UTC](https://community.openhab.org/t/using-exec-binding-to-create-custom-sql-queries-and-question-about-interrupts/36024 "2017-11-10T17:37:34Z")
Hey! So I’m rather inexperienced with openHAB, but I’ve been testing the persistence bindings and so far have not seen a solution to load values from queries or write specifics things into a database. I concluded that a… --- ## [Aeon Labs Window / Door Sensor 6](https://community.openhab.org/t/aeon-labs-window-door-sensor-6/10990)
**Author:** [@bun](https://community.openhab.org/u/bun)\ **Replies:** 15\ **Last updated:** [October 23, 2017, 8:57pm UTC](https://community.openhab.org/t/aeon-labs-window-door-sensor-6/10990 "2017-10-23T20:57:42Z")
I purchased a Aeon Labs Window / Door Sensor 6 model ZW112-A. The OpenHAB log says that it isn’t in the database. “No database entry: Aeon Labs \[ID:70,Type:102\]” I tried to add it but noticed it is already in the databa… --- ## [Rule to Write values to a custom db table](https://community.openhab.org/t/rule-to-write-values-to-a-custom-db-table/34784)
**Author:** [@mtrax](https://community.openhab.org/u/mtrax)\ **Replies:** 3\ **Last updated:** [October 4, 2017, 2:18pm UTC](https://community.openhab.org/t/rule-to-write-values-to-a-custom-db-table/34784 "2017-10-04T14:18:42Z")
When a rule is triggered I would like to write to a database table time, value and two other variables? Eg current time, sensor and state --- ## [NextPVR recordings](https://community.openhab.org/t/nextpvr-recordings/26251)
**Author:** [@mikaelgu](https://community.openhab.org/u/mikaelgu)\ **Replies:** 7\ **Last updated:** [April 8, 2017, 8:13am UTC](https://community.openhab.org/t/nextpvr-recordings/26251 "2017-04-08T08:13:20Z")
Hi, I’m looking into getting info of recordings from NextPVR into OpenHAB. Now, I’ve been playing with OpenHAB for about a week, so I’m still very new to it all, so I might be missing something obvious.. Doing some rese… --- ## [Trouble with Fibaro metered smart plug](https://community.openhab.org/t/trouble-with-fibaro-metered-smart-plug/25558)
**Author:** [@tjarvstrand](https://community.openhab.org/u/tjarvstrand)\ **Replies:** 8\ **Last updated:** [March 26, 2017, 6:18pm UTC](https://community.openhab.org/t/trouble-with-fibaro-metered-smart-plug/25558 "2017-03-26T18:18:33Z")
Hi! I’m completely new to OpenHAB and trying to configure my first Z-wave device. I’m running OH2 on a Raspberry Pi with Raspian Jessie Lite. For Z-wave I have an Aeon Labs Z-stick Gen5 and I’m trying to connect a Fibar… --- ## [Energy harvesting](https://community.openhab.org/t/energy-harvesting/25010)
**Author:** [@tomhag](https://community.openhab.org/u/tomhag)\ **Replies:** 2\ **Last updated:** [March 18, 2017, 10:51am UTC](https://community.openhab.org/t/energy-harvesting/25010 "2017-03-18T10:51:50Z")
Hi, I have some Enocean and WEMO power switch with kw/h counter. The Enocean counts from 0 to 65xxxx. Today this is going to a controller that has the logic for Today useage, yesterday, this week, last week, this month… --- ## [Using JDBC and Database from Add-ons](https://community.openhab.org/t/using-jdbc-and-database-from-add-ons/22879)
**Author:** [@ghab](https://community.openhab.org/u/ghab)\ **Replies:** 4\ **Last updated:** [February 13, 2017, 5:55pm UTC](https://community.openhab.org/t/using-jdbc-and-database-from-add-ons/22879 "2017-02-13T17:55:33Z")
Hello Devs, I hope this is the right category for my questions. To be clear, I am a newbie to OpenHAB, but I have experience in Java. 1.Question: I would like to implement some add-on, that gets all generated events … --- ## [Storing serial Data from arduino to database](https://community.openhab.org/t/storing-serial-data-from-arduino-to-database/20964)
**Author:** [@Soham\_Bhalerao](https://community.openhab.org/u/Soham_Bhalerao)\ **Replies:** 2\ **Last updated:** [January 23, 2017, 8:03am UTC](https://community.openhab.org/t/storing-serial-data-from-arduino-to-database/20964 "2017-01-23T08:03:14Z")
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 … --- ## [Losing all things/items after upgrading via apt-get](https://community.openhab.org/t/losing-all-things-items-after-upgrading-via-apt-get/17813)
**Author:** [@philKrylc](https://community.openhab.org/u/philKrylc)\ **Replies:** 3\ **Last updated:** [December 6, 2016, 5:02pm UTC](https://community.openhab.org/t/losing-all-things-items-after-upgrading-via-apt-get/17813 "2016-12-06T17:02:52Z")
Hi everybody, after updating OH2-Online (Nightly) via apt-get I lost all my things and items. All of these are configured in the database. Bindings and addons are defined in the addons.cfg, and were properly reinstalled… --- ## [Duplicating Z-Wave DB entries?](https://community.openhab.org/t/duplicating-z-wave-db-entries/16007)
**Author:** [@kai-bcn](https://community.openhab.org/u/kai-bcn)\ **Replies:** 5\ **Last updated:** [November 1, 2016, 9:08pm UTC](https://community.openhab.org/t/duplicating-z-wave-db-entries/16007 "2016-11-01T21:08:13Z")
I have started with openHABianPi (great!) and am looking at Z-Wave devices which are missing from the DB. Looking at the Z-Wave DB for openhab2 with search term “FGRM222”, I see that there are already multiple entrie… --- ## [Graphing with/without persistence?](https://community.openhab.org/t/graphing-with-without-persistence/9977)
**Author:** [@hedcenforever](https://community.openhab.org/u/hedcenforever)\ **Replies:** 1\ **Last updated:** [April 21, 2016, 3:48pm UTC](https://community.openhab.org/t/graphing-with-without-persistence/9977 "2016-04-21T15:48:57Z")
Hi, Is it possible to graph live sensor data without a database/persistence, or must you have data stored in a database/persistence to create a graph/chart? Thanks