/ Check-in [352fa09e]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Add a comment to sqlite3ota.h. No code changes.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | ota-update
Files: files | file ages | folders
SHA1: 352fa09efd8240567b8f9487944e8c3ade4e664a
User & Date: dan 2015-04-21 15:35:30
Context
2015-04-22
11:34
Add comments related to database locking to sqlite3ota.h. check-in: 77242965 user: dan tags: ota-update
2015-04-21
15:35
Add a comment to sqlite3ota.h. No code changes. check-in: 352fa09e user: dan tags: ota-update
2015-04-17
17:00
Ensure that filenames passed to the VFS xOpen() function are terminated by 2 '\0' bytes. check-in: 66eff473 user: dan tags: ota-update
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to ext/ota/sqlite3ota.h.

   184    184   **   INSERT INTO data_ft1(a, b, ota_rowid, ota_control) 
   185    185   **       VALUES(NULL, 'usa', 12, '.x');
   186    186   **
   187    187   ** causes a result similar to:
   188    188   **
   189    189   **   UPDATE ft1 SET b = 'usa' WHERE rowid = 12;
   190    190   **
          191  +** The data_xxx tables themselves should have no PRIMARY KEY declarations.
          192  +** However, OTA is more efficient if reading the rows in from each data_xxx
          193  +** table in "rowid" order is roughly the same as reading them sorted by
          194  +** the PRIMARY KEY of the corresponding target database table. In other 
          195  +** words, rows should be sorted using the destination table PRIMARY KEY 
          196  +** fields before they are inserted into the data_xxx tables.
   191    197   **
   192    198   ** USAGE
   193    199   **
   194    200   ** The API declared below allows an application to apply an OTA update 
   195    201   ** stored on disk to an existing target database. Essentially, the 
   196    202   ** application:
   197    203   **