rtl_433 mhz

One of the most difficult problems I’ve attempted to resolve in the last few years, is how to capture and record (into mysql database) data received from 433mhz sensors..

rtl_433 -M utc -F json -G

{“time” : “2019-09-25 19:11:54”, “model” : “Acurite tower sensor”, “id” : 2766, “sensor_id” : 2766, “channel” : “A”, “temperature_C” : 22.700, “humidity” : 44, “battery_low” : 0}

{“time” : “2019-09-25 19:12:01”, “model” : “Acurite Lightning 6045M”, “id” : 253, “channel” : “A”, “temperature_F” : 72.100, “humidity” : 41, “strike_count” : 26, “storm_dist” : 27, “active” : 1, “rfi” : 0, “ussb1” : 0, “battery” : “OK”, “exception” : 0, “raw_msg” : “c0fd6fa9d12d9a1b88”}

{“time” : “2019-09-25 19:12:04”, “model” : “Smoke detector GS 558”, “id” : 8078, “unit” : 14, “learn” : 0, “code” : “63f1ce”}

Trying to parse and collect the data using LiveCode has proven to be difficult. First problem with rtl receiver, is it isn’t seen as a com port, or other readable device. It is seen as its own terminal device. I’ve tried piping, didn’t work. Basically everything I’ve tried, hasn’t worked.

The best advice I have received to is send data out to flat file, then read the file. Which basically mean lots of file activity and parsing. Unsure if I am willing to do that for what should be a simple task. That would cause a great deal of read/write activity on the SD drives and possibly wear out the drive faster.

Heard of a new program that outputs the data to files specific to the device id, trying to find it. Will keep everyone informed.