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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 3580ba4b5bd75ec6f3c305b97fc11871a537b3bd013ad0591de3f4570260c3fe
User & Date: drh 2018-09-14 16:34:55.586
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
Unified Diff 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
︙︙