Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | The application_id is a signed integer. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
3580ba4b5bd75ec6f3c305b97fc11871 |
| 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
Changes to pages/pragma.in.
| ︙ | ︙ | |||
236 237 238 239 240 241 242 |
</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
| | | 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
|
| ︙ | ︙ |