Learn mobile phone programming to learn about the SQLite database

SQLite is an embedded database, and its database is a file. Since SQLite itself is written in C and is small in size, it is often integrated into various applications, even in iOS and Android apps.

share picture It implements a self-sufficient, serverless, zero-configuration, transactional SQL database engine. The SQLite engine is not an independent process , Can be statically or dynamically connected according to application requirements. SQLite directly accesses its storage files.

Advantages of SQLite database

p>

1. No installation, configuration and management are required, and the volume is small, much smaller than some large databases.

2. No external dependencies are required.

3. SQLite transactions are ACID compatible, allowing multi-threading Or access by multiple processes.

4. It can run across platforms and supports most standard sql2 query language operations.

Limitations of SQLite

1. Only LEFT OUTER JOIN is realized.

2. DROP COLUMN, ALTER COLUMN, ADD CONSTRAINT are not supported.

3. FOR EACH STATEMENT triggers are not supported.

4. In SQLite, the view is read-only. You cannot use the view Execute DELETE, INSERT, or UPDATE statements on the computer.

5. The only access permission that can be applied is the normal file access permission of the underlying operating system.< /span>

sqlite command

sqlite commands also include CREATE, SELECT, INSERT, UPDATE, DELETE and DROP. From this point of view, it is the same as sql Very similar. http://www.wu0553.com/news/37247.htmlhttp://www.wu0553.com/news/37250.htmlhttp://www.wu0553.com/news/37251.htmlhttp:// www.wu0553.com/news/37253.htmlhttp://www.wu0553.com/news/37254.htmlhttp://www.wu0553.com/news/37256.htmlhttp://www.wu0553.com/news/ 37257.htmlhttp://www.wu0553.com/news/37259.htmlhttp://www.wu0553.com/news/37260.htmlhttp://www.wu0553.com/news/37261.htmlhttp://www. wu0553.com/news/37263.htmlhttp://www.wu0553.com/news/37267.htmlhttp://www.wu0553.com/news/37268.htmlhttp://www.wu0553.com/news/37322. htmlhttp://www.wu0553.com/news/37366.htmlhttp://www.wu0553.com/news/37370.htmlhttp://www.wu0553.com/news/37377.htmlhttp://www.wu0553. com/news/37395.htmlhttp://www.wu0553.com/news/37396.htmlhttp://www.wu0553.com/news/37397.htmlhttp://www.wu0553.com/news/37402.htmlhttp: //www.wu0553.com/news/37403.htmlhttp://www.wu0553.com/news/37404.htmlhttp://www.wu0553.com/news/37405.htmlhttp://www.wu0553.com/ news/37406.htmlhttp://www.wu0553.com/news/37407.htmlhttp://www.wu0553.com/news/3743 0.htmlhttp://www.wu0553.com/news/37431.htmlhttp://www.wu0553.com/news/37432.htmlhttp://www.wu0553.com/news/37433.htmlhttp://www. wu0553.com/news/37436.htmlhttp://www.wu0553.com/news/37441.htmlhttp://www.wu0553.com/news/37448.htmlhttp://www.wu0553.com/news/37454. htmlhttp://www.wu0553.com/news/37455.htmlhttp://www.wu0553.com/news/37465.htmlhttp://www.wu0553.com/news/37466.htmlhttp://www.wu0553. com/news/37467.htmlhttp://www.wu0553.com/news/37468.htmlhttp://www.wu0553.com/news/37469.htmlhttp://www.wu0553.com/news/37470.htmlhttp: //www.wu0553.com/news/37471.htmlhttp://www.wu0553.com/news/37473.htmlhttp://www.wu0553.com/news/37474.htmlhttp://www.wu0553.com/ news/37475.htmlhttp://www.wu0553.com/news/37476.htmlhttp://www.wu0553.com/news/37477.htmlhttp://www.wu0553.com/news/37478.htmlhttp:// www.wu0553.com/news/37480.htmlhttp://www.wu0553.com/news/37481.htmlhttp://www.wu0553.com/news/37482.htmlhttp://www.wu0553.com/news/ 37483.html

share picture

Leave a Comment

Your email address will not be published.