sqlite

Getting started with sqlite

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.


This modified text is an extract of the original Stack Overflow Documentation created by the contributors and released under CC BY-SA 3.0 This website is not affiliated with Stack Overflow