SQLite tutorial

This is SQLite tutorial. It covers the SQLite database engine, sqlite3 command line tool and the SQL language covered by the database engine.

Table of contents

• Introduction
• The sqlite3 command line tool
• Creating, altering and dropping tables
• SQLite expressions
• Inserting, updating and deleting data
• The SELECT statement
• Constraints
• Joining tables
• SQLite functions
• Views, triggers, transactions

SQLite

SQLite is an embedded relational database engine. Its developers call it a self-contained, serverless, zero-configuration and transactional SQL database engine.