SQLite Tutorial

Next: SQLite Introduction

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the world's most widely deployed SQL database engine. SQLite source code is not subject to copyright restrictions.

This tutorial will show you how to use SQLite program, and allows you to quickly get started.

Now start learning SQLite!

Who should take this tutorial?

This tutorial helps beginners understand the SQLite database engine through the basics and advanced concepts.

Before reading this tutorial, you need to know:

Before you begin using all kinds of examples of this tutorial to practice, you need to understand what is a database, in particular RDBMS, and what is a computer programming language.

Compile / execute SQLite program

If you want to pass SQLite DBMS compile / execute SQL program, but you do not have the relevant settings, you can access compileonline.com . You only need a simple clicks, you can experience the real programming experience on high-end servers. This online tool is completely free.

SQLite Functions Reference Manual

This tutorial provides all the important functions of the built-in SQLite reference manual.

SQLite commonly used functions

SQLite useful resources

This tutorial lists the SQLite database web sites and books.

SQLite useful sites

Home Page SQLite - SQLite official website provides the latest SQLite installed version, latest information and complete SQLite SQLite tutorial.
The SQLite3 PHP - website provides complete details SQLite 3 database PHP support.
The JDBC Driver SQLite: - SQLite the JDBC, by the Taro L. Saito developed a Java for access and create a SQLite database file libraries.
The SQLite-0.31-the DBD - the SQLite Driver driver uses the Perl with the Perl DBI module.
1.625-the DBI - the Perl the DBI module includes SQLite, including any database provides a common interface.
The Python the SQLite - the sqlite3 Python module consists Gerhard Haring prepared. It provides compatibility with the DB-API 2.0 specification SQL interface.

SQLite useful books