Documentation Source Text

Check-in [015a7ffa9e]
Login

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

Overview
Comment:Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation.
Timelines: family | ancestors | descendants | both | branch-3.22
Files: files | file ages | folders
SHA3-256:015a7ffa9eb34f2339db165f4d1ec0b73ee8d16cd1e567958630c7226886abf7
User & Date: drh 2018-03-20 13:15:15
Context
2018-03-23
22:56
Copy the new CoC overview from trunk. check-in: 3b828f75e4 user: drh tags: branch-3.22
2018-03-20
13:15
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. check-in: 015a7ffa9e user: drh tags: branch-3.22
13:14
Remove obsolete text about SQLITE_EXTRA_DURABLE from the PRAGMA synchronous documentation. check-in: fc5ba69bb7 user: drh tags: trunk
2018-03-15
11:25
Fix typos in the th3.html document. check-in: 996754464c user: drh tags: branch-3.22
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
    The extra WAL sync following each transaction help ensure that 
    transactions are durable across a power loss.  Transactions are
    consistent with or without the extra syncs provided by
    synchronous=FULL.
    If durability is not a concern, then synchronous=NORMAL is normally
    all one needs in WAL mode.</p>

    <p>^The default setting is usually synchronous=FULL.
    The [SQLITE_EXTRA_DURABLE] compile-time option changes the
    default to synchronous=EXTRA.</p>

    <p>The TEMP schema always has synchronous=OFF since the content of
    of TEMP is ephemeral and is not expected to survive a power outage.
    Attempts to change the synchronous setting for TEMP are
    silently ignored.

    <p>See also the [fullfsync] and [checkpoint_fullfsync] pragmas.</p>
}







<
<
<
<







1200
1201
1202
1203
1204
1205
1206




1207
1208
1209
1210
1211
1212
1213
    The extra WAL sync following each transaction help ensure that 
    transactions are durable across a power loss.  Transactions are
    consistent with or without the extra syncs provided by
    synchronous=FULL.
    If durability is not a concern, then synchronous=NORMAL is normally
    all one needs in WAL mode.</p>





    <p>The TEMP schema always has synchronous=OFF since the content of
    of TEMP is ephemeral and is not expected to survive a power outage.
    Attempts to change the synchronous setting for TEMP are
    silently ignored.

    <p>See also the [fullfsync] and [checkpoint_fullfsync] pragmas.</p>
}