SQLite Download Page

hd_keywords {download page} set nDownload 0 set BG {} unset -nocomplain href unset -nocomplain href_cnt set href_cnt 0 proc Product {pattern desc {frag {}}} { regsub VVV $pattern {*} p3 regsub DATE $p3 {20*} p3 regsub YEAR $p3 {20[134][0-9]} p3 regsub VVV $pattern {(30\d{5})} pattern regsub DATE $pattern {(\d{12})} pattern regsub YEAR $pattern {\d{4}} pattern set p2 [string map {* .*} $pattern] set flist [glob -nocomplain $p3] foreach file [lsort -dict $flist] { if {![regexp ^$p2\$ $file all version]} continue if {[regexp {^(\d\d\d\d)(\d\d)(\d\d)(\d\d)(\d\d)$} $version \ all year month day hour min]} { set version "$year-$month-$day $hour:$min UTC" } elseif {[regexp {^30(\d)(\d\d)(\d\d)$} $version \ all major minor patch]} { scan $major %d m1 scan $minor %d m2 scan $patch %d m3 set version 3.$m1.$m2 if {$patch>0} { append version .$m3 } } set size [file size $file] set sha1sum [lindex [exec sha1sum $file] 0] set units bytes if {$size>1024*1024} { set size [format %.2f [expr {$size/(1024.0*1024.0)}]] set units MiB } elseif {$size>1024} { set size [format %.2f [expr {$size/(1024.0)}]] set units KiB } global pending_heading pending_tag BG if {$BG!=""} { set tr "" } else { set tr "" } if {$pending_heading!=""} { if {$pending_tag!=""} { set tg "" set pending_tag {} } else { set tg "" } hd_puts "$tr\n" set pending_heading {} } hd_puts "$tr" hd_puts "\n" hd_puts "" regsub -all VERSION $desc $version d2 hd_puts "\n\n" incr ::nDownload } if {$frag!=""} { eval hd_keywords [lrange $frag 1 end] } } cd $::DEST proc Heading {title {tag {}} {bgcolor {}}} { set ::pending_heading $title set ::pending_tag $tag set ::BG $bgcolor # hd_puts "" } set Caution #fff1c8 Heading {Pre-release Source-Code Snapshots} {} $Caution Product {snapshot/sqlite-amalgamation-DATE.zip} { This is a snapshot (as of VERSION) of the current SQLite source code under development. See the pending change log or the timeline for a summary of updates since the last release. This ZIP archive contains all preprocessed C code combined into a single source file (the [amalgamation]). } Product {snapshot/sqlite-amalgamation32k-DATE.zip} { This is a snapshot (as of VERSION) of the current SQLite source code under development. See the pending change log or the timeline for a summary of updates since the last release. The code in this ZIP archive is split into a small number of source files, such that no single source file is longer than 32767 lines of code. } Product {snapshot/sqlite-tea-DATE.zip} { This is a snapshot (as of VERSION) of the current SQLite code under development, packaged and ready to build using the Tcl Extension Architecture (TEA). Use this snapshot for testing only. This is not a release. } Product {snapshot/sqlite-shell-win32-x86-DATE.zip} { This is a snapshot (as of VERSION) build of the sqlite3.exe command-line shell shell program for 32-bit windows. } Product {snapshot/sqlite-shell-win64-x64-DATE.zip} { This is a snapshot (as of VERSION) build of the sqlite3.exe command-line shell shell program for 64-bit windows. } Product {snapshot/sqlite-winrt81-DATE.vsix} { This is a snapshot (as of VERSION) for a complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT 8.1 application development with Visual Studio 2013. This is not a release. } Heading {Source Code} Product {YEAR/sqlite-amalgamation-VVV.zip} { This ZIP archive contains all C source code for SQLite VERSION combined into a single source file (the [amalgamation]). } Product {YEAR/sqlite-amalgamation32k-VVV.zip} { This ZIP archive contains all C source code for SQLite VERSION combined into a small number of source files, where no source file is longer than 32767 lines of code. } Product {YEAR/sqlite-autoconf-VVV.tar.gz} { A tarball containing the [amalgamation] for SQLite VERSION together with an configure script and makefile for building it. This tarball also contains in the "tea" subdirectory a separate configure script and makefile compatible with the Tcl Extension Architecture (TEA) for building the TCL bindings to SQLite. } {amalgtarball {amalgamation tarball}} Product {YEAR/sqlite-tea-VVV.tar.gz} { A tarball of the [amalgamation] together with a Tcl Extension Architecture (TEA) compatible configure script and makefile. } {teatarball {TEA tarball}} Heading {Documentation} docco Product {YEAR/sqlite-doc-VVV.zip} { This ZIP archive contains most of the static HTML files that comprise this website, including all of the SQL Syntax and the C/C++ interface specs and other miscellaneous documentation. } Heading {Precompiled Binaries for Linux} linux Product YEAR/sqlite-shell-linux-x86-VVV.zip { A [command-line shell] for accessing and modifying SQLite databases. This program is compatible with all versions of SQLite through VERSION and beyond. } Product YEAR/sqlite-analyzer-linux-x86-VVV.zip { An analysis program for database files compatible with all SQLite versions through VERSION and beyond. } Heading {Precompiled Binaries for Mac OS X (x86)} mac Product YEAR/sqlite-shell-osx-x86-VVV.zip { A [command-line shell] for accessing and modifying SQLite databases. This program is compatible with all versions of SQLite through VERSION and beyond. } Product YEAR/sqlite-analyzer-osx-x86-VVV.zip { An analysis program for database files compatible with all SQLite versions through VERSION and beyond. } Heading {Precompiled Binaries for Windows} win32 set start $nDownload Product YEAR/sqlite-shell-win32-x86-VVV.zip { A [command-line shell] for accessing and modifying SQLite databases. This program is compatible with all versions of SQLite through VERSION and beyond. } Product YEAR/sqlite-dll-win32-x86-VVV.zip { This ZIP archive contains a DLL for the SQLite library version VERSION for 32-bit x86 processors using the Win32 API. The DLL is built using [SQLITE_ENABLE_COLUMN_METADATA] so that it is suitable for use with Ruby on Rails. } Product YEAR/sqlite-dll-win32-x64-VVV.zip { This ZIP archive contains a DLL for the SQLite library version VERSION for 64-bit x64 processors using the Win32 API. } Product YEAR/sqlite-analyzer-win32-x86-VVV.zip { An analysis program for database files compatible with all SQLite versions through VERSION and beyond. } Heading {Precompiled Binaries for Windows Phone 8} wp8 Product YEAR/sqlite-wp80-winrt-VVV.vsix { A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2012 targeting Windows Phone 8.0. } Product YEAR/sqlite-wp80-winrt-DATE.vsix { A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2012 targeting Windows Phone 8.0. This particular VSIX uses a snapshot of SQLite as of VERSION. } Heading {Precompiled Binaries for Windows Runtime} winrt Product YEAR/sqlite-dll-winrt-x86-VVV.zip { This ZIP archive contains a DLL for the SQLite library version VERSION for 32-bit x86 processors using the WinRT API. } Product YEAR/sqlite-dll-winrt-x64-VVV.zip { This ZIP archive contains a DLL for the SQLite library version VERSION for 64-bit x64 processors using the WinRT API. } Product YEAR/sqlite-winrt-VVV.vsix { A complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT application development with Visual Studio 2012. } if {$nDownload>$start} { hd_puts {} hd_puts "" hd_puts "" hd_puts "" hd_puts " " } Heading {Legacy Source Code Distribution Formats (Not Recommended)} old Product {YEAR/sqlite-src-VVV.zip} { A ZIP archive of the complete source tree for SQLite version VERSION as extracted from the version control system. The Makefile and configure script in this tarball are not supported. Their use is not recommended. The SQLite developers do not use them. You should not use them either. If you want a configure script and an automated build, use either the amalgamation tarball or TEA tarball instead of this one. To build from this tarball, hand-edit one of the template Makefiles in the root directory of the tarball and build using your own customized Makefile. } Product {YEAR/sqlite-preprocessed-VVV.zip} { This ZIP archive contains preprocessed C code for SQLite version VERSION individual source files. The use of this source distribution is not recommended. Use one of the amalgamation packages above unless you have a compelling reason not to. }
$tg$pending_heading
" if {$frag!=""} { eval hd_fragment $frag set frag {} } global href href_cnt incr href_cnt set href(a$href_cnt) $file hd_puts "[file tail $file]
($size $units)
" hd_resolve [string trim $d2] hd_puts "
(sha1: $sha1sum)
$title
Precompiled Binaries for .NET
" set url http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki hd_puts "System.Data.SQLite" hd_puts " Visit the System.Data.SQLite.org website and especially the download page for source code and binaries of SQLite for .NET.

hd_fragment encoding {build product names}

Build Product Names

Build products are named using one of the following templates:

  1. sqlite-product-version.zip
  2. sqlite-product-version.tar.gz
  3. sqlite-product-os-cpu-version.zip
  4. sqlite-product-date.zip

Templates (1) and (2) are used for source-code products. Template (1) is used for generic source-code products and templates (2) is used for source-code products that are generally only useful on unix-like platforms. Template (3) is used for precompiled binaries products. Template (4) is used for unofficial pre-release "snapshots" of source code.

The version is encoded so that filenames sort in order of increasing version number when viewed using "ls". For version 3.X.Y the filename encoding is 3XXYY00. For branch version 3.X.Y.Z, the encoding is 3XXYYZZ.

The date in template (4) is of the form: YYYYMMDDHHMM

Source Code Repositories

The SQLite source code is maintained in three geographically-dispersed self-synchronizing [http://www.fossil-scm.org/ | Fossil] repositories that are available for anonymous read-only access. Anyone can view the repository contents and download historical versions of individual files or ZIP archives of historical check-ins.

Note that a unix-like development environment, including a recent version of Tcl, is required in order to build from the repository sources. The [amalgamation] source code files (the "sqlite3.c" and "sqlite3.h" files) are not contained in the repository.

http://www.sqlite.org/cgi/src (Dallas)
http://www2.sqlite.org/cgi/src (Newark)
http://www3.sqlite.org/cgi/src (Fremont)

The documentation is maintained in separate [http://www.fossil-scm.org/ | Fossil] repositories located at:

http://www.sqlite.org/cgi/docsrc (Dallas)
http://www2.sqlite.org/cgi/docsrc (Newark)
http://www3.sqlite.org/cgi/docsrc (Fremont)
proc set_download_hyperlinks {} { set script "\n" hd_puts $script } set_download_hyperlinks