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. SQLite source code is not subject to copyright restrictions.
This tutorial will teach you how to use SQLite for programming and help you get started quickly.
Who should read this tutorial?
This tutorial helps beginners understand the basic knowledge and advanced concepts related to the SQLite database engine.
What you need to know before reading this tutorial:
Before you start practicing with the various examples provided in this tutorial, you need to understand what a database is, especially RDBMS, and what a computer programming language is.
Compile/Execute SQLite Programs
If you want to compile/execute SQL programs through the SQLite DBMS, but you do not have the relevant setup, you can visitSQLite Online IDE. You only need a simple click to 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.
SQLite Commonly Used Functions
SQLite Useful Resources
This tutorial lists SQLite database websites and books.
SQLite Useful 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- The website provides complete details of 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.
DBD-SQLite-0.31- The SQLite Perl driver is used together with the Perl DBI module.
DBI-1.625- The Perl DBI module provides a generic interface for any database, including SQLite.
SQLite Python- The sqlite3 Python module was written by Gerhard Haring. It provides an SQL interface compatible with the DB-API 2.0 specification.