Documentation Source Text

Check-in [3580ba4b5b]
Login

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

Overview
Comment:The application_id is a signed integer.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:3580ba4b5bd75ec6f3c305b97fc11871a537b3bd013ad0591de3f4570260c3fe
User & Date: drh 2018-09-14 16:34:55
Context
2018-09-14
16:54
Add news for the 3.25.0 release. check-in: 884ea7b3ed user: drh tags: trunk
16:34
The application_id is a signed integer. check-in: 3580ba4b5b user: drh tags: trunk
15:54
Update the speed-and-size spreadsheet with the latest measurements. check-in: 37ab9b40af user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/pragma.in.

236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
</ul>

<tcl>Pragma {application_id} {
    <p><b>PRAGMA DB.application_id;
     <br>PRAGMA DB.application_id = </b><i>integer </i><b>;</b>
  
<p>    ^The application_id PRAGMA is used to query or set the 32-bit
       unsigned big-endian "Application ID" integer located at offset
       68 into the [database header].  Applications that use SQLite as their
       [application file-format] should set the Application ID integer to
       a unique integer so that utilities such as 
       [http://www.darwinsys.com/file/ | file(1)] can determine the specific
       file type rather than just reporting "SQLite3 Database".  A list of
       assigned application IDs can be seen by consulting the
       [http://www.sqlite.org/src/artifact?ci=trunk&filename=magic.txt







|







236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
</ul>

<tcl>Pragma {application_id} {
    <p><b>PRAGMA DB.application_id;
     <br>PRAGMA DB.application_id = </b><i>integer </i><b>;</b>
  
<p>    ^The application_id PRAGMA is used to query or set the 32-bit
       signed big-endian "Application ID" integer located at offset
       68 into the [database header].  Applications that use SQLite as their
       [application file-format] should set the Application ID integer to
       a unique integer so that utilities such as 
       [http://www.darwinsys.com/file/ | file(1)] can determine the specific
       file type rather than just reporting "SQLite3 Database".  A list of
       assigned application IDs can be seen by consulting the
       [http://www.sqlite.org/src/artifact?ci=trunk&filename=magic.txt