Selection of embedded system databases and use of sqlite Databases

Take notes from an article titled arm-linux-based sqlite Embedded Database Technology in the magazine network security technology and application. 1. Principles of database selection for Embedded Systems:. Appropriate volume. B. Strong functions. Multiple applications are required. C. Open-source code. Reduces development costs, improves product maintenance, and ensures stable operation of products.

Take notes from an article titled arm-linux-based sqlite Embedded Database Technology in the magazine network security technology and application. 1. Principles of database selection for Embedded Systems:. Appropriate volume. B. Strong functions. Multiple applications are required. C. Open-source code. Reduces development costs, improves product maintenance, and ensures stable operation of products.

Take notes from an article titled arm-linux-based sqlite Embedded Database Technology in the magazine network security technology and application.

1. Embedded System database selection principles:

A. Appropriate volume.

B. Strong functions. Multiple applications are required.

C. Open-source code. Reduces development costs, improves product maintenance, and provides complete solutions for stable product operation.

2. sqlite

Support for most sql92: Multiple tables, indexes, views, transactions, triggers, drivers, and user interfaces.

Effective High-Speed upgrade.

Architecture: The SQLite analysis generator is highly optimized to quickly generate efficient code and prevent memory leakage. Based on kunth, the bottom is an over-optimized B-tree. It can run on top of the page buffer, and the page cache can be adjusted to minimize disk search. The cache goes down to the top of the OS abstraction layer.

Development Technology: TCL interface.

Use C language to implement APIs. First, provide the access mode/file name to call sqlite_open (Linked database. Second, execute callback to obtain the results from the database. Step 3: Call sqlite_exec () to execute an SQL query and obtain a callback pointer.

Hardware Platform transplantation: Obtain the source code and perform cross-compilation based on the differentiated platform to complete the transplantation.

Compilation steps:

1. decompress the source code to generate the sqlite directory.

2. echo $ path: Check whether the path contains the compilation tool armlinuxgcc.

3. Modify sqlite/src/sqliteInt. h to ensure the size of the btree variable.

4. Select configure to complete the configuration.

5. Modify makefile. BCC = armlinuxgccg02 to gccg02. In addition, libsqlite. la is changed to. libs/libsqlite. a (static compilation)

6. compile.