sqlite Getting started with sqlite

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Extensions
> Step 2: And Like the video. BONUS: You can also share it!

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.



Got any sqlite Question?