Characteristics:
1. Lightweight
2. Independence, no dependencies, disorderly installation
3. Isolation all in one folder system
4. Cross-platform support for many operating systems
5. Multi-lingual interface supports many programming languages
6. Security things, through exclusive and shared locks for the processing of independent transactions, multiple processes can read data from the same database at the same time, but only one can write data
Supported Data types:
Support for NULL,INTEGER,REAL,TEXT,BLOB data types
Represents, null, integer, floating-point value, String type, binary object,
Dynamic type reference (weak reference)
When a value is inserted into the database, SQLite will check his type, and if the type does not match the associated column, SQLite will attempt to convert the transformation to the type of the column, and if it cannot, the value will be stored as its own type.
Instructions for use:
There is no network server available for SQLite, there may be file locking or performance issues that can only be shared over a network share.
No concept of user account, but based on file system sharing settings
Features of the SQLite database