Documentation Source Text

Check-in [121aeee579]
Login

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

Overview
Comment:Merge typo fix from the 3.25 branch.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:121aeee57976cbf0814abc2279f8a9ea404b5faa375f48b92e8f0d734eacec64
User & Date: drh 2018-11-26 12:01:57
Context
2018-11-26
18:57
Caution users to have well-defined column names in VIEWs. check-in: 5a0203cdca user: drh tags: trunk
12:01
Merge typo fix from the 3.25 branch. check-in: 121aeee579 user: drh tags: trunk
12:01
Fix typo in the wal.html document. Leaf check-in: 4182b1655e user: drh tags: branch-3.25
2018-11-24
20:58
In the GeoPoly documentation, mention that geopoly_ccw() can be used to correct vertex order after geopoly_xform(). check-in: bfc897c9c0 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/wal.in.

363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
<li>There is write permission on the directory containing the database so
    that the <tt>-shm</tt> and <tt>-wal</tt> files can be created.
<li>The database connection is opened using the
    [immutable query parameter].
</ol>

<p>Even though it is possible to open a read-only WAL-mode database,
it is good practice is to converted to 
[journal_mode | PRAGMA journal_mode=DELETE] prior to burning an
SQLite database image onto read-only media.</p>

<tcl>hd_fragment bigwal {large WAL files} {avoiding large WAL files}</tcl>
<h1>Avoiding Excessively Large WAL Files</h1>

<p>In normal cases, new content is appended to the WAL file until the







|







363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
<li>There is write permission on the directory containing the database so
    that the <tt>-shm</tt> and <tt>-wal</tt> files can be created.
<li>The database connection is opened using the
    [immutable query parameter].
</ol>

<p>Even though it is possible to open a read-only WAL-mode database,
it is good practice to converted to 
[journal_mode | PRAGMA journal_mode=DELETE] prior to burning an
SQLite database image onto read-only media.</p>

<tcl>hd_fragment bigwal {large WAL files} {avoiding large WAL files}</tcl>
<h1>Avoiding Excessively Large WAL Files</h1>

<p>In normal cases, new content is appended to the WAL file until the