- SQLite is an open-source, embedded relational database that implements a self-contained, 0 configuration, transactional SQL database engine. It occupies very low resources, in the embedded device, may only need hundreds of K of memory is enough.
- It is characterized by its high portability, ease of use, compact structure, high efficiency and reliability.
- Database systems developed specifically for mobile devices with relatively limited resources
- Support Windows/linux/unix and other mainstream operating systems, and can be combined with many programming languages, such as C #, PHP, Java, and ODBC interface.
- SQLite supports most of the SQL92 commands and provides simple transactional functionality.
- Each database of SQLite is a file
- Key Features of SQLite:
1). Management is simple and can even be considered without management.
2). Easy to operate, SQLite-generated database files can be ported seamlessly across platforms.
3). Can be easily embedded into other applications in many forms, such as static libraries, dynamic libraries, etc.
4). Easy to maintain.
In summary, the main advantage of SQLite is dexterity, fast and high reliability.
"Android 9" SQLite database