Stats

118 Contributors: 4
2017-01-05
Licensed under: CC-BY-SA

Not affiliated with Stack Overflow
Rip Tutorial: info@zzzprojects.com

Download eBook

Getting started with sqlite

Download sqlite eBook

Versions

VersionMajor ChangesRelease Date
3.02004-06-18
3.7.11SELECT max(x), y2012-03-20
3.8.3CTEs2014-02-11

Installation

SQLite is a C library that is typically compiled directly into the application by downloading the source code of the latest version, and adding the sqlite3.c file to the project.

Many script languages (e.g., Perl, Python, Ruby, etc.) and frameworks (e.g., Android) have support for SQLite; this is done with a built-in copy of the SQLite library, which does not need to be installed separately.

For testing SQL, it might be useful to use the command-line shell (sqlite3 or sqlite3.exe). It is already shipped with most Linux distributions; on Windows, download the precompiled binaries in the sqlite-tools package, and extract them somewhere.

Documentation

SQLite already has extensive documentation, which should not be duplicated here.