WISE-PaaS/EdgeSense

For RISC products, we adopt lightweight EdgeSense features. In this chapter, we introduce the basic concepts for these components.

Edge Intelligent Suite

MQTT Broker

There are many MQTT brokers, and we choose Mosquitto as default broker.

You can try this sample flow.

1. Enable Mosquitto broker

# /etc/init.d/mqtt start
Starting MQTT Server:  [ OK ]

2. Subscribe a topic

# mosquitto_sub -d -t 'risc/topic'
Client mosqsub/2768-rsb-4760 sending CONNECT
Client mosqsub/2768-rsb-4760 received CONNACK
Client mosqsub/2768-rsb-4760 sending SUBSCRIBE (Mid: 1, Topic: risc/topic, QoS: 0)
Client mosqsub/2768-rsb-4760 received SUBACK
Subscribed (mid: 1): 0

3. Connect from another terminal, e.g. SSH. Then, publish contents for this topic.

# mosquitto_pub -d -t 'risc/topic' -m 'advantech'
Client mosqpub/2767-rsb-4760 sending CONNECT
Client mosqpub/2767-rsb-4760 received CONNACK
Client mosqpub/2767-rsb-4760 sending PUBLISH (d0, q0, r0, m1, 'risc/topic', ... (9 bytes))
Client mosqpub/2767-rsb-4760 sending DISCONNECT

4. You should be able to see contents from Subscriber side.

Client mosqsub/2766-rsb-4760 received PUBLISH (d0, q0, r0, m0, 'risc/topic', ... (9 bytes))
advantech

SQLite

SQLite is an embedded SQL database engine. It reads and writes directly to ordinary disk files. SQLite is also a compact library. So, you can write programs that use SQLite in many supported languages, such as C/C++, GO, Java, Objective-C, Perl, PHP, Python, etc.

Here is a SQL example. You can input these commands on your devices for trial.

# sqlite3 test.db3
SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.

sqlite> create table project(model, vendor, chipset);
sqlite> create index project_model_index on project(model);

sqlite> insert into project values ('RSB-4760', 'Qualcomm', 'APQ8016');
sqlite> insert into project values ('RSB-4411', 'NXP', 'i.MX6');
sqlite> insert into project values ('ROM-7421', 'NXP', 'i.MX6');
sqlite> insert into project values ('UBC-221', 'Intel', 'Quark');

sqlite> select * from project;
RSB-4760|Qualcomm|APQ8016
RSB-4411|NXP|i.MX6
ROM-7421|NXP|i.MX6
UBC-221|Intel|Quark

sqlite> select * from project where vendor='NXP';
RSB-4411|NXP|i.MX6
ROM-7421|NXP|i.MX6

sqlite> select count(*) from project;
4

sqlite> .quit

For more information, you can refer to the SQLite official website.

- SQLite In 5 Minutes Or Less

- Command Line Shell For SQLite