From 85fa2685543a1906e7bd47e9d94d02606d0917ef Mon Sep 17 00:00:00 2001 From: Dobrica Pavlinusic Date: Thu, 3 Aug 2017 14:10:45 +0200 Subject: [PATCH 1/1] added description of project --- README | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 README diff --git a/README b/README new file mode 100644 index 0000000..bcfcc08 --- /dev/null +++ b/README @@ -0,0 +1,7 @@ +Capture 433 Mhz sensors using rtl-sdr emit json using mqtt and save to influx/PostgreSQL + + +Example queryies: + + select time,model,json->'temperature_C' as temp,((abs((json->>'temperature_C')::float) - 32)/(9/5)) as f2c,json->'humidity' as hum from rtl433 where (json->>'temperature_C')::float < 200 order by time desc limit 30 ; + -- 2.20.1