AdaFruit Funhouse publishing Temperature, Humidity and Pressure to MQTT / Apache Pulsar

Related tags

Networkingpulsar-adafruit-funhouse
Overview

pulsar-adafruit-funhouse

AdaFruit Funhouse publishing Temperature, Humidity and Pressure to MQTT / Apache Pulsar

Device

Adafruit Funhouse

Get your own from adafruit

Fork of adafruit Funhouse

I removed the mqtt consume, as I just want to produce data. I also lowered the time down to 10 seconds to get more data.

Apache Pulsar / MQTT Server Setup

bin/pulsar-admin topics create persistent://public/default/funhousestate

bin/pulsar-admin topics create persistent://public/default/funhouselightstate

bin/pulsar-admin topics create persistent://public/default/funhouselightset

bin/pulsar-client consume "persistent://public/default/funhousestate" -s "fhs" -n 0

bin/pulsar-client consume "persistent://public/default/funhouselightstate" -s "fhs2" -n 0

Example Consuming


11:02:47.628 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConnectionPool - [[id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650]] Connected to server
11:02:47.628 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ClientCnx - [id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650] Connected through proxy to target broker at 127.0.0.1:6650
11:02:47.630 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConsumerImpl - [persistent://public/default/funhousestate][fhs] Subscribing to topic on cnx [id: 0x3ec5ce7d, L:/127.0.0.1:59610 - R:localhost/127.0.0.1:6650], consumerId 0
11:02:47.642 [pulsar-client-io-1-1] INFO  org.apache.pulsar.client.impl.ConsumerImpl - [persistent://public/default/funhousestate][fhs] Subscribed to topic on localhost/127.0.0.1:6650 -- consumer: 0
11:02:47.673 [pulsar-client-io-1-1] INFO  com.scurrilous.circe.checksum.Crc32cIntChecksum - SSE4.2 CRC32C provider initialized
----- got message -----
key:[null], properties:[], content:{"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 7049}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 7784}
11:03:47.607 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.03 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.03 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9234}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9413}
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9413}
11:04:47.608 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.05 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.05 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 11180}
11:05:47.609 [pulsar-timer-5-1] INFO  org.apache.pulsar.client.impl.ConsumerStatsRecorderImpl - [persistent://public/default/funhousestate] [fhs] [940a9] Prefetched messages: 0 --- Consume throughput received: 0.02 msgs/s --- 0.00 Mbit/s --- Ack sent rate: 0.02 ack/s --- Failed messages: 0 --- batch messages: 0 ---Failed acks: 0
----- got message -----
key:[null], properties:[], content:{"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 13365}

Device Output

Connecting to AP WiFi-SSiD
Attempting to connect to 192.168.1.230
Connected to MQTT! Subscribing...
Publishing to funhouselightstate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate
Publishing to funhousestate

Pulsar SQL (Trino/Presto) Against Our Topic

select from_utf8(__value__), __event_time__ from pulsar."public/default".funhousestate; _col0 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4877, "temperature": 78.4426, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5187, "temperature": 78.3746, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5695, "temperature": 78.3619, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5451, "temperature": 78.4014, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5962, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5153, "temperature": 78.4653, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4735, "temperature": 78.5113, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4802, "temperature": 78.5772, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4331, "temperature": 78.5614, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4751, "temperature": 78.5284, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4645, "temperature": 78.4927, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4821, "temperature": 78.5175, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4546, "temperature": 78.5806, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4349, "temperature": 78.5353, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.5181, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4441, "temperature": 78.5205, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.446, "temperature": 78.5514, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4064, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.445, "temperature": 78.489, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 86 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4509, "temperature": 78.4745, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4372, "temperature": 78.5597, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4294, "temperature": 78.5689, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3617, "temperature": 78.6016, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.68, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3444, "temperature": 78.629, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.408, "temperature": 78.6046, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3903, "temperature": 78.6146, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3998, "temperature": 78.594, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3886, "temperature": 78.5878, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3589, "temperature": 78.5954, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4276, "temperature": 78.5999, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.593, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.44, "temperature": 78.572, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 192 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3759, "temperature": 78.5319, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4074, "temperature": 78.5562, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4225, "temperature": 78.5463, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4137, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4313, "temperature": 78.6417, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3575, "temperature": 78.7125, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3391, "temperature": 78.6949, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3239, "temperature": 78.7299, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2817, "temperature": 78.7293, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3036, "temperature": 78.7842, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2396, "temperature": 78.8216, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7218, "temperature": 78.364, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.88, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7223, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.83, "button_sel": "off", "pir_sensor": "off", "humidity": 26.691, "temperature": 78.4127, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7081, "temperature": 78.2891, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8562, "temperature": 78.217, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8162, "temperature": 78.2222, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7946, "temperature": 78.1611, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7673, "temperature": 78.3159, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6741, "temperature": 78.3077, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6788, "temperature": 78.2239, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5748, "temperature": 78.3468, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4924, "temperature": 78.5672, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4867, "temperature": 78.7173, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3744, "temperature": 78.8199, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2759, "temperature": 78.8206, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 3 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3747, "temperature": 78.8141, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3929, "temperature": 78.7966, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4026, "temperature": 78.7694, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3921, "temperature": 78.7409, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4369, "temperature": 78.7111, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4217, "temperature": 78.7327, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 7 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "on", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 2 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4091, "temperature": 78.7592, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.7471, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4155, "temperature": 78.7636, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3756, "temperature": 78.7626, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3491, "temperature": 78.7262, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.74, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3958, "temperature": 78.7001, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4425, "temperature": 78.5669, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4686, "temperature": 78.5387, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4582, "temperature": 78.5126, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": (87 rows) Query 20211220_163025_00001_jb263, FINISHED, 1 node Splits: 18 total, 18 done (100.00%) 0:01 [87 rows, 36KB] [82 rows/s, 34.1KB/s] "> 
presto> describe pulsar."public/default".funhousestate;
      Column       |   Type    | Extra |                                   Comment                                   
-------------------+-----------+-------+-----------------------------------------------------------------------------
 __value__         | varbinary |       | The value of the message with primitive type schema                         
 __partition__     | integer   |       | The partition number which the message belongs to                           
 __event_time__    | timestamp |       | Application defined timestamp in milliseconds of when the event occurred    
 __publish_time__  | timestamp |       | The timestamp in milliseconds of when event as published                    
 __message_id__    | varchar   |       | The message ID of the message used to generate this row                     
 __sequence_id__   | bigint    |       | The sequence ID of the message used to generate this row                    
 __producer_name__ | varchar   |       | The name of the producer that publish the message used to generate this row 
 __key__           | varchar   |       | The partition key for the topic                                             
 __properties__    | varchar   |       | User defined properties                                                     
(9 rows)

Query 20211220_162305_00000_jb263, FINISHED, 1 node

presto> select from_utf8(__value__), __event_time__ from pulsar."public/default".funhousestate;
                                                                                                               _col0                                                                                                         
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4877, "temperature": 78.4426, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5187, "temperature": 78.3746, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5695, "temperature": 78.3619, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5451, "temperature": 78.4014, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5962, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5153, "temperature": 78.4653, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4735, "temperature": 78.5113, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4802, "temperature": 78.5772, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4331, "temperature": 78.5614, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4751, "temperature": 78.5284, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4645, "temperature": 78.4927, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4821, "temperature": 78.5175, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4546, "temperature": 78.5806, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4349, "temperature": 78.5353, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.5181, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4441, "temperature": 78.5205, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.72, "button_sel": "off", "pir_sensor": "off", "humidity": 26.446, "temperature": 78.5514, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8
 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4064, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.71, "button_sel": "off", "pir_sensor": "off", "humidity": 26.445, "temperature": 78.489, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 86
 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4509, "temperature": 78.4745, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 8
 {"pressure": 1024.7, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4372, "temperature": 78.5597, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4294, "temperature": 78.5689, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.69, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3617, "temperature": 78.6016, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.68, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3444, "temperature": 78.629, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.408, "temperature": 78.6046, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3903, "temperature": 78.6146, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.67, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3998, "temperature": 78.594, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3886, "temperature": 78.5878, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3589, "temperature": 78.5954, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4276, "temperature": 78.5999, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.593, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.44, "temperature": 78.572, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 192
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3759, "temperature": 78.5319, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4074, "temperature": 78.5562, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4225, "temperature": 78.5463, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4137, "temperature": 78.5587, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4313, "temperature": 78.6417, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3575, "temperature": 78.7125, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.66, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3391, "temperature": 78.6949, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3239, "temperature": 78.7299, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.65, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2817, "temperature": 78.7293, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3036, "temperature": 78.7842, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.64, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2396, "temperature": 78.8216, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1025.05, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1458, "temperature": 77.8455, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.98, "button_sel": "off", "pir_sensor": "off", "humidity": 27.0822, "temperature": 77.9334, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.151, "temperature": 77.8507, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "on", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 9
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 27.1309, "temperature": 77.8442, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.91, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7443, "temperature": 78.4608, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.93, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8115, "temperature": 78.1902, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.92, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7218, "temperature": 78.364, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.88, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7223, "temperature": 78.4419, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.83, "button_sel": "off", "pir_sensor": "off", "humidity": 26.691, "temperature": 78.4127, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7081, "temperature": 78.2891, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8562, "temperature": 78.217, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 1
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.8162, "temperature": 78.2222, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7946, "temperature": 78.1611, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.79, "button_sel": "off", "pir_sensor": "off", "humidity": 26.7673, "temperature": 78.3159, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6741, "temperature": 78.3077, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.6788, "temperature": 78.2239, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.5748, "temperature": 78.3468, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4924, "temperature": 78.5672, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4867, "temperature": 78.7173, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3744, "temperature": 78.8199, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2759, "temperature": 78.8206, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 3
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.2799, "temperature": 78.8103, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3747, "temperature": 78.8141, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3929, "temperature": 78.7966, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.78, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4026, "temperature": 78.7694, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3921, "temperature": 78.7409, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4369, "temperature": 78.7111, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.77, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4217, "temperature": 78.7327, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "on", "captouch8": "off", "light": 7
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4199, "temperature": 78.6538, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "on", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 2
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4277, "temperature": 78.6932, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.76, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4091, "temperature": 78.7592, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4165, "temperature": 78.7471, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4155, "temperature": 78.7636, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3756, "temperature": 78.7626, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.75, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3491, "temperature": 78.7262, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.74, "button_sel": "off", "pir_sensor": "off", "humidity": 26.3958, "temperature": 78.7001, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4425, "temperature": 78.5669, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4686, "temperature": 78.5387, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
 {"pressure": 1024.73, "button_sel": "off", "pir_sensor": "off", "humidity": 26.4582, "temperature": 78.5126, "button_down": "off", "captouch6": "off", "captouch7": "off", "button_up": "off", "captouch8": "off", "light": 
(87 rows)

Query 20211220_163025_00001_jb263, FINISHED, 1 node
Splits: 18 total, 18 done (100.00%)
0:01 [87 rows, 36KB] [82 rows/s, 34.1KB/s]

Tweaking Python Code

MU

Owner
Timothy Spann
Dev Advocate, Java Dev, Cloud Analytics Dev, Apache NiFi Dev, Data Engineer, IoT Dev, AI, ML, Python Developer, RP, FLANK, FLIP, Apache Pulsar, StreamNative
Timothy Spann
GitHub Repository
Very simple and tiny file sharing service written in python

Simple File sharing tool Sharing client usage (You will need to use python3 for linux) main.py --send -f file/path Optionnal flags : pwd : set a passw

2 Jul 26, 2022
JF⚡can - Super fast port scanning & service discovery using Masscan and Nmap. Scan large networks with Masscan and use Nmap's scripting abilities to discover information about services. Generate report.

Description Killing features Perform a large-scale scans using Nmap! Allows you to use Masscan to scan targets and execute Nmap on detected ports with

377 Jan 03, 2023
This tool is for finding more detailed information of an IP Address.

This tool is for finding more detailed information of an IP Address.

3 Oct 08, 2021
stellar-add-guest is a small tool to generate a new guest for Stellar Wireless (Enterprise mode) in OmniVista 2500 hosted on OmniSwitch with AOS Release 8

stellar-add-guest is a small tool to generate a new guest for Stellar Wireless (Enterprise mode) in OmniVista 2500 hosted on OmniSwitch with AOS Release 8.

BennyE 3 Jan 24, 2022
PetrickScanner is a simple Python OOP TCP Port Scanner

PetrickScanner PetrickScanner is a simple Python OOP TCP Port Scanner Functions Python TCP Port Scanner DNS Resolver Random Scanner PLEASE ANY PROBLEM

11 Nov 30, 2021
A simple port scanner for Web/ip scanning Port 0/500 editable inside the .py file

Simple-Port-Scanner a simple port scanner for Web/ip scanning Port 0/500 editable inside the .py file Open Cmd/Terminal Cmd Downloads Run Command: pip

YABOI 1 Nov 22, 2021
Secure connection between tenhou Window client and server.

tenhou-secure The tenhou Windows client looks awesome. However, the traffic between the client and tenhou server is NOT encrypted, including your uniq

1 Nov 11, 2021
API Server for VoIP analysis (CDR + Audio CODECs)

Swagger generated server Overview This server was generated by the swagger-codegen project. By using the OpenAPI-Spec from a remote server, you can ea

Noor Muhammad Malik 1 Jan 11, 2022
Easy-to-use sync library for handy proxy parse

Proxy Parser About Synchronous library, for convenient and fast parsing of proxies from different sources. Uses Scrapy as a parser. At the moment the

Michael Mironov 2 Nov 22, 2022
Very simple FTP client, sync folder to FTP server, use python, opensource

ftp-sync-python Opensource, A way to safe your data, avoid lost data by Virus, Randsomware Some functions: Upload a folder automatically to FTP server

4 Sep 13, 2022
A simple python script to send cute messages to my boyfriend.

Morning Messages A simple python script to send cute messages to my boyfriend. It gives him the weather and news currently. Installation git clone htt

Sabrina Medwinter 3 Oct 12, 2022
Wifijammer - Continuously jam all wifi clients/routers

wifijammer Continuously jam all wifi clients and access points within range. The effectiveness of this script is constrained by your wireless card. Al

Dan McInerney 3.5k Dec 31, 2022
track IP Address

ipX Table of Contents ipX Welcome Features Uses Author 📝 License Welcome find the location of an IP address. Specifically, you can get the following

Ali Shahid 15 Sep 26, 2022
Wallc - Calculate the layout on the wall to hang up pictures

wallc Calculate the layout on the wall to hang up pictures. Installation pip install git+https://github.com/trbznk/wallc.git Getting Started Currently

Alex Trbznk 68 Sep 09, 2022
A simple electrical network analyzer, BASED ON computer-aided design.

Electrical Network Analyzer A simple electrical network analyzer. Given the oriented graph of the electrical network (circut), BASED ON computer-aided

Ahmad Abdulrahman 4 Oct 15, 2022
This is a zeep based SOAP client wrapper for simple communication with the Bricknode SOAP API.

This is a zeep based SOAP client wrapper for simple communication with the Bricknode SOAP API.

Nord Fondkommission AB 2 Dec 15, 2021
Blockchain-Enabled IoT Sensor Framework that uses Augmented Reality and Artificial Intelligence.

Arduino + Raspberry Pi + Unity3D + Cloud + Hyperledger Our Mission: Keep it simple, leave no one behind. Blockchain-Enabled Smart Sensor Framework usi

DappAR 23 Dec 05, 2021
This Tool Help To Information gathering for domain name or ip address...

Owl-Eye This Tool Help To Information gathering for domain name or ip address... follow this command $apt update && upgrade $apt install python apt in

Black Owl 6 Nov 12, 2022
This script aims to make the dynamic public ip of your local server, public.

EZ DDNS CLOUDFLARE This script aims to make the dynamic ip of your local server, public. It does this by regularly updating cloudflare's dns record. B

3 Feb 13, 2022
CSP-style concurrency for Python

aiochan Aiochan is a library written to bring the wonderful idiom of CSP-style concurrency to python. The implementation is based on the battle-tested

Ziyang Hu 127 Dec 23, 2022