Documentation Source Text

Check-in [089a50e46d]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add the new book by Kay Droessler to the "Books About SQLite" page.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 089a50e46d9ae47ac05d7f467cd6437aa94504b2
User & Date: drh 2010-06-15 12:50:46.000
Context
2010-06-17
15:21
Minor edits to the WAL document. (check-in: f84c08f7bf user: drh tags: trunk)
2010-06-15
12:50
Add the new book by Kay Droessler to the "Books About SQLite" page. (check-in: 089a50e46d user: drh tags: trunk)
12:07
Updates to WAL documentation. (check-in: 9f38773d3b user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Added images/books/droessler.jpg.

cannot compute difference between binary files

Changes to pages/books.in.
︙︙
27
28
29
30
31
32
33



























34
35
36
37
38
39
40

and learn how you to work with SQLite using either a scripting 
language or a C-based language, such as C# or Objective C.Now, 
even relatively small and nimble applications can be a part of 
the data revolution. Using SQLite shows you how.
</p>
</table>




























<hr>
<table border=0>
<tr><td valign=top><img src="images/books/symbiansql.jpg"><td valign=top>
<h2>Inside Symbian SQL (2010)</h2>

<p>Authors: Ivan Litovski &amp; Richard Maynard<br>
Publisher: Wiley<br>








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>








27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

and learn how you to work with SQLite using either a scripting 
language or a C-based language, such as C# or Objective C.Now, 
even relatively small and nimble applications can be a part of 
the data revolution. Using SQLite shows you how.
</p>
</table>

<hr>
<table border=0><tr><td valign=top><p><img src="images/books/droessler.jpg">
<td valign=top>
<h2>SQLite 3 - Einstieg in die Datenbankwelt (2010)</h2>

<p>
Author: Key Droessler<br>
Publisher: Lulu.com<br>
<a href="http://www.amazon.com/SQLite-Einstieg-die-Datenbankwelt-German/dp/1445741075">Amazon</a></p>

<p>Die Datenbanksprache SQL ( Structured Query Language ) wird in Datenbanken
zur Definition, Manipulation, Sicherung, aber hauptsaechlich zur Abfrage 
von Daten aus der Datenbank eingesetzt. Unabhaengig vom Betriebssystem oder 
aufwendigen, benutzerfreundlichen, graphischen Oberflaechen bleibt die 
Logik aber immer gleich.SQLite ist eine freie Desktop-Datenbank, 
sie kostet nichts, ist fuer viele Betriebssysteme verfuegbar, 
schnell heruntergeladen und installiert und auf das Notwendigste 
reduziert. Fuer den Einsteiger sind das die besten Voraussetzungen, 
ohne viel Aufwand schnell in die Welt der Datenbanken und Datenbanksprache 
reinzuschnuppern.Wer nach den Uebungen aber auf den Geschmack gekommen ist,
hat schon den groessten Teil an Datenbanken und SQL gelernt, denn alles 
Besprochene ist Wissen, welches auch auf jedes andere der vielen 
Datenbanken grundlegend anwendbar ist. Nun koennen Sie auf die richtig 
Grossen zugehen, vom grossen Fachbuch bis zum riesigen Datenbanksystem.
</p>
</table>

<hr>
<table border=0>
<tr><td valign=top><img src="images/books/symbiansql.jpg"><td valign=top>
<h2>Inside Symbian SQL (2010)</h2>

<p>Authors: Ivan Litovski &amp; Richard Maynard<br>
Publisher: Wiley<br>
︙︙
Changes to pages/lang.in.
︙︙
2642
2643
2644
2645
2646
2647
2648
2649

2650
2651
2652
2653
2654
2655
2656

the size of the database file to shrink.  However, [auto_vacuum]
also causes excess fragmentation of the database file.  ^And [auto_vacuum]
does not compact partially filled pages of the database as VACUUM
does.</p>

<p>^The [page_size] and/or [auto_vacuum] mode of a database can be changed
by invoking the [page_size pragma] and/or [auto_vacuum pragma] and then
immediately VACUUMing the database.</p>


<tcl>
##############################################################################
Section {INDEXED BY} indexedby {{INDEXED BY} {NOT INDEXED}}

</tcl>
<p>^The INDEXED BY phrase is a SQL extension found only in SQLite which can








|
>








2642
2643
2644
2645
2646
2647
2648
2649
2650
2651
2652
2653
2654
2655
2656
2657

the size of the database file to shrink.  However, [auto_vacuum]
also causes excess fragmentation of the database file.  ^And [auto_vacuum]
does not compact partially filled pages of the database as VACUUM
does.</p>

<p>^The [page_size] and/or [auto_vacuum] mode of a database can be changed
by invoking the [page_size pragma] and/or [auto_vacuum pragma] and then
immediately VACUUMing the database. ^Except, the page size cannot be
changed when [write-ahead log] mode is in use.</p>

<tcl>
##############################################################################
Section {INDEXED BY} indexedby {{INDEXED BY} {NOT INDEXED}}

</tcl>
<p>^The INDEXED BY phrase is a SQL extension found only in SQLite which can
︙︙