{"repo":"ioBroker/ioBroker.sql","free":true,"listed":false,"github":"https://github.com/ioBroker/ioBroker.sql","clone":"git clone https://github.com/ioBroker/ioBroker.sql.git","description":"Store history data in SQL Database: MySQL, PostgreSQL or SQLite","language":"JavaScript","stars":46,"topics":["mssql","mysql","postgresql","sqlite","iobroker","storage-provider","history-adapter","history"],"license":"MIT","category":"databases-storage","readme_excerpt":"ioBroker.sql This adapter saves state history into SQL DB. Supports PostgreSQL, mysql, Microsoft SQL Server and sqlite. You can leave port 0 if the default port is desired. This adapter uses Sentry libraries to automatically report exceptions and code errors to the developers. For more details and for information how to disable the error reporting, see Sentry-Plugin Documentation! Sentry reporting is used starting with js-controller 3.0. Settings Connection Settings - DB Type : Type of the SQL DB: MySQL, PostgreSQL, MS-SQL or SQLite3 - Host : IP address or host name with SQL Server - Port : Port of SQL Server (leave blank if not sure) - Database name : Database name. Default iobroker - User : Username for SQL. Must exist in the DB. - Password : Password for SQL. - Password confirm : Just repeat password here. - Encrypt : Some DBs support encryption. - Round real to : Number of digits after the comma. - Allow parallel requests : Allow simultaneous SQL requests to DB. - Do not create database : Activate this option if a database already created (e.g. by administrator) and the ioBroker-user does not have enough rights to create a DB. Default Settings - Debounce Time - Protection against unstable values to make sure that only stable values are logged when the value did not change in the defined amount of Milliseconds. ATTENTION: If values change more often than this setting effectively, no value will be logged (because any value is unstable) - Blocktime - Defines for how long aft","default_branch":null,"files":null,"tree":[],"storefront":"/r/ioBroker","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ioBroker/ioBroker.sql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}