SQLite getting started, sqlite
What is SQLite?
- SQLite is a lightweight embedded database.
- It occupies very low resources. In embedded devices, it may only need several hundred KB of memory.
- It processes faster than MySql and PostgreSQL, both famous databases.
SQLite is non-typed.
What is a database?
A Database is a warehouse that organizes, stores, and manages data according to the data structure.
Databases can be divided into two types
- Relational Database Service (mainstream)
- Object-based database
Common relational databases
- PC: Oracle, MySQL, SQL Server, Access, DB2, Sybase
- Embedded \ mobile client: SQLite
Features of relational databases
* Oracle, SQL Server, MySQL... the database used by the server must be installed on an independent machine and configured separately * SQLite is a file that stores the required data * SQLite is built in the MAC, you can use it directly without any need!
Types of SQLiteSQL statements in iOS development