SQLite Tutorial
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.
This tutorial will show you how to program with SQLite and get you quickly up and running.
Who Should Read This Tutorial?
This tutorial is beneficial for beginners to understand the basics and advanced concepts related to the SQLite database engine.
Prerequisites for This Tutorial:
Before practicing the various examples provided in this tutorial, you should have an understanding of what a database is, especially RDBMS, and what a computer programming language is.
Compiling/Executing SQLite Programs
If you want to compile/execute SQL programs using the SQLite DBMS but do not have the necessary setup, you can visit the SQLite Online IDE. With just a few clicks, you can experience real programming on high-end servers. This is a completely free online tool.
SQLite Function Reference Manual
This tutorial provides a reference manual for all important built-in SQLite functions.
Useful Resources for SQLite
This tutorial lists websites and books related to SQLite.
Useful SQLite Websites
SQLite Home Page - The official SQLite website provides the latest SQLite installation versions, the latest SQLite news, and a complete SQLite tutorial.
PHP SQLite3 - This site provides complete details on PHP support for SQLite 3 databases.
SQLite JDBC Driver - SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java.
DBD-SQLite-0.31 - The SQLite Perl driver works with the Perl DBI module.
DBI-1.625 - The Perl DBI module provides a common interface for any database, including SQLite.
SQLite Python - The sqlite3 Python module, written by Gerhard Haring, provides an SQL interface compliant with the DB-API 2.0 specification.