Shulou(Shulou.com)05/31 Report--

This article introduces you how to SQLite Quick Start, the content is very detailed, interested friends can refer to it, I hope it can help you.

SQLite Basics What is SQLite?

SQLite is a lightweight embedded database

It's very low resource intensive, and in embedded devices, maybe a few hundred kilobytes of memory is enough.

Its processing speed is faster than MySql and PostgreSQL.

SQLite is typeless

what is database

Database is a warehouse that organizes, stores and manages data according to data structure

Databases can be divided into two categories

Relational database (mainstream)

object-oriented database

Common relational database

PC side: Oracle, MySQL, SQL Server, Access, DB2, Sybase

Embedded\Mobile Client: SQLite

Characteristics of Relational Database

* Oracle, SQL Server, MySQL... The database used by the server needs to be installed. It needs to be configured separately. * SQLite has zero cost. It is a file that stores the required data. * SQLite is built in MAC. You can use it directly without anything!

Easy data maintenance

Storage space savings

You can divide a piece of data and maintain it separately!

Access data in tabular form

Each row represents a complete record

Create a relationship between a foreign key and another data table

SQLite in iOS development

Database file is an independent file. In actual development, database file is usually saved in document/Cache directory of sandbox.

Program development, the need to operate database files through the T_SQL language!

Types of SQL statements

Data Definition Language (DDL)

include create and drop operations

Create or drop a table in the database

Data Manipulation Language (DML)

Including insert, update, delete and other operations

The above three operations are used to add, modify, and delete data in the table

Data Query Language (DQL)

Can be used to query data from tables

The keyword select is the most frequently used operation for DQL (and all SQL).

Other commonly used keywords for DQL are where, order by, group by and having.

About how to SQLite quick start to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.