Debian Codegraph @

www/books.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Books About SQLite</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120
121 <h1 align=center>Books About SQLite</h1>
122
123 <hr>
124 <table border=0><tr><td valign=top><img src="images/books/sanderson2018.jpg" style="border:44px solid white;">
125 <td valign=top>
126 <h2>SQLite Forensics (2018)</h2>
127
128 <p>
129 Author: Paul Sanderson<br>
130 Publisher: <a href="https://www.amazon.com/product/dp/1980293074">Amazon</a>
131
132 <p>
133 This text by noted digital forensics expert, Paul Sanderson, provides
134 investigators with low-level technical details useful in analysing
135 SQLite database files.
136
137 <p>
138 Every computer and phone uses hundreds of SQLite databases and there are
139 over one trillion SQLite databases in active use. Hence, the importance
140 of examining the data held in these databases in an
141 investigation, including deleted data when possible, is paramount. This
142 book fully explains the format of the SQLite database file. It shows how
143 records are encoded, how to decode them manually and how to decode
144 records that are partially overwritten. It also describe how the
145 workings of SQLite, and in particular the journal and WAL, can be used
146 to ascertain what has happened in a manner that cannot be determined
147 from the data alone. The book covers basic SQL queries and how they can
148 be used to create a custom report that includes data from different
149 tables, and shows how one can use SQL queries to test hypotheses about
150 the relationships of data in different tables.
151 <p>
152 This book is aimed mainly at
153 forensic practitioners, and it is assumed that the reader has some basic
154 knowledge of computer forensics; it will also be of interest to computer
155 professionals in general particularly those who have an interest in the
156 SQLite file format.
157 </table>
158
159
160 <hr>
161 <table border=0><tr><td valign=top><img src="images/books/darocha2016.jpg">
162 <td valign=top>
163 <h2>Learning SQLite for iOS (2016)</h2>
164
165 <p>
166 Author: Gene&nbsp;Da&nbsp;Rocha<br>
167 Publisher: <a href="https://www.packtpub.com/application-development/learning-sqlite-ios">Packt Publishing</a>
168
169 <p>
170 This book starts with the architecture of SQLite database and introduces
171 you to concepts in SQL. You will find yourself equipped to design your
172 own database system, administer it, and maintain it. Further, you will
173 learn how to operate your SQLite databases smoothly using SQL commands.
174
175 <p>
176 You will be able to extend the functionality of SQLite by using its vast
177 arsenal of C API calls to build some interesting, exciting, new, and
178 intelligent data-driven applications. Understand how Xcode, HTML5, and
179 Phonegap can be used to build a cross-platform modern app which can
180 benefit from all these technologies - all through creating a complete,
181 customizable application skeleton that you can build on for your own
182 apps. This book provides a comprehensive description of SQLite database
183 system. It describes design principles, engineering trade-offs,
184 implementation issues, and operations of SQLite.
185 </table>
186
187 <hr>
188 <table border=0><tr><td valign=top><img src="images/books/haldar2.jpg">
189 <td valign=top>
190 <h2>SQLite Database System Design and Implementation (2015)</h2>
191
192 <p>
193 Author: Sibsankar Haldar<br>
194 Publisher: <a href="https://books.google.com/books?id=OEJ1CQAAQBAJ">https://books.google.com/</a><br>
195
196 <p>
197 This book provides a comprehensive description of SQLite database system.
198 It describes design principles, engineering trade-offs, implementation issues,
199 and operations of SQLite.
200 </table>
201
202 <hr>
203 <table border=0><tr><td valign=top><img src="images/books/aditya.jpg">
204 <td valign=top>
205 <h2>Android SQLite Essentials (2014)</h2>
206
207 <p>
208 Authors: Sunny Kumar Aditya and Vikash Kumar Karn<br>
209 Publisher: <a href="https://www.packtpub.com/application-development/android-sqlite-essentials">
210 Packt Publishing</a><br>
211
212 <p>
213 Android SQLite Essentials focuses on the core concepts behind building
214 database-driven applications. This book covers the basic and advanced
215 topics with equivalent simplicity and detail, in order to enable
216 readers to quickly grasp and implement the concepts to build an
217 application database.
218
219 <p>This book takes a hands-on, example-based approach to help readers
220 understand the core topics of SQLite and Android database-driven
221 applications. This book focuses on providing you with latent as well
222 as widespread knowledge about practices and approaches towards
223 development in an easily understandable manner.
224 </table>
225
226 <hr>
227 <table border=0><tr><td valign=top><img src="images/books/das.jpg">
228 <td valign=top>
229 <h2>SQLite for Mobile Apps Simplified (2014)</h2>
230
231 <p>
232 Author: Sribatsa Das<br>
233 Publisher: Amazon<br>
234 <a href="https://www.amazon.com/dp/product/B00M3OVSRK">Amazon</a>
235
236 <p>
237 SQLite for Mobile Apps Simplified is devoted to presenting approach
238 and implementation methodology for using SQLite database in mobile apps.
239 It presents step-by-step examples to create schema, execute transactions
240 and access data from Android, BlackBerry and iOS applications.
241 In addition, it presents ADB Shell and SQLite command-line shell from
242 ADB Shell to access the SQLite Database created by the Android apps.
243 For BlackBerry and iOS application, the book presents ways to access
244 the data using the command line shell.
245 </table>
246
247 <hr>
248 <table border=0><tr><td valign=top><img src="images/books/owens.jpg">
249 <td valign=top>
250 <h2>The Definitive Guide to SQLite (2nd edition, 2010)</h2>
251
252 <p>
253 Authors: Mike Owens and Grant Allen<br>
254 Publisher: Apress<br>
255 <a href="http://www.amazon.com/gp/product/1430232250">Amazon</a></p>
256
257 <p>
258 Outside of the world of enterprise computing, there is one database
259 that enables a huge range of software and hardware to flex relational
260 database capabilities, without the baggage and cost of traditional
261 database management systems. That database is SQLite - an embeddable
262 database with an amazingly small footprint, yet able to handle databases
263 of enormous size. SQLite comes equipped with an array of powerful
264 features available through a host of programming and development
265 environments. It is supported by languages such as C, Java, Perl,
266 PHP, Python, Ruby, TCL, and more.</p>
267
268 <p><i>The Definitive Guide to SQLite, Second Edition</i>
269 is devoted to complete coverage of the latest version of this powerful
270 database. It offers a thorough overview of SQLite's capabilities
271 and APIs. The book also uses SQLite as the basis for helping newcomers
272 make their first foray into database development. In only a short time
273 you can be writing programs as diverse as a server-side browser plug-in
274 or the next great iPhone or Android application!
275 </p>
276 </table>
277
278 <hr>
279 <table border=0><tr><td valign=top><p><img src="images/books/kreibich.gif">
280 <td valign=top>
281 <h2>Using SQLite (2010)</h2>
282
283 <p>
284 Author: Jay A. Kreibich<br>
285 Publisher: O'Reilly Media<br>
286 <a href="http://oreilly.com/catalog/9780596521196/">O'Reilly</a></p>
287
288 <p>Developers, take note: databases aren't just for the IS group any more.
289 You can build database-backed applications for the desktop, Web,
290 embedded systems, or operating systems without linking to heavy-duty
291 client-server databases such as Oracle and MySQL.
292 This book shows how you to use SQLite, a small and lightweight
293 database that you can build right into your application during development.
294 Applications that handle data have an enormous advantage today, and
295 with SQLite, you'll discover how to develop a database-backed application
296 that remains manageable in size and complexity. This book guides
297 you every step of the way. You'll get a crash course in data modeling,
298 become familiar with SQLite's dialect of the SQL database language,
299 and learn how you to work with SQLite using either a scripting
300 language or a C-based language, such as C# or Objective C.Now,
301 even relatively small and nimble applications can be a part of
302 the data revolution. Using SQLite shows you how.
303 </p>
304 </table>
305
306 <hr>
307 <table border=0><tr><td valign=top><p><img src="images/books/droessler.jpg">
308 <td valign=top>
309 <h2>SQLite 3 - Einstieg in die Datenbankwelt (2010)</h2>
310
311 <p>
312 Author: Kay Droessler<br>
313 Publisher: Lulu.com<br>
314 <a href="https://www.amazon.com/product/dp/1445741075">Amazon</a></p>
315
316 <p>Die Datenbanksprache SQL ( Structured Query Language ) wird in Datenbanken
317 zur Definition, Manipulation, Sicherung, aber hauptsaechlich zur Abfrage
318 von Daten aus der Datenbank eingesetzt. Unabhaengig vom Betriebssystem oder
319 aufwendigen, benutzerfreundlichen, graphischen Oberflaechen bleibt die
320 Logik aber immer gleich.SQLite ist eine freie Desktop-Datenbank,
321 sie kostet nichts, ist fuer viele Betriebssysteme verfuegbar,
322 schnell heruntergeladen und installiert und auf das Notwendigste
323 reduziert. Fuer den Einsteiger sind das die besten Voraussetzungen,
324 ohne viel Aufwand schnell in die Welt der Datenbanken und Datenbanksprache
325 reinzuschnuppern.Wer nach den Uebungen aber auf den Geschmack gekommen ist,
326 hat schon den groessten Teil an Datenbanken und SQL gelernt, denn alles
327 Besprochene ist Wissen, welches auch auf jedes andere der vielen
328 Datenbanken grundlegend anwendbar ist. Nun koennen Sie auf die richtig
329 Grossen zugehen, vom grossen Fachbuch bis zum riesigen Datenbanksystem.
330 </p>
331 </table>
332
333 <hr>
334 <table border=0>
335 <tr><td valign=top><img src="images/books/symbiansql.jpg"><td valign=top>
336 <h2>Inside Symbian SQL (2010)</h2>
337
338 <p>Authors: Ivan Litovski &amp; Richard Maynard<br>
339 Publisher: Wiley<br>
340 <a href="http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470744022.html">wiley.com</a></p>
341
342 <p>
343 This is the definitive reference book on the Symbian SQL database
344 which is based on SQLite. The authors (both members of the Symbian
345 engineering team responsible for the implementation of the code)
346 show you how to design code
347 and ease migration from an internal and external point of view,
348 plus they reveal the dos and don'ts of writing high-performance
349 database applications. Packed with resources and sample code,
350 this timely book reveals how to design and tune applications
351 that use the Symbian SQL framework to ultimately improve performance.</p>
352
353 <p>With its sample code and insider expertise, this text has everything
354 you need to keep you ahead of the curve.
355 </p>
356 </table>
357
358 <hr>
359 <table border=0>
360 <tr><td valign=top><img src="images/books/vanderLans.jpg"><td valign=top>
361 <h2>The SQL Guide to SQLite (2009)</h2>
362
363 <p>Author: Rick F. van der Lans<br>
364 Publisher: Lulu.com<br>
365 <a href="https://www.amazon.com/product/dp/0557076765">Amazon</a></p>
366
367 <p>SQLite is a small, fast, embeddable, SQL-based database server.
368 It is easy to install, needs no management, and is open source.
369 This book describes SQLite in detail. With hundreds of examples, plus a
370 proven approach and structure, the book teaches you how to use SQLite
371 efficiently and effectively. It contains a complete description of the
372 SQL dialect as implemented in SQLite version 3.6. The book can be seen
373 as a tutorial and a reference book. Source code for the numerous SQL
374 examples and exercises included in this book can be downloaded from www.r20.nl.
375 </p>
376 </table>
377
378 <hr>
379 <table border=0>
380 <tr><td valign=top><img src="images/books/nishizawa2.jpg"><td valign=top>
381 <h2>An Introduction to SQLite - 2nd Edition (2009)</h2>
382
383 <p>Author: Naoki Nishizawa<br>
384 Publisher: Shoeisha<br>
385 <a href="https://www.amazon.co.jp/product/dp/479811944X">Amazon.jp</a></p>
386
387 <p>This text is written in fluent Japanese specifically for a Japanese
388 audience. This is the second edition of the book - the first edition
389 was published in 2005.
390 </p>
391 </table>
392
393 <hr>
394 <table border=0><tr><td valign=top><p><img src="images/books/haldar.gif">
395 <td valign=top>
396 <h2>Inside SQLite (2007)</h2>
397
398 <p>
399 Author: Sibsankar Haldar<br>
400 Publisher: O'Reilly Media<br>
401 <a href="http://oreilly.com/catalog/9780596550066">O'Reilly</a></p>
402
403 <p>SQLite is a small, zero-configuration, custom-tailored, embeddable,
404 thread-safe, easily maintainable, transaction-oriented, SQL-based,
405 relational database management system. There is no separate install or
406 setup procedure to initialize SQLite before using it.
407 There is no configuration file.
408 SQLite is open source, and is available in the public domain
409 (for more information on open source, visit http://opensource.org).
410 You can download SQLite source code from its homepage https://sqlite.org,
411 compile it using your favorite C compiler, and start using the compiled
412 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.
413 This Short Cut discusses design principles, engineering trade-offs,
414 implementation issues, and operations of SQLite. It presents a
415 comprehensive description of all important components of the SQLite engine.</p>
416 </table>
417
418
419 <hr>
420 <table border=0><tr><td valign=top><img src="images/books/newman.jpg">
421 <td valign=top>
422 <h2>SQLite (2004)</h2>
423
424 <p>Author: Chris Newman<br>
425 Publisher: Sams<br>
426 <a href="https://www.amazon.com/product/dp/067232685X">Amazon</a></p>
427
428 <p>
429 SQLite is a small, fast, embeddable database. What makes it popular is
430 the combination of the database engine and interface into a single library
431 as well as the ability to store all the data in a single file.
432 Its functionality lies between MySQL and PostgreSQL, however it is faster
433 than both databases.</p>
434
435 <p>In <i>SQLite</i>,
436 author Chris Newman provides a thorough, practical guide to
437 using, administering and programming this up-and-coming database.
438 If you want to learn about SQLite or about its use in conjunction with
439 PHP this is the book for you.</p>
440 </table>
441 <p align="center"><small><i>This page was last updated on 2025-04-16 13:13:29Z </small></i></p>
442