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 04: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