Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/ota/sqlite3ota.c
2015-07-23
| ||
20:44 | Renamed to ext/rbu/sqlite3rbu.c. Change the name of the OTA extension to RBU: Resumable Bulk Update. (check-in: [017c5019e1] user: drh branch: trunk, size: 0) | |
2015-06-29
| ||
15:41 | [21575d86ea] part of check-in [6aaaec6e63] Fix minor problems in the ota demo application. (check-in: [6aaaec6e63] user: dan branch: trunk, size: 118598) | |
2015-05-19
| ||
17:48 | [2246b779f4] part of check-in [c74e0bc481] Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. (check-in: [c74e0bc481] user: dan branch: trunk, size: 118554) | |
16:22 | [89530008cf] part of check-in [5af8db56af] Allow OTA update state data to be stored in a database separate from the OTA update database. (check-in: [5af8db56af] user: dan branch: ota-update, size: 118841) | |
2015-04-23
| ||
19:18 | [5bfd677bd9] part of check-in [fa62093b25] Fix a performance problem in calls to sqlite3ota_close() made after the OTA update has been completely applied and checkpointed. (check-in: [fa62093b25] user: dan branch: ota-update, size: 117880) | |
18:14 | [3b53197166] part of check-in [baee3556ea] Have OTA maintain a small LRU cache of UPDATE statements. This reduces the amount of time it spends compiling UPDATE if a single data_xxx table contains many different ota_control strings. (check-in: [baee3556ea] user: dan branch: ota-update, size: 117871) | |
2015-04-17
| ||
17:00 | [b45d73607b] part of check-in [66eff473c3] Ensure that filenames passed to the VFS xOpen() function are terminated by 2 '\0' bytes. (check-in: [66eff473c3] user: dan branch: ota-update, size: 116639) | |
16:29 | [7a2a9f20ac] part of check-in [c3dc15e717] Fix a memory leak in sqlite3ota.c that can follow an OOM error. (check-in: [c3dc15e717] user: dan branch: ota-update, size: 116216) | |
08:36 | [725e87f0f5] part of check-in [0d0e5ec064] Have OTA always specify SQLITE_CONFIG_URI when opening databases. Fix a test issue causing otacrash.test to fail. (check-in: [0d0e5ec064] user: dan branch: ota-update, size: 116178) | |
2015-04-16
| ||
18:49 | [424d4b9a01] part of check-in [d0fba72a47] Be sure to release any xShmLock locks held when closing an OTA handle. (check-in: [d0fba72a47] user: dan branch: ota-update, size: 116164) | |
14:33 | [876445eb19] part of check-in [5db810a88d] Fix a mismatched printf() argument and format specifier. Add ota files to Makefile.in. (check-in: [5db810a88d] user: dan branch: ota-update, size: 115707) | |
10:55 | [8c0d30482b] part of check-in [658c3b0c80] Avoid attempting to rename the *-oal file while it is still open. (check-in: [658c3b0c80] user: dan branch: ota-update, size: 115709) | |
2015-03-24
| ||
18:03 | [9c16cd3bf9] part of check-in [6326fd3249] When the OTA module updates or deletes a row, save only those fields that are part of an index or primary key to the ota update database. (check-in: [6326fd3249] user: dan branch: ota-update, size: 115628) | |
2015-03-23
| ||
17:10 | [1d3b605c27] part of check-in [858de8a5e7] Fix a broken assert() in the ota module. (check-in: [858de8a5e7] user: dan branch: ota-update, size: 113879) | |
2015-03-05
| ||
16:21 | [252a59574d] part of check-in [46119e8d8e] Fix some problems with OTA and empty target databases, or target databases with the wrong set of tables. Also add SQLITE_FCNTL_VFSNAME support to the OTA VFS. (check-in: [46119e8d8e] user: dan branch: ota-update, size: 113844) | |
2015-02-23
| ||
20:09 | [f0ee6872b8] part of check-in [d6d21ff552] Fix building with ENABLE_OTA and OMIT_LOAD_EXTENSION. (check-in: [d6d21ff552] user: dan branch: ota-update, size: 113268) | |
15:41 | [e060a4cb49] part of check-in [f7865b9428] Change SQLITE_FCNTL_ZIPVFS_PAGER to SQLITE_FCNTL_ZIPVFS. (check-in: [f7865b9428] user: dan branch: ota-update, size: 113204) | |
15:02 | [fa63725a85] part of check-in [ef08ecceb7] Update the sqlite3ota_db() API to account for the fact that each OTA handle now uses two SQLite database handles. (check-in: [ef08ecceb7] user: dan branch: ota-update, size: 113210) | |
12:22 | [7949ecd5b1] part of check-in [1cb675e539] Improve tests for resuming ota updates following power failures. Fix a problem revealed by the same. (check-in: [1cb675e539] user: dan branch: ota-update, size: 113140) | |
2015-02-21
| ||
20:08 | [3ee4de29a1] part of check-in [6d5ed70d0d] Fix some problems with resuming ota updates if saving the state is interrupted by a power failure or system crash. (check-in: [6d5ed70d0d] user: dan branch: ota-update, size: 113097) | |
2015-02-20
| ||
14:36 | [0cd5505ebd] part of check-in [718fd8b673] Add some missing comments and fix other minor code issues in sqlite3ota.c. (check-in: [718fd8b673] user: dan branch: ota-update, size: 109796) | |
2015-02-19
| ||
19:59 | [692de0a8c4] part of check-in [9c8682d665] Ensure the mutex used to protect the linked list of all main database files opened by a single ota vfs is allocated. (check-in: [9c8682d665] user: dan branch: ota-update, size: 104790) | |
18:06 | [a8e19ef2a2] part of check-in [60e0a46b82] Update various documentation comments in sqlite3ota.c and sqlite3ota.h. (check-in: [60e0a46b82] user: dan branch: ota-update, size: 101552) | |
13:36 | [6c329a3c1f] part of check-in [a3c1bc5d5e] Add tests for a couple of previously untested branches in the ota code. (check-in: [a3c1bc5d5e] user: dan branch: ota-update, size: 96582) | |
2015-02-18
| ||
20:16 | [981bbfae01] part of check-in [2b10c5d2b8] Add ota tests to increase code coverage. Fix some minor issues in error handling within the ota code. (check-in: [2b10c5d2b8] user: dan branch: ota-update, size: 96237) | |
17:40 | [f04e79519f] part of check-in [144bb29ffc] Fix a problem with OTA updates in the presence of database readers. (check-in: [144bb29ffc] user: dan branch: ota-update, size: 96323) | |
2015-02-17
| ||
20:49 | [0c6cb4cea1] part of check-in [a438fa6c9a] Improve test coverage of ota code a bit. (check-in: [a438fa6c9a] user: dan branch: ota-update, size: 95266) | |
2015-02-16
| ||
21:13 | [f378ebb435] part of check-in [e0b7151962] Add extra tests and fixes for ota. (check-in: [e0b7151962] user: dan branch: ota-update, size: 94734) | |
11:48 | [f2ea3fe9d7] part of check-in [62dc1fffc3] Add further tests and fixes for ota. (check-in: [62dc1fffc3] user: dan branch: ota-update, size: 94308) | |
06:27 | [79874bc6f3] part of check-in [f20779a6e8] Move tcl test code from sqlite3ota.c to new file ext/ota/test_ota.c. (check-in: [f20779a6e8] user: dan branch: ota-update, size: 94211) | |
2015-02-14
| ||
18:58 | [0cf2a1b5ac] part of check-in [b64a11a754] Change the way the "incremental checkpoint" function of OTA works in order to reduce the effect on the SQLite core code. (check-in: [b64a11a754] user: dan branch: ota-update, size: 99519) | |
2015-02-11
| ||
17:05 | [466546d41d] part of check-in [71887cd9b3] Merge the ota-update-no-pager_ota_mode branch into this one. (check-in: [71887cd9b3] user: dan branch: ota-update, size: 92967) | |
16:54 | [0ef0f18934] part of check-in [0b63e8dcba] Merge latest trunk changes with this branch. (check-in: [0b63e8dcba] user: dan branch: ota-update-no-pager_ota_mode, size: 93110) | |
16:25 | [7400075206] part of check-in [6fc5d4d26a] Ensure that an error is reported if an attempt is made to update a wal mode database via ota. (check-in: [6fc5d4d26a] user: dan branch: ota-update-no-pager_ota_mode, size: 93003) | |
2015-02-10
| ||
20:00 | [1f96966839] part of check-in [0f152416be] Further tweaks to work with zipvfs. (check-in: [0f152416be] user: dan branch: ota-update-no-pager_ota_mode, size: 92331) | |
17:08 | [c73855939e] part of check-in [e729668168] Add documentation and test cases for sqlite3ota_create_vfs(). Also code to detect errors in zipvfs/ota setup. (check-in: [e729668168] user: dan branch: ota-update-no-pager_ota_mode, size: 92093) | |
2015-02-09
| ||
20:07 | [3d3179fb9b] part of check-in [96443ecb69] Add the sqlite3ota_create_vfs() and sqlite3ota_destroy_vfs() functions. (check-in: [96443ecb69] user: dan branch: ota-update-no-pager_ota_mode, size: 89844) | |
2015-02-07
| ||
20:20 | [a5cea44e3d] part of check-in [7bb633639d] Add comments to explain the role of the ota vfs. (check-in: [7bb633639d] user: dan branch: ota-update-no-pager_ota_mode, size: 88999) | |
19:17 | [7015400382] part of check-in [8ac58e4678] Remove "PRAGMA pager_ota_mode". (check-in: [8ac58e4678] user: dan branch: ota-update-no-pager_ota_mode, size: 87691) | |
2015-02-06
| ||
00:31 | [bf417242a1] part of check-in [7f10a0eaf1] Revise the way that the index structure for a WITHOUT ROWID table is discovered. (check-in: [7f10a0eaf1] user: drh branch: ota-update, size: 70636) | |
2015-02-05
| ||
17:36 | [6f4f4e07d4] part of check-in [74e073dd60] Prevent ota updates from violating NOT NULL constraints. Add a comment to the "limitations" section of sqlite3ota.h saying that CHECK constraints are not enforced. (check-in: [74e073dd60] user: dan branch: ota-update, size: 70113) | |
01:49 | [0721c7dae5] part of check-in [50ecdfc443] Figure out the primary-key type of a table using queries of sqlite_master and the table_info and index_list pragmas, obviating the need for SQLITE_TESTCTRL_TBLTYPE. (check-in: [50ecdfc443] user: drh branch: ota-update, size: 69765) | |
2015-02-04
| ||
19:20 | [41df903106] part of check-in [c4845a3b59] Fix the error messages returned by ota if an update violates a unique constraint. (check-in: [c4845a3b59] user: dan branch: ota-update, size: 65678) | |
16:32 | [8d1f7f1643] part of check-in [1db198ccca] Avoid a linear scan of the entire table when ota updates or deletes a row from a table with an external primary key index. (check-in: [1db198ccca] user: dan branch: ota-update, size: 64918) | |
11:08 | [d8910eb0f8] part of check-in [0d5415f264] Fix a memory leak that could follow an OOM error in ota. (check-in: [0d5415f264] user: dan branch: ota-update, size: 61675) | |
2015-02-03
| ||
18:43 | [de2e605697] part of check-in [a21fefb79a] Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . (check-in: [a21fefb79a] user: dan branch: ota-update, size: 61770) | |
15:56 | [52c91eec41] part of check-in [1c111447a0] Remove "PRAGMA ota_mode". (check-in: [1c111447a0] user: dan branch: ota-update, size: 60250) | |
2015-01-31
| ||
20:42 | [975ccfe032] part of check-in [cdaeab467f] Have ota use imposter tables to write to indexes instead of the sqlite3_index_writer() interface. The error handling in this version is broken in a few small ways. (check-in: [cdaeab467f] user: dan branch: ota-update, size: 58708) | |
2014-12-06
| ||
19:30 | [84cab0f965] part of check-in [ba59a7e2ba] Allow the ota extension to write to tables with no PRIMARY KEY declaration. (check-in: [ba59a7e2ba] user: dan branch: ota-update, size: 53494) | |
2014-11-27
| ||
18:09 | [f1e930690e] part of check-in [ccee999649] Update ota so that the hidden columns of virtual tables may be written. (check-in: [ccee999649] user: dan branch: ota-update, size: 50937) | |
2014-11-22
| ||
09:09 | [accfada2ab] part of check-in [600cefdd4d] Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: [600cefdd4d] user: dan branch: ota-update, size: 49444) | |
2014-11-21
| ||
10:46 | [07ef7b7235] part of check-in [4dfcfe5439] Add support for updating virtual tables via ota. (check-in: [4dfcfe5439] user: dan branch: ota-update, size: 49229) | |
2014-11-20
| ||
19:19 | [edeea10871] part of check-in [c64dcd1788] Add the "ota_delta()" feature for delta-compressed updates. (check-in: [c64dcd1788] user: dan branch: ota-update, size: 47047) | |
17:37 | [2c31a56890] part of check-in [55066a1171] Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. (check-in: [55066a1171] user: dan branch: ota-update, size: 45222) | |
15:11 | [c2b3491395] part of check-in [556c3de53a] Updates to support zipvfs in pass-through mode. (check-in: [556c3de53a] user: dan branch: ota-update, size: 44034) | |
2014-10-22
| ||
15:33 | [c7f8cdf554] part of check-in [ec7321ae48] Add tests to check error handling in OTA. (check-in: [ec7321ae48] user: dan branch: ota-update, size: 43889) | |
2014-10-21
| ||
19:35 | [a8b4fbe223] part of check-in [6fd09854fe] Test that sqlite3ota_open() works with URI paths. Fix some other issues. (check-in: [6fd09854fe] user: dan branch: ota-update, size: 43729) | |
18:09 | [2ae05cfc4e] part of check-in [2402baa002] Add tests for another application writing the database while an ota update is ongoing. (check-in: [2402baa002] user: dan branch: ota-update, size: 43406) | |
2014-10-20
| ||
16:24 | [1b4e4cdb05] part of check-in [0bf1301aac] Have the ota extension perform an incremental checkpoint after generating the wal file. (check-in: [0bf1301aac] user: dan branch: ota-update, size: 43211) | |
2014-09-18
| ||
17:57 | [b22002105b] part of check-in [718da6de87] Update the ota extension to support SQLITE_ENABLE_8_3_NAMES builds. (check-in: [718da6de87] user: dan branch: ota-update, size: 37792) | |
15:57 | [4b7f15662e] part of check-in [0da1862b1b] Remove some c++isms from sqlite3ota.c. (check-in: [0da1862b1b] user: dan branch: ota-update, size: 36489) | |
14:48 | [e5dfb63ac4] part of check-in [e3943fa7bb] Add an API to query an ota handle for the total number of key/value operations performed so far. (check-in: [e3943fa7bb] user: dan branch: ota-update, size: 36467) | |
11:15 | [276c0426e6] part of check-in [7da98ca242] Fix an ota bug causing attempts to write to tables with more than 8 columns to fail. (check-in: [7da98ca242] user: dan branch: ota-update, size: 35963) | |
2014-09-17
| ||
19:05 | [49187d90b4] part of check-in [0126860751] Fix an unintialized variable problem in sqlite3ota.c. (check-in: [0126860751] user: dan branch: ota-update, size: 35964) | |
2014-09-15
| ||
15:22 | [668ed08dd8] part of check-in [79f2418429] Have sqlite3ota.c use grave accents instead of double-quotes to enclose identifiers in generated SQL. To avoid having the SQL engine substitute a literal string if a column reference cannot be resolved. (check-in: [79f2418429] user: dan branch: ota-update, size: 35952) | |
14:54 | [c29b3eb617] part of check-in [473a72d700] Ensure the correct collation sequences are used when sorting data in sqlite3ota.c. (check-in: [473a72d700] user: dan branch: ota-update, size: 35952) | |
2014-09-08
| ||
17:50 | [3697f6db2d] part of check-in [e109b27e4d] Add support for update statements to sqlite3ota.c. (check-in: [e109b27e4d] user: dan branch: ota-update, size: 34046) | |
2014-09-06
| ||
20:19 | [ceb0f77dc6] part of check-in [f988234ba5] Add support for delete operations to the ota extension. (check-in: [f988234ba5] user: dan branch: ota-update, size: 30937) | |
2014-09-05
| ||
19:52 | [3ddf5f8122] part of check-in [3c2f4a0781] Switch back to using a single database connection in sqlite3ota.c. (check-in: [3c2f4a0781] user: dan branch: ota-update, size: 25390) | |
19:31 | [c400c9e9ef] part of check-in [98387f0569] Reorganize the code in sqlite3ota.c in preparation for adding support for update and delete operations. (check-in: [98387f0569] user: dan branch: ota-update, size: 25352) | |
2014-09-03
| ||
19:30 | [3e05e3fa57] part of check-in [209f672e58] Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. (check-in: [209f672e58] user: dan branch: ota-update, size: 24223) | |
2014-09-02
| ||
19:59 | Added: [ad55821883] part of check-in [2954ab5010] Add an experimental extension for applying bulk updates to databases. (check-in: [2954ab5010] user: dan branch: ota-update, size: 22619) | |