Selection of embedded system databases and use of sqlite Databases

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.