SQL

Rens Brandwijk

Enables Homey request data from a MYSQL server

** MYSQL Sensor App for Athom homey ** CHANGELOG * 2.0.3 - added MySQL POWER DEVICE (cumulative) - 2.0.2 - fixed name for sensor device - 2.0.1 - Added support for sensor device - 2.0.0 - Update to SDK 2 - Added support for gas and weather device - 1.0.0 First release - Icon changed - 0.0.2 - Small bugfixes. - powermult set during pairing became corrupt. - Default powermult removed - Version number changed - USAGE With this app you can create virtual devices that gather data from a mysql database into homey. The database can be on a NAS or on a seperate server. - SETUP - Install the app on your homey. - Add a MySQL device. - Fill the folowing fields - Name : Name of device - Host : Name of MYSQL server - User : User name used to contact MYSQL server - Password : Password - Query : Query used to retrieve data. Use the following fieldnames: Power device : power (current usage in watt) and meter (total use in KwH) Power device(cumulative): power (current usage in watt), meterpower (total use in KwH), meterinmax (total use in KwH), meteroutmax (total return in KwH), meterintoday (total use in KwH in today), meterouttoday (total return in KwH out today), metertotal_today (total usage or return in KwH today) gas device : meter (total use in m3) weather device : temp (current temperature in C) and humidity (Current humidity in %) sensor device : triggered (integer value greater then 0 is alarm triggered) - Energy Multiplier : Correction factor for energy value. P1 (smartmeter) logs for example output 10 watt as 0.010 so the correction factor is 1000 - Polling rate :Number of seconds between MySQL server poll 10 - 10 seconds. *FEATURES - DEVICES - MySQL POWER DEVICE - MySQL POWER DEVICE (cumulative) - MYSQL GAS DEVICE - MYSQL WEATHER DEVICE - MYSQL SENSOR DEVICE Cards and flows are athoms default by these types of devices.

Supported devices

MYSQL Power Device
MYSQL Power Device (cumulative)
MYSQL gas Device
MYSQL weather Device
MYSQL sensor Device

Reviews

This app has no reviews yet.

You can leave a review once you're using this app.

Thank you for your review.

Submit review

Write a review

Install SQL on

SQL will install on Homey shortly.

Install

Be the first to hear about Homey’s latest developments.

Subscribe to our newsletter and be on top-of-mind about new Homey features, exclusive offers and more.