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>Books About SQLite</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
<h1 align=center>Books About SQLite</h1>
126
<table border=0><tr><td valign=top><img src="images/books/owens.jpg">
128
<h2>The Definitive Guide to SQLite (2nd edition, 2010)</h2>
131
Authors: Mike Owens and Grant Allen<br>
132
Publisher: Apress<br>
133
<a href="http://www.amazon.com/gp/product/1430232250">Amazon</a></p>
136
Outside of the world of enterprise computing, there is one database
137
that enables a huge range of software and hardware to flex relational
138
database capabilities, without the baggage and cost of traditional
139
database management systems. That database is SQLite\u2014an embeddable
140
database with an amazingly small footprint, yet able to handle databases
141
of enormous size. SQLite comes equipped with an array of powerful
142
features available through a host of programming and development
143
environments. It is supported by languages such as C, Java, Perl,
144
PHP, Python, Ruby, TCL, and more.</p>
146
<p><i>The Definitive Guide to SQLite, Second Edition</i>
147
is devoted to complete coverage of the latest version of this powerful
148
database. It offers a thorough overview of SQLite\u2019s capabilities
149
and APIs. The book also uses SQLite as the basis for helping newcomers
150
make their first foray into database development. In only a short time
151
you can be writing programs as diverse as a server-side browser plug-in
152
or the next great iPhone or Android application!
157
<table border=0><tr><td valign=top><p><img src="images/books/kreibich.gif">
159
<h2>Using SQLite (2010)</h2>
162
Author: Jay A. Kreibich<br>
163
Publisher: O'Reilly Media<br>
164
<a href="http://oreilly.com/catalog/9780596521196/">O'Reilly</a></p>
166
<p>Developers, take note: databases aren't just for the IS group any more.
167
You can build database-backed applications for the desktop, Web,
168
embedded systems, or operating systems without linking to heavy-duty
169
client-server databases such as Oracle and MySQL.
170
This book shows how you to use SQLite, a small and lightweight
171
database that you can build right into your application during development.
172
Applications that handle data have an enormous advantage today, and
173
with SQLite, you'll discover how to develop a database-backed application
174
that remains manageable in size and complexity. This book guides
175
you every step of the way. You'll get a crash course in data modeling,
176
become familiar with SQLite's dialect of the SQL database language,
177
and learn how you to work with SQLite using either a scripting
178
language or a C-based language, such as C# or Objective C.Now,
179
even relatively small and nimble applications can be a part of
180
the data revolution. Using SQLite shows you how.
185
<table border=0><tr><td valign=top><p><img src="images/books/droessler.jpg">
187
<h2>SQLite 3 - Einstieg in die Datenbankwelt (2010)</h2>
190
Author: Key Droessler<br>
191
Publisher: Lulu.com<br>
192
<a href="http://www.amazon.com/SQLite-Einstieg-die-Datenbankwelt-German/dp/1445741075">Amazon</a></p>
194
<p>Die Datenbanksprache SQL ( Structured Query Language ) wird in Datenbanken
195
zur Definition, Manipulation, Sicherung, aber hauptsaechlich zur Abfrage
196
von Daten aus der Datenbank eingesetzt. Unabhaengig vom Betriebssystem oder
197
aufwendigen, benutzerfreundlichen, graphischen Oberflaechen bleibt die
198
Logik aber immer gleich.SQLite ist eine freie Desktop-Datenbank,
199
sie kostet nichts, ist fuer viele Betriebssysteme verfuegbar,
200
schnell heruntergeladen und installiert und auf das Notwendigste
201
reduziert. Fuer den Einsteiger sind das die besten Voraussetzungen,
202
ohne viel Aufwand schnell in die Welt der Datenbanken und Datenbanksprache
203
reinzuschnuppern.Wer nach den Uebungen aber auf den Geschmack gekommen ist,
204
hat schon den groessten Teil an Datenbanken und SQL gelernt, denn alles
205
Besprochene ist Wissen, welches auch auf jedes andere der vielen
206
Datenbanken grundlegend anwendbar ist. Nun koennen Sie auf die richtig
207
Grossen zugehen, vom grossen Fachbuch bis zum riesigen Datenbanksystem.
213
<tr><td valign=top><img src="images/books/symbiansql.jpg"><td valign=top>
214
<h2>Inside Symbian SQL (2010)</h2>
216
<p>Authors: Ivan Litovski & Richard Maynard<br>
218
<a href="http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470744022.html">wiley.com</a></p>
221
This is the definitive reference book on the Symbian SQL database
222
which is based on SQLite. The authors (both members of the Symbian
223
engineering team responsible for the implementation of the code)
224
show you how to design code
225
and ease migration from an internal and external point of view,
226
plus they reveal the dos and don'ts of writing high-performance
227
database applications. Packed with resources and sample code,
228
this timely book reveals how to design and tune applications
229
that use the Symbian SQL framework to ultimately improve performance.</p>
231
<p>With its sample code and insider expertise, this text has everything
232
you need to keep you ahead of the curve.
238
<tr><td valign=top><img src="images/books/vanderLans.jpg"><td valign=top>
239
<h2>The SQL Guide to SQLite (2009)</h2>
241
<p>Author: Rick F. van der Lans<br>
242
Publisher: Lulu.com<br>
243
<a href="http://www.amazon.com/SQL-Guide-SQLite-Rick-Lans/dp/0557076765/ref=sr_1_3?ie=UTF8&s=books&qid=1256736387&sr=1-3">Amazon</a></p>
245
<p>SQLite is a small, fast, embeddable, SQL-based database server.
246
It is easy to install, needs no management, and is open source.
247
This book describes SQLite in detail. With hundreds of examples, plus a
248
proven approach and structure, the book teaches you how to use SQLite
249
efficiently and effectively. It contains a complete description of the
250
SQL dialect as implemented in SQLite version 3.6. The book can be seen
251
as a tutorial and a reference book. Source code for the numerous SQL
252
examples and exercises included in this book can be downloaded from www.r20.nl.
258
<tr><td valign=top><img src="images/books/nishizawa2.jpg"><td valign=top>
259
<h2>An Introduction to SQLite - 2nd Edition (2009)</h2>
261
<p>Author: Naoki Nishizawa<br>
262
Publisher: Shoeisha<br>
263
<a href="http://www.amazon.co.jp/SQLite%E5%85%A5%E9%96%80-%E7%AC%AC2%E7%89%88-%E8%A5%BF%E6%B2%A2-%E7%9B%B4%E6%9C%A8/dp/479811944X/ref=pd_sim_b_2">Amazon.jp</a></p>
265
<p>This text is written in fluent Japanese specifically for a Japanese
266
audience. This is the second edition of the book - the first edition
267
was published in 2005.
272
<table border=0><tr><td valign=top><p><img src="images/books/haldar.gif">
274
<h2>Inside SQLite (2007)</h2>
277
Author: Sibsankar Haldar<br>
278
Publisher: O'Reilly Media<br>
279
<a href="http://oreilly.com/catalog/9780596550066">O'Reilly</a></p>
281
<p>SQLite is a small, zero-configuration, custom-tailored, embeddable,
282
thread-safe, easily maintainable, transaction-oriented, SQL-based,
283
relational database management system. There is no separate install or
284
setup procedure to initialize SQLite before using it.
285
There is no configuration file.
286
SQLite is open source, and is available in the public domain
287
(for more information on open source, visit http://opensource.org).
288
You can download SQLite source code from its homepage http://www.sqlite.org,
289
compile it using your favorite C compiler, and start using the compiled
290
library. SQLite runs on Linux, Windows, Mac OS X, and a few other operating systems. It has been widely used in low-to-medium tier database applications.
291
This Short Cut discusses design principles, engineering trade-offs,
292
implementation issues, and operations of SQLite. It presents a
293
comprehensive description of all important components of the SQLite engine.</p>
298
<table border=0><tr><td valign=top><img src="images/books/newman.jpg">
300
<h2>SQLite (2004)</h2>
302
<p>Author: Chris Newman<br>
304
<a href="http://www.amazon.com/SQLite-Chris-Newman/dp/067232685X/ref=sr_1_2?ie=UTF8&s=books&qid=1256736664&sr=1-2">Amazon</a></p>
307
SQLite is a small, fast, embeddable database. What makes it popular is
308
the combination of the database engine and interface into a single library
309
as well as the ability to store all the data in a single file.
310
Its functionality lies between MySQL and PostgreSQL, however it is faster
311
than both databases.</p>
314
author Chris Newman provides a thorough, practical guide to
315
using, administering and programming this up-and-coming database.
316
If you want to learn about SQLite or about its use in conjunction with
317
PHP this is the book for you.</p>