Sqlite[1 of data storage]

"AboutSQLite "

SQLite is an open source embedded database engine written by R.richard Hipp in C language. It supports most of the SQL92 standards and can be run on all major operating systems

---supports databases of up to 2TB size, exists as a single file, and is stored in disk as a b-tree data structure

Characteristics

1. Lightweight a dynamic library, single file

2. Independence is not dependent, installation is not required

3. All of the isolation in one folder

4. Cross-platform support for many operating systems

5. Multi-lingual interface supports many programming languages

6. Security Services

PS: (About transaction security issues: 1. Independent transaction processing through exclusive and shared locks of the database; 2. Multiple processes can read data from the same database at the same time, but only one can write data)

"Data Type"

About SQLite data types

-SQLite supports null, Integer, real, text, blob data types

-In turn: null, reshape, float, string value, binary object

Dynamic Data type (weak reference)

-When a value is inserted into the database,SQLite checks its data type, and if the type does not match the associated column,SQLite attempts to convert the value to the type of the column, and if it cannot, the value will be stored as its own type

"Notice of Use"

-Embedded database has its niche due to low resource usage, good performance, and 0 management costs (eg:android, IOS)

-There is no Web server available for SQLite , only over network sharing, there may be file lock locking or performance issues

-only database-level locks are available

-No user account concept, but the file system to determine the permissions of all databases

Sqlite[1 of data storage]