sqlit--Learning Tutorial (Introduction)

Introduction: https://baike.baidu.com/item/SQLite/375020

SQLite Tutorial: http://www.runoob.com/sqlite/sqlite-tutorial.html

Useful Resources for SQLite

This tutorial lists the SQLite database sites and books.

Why use SQLite?

• There is no need for a separate server process or operation of the system (no server).

• SQLite does not require configuration, which means that installation or management is not required.

• A complete SQLite database is stored in a single cross-platform disk file.

• SQLite is very small, is lightweight, fully configured when less than 400KiB, omit optional feature configuration when less than 250KiB.

• SQLite is self-sufficient, which means that no external dependencies are required.

• SQLite transactions are fully ACID-compatible and allow secure access from multiple processes or threads.

• SQLite supports the functionality of most query languages for the SQL92 (SQL2) standard.

• SQLite is written using ansi-c and provides a simple and easy-to-use API.

• SQLite can be run in UNIX (Linux, Mac os-x, Android, IOS) and Windows (Win32, WinCE, WinRT).

Useful websites for SQLite

• The SQLite Home Page-sqlite official website offers the latest SQLite installation, the latest SQLite information and a complete SQLite tutorial.

• PHP SQLite3-The website provides full details of the PHP support for the SQLite 3 database.

• SQLite jdbc Driver:-SQLite jdbc, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java.

• The Dbd-sqlite-0.31-sqlite Perl driver driver is used with the Perl DBI module.

• The Dbi-1.625-perl DBI module provides a common interface for any database, including SQLite.

• The SQLite python-sqlite3 Python module was written by Gerhard Haring. It provides a SQL interface that is compatible with the DB-API 2.0 specification.

SQLite command

The standard SQLite command that interacts with a relational database is similar to SQL. Commands include CREATE, SELECT, INSERT, UPDATE, DELETE, and DROP. These commands are divided into the following types based on their operational nature:

DDL-Data Definition language

DML-Data Manipulation language

DQL-Data Query Language

sqlit--Learning Tutorial (Introduction)