Getting started with sqlite
Versions#
| Version | Major Changes | Release Date |
|---|---|---|
| 3.0 | 2004-06-18 | |
| 3.7.11 | SELECT max(x), y | 2012-03-20 |
| 3.8.3 | CTEs | 2014-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.