Difference between revisions of "WISE-PaaS/EdgeSense"
From ESS-WIKI
Daniel.hung (talk | contribs) (Created page with "For RISC products, we adopt '''''lightweight '''''EdgeSense features. In this chapter, we introduce the basic concepts for these components. == <font color="#0070c0">Clo...") |
Daniel.hung (talk | contribs) |
||
| Line 8: | Line 8: | ||
== <font color="#0070c0">Edge Intelligent Suite</font> == | == <font color="#0070c0">Edge Intelligent Suite</font> == | ||
| − | |||
| − | |||
=== <font color="#0070c0">Node-RED</font> === | === <font color="#0070c0">Node-RED</font> === | ||
| Line 16: | Line 14: | ||
=== <font color="#0070c0">SQLite</font> === | === <font color="#0070c0">SQLite</font> === | ||
| + | |||
| + | 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 [https://sqlite.org/index.html SQLite official website]. | ||
| + | |||
| + | - [https://sqlite.org/quickstart.html SQLite In 5 Minutes Or Less] | ||
| + | |||
| + | - [https://sqlite.org/cli.html Command Line Shell For SQLite] | ||
== <font color="#0070c0">Security</font> == | == <font color="#0070c0">Security</font> == | ||
Revision as of 05:46, 22 November 2017
For RISC products, we adopt lightweight EdgeSense features. In this chapter, we introduce the basic concepts for these components.
Contents
Cloud Solution
WISE-PaaS
ARM mbed Cloud
Edge Intelligent Suite
Node-RED
MQTT Broker
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.
- Command Line Shell For SQLite