Node-RED で IoTダッシュボードしてみた

by hig

Slide 1

Slide 1 text

/PEF3&%Ͱ *P5μογϡϘʔυͯ͠Έͨ 2017.3.24

Slide 2

Slide 2 text

ࣗݾ঺հ ໊લ Ṥޱ ༑ଠʢͻ͙ͪ Ώ͏ͨʣ ॴଐ גࣜձࣾ΢ϑϧ ࢿ֨ "84ιϦϡʔγϣϯΞʔΩςΫτ ΞιγΤΠτ 4BMFTGPSDFೝఆΞυϛχετϨʔλ ʢچ໊ʁʣ ٕज़ ϑϩϯτΤϯυ΋ͪΐͬͱ͍͡ΕΔɺόοΫΤϯυΤϯδχΞ͔ɻ ޷͖OPEFKT HPMBOH ॻ͚ΔQIQ ॻ͖͍ͨTDBMB FSMBOH ܦݧ͋Γ$ $ 7# $0#0- ۀ຿ Ϋϥ΢υͷΠϯϑϥઃܭɾߏஙɺϑϩϯτɾόοΫͷίʔσΟϯ άɺ࠷ۙ͸ϋʔυ΢ΣΞ΋গ͠ɻ උߟ ؾʹͳΔݴ༿܈ à ΫϥελϦϯάɺετϦʔϛϯάɺίϯςφɺ ΦʔέετϨʔγϣϯ ʗ

Slide 3

Slide 3 text

ՄࢹԽͷҙຯ͕ͳ͍ʂ ηϯαʔσʔλͷՄࢹԽγεςϜ ? *P5σόΠε .255CSPLFS EBTICPBSE EBUBTUPSF EBUBCBTF ʗ

Slide 4

Slide 4 text

*P5σόΠε޻࡞ ʗ &41S%FWFMPQFS ʢ&418300.։ൃϘʔυʣ &41S%FWFMPQFS༻ ࣠׳ੑܭଌϢχοτγʔϧυ ୯ࡾి஑ຊ ϛχϒϨουϘʔυ ඦۉͷܞଳॆిి஑#PY

Slide 5

Slide 5 text

*P5σόΠε׬੒ ʗ

Slide 6

Slide 6 text

ϒϩʔΧʔ͸NPTDB ▲引⽤引⽤元▶ ʗ 性能は低い？ Node.js 実装というだけで採⽤ IUUQBDSPFOHJOFFSIBUFOBCMPHDPNFOUSZ

Slide 7

Slide 7 text

σʔλΛͨΊΔͷ͸.Z42- ʗ このページに感化される構想段階では NoSQL系にはつらい Query を書く予定だった IUUQQPTUEDDTDBMJOHUPNNZTRMJTBCFUUFSOPTRM

Slide 8

Slide 8 text

ͦͯ͠ຊ୊ アップデート頻度⾼し ʗ マルチユーザ⾮対応

Slide 9

Slide 9 text

͜Μͳ6* d3.js のライブラリっぽい ʗ

Slide 10

Slide 10 text

ࠓ೔ग़ͯ͘Δͷ͸ ʗ

Slide 11

Slide 11 text

αΠυόʔͰͰ͖Δ͜ͱ ʗ

Slide 12

Slide 12 text

֤ϊʔυͷৄࡉ͸ׂѪ ͍ͬͯ͡ڭ͍͑ͯͩ͘͞ʂ ʗ

Slide 13

Slide 13 text

ࠓճͷμογϡϘʔυ ʗ

Slide 14

Slide 14 text

ʗ ϦΞϧλΠϜνϟʔτ

Slide 15

Slide 15 text

ϦΞϧλΠϜνϟʔτͷϑϩʔ ぶさいくな function Subscribe 画⾯上の通知 ʗ

Slide 16

Slide 16 text

Ϳ͍͘͞GVODUJPO ͷத ʗ 9つの配列（数値）が⾶んでくる

Slide 17

Slide 17 text

ʗ ཤྺݕࡧ

Slide 18

Slide 18 text

ཤྺݕࡧϑϩʔ 変更はイベント発⽣時 global に保存 ʗ

Slide 19

Slide 19 text

1分間を表⽰ラインを消せる ཤྺදࣔ ʗ

Slide 20

Slide 20 text

ཤྺσʔλऔಘνϟʔτදࣔ template でSQL ⽣成 1時間分のデータを取得 Send ボタン本システム最難関 ʗ

Slide 21

Slide 21 text

ຊγεςϜ࠷೉ؔGVODUJPO 1時間のデータを整形 ʗ

Slide 22

Slide 22 text

Play ! ཤྺ࠶ੜ 1時間を 1分間隔で再⽣

Slide 23

Slide 23 text

ཤྺ࠶ੜϑϩʔ 500ms 1分間分進む取得済みデータをセット ʗ

Slide 24

Slide 24 text

GVODUJPOͷத ʗ

Slide 25

Slide 25 text

ηϯαʔ஋औಘอଘϑϩʔ ʗ

Slide 26

Slide 26 text

.Z42-ͷத create table sensor.s9axis ( id int auto_increment, sensor_id varchar(32), gyroscope_x double, gyroscope_y double, gyroscope_z double, acceleration_x double, acceleration_y double, acceleration_z double, magnetometer_x double, magnetometer_y double, magnetometer_z double, timestamp bigint unsigned not null, primary key (`id`), index idx_timestamp(`timestamp`) ) engine=InnoDB default charset=utf8; mysql> select * from s9axis order by timestamp limit 10; +--------+----------------------+-------------+-------------+-------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+ | id | sensor_id | gyroscope_x | gyroscope_y | gyroscope_z | acceleration_x | acceleration_y | acceleration_z | magnetometer_x | magnetometer_y | magnetometer_z | timestamp | +--------+----------------------+-------------+-------------+-------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+ | 160349 | LSM9DS1_ESP-WROOM-02 | -154.33 | 184.39 | -15.83 | -11.15 | 27.83 | 222.88 | 45.52 | 137.61 | -4.65 | 1489914000000 | | 203579 | LSM9DS1_ESP-WROOM-02 | -0.11 | 34.33 | -29.05 | -53.58 | 85.23 | 219.73 | -18.8 | 51.15 | -42.09 | 1489914000000 | | 160350 | LSM9DS1_ESP-WROOM-02 | 14.8 | -16.13 | 12.3 | 40.61 | 41.49 | -194.79 | -67.16 | 34.73 | 81.1 | 1489914001000 | | 203580 | LSM9DS1_ESP-WROOM-02 | 125.08 | 93.32 | 37.41 | -92.43 | -44.83 | 0.46 | 294.25 | -12.81 | -65.64 | 1489914001000 | | 160351 | LSM9DS1_ESP-WROOM-02 | 179.96 | 53.47 | -21.35 | 22.23 | 12.39 | 141.75 | -50.18 | 108.27 | 16.99 | 1489914002000 | ʗ