Features of SQlite Databases

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

Title: features of SQLite Database

Note:

Date: 2011.4.17

Name: Zhu minglei

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

1. Even if a system crash or a sudden power failure occurs, database transactions can still be executed correctly (Atomicity), consistency, isolation, and durability.

2. Zero Configuration-No configuration or management is required.

3. Complete the vast majority of sql92 standards.

4. A complete database is stored in a separate cross-platform disk file.

5. Supports terabyte-level databases and Gigabyte-sized-level strings and blobs (Binary large object type ).

6. Simplified code encapsulation: the storage space required for full configuration is less than kib (what unit ?), The storage space required for omitting the optional functions is less than that required by ikekib.

7. For Common Operations, SQLite is faster than the popular Client/Server database engine.

8. The provided APIs are easy to use.

9 compiled by standard C. SQLite can be used in dozens of programming languages (a long list. There are many different SQLite wrapper (encapsulation) for different programming languages ).

10 provides source code that has passed 100% branch tests and has good comments.

11 as a separate standard C source code file, you can easily add it to other projects.

12 self-contained (self-contained): no external dependency.

13 cross-platform: Unix systems (Linux and Mac OS x), OS/2, Windows (Win32 and WinCE) support out-of-the-box use (supported out of the box ), and it is easy to transplant to other operating systems.

14 all the Code submitted by the SQlite author is committed to the public domain and can be used for any purpose, including commercial purposes.

15 has an independent CLI client that can be used to manage SQLite databases.