1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>The SQLite Amalgamation</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
72
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="about.html">About</a>
83
<a href="sitemap.html">Sitemap</a>
84
<a href="docs.html">Documentation</a>
85
<a href="download.html">Download</a>
86
<a href="copyright.html">License</a>
87
<a href="news.html">News</a>
88
<a href="support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
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...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
123
<h2>The SQLite Amalgamation</h2>
125
<p>The core SQLite library consists of about 96 files of C code
126
(as of <a href="releaselog/3_6_21.html">Version 3.6.21</a>) in the core with 11 additional files
127
in the <a href="fts3.html">FTS3</a> and <a href="rtree.html">RTREE</a> extensions.
128
Most of these are "source" files in the sense that they are stored
129
in the configuration management system and are maintained directly.
130
But 6 of the core C files are generated automatically during the
131
compilation process. Of the 96 code files, 76 are C code and
132
20 are C header files.</p>
134
<p>The standard makefiles for SQLite have a target for building
135
an object we call the "amalgamation".
136
The amalgamation is a single C code file, named "sqlite3.c",
137
that contains all C code
138
for the core SQLite library and the <a href="fts3.html">FTS3</a> and <a href="rtree.html">RTREE</a> extensions.
139
This file contains about 110K lines of code
140
(65K if you omit blank lines and comments) and is over 3.8 megabytes
143
<p>The amalgamation contains everything you need to integrate SQLite
144
into a larger project. Just copy the amalgamation into your source
145
directory and compile it along with the other C code files in your project.
146
You may also want to make use of the "sqlite3.h" header file that
147
defines the programming API for SQLite.
148
The sqlite3.h header file is available separately.
149
The sqlite3.h file is also contained within the amalgamation, in
150
the first couple of thousand lines. So if you have a copy of
151
sqlite3.c but cannot seem to locate sqlite3.h, you can always
152
regenerate the sqlite3.h by copying and pasting from the amalgamation.</p>
154
<p>In addition to making SQLite easier to incorporate into other
155
projects, the amalgamation also makes it run faster. Many
156
compilers are able to do additional optimizations on code when
157
it is contained with in a single translation unit such as it
158
is in the amalgamation. We have measured performance improvements
159
of between 5 and 10% when we use the amalgamation to compile
160
SQLite rather than individual source files. The downside of this
161
is that the additional optimizations often take the form of
162
function inlining which tends to make the size of the resulting
163
binary image larger.</p>
165
<p>The amalgamation and
166
the sqlite3.h header file are available on
167
the <a href="download.html">download page</a> as a file
168
named sqlite-amalgamation-X_X_X.zip
169
where the X's are replaced by the appropriate version number.</p>