First knowledge of Sqlite

========================================================== ==================================

Title: SQLite first recognized

Note:

Date: 2011.4.9

Name: Zhu minglei

========================================================== ==================================

Future projects of the company may use the SQLite database more. First, I briefly read the "about SQLite" document on the official website (which is a good document ).

As a sophisticated database engine, SQLite supports self-contained, serverless, zero-configuration, and transactional. According to the introduction in this article, it is simple to use and very reliable. It does not have a separate server process, but all reads and writes are directly operated on disk files. All the tables, indexes, triggers, and views that should be available in a complete database are stored in this disk file. In addition, SQLite database files can be used on multiple platforms and systems with excellent compatibility.

SQLite itself is very small and compact, and the memory required for running is also small. It seems that it is a good choice for platforms with small storage space and limited memory.

The reliability of SQLite is highly evaluated. Prior to the release of each version, the "Automated Testing Tool" was used to test the case of millions (including hundreds of millions of separate SQL statements. SQLite's response to memory allocation errors and disk Io errors is gracefully ?). Even if the system crashes and suddenly loses power, SQLite transmission still acid (abbreviation of the four basic elements for correct execution of database transactions. Includes: atomicity, consistency, isolation, and durability )).

In addition, SQLite is maintained by a full-time international team. In the future, the functions will be more powerful and the stability will be higher.

Reading this document is as fascinating as Reading Hou Jie's book. Next, let's take a closer look.