Documentation Source Text

Check-in [97e70fb787]
Login

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

Overview
Comment:Fix typo in the how-to-corrupt document. (Cherrypick from trunk)
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | branch-3.21
Files: files | file ages | folders
SHA3-256: 97e70fb787d609771f93f7f9fb2fc2ea35a76f05d026a6328462ec6c96b11f4e
User & Date: drh 2018-01-13 20:39:14.853
Context
2018-01-13
20:39
Fix typo in the how-to-corrupt document. (Cherrypick from trunk) (Leaf check-in: 97e70fb787 user: drh tags: branch-3.21)
20:37
Fix typo in the how-to-corrupt document. (check-in: 66c7f7dcd6 user: drh tags: trunk)
2017-11-23
21:43
Default value for the "s" query parameter in /search is now "d". (check-in: 6182e9ea42 user: drh tags: branch-3.21)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/howtocorrupt.in.
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
If protections are disabled, database corruption may occur.

<p>The following are examples of disabling the built-in protection
mechanisms of SQLite:

<ul>
<li><p>Setting [PRAGMA synchronous=OFF] can cause the database to
go corrupt if there is an operating-system crass or power failure,
though this setting is safe from damage due to application crashes.

<li><p>Changing the [PRAGMA schema_version] while other database
connections are open.

<li><p>Using [PRAGMA journal_mode=OFF] or [PRAGMA journal_mode=MEMORY]
and taking an application crash in the middle of a write transaction.







|







409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
If protections are disabled, database corruption may occur.

<p>The following are examples of disabling the built-in protection
mechanisms of SQLite:

<ul>
<li><p>Setting [PRAGMA synchronous=OFF] can cause the database to
go corrupt if there is an operating-system crash or power failure,
though this setting is safe from damage due to application crashes.

<li><p>Changing the [PRAGMA schema_version] while other database
connections are open.

<li><p>Using [PRAGMA journal_mode=OFF] or [PRAGMA journal_mode=MEMORY]
and taking an application crash in the middle of a write transaction.