Skip to content

Instantly share code, notes, and snippets.

@hlian

hlian/gist:7814509

Created December 5, 2013 21:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hlian/7814509 to your computer and use it in GitHub Desktop.
Save hlian/7814509 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>SQLite Download Page</title>
<style type="text/css">
body {
margin: auto;
font-family: Verdana, sans-serif;
padding: 8px 1%;
}
a { color: #044a64 }
a:visited { color: #734559 }
.logo { position:absolute; margin:3px; }
.tagline {
float:right;
text-align:right;
font-style:italic;
width:300px;
margin:12px;
margin-top:58px;
}
.menubar {
clear: both;
border-radius: 8px;
background: #044a64;
padding: 0px;
margin: 0px;
cell-spacing: 0px;
}
.toolbar {
text-align: center;
line-height: 1.6em;
margin: 0;
padding: 0px 8px;
}
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
.toolbar a:visited { color: white; }
.toolbar a:hover { color: #044a64; background: white; }
.content { margin: 5%; }
.content dt { font-weight:bold; }
.content dd { margin-bottom: 25px; margin-left:20%; }
.content ul { padding:0px; padding-left: 15px; margin:0px; }
/* Things for "fancyformat" documents start here. */
.fancy img+p {font-style:italic}
.fancy .codeblock i { color: darkblue; }
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
.fancy h2 { margin-left: 10px }
.fancy h3 { margin-left: 20px }
.fancy h4 { margin-left: 30px }
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
.fancy #toc a { color: darkblue ; text-decoration: none }
.fancy .todo { color: #AA3333 ; font-style : italic }
.fancy .todo:before { content: 'TODO:' }
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
.fancy img { display:block; }
.fancy :link:hover, .fancy :visited:hover { background: wheat }
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
.fancy li p { margin: 1em 0 }
/* End of "fancyformat" specific rules. */
</style>
</head>
<body>
<div><!-- container div to satisfy validator -->
<a href="index.html">
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
border="0"></a>
<div><!-- IE hack to prevent disappearing logo--></div>
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
<table width=100% class="menubar"><tr>
<td width=100%>
<div class="toolbar">
<a href="about.html">About</a>
<a href="sitemap.html">Sitemap</a>
<a href="docs.html">Documentation</a>
<a href="download.html">Download</a>
<a href="copyright.html">License</a>
<a href="news.html">News</a>
<a href="support.html">Support</a>
</div>
<script>
gMsg = "Search SQLite Docs..."
function entersearch() {
var q = document.getElementById("q");
if( q.value == gMsg ) { q.value = "" }
q.style.color = "black"
q.style.fontStyle = "normal"
}
function leavesearch() {
var q = document.getElementById("q");
if( q.value == "" ) {
q.value = gMsg
q.style.color = "#044a64"
q.style.fontStyle = "italic"
}
}
</script>
<td>
<div style="padding:0 1em 0px 0;white-space:nowrap">
<form name=f method="GET" action="http://www.sqlite.org/search">
<input id=q name=q type=text
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
</form>
</div>
</table>
<div class=startsearch></div>
<h2>SQLite Download Page</h2>
<table width="100%" cellpadding="5" cellspacing="0">
<tr bgcolor="#fff1c8"><td colspan="4"><b>Pre-release Source-Code Snapshots</b></td></tr>
<tr bgcolor="#fff1c8"><td width="10"></td><td valign="top" align="right"><a id='a1' href='hp1.html'>sqlite-amalgamation-201311271348.zip</a><br>(1.40 MiB)</td>
<td width="5"></td>
<td valign="top">This is a snapshot (as of 2013-11-27 13:48 UTC) of the current SQLite source code under
development.
See the <a href="http://www.sqlite.org/draft/releaselog/current.html">pending
change log</a> or the
<a href="http://www.sqlite.org/src/timeline?t=trunk&n=1000&a=release">timeline</a>
for a summary of updates since the last release.
This ZIP archive contains all preprocessed C code combined into a
single source file (the <a href="amalgamation.html">amalgamation</a>).<br>(sha1: 21f8368c7d2bfa6a48fa4427331a11b6868a1c78)</td></tr>
<tr bgcolor="#fff1c8"><td width="10"></td><td valign="top" align="right"><a id='a2' href='hp1.html'>sqlite-amalgamation32k-201311271348.zip</a><br>(1.41 MiB)</td>
<td width="5"></td>
<td valign="top">This is a snapshot (as of 2013-11-27 13:48 UTC) of the current SQLite source code under
development.
See the <a href="http://www.sqlite.org/draft/releaselog/current.html">pending
change log</a> or the
<a href="http://www.sqlite.org/src/timeline?t=trunk&n=1000&a=release">timeline</a>
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.<br>(sha1: 405ca531eb3c3c4a39e0366e8f73cbafdabc0da4)</td></tr>
<tr><td colspan="4"><b>Source Code</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a3' href='hp1.html'>sqlite-amalgamation-3080100.zip</a><br>(1.39 MiB)</td>
<td width="5"></td>
<td valign="top">This ZIP archive contains all C source code for SQLite 3.8.1
combined into a
single source file (the <a href="amalgamation.html">amalgamation</a>).<br>(sha1: 75a1ab154e796d2d1b391a2c7078679e15512bda)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a name="amalgtarball"></a>
<a id='a4' href='hp1.html'>sqlite-autoconf-3080100.tar.gz</a><br>(1.81 MiB)</td>
<td width="5"></td>
<td valign="top">A tarball containing the <a href="amalgamation.html">amalgamation</a>
for SQLite 3.8.1 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
<a href="http://www.tcl.tk/doc/tea/">Tcl Extension
Architecture (TEA)</a> for building the TCL bindings to SQLite.<br>(sha1: 42464b07df2d6f8aa28f73ce4cc6d48b47be810e)</td></tr>
<tr><td colspan="4"><a name="docco"></a><b>Documentation</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a5' href='hp1.html'>sqlite-doc-3080100.zip</a><br>(4.05 MiB)</td>
<td width="5"></td>
<td valign="top">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.<br>(sha1: d7cb698f32318fbf5dce9f10c9cd7b84c3d70105)</td></tr>
<tr><td colspan="4"><a name="linux"></a><b>Precompiled Binaries for Linux</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a6' href='hp1.html'>sqlite-shell-linux-x86-3080100.zip</a><br>(329.43 KiB)</td>
<td width="5"></td>
<td valign="top">A <a href="sqlite.html">command-line shell</a>
for accessing and modifying SQLite databases.
This program is compatible with all versions of SQLite through 3.8.1
and beyond.<br>(sha1: d87f53de99448d9b3efb5d463018fc7a4e31f924)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a7' href='hp1.html'>sqlite-analyzer-linux-x86-3080100.zip</a><br>(278.03 KiB)</td>
<td width="5"></td>
<td valign="top">An analysis program for database files compatible with all SQLite
versions through 3.8.1 and beyond.<br>(sha1: 78b35ae90a165c3216311900b54c59b85bf00abf)</td></tr>
<tr><td colspan="4"><a name="mac"></a><b>Precompiled Binaries for Mac OS X (x86)</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a8' href='hp1.html'>sqlite-shell-osx-x86-3080100.zip</a><br>(347.85 KiB)</td>
<td width="5"></td>
<td valign="top">A <a href="sqlite.html">command-line shell</a>
for accessing and modifying SQLite databases.
This program is compatible with all versions of SQLite through 3.8.1
and beyond.<br>(sha1: 93c8fe64e96b2a71ebbd2279fb3d1b08b829877b)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a9' href='hp1.html'>sqlite-analyzer-osx-x86-3080100.zip</a><br>(805.25 KiB)</td>
<td width="5"></td>
<td valign="top">An analysis program for database files compatible with all SQLite
versions through 3.8.1 and beyond.<br>(sha1: 5fdcda5997da7343a86f7007ef945cde24c156df)</td></tr>
<tr><td colspan="4"><a name="win32"></a><b>Precompiled Binaries for Windows</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a10' href='hp1.html'>sqlite-shell-win32-x86-3080100.zip</a><br>(280.00 KiB)</td>
<td width="5"></td>
<td valign="top">A <a href="sqlite.html">command-line shell</a>
for accessing and modifying SQLite databases.
This program is compatible with all versions of SQLite through 3.8.1
and beyond.<br>(sha1: 6f88192e76dbd75b2f7d2324107e3638d6425ab2)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a11' href='hp1.html'>sqlite-dll-win32-x86-3080100.zip</a><br>(315.08 KiB)</td>
<td width="5"></td>
<td valign="top">This ZIP archive contains a DLL for the SQLite library version 3.8.1 for
32-bit x86 processors using the Win32 API.
The DLL is built using <a href="compile.html#enable_column_metadata">SQLITE_ENABLE_COLUMN_METADATA</a> so that it is
suitable for use with Ruby on Rails.<br>(sha1: c8d9d458628f6f62d850873c987a6cbe2ef0fdf1)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a12' href='hp1.html'>sqlite-analyzer-win32-x86-3080100.zip</a><br>(672.79 KiB)</td>
<td width="5"></td>
<td valign="top">An analysis program for database files compatible with all SQLite
versions through 3.8.1 and beyond.<br>(sha1: 9f0f2f6c7aa6ef0893c6dcbeb4ccb571439b2b52)</td></tr>
<tr><td colspan="4"><a name="wp8"></a><b>Precompiled Binaries for Windows Phone 8</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a13' href='hp1.html'>sqlite-wp80-winrt-3080100.vsix</a><br>(2.83 MiB)</td>
<td width="5"></td>
<td valign="top">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.<br>(sha1: 35795442a5cb864bcf7745288992c21a32ad9d8c)</td></tr>
<tr><td colspan="4"><a name="winrt"></a><b>Precompiled Binaries for Windows Runtime</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a14' href='hp1.html'>sqlite-winrt80-3080100.vsix</a><br>(4.28 MiB)</td>
<td width="5"></td>
<td valign="top">A complete VSIX package with an extension SDK and all other components
needed to use SQLite for WinRT 8.0 application development with Visual Studio
2012.<br>(sha1: 7071adab04c540252e1b489407a48f0ab9875db8)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a15' href='hp1.html'>sqlite-winrt81-3080002.vsix</a><br>(4.21 MiB)</td>
<td width="5"></td>
<td valign="top">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.<br>(sha1: 81fbbca307552a38ed577def2d365ac1b8fcecfc)</td></tr>
<tr><td colspan="4"><b>Precompiled Binaries for .NET</b></td></tr><tr><td width="10"></td><td valign="top" align="right"><a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki">System.Data.SQLite</a></td><td width="5"></td><td valign="top">
Visit the <a href="http://system.data.sqlite.org/">System.Data.SQLite.org
</a> website and especially the <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki">download page</a> for
source code and binaries of SQLite for .NET.</td></tr>
<tr><td colspan="4"><a name="old"></a><b>Legacy Source Code Distribution Formats (Not Recommended)</b></td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a16' href='hp1.html'>sqlite-src-3080100.zip</a><br>(5.19 MiB)</td>
<td width="5"></td>
<td valign="top">A ZIP archive of the complete source tree for SQLite version 3.8.1
as extracted from the version control system. <i>The Makefile and
configure script in this tarball are not supported</i>. Their use
is <u>not</u> 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.<br>(sha1: 4c18b90ef7802ad9990b36d10707daa209f3be7c)</td></tr>
<tr><td width="10"></td><td valign="top" align="right"><a id='a17' href='hp1.html'>sqlite-preprocessed-3080100.zip</a><br>(1.52 MiB)</td>
<td width="5"></td>
<td valign="top">This ZIP archive contains preprocessed C code for SQLite version 3.8.1
individual source files. The use of this source distribution is
<u>not</u> recommended. Use one of the amalgamation packages above
unless you have a compelling reason not to.<br>(sha1: 2488bf37311342ad9bfcf096069ca9488f0b12ac)</td></tr>
</table>
<hr>
<a name="encoding"></a>
<h3>Build Product Names</h3>
<p>
Build products are named using one of the following templates:
<ol>
<li> <b>sqlite-</b>product<b>-</b>version<b>.zip</b>
<li> <b>sqlite-</b>product<b>-</b>version<b>.tar.gz</b>
<li> <b>sqlite-</b>product<b>-</b>os<b>-</b>cpu<b>-</b>version<b>.zip</b>
<li> <b>sqlite-</b>product<b>-</b>date<b>.zip</b>
</ol>
<p>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.
<p>The <i>version</i> 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.
<p>The <i>date</i> in template (4) is of the form: YYYYMMDDHHMM
<a name="cvs"></a>
<a name="fossil"></a>
<h3>Source Code Repositories</h3>
<p>
The SQLite source code is maintained in three geographically-dispersed
self-synchronizing
<a href="http://www.fossil-scm.org/">Fossil</a> 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.</p>
<p>Note that a unix-like development environment, including a recent
version of <a href="http://www.tcl.tk/">Tcl</a>, is required in order to
build from the repository sources. The <a href="amalgamation.html">amalgamation</a> source code files
(the "sqlite3.c" and "sqlite3.h" files) are not contained in
the repository.</p>
<blockquote>
<a href="http://www.sqlite.org/cgi/src">http://www.sqlite.org/cgi/src</a> (Dallas)<br>
<a href="http://www2.sqlite.org/cgi/src">http://www2.sqlite.org/cgi/src</a> (Newark)<br>
<a href="http://www3.sqlite.org/cgi/src">http://www3.sqlite.org/cgi/src</a> (Fremont)<br>
</blockquote>
<p>The documentation is maintained in separate
<a href="http://www.fossil-scm.org/">Fossil</a> repositories located
at:</p>
<blockquote>
<a href="http://www.sqlite.org/cgi/docsrc">http://www.sqlite.org/cgi/docsrc</a> (Dallas)<br>
<a href="http://www2.sqlite.org/cgi/docsrc">http://www2.sqlite.org/cgi/docsrc</a> (Newark)<br>
<a href="http://www3.sqlite.org/cgi/docsrc">http://www3.sqlite.org/cgi/docsrc</a> (Fremont)<br>
</blockquote>
<script type='text/JavaScript'>
/* <![CDATA[ */
function adce4d016d6cd(){
function d391(a,b){document.getElementById(a).href=b;}
d391('a16','2013/sqlite-src-3080100.zip');
d391('a7','2013/sqlite-analyzer-linux-x86-3080100.zip');
d391('a17','2013/sqlite-preprocessed-3080100.zip');
d391('a8','2013/sqlite-shell-osx-x86-3080100.zip');
d391('a9','2013/sqlite-analyzer-osx-x86-3080100.zip');
d391('a1','snapshot/sqlite-amalgamation-201311271348.zip');
d391('a10','2013/sqlite-shell-win32-x86-3080100.zip');
d391('a2','snapshot/sqlite-amalgamation32k-201311271348.zip');
d391('a11','2013/sqlite-dll-win32-x86-3080100.zip');
d391('a3','2013/sqlite-amalgamation-3080100.zip');
d391('a12','2013/sqlite-analyzer-win32-x86-3080100.zip');
d391('a13','2013/sqlite-wp80-winrt-3080100.vsix');
d391('a4','2013/sqlite-autoconf-3080100.tar.gz');
d391('a14','2013/sqlite-winrt80-3080100.vsix');
d391('a5','2013/sqlite-doc-3080100.zip');
d391('a15','2013/sqlite-winrt81-3080002.vsix');
d391('a6','2013/sqlite-shell-linux-x86-3080100.zip');
}
setTimeout('adce4d016d6cd();',10);
/* ]]> */
</script>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment