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

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