/ History for ext/ota/sqlite3ota.c
Login

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

History for ext/ota/sqlite3ota.c

2015-06-29
15:41
[21575d86] part of check-in [6aaaec6e] Fix minor problems in the ota demo application. (check-in: [6aaaec6e] user: dan branch: trunk, size: 118598)
2015-05-19
17:48
[2246b779] part of check-in [c74e0bc4] Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. (check-in: [c74e0bc4] user: dan branch: trunk, size: 118554)
16:22
[89530008] part of check-in [5af8db56] Allow OTA update state data to be stored in a database separate from the OTA update database. (check-in: [5af8db56] user: dan branch: ota-update, size: 118841)
2015-04-23
19:18
[5bfd677b] part of check-in [fa62093b] Fix a performance problem in calls to sqlite3ota_close() made after the OTA update has been completely applied and checkpointed. (check-in: [fa62093b] user: dan branch: ota-update, size: 117880)
18:14
[3b531971] part of check-in [baee3556] 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: [baee3556] user: dan branch: ota-update, size: 117871)
2015-04-17
17:00
[b45d7360] part of check-in [66eff473] Ensure that filenames passed to the VFS xOpen() function are terminated by 2 '\0' bytes. (check-in: [66eff473] user: dan branch: ota-update, size: 116639)
16:29
[7a2a9f20] part of check-in [c3dc15e7] Fix a memory leak in sqlite3ota.c that can follow an OOM error. (check-in: [c3dc15e7] user: dan branch: ota-update, size: 116216)
08:36
[725e87f0] part of check-in [0d0e5ec0] Have OTA always specify SQLITE_CONFIG_URI when opening databases. Fix a test issue causing otacrash.test to fail. (check-in: [0d0e5ec0] user: dan branch: ota-update, size: 116178)
2015-04-16
18:49
[424d4b9a] part of check-in [d0fba72a] Be sure to release any xShmLock locks held when closing an OTA handle. (check-in: [d0fba72a] user: dan branch: ota-update, size: 116164)
14:33
[876445eb] part of check-in [5db810a8] Fix a mismatched printf() argument and format specifier. Add ota files to Makefile.in. (check-in: [5db810a8] user: dan branch: ota-update, size: 115707)
10:55
[8c0d3048] part of check-in [658c3b0c] Avoid attempting to rename the *-oal file while it is still open. (check-in: [658c3b0c] user: dan branch: ota-update, size: 115709)
2015-03-24
18:03
[9c16cd3b] part of check-in [6326fd32] 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: [6326fd32] user: dan branch: ota-update, size: 115628)
2015-03-23
17:10
[1d3b605c] part of check-in [858de8a5] Fix a broken assert() in the ota module. (check-in: [858de8a5] user: dan branch: ota-update, size: 113879)
2015-03-05
16:21
[252a5957] part of check-in [46119e8d] 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: [46119e8d] user: dan branch: ota-update, size: 113844)
2015-02-23
20:09
[f0ee6872] part of check-in [d6d21ff5] Fix building with ENABLE_OTA and OMIT_LOAD_EXTENSION. (check-in: [d6d21ff5] user: dan branch: ota-update, size: 113268)
15:41
[e060a4cb] part of check-in [f7865b94] Change SQLITE_FCNTL_ZIPVFS_PAGER to SQLITE_FCNTL_ZIPVFS. (check-in: [f7865b94] user: dan branch: ota-update, size: 113204)
15:02
[fa63725a] part of check-in [ef08ecce] Update the sqlite3ota_db() API to account for the fact that each OTA handle now uses two SQLite database handles. (check-in: [ef08ecce] user: dan branch: ota-update, size: 113210)
12:22
[7949ecd5] part of check-in [1cb675e5] Improve tests for resuming ota updates following power failures. Fix a problem revealed by the same. (check-in: [1cb675e5] user: dan branch: ota-update, size: 113140)
2015-02-21
20:08
[3ee4de29] part of check-in [6d5ed70d] Fix some problems with resuming ota updates if saving the state is interrupted by a power failure or system crash. (check-in: [6d5ed70d] user: dan branch: ota-update, size: 113097)
2015-02-20
14:36
[0cd5505e] part of check-in [718fd8b6] Add some missing comments and fix other minor code issues in sqlite3ota.c. (check-in: [718fd8b6] user: dan branch: ota-update, size: 109796)
2015-02-19
19:59
[692de0a8] part of check-in [9c8682d6] Ensure the mutex used to protect the linked list of all main database files opened by a single ota vfs is allocated. (check-in: [9c8682d6] user: dan branch: ota-update, size: 104790)
18:06
[a8e19ef2] part of check-in [60e0a46b] Update various documentation comments in sqlite3ota.c and sqlite3ota.h. (check-in: [60e0a46b] user: dan branch: ota-update, size: 101552)
13:36
[6c329a3c] part of check-in [a3c1bc5d] Add tests for a couple of previously untested branches in the ota code. (check-in: [a3c1bc5d] user: dan branch: ota-update, size: 96582)
2015-02-18
20:16
[981bbfae] part of check-in [2b10c5d2] Add ota tests to increase code coverage. Fix some minor issues in error handling within the ota code. (check-in: [2b10c5d2] user: dan branch: ota-update, size: 96237)
17:40
[f04e7951] part of check-in [144bb29f] Fix a problem with OTA updates in the presence of database readers. (check-in: [144bb29f] user: dan branch: ota-update, size: 96323)
2015-02-17
20:49
[0c6cb4ce] part of check-in [a438fa6c] Improve test coverage of ota code a bit. (check-in: [a438fa6c] user: dan branch: ota-update, size: 95266)
2015-02-16
21:13
[f378ebb4] part of check-in [e0b71519] Add extra tests and fixes for ota. (check-in: [e0b71519] user: dan branch: ota-update, size: 94734)
11:48
[f2ea3fe9] part of check-in [62dc1fff] Add further tests and fixes for ota. (check-in: [62dc1fff] user: dan branch: ota-update, size: 94308)
06:27
[79874bc6] part of check-in [f20779a6] Move tcl test code from sqlite3ota.c to new file ext/ota/test_ota.c. (check-in: [f20779a6] user: dan branch: ota-update, size: 94211)
2015-02-14
18:58
[0cf2a1b5] part of check-in [b64a11a7] Change the way the "incremental checkpoint" function of OTA works in order to reduce the effect on the SQLite core code. (check-in: [b64a11a7] user: dan branch: ota-update, size: 99519)
2015-02-11
17:05
[466546d4] part of check-in [71887cd9] Merge the ota-update-no-pager_ota_mode branch into this one. (check-in: [71887cd9] user: dan branch: ota-update, size: 92967)
16:54
[0ef0f189] part of check-in [0b63e8dc] Merge latest trunk changes with this branch. (check-in: [0b63e8dc] user: dan branch: ota-update-no-pager_ota_mode, size: 93110)
16:25
[74000752] part of check-in [6fc5d4d2] Ensure that an error is reported if an attempt is made to update a wal mode database via ota. (check-in: [6fc5d4d2] user: dan branch: ota-update-no-pager_ota_mode, size: 93003)
2015-02-10
20:00
[1f969668] part of check-in [0f152416] Further tweaks to work with zipvfs. (check-in: [0f152416] user: dan branch: ota-update-no-pager_ota_mode, size: 92331)
17:08
[c7385593] part of check-in [e7296681] Add documentation and test cases for sqlite3ota_create_vfs(). Also code to detect errors in zipvfs/ota setup. (check-in: [e7296681] user: dan branch: ota-update-no-pager_ota_mode, size: 92093)
2015-02-09
20:07
[3d3179fb] part of check-in [96443ecb] Add the sqlite3ota_create_vfs() and sqlite3ota_destroy_vfs() functions. (check-in: [96443ecb] user: dan branch: ota-update-no-pager_ota_mode, size: 89844)
2015-02-07
20:20
[a5cea44e] part of check-in [7bb63363] Add comments to explain the role of the ota vfs. (check-in: [7bb63363] user: dan branch: ota-update-no-pager_ota_mode, size: 88999)
19:17
[70154003] part of check-in [8ac58e46] Remove "PRAGMA pager_ota_mode". (check-in: [8ac58e46] user: dan branch: ota-update-no-pager_ota_mode, size: 87691)
2015-02-06
00:31
[bf417242] part of check-in [7f10a0ea] Revise the way that the index structure for a WITHOUT ROWID table is discovered. (check-in: [7f10a0ea] user: drh branch: ota-update, size: 70636)
2015-02-05
17:36
[6f4f4e07] part of check-in [74e073dd] 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: [74e073dd] user: dan branch: ota-update, size: 70113)
01:49
[0721c7da] part of check-in [50ecdfc4] 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: [50ecdfc4] user: drh branch: ota-update, size: 69765)
2015-02-04
19:20
[41df9031] part of check-in [c4845a3b] Fix the error messages returned by ota if an update violates a unique constraint. (check-in: [c4845a3b] user: dan branch: ota-update, size: 65678)
16:32
[8d1f7f16] part of check-in [1db198cc] 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: [1db198cc] user: dan branch: ota-update, size: 64918)
11:08
[d8910eb0] part of check-in [0d5415f2] Fix a memory leak that could follow an OOM error in ota. (check-in: [0d5415f2] user: dan branch: ota-update, size: 61675)
2015-02-03
18:43
[de2e6056] part of check-in [a21fefb7] Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . (check-in: [a21fefb7] user: dan branch: ota-update, size: 61770)
15:56
[52c91eec] part of check-in [1c111447] Remove "PRAGMA ota_mode". (check-in: [1c111447] user: dan branch: ota-update, size: 60250)
2015-01-31
20:42
[975ccfe0] part of check-in [cdaeab46] 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: [cdaeab46] user: dan branch: ota-update, size: 58708)
2014-12-06
19:30
[84cab0f9] part of check-in [ba59a7e2] Allow the ota extension to write to tables with no PRIMARY KEY declaration. (check-in: [ba59a7e2] user: dan branch: ota-update, size: 53494)
2014-11-27
18:09
[f1e93069] part of check-in [ccee9996] Update ota so that the hidden columns of virtual tables may be written. (check-in: [ccee9996] user: dan branch: ota-update, size: 50937)
2014-11-22
09:09
[accfada2] part of check-in [600cefdd] Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: [600cefdd] user: dan branch: ota-update, size: 49444)
2014-11-21
10:46
[07ef7b72] part of check-in [4dfcfe54] Add support for updating virtual tables via ota. (check-in: [4dfcfe54] user: dan branch: ota-update, size: 49229)
2014-11-20
19:19
[edeea108] part of check-in [c64dcd17] Add the "ota_delta()" feature for delta-compressed updates. (check-in: [c64dcd17] user: dan branch: ota-update, size: 47047)
17:37
[2c31a568] part of check-in [55066a11] Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. (check-in: [55066a11] user: dan branch: ota-update, size: 45222)
15:11
[c2b34913] part of check-in [556c3de5] Updates to support zipvfs in pass-through mode. (check-in: [556c3de5] user: dan branch: ota-update, size: 44034)
2014-10-22
15:33
[c7f8cdf5] part of check-in [ec7321ae] Add tests to check error handling in OTA. (check-in: [ec7321ae] user: dan branch: ota-update, size: 43889)
2014-10-21
19:35
[a8b4fbe2] part of check-in [6fd09854] Test that sqlite3ota_open() works with URI paths. Fix some other issues. (check-in: [6fd09854] user: dan branch: ota-update, size: 43729)
18:09
[2ae05cfc] part of check-in [2402baa0] Add tests for another application writing the database while an ota update is ongoing. (check-in: [2402baa0] user: dan branch: ota-update, size: 43406)
2014-10-20
16:24
[1b4e4cdb] part of check-in [0bf1301a] Have the ota extension perform an incremental checkpoint after generating the wal file. (check-in: [0bf1301a] user: dan branch: ota-update, size: 43211)
2014-09-18
17:57
[b2200210] part of check-in [718da6de] Update the ota extension to support SQLITE_ENABLE_8_3_NAMES builds. (check-in: [718da6de] user: dan branch: ota-update, size: 37792)
15:57
[4b7f1566] part of check-in [0da1862b] Remove some c++isms from sqlite3ota.c. (check-in: [0da1862b] user: dan branch: ota-update, size: 36489)
14:48
[e5dfb63a] part of check-in [e3943fa7] Add an API to query an ota handle for the total number of key/value operations performed so far. (check-in: [e3943fa7] user: dan branch: ota-update, size: 36467)
11:15
[276c0426] part of check-in [7da98ca2] Fix an ota bug causing attempts to write to tables with more than 8 columns to fail. (check-in: [7da98ca2] user: dan branch: ota-update, size: 35963)
2014-09-17
19:05
[49187d90] part of check-in [01268607] Fix an unintialized variable problem in sqlite3ota.c. (check-in: [01268607] user: dan branch: ota-update, size: 35964)
2014-09-15
15:22
[668ed08d] part of check-in [79f24184] 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: [79f24184] user: dan branch: ota-update, size: 35952)
14:54
[c29b3eb6] part of check-in [473a72d7] Ensure the correct collation sequences are used when sorting data in sqlite3ota.c. (check-in: [473a72d7] user: dan branch: ota-update, size: 35952)
2014-09-08
17:50
[3697f6db] part of check-in [e109b27e] Add support for update statements to sqlite3ota.c. (check-in: [e109b27e] user: dan branch: ota-update, size: 34046)
2014-09-06
20:19
[ceb0f77d] part of check-in [f988234b] Add support for delete operations to the ota extension. (check-in: [f988234b] user: dan branch: ota-update, size: 30937)
2014-09-05
19:52
[3ddf5f81] part of check-in [3c2f4a07] Switch back to using a single database connection in sqlite3ota.c. (check-in: [3c2f4a07] user: dan branch: ota-update, size: 25390)
19:31
[c400c9e9] part of check-in [98387f05] Reorganize the code in sqlite3ota.c in preparation for adding support for update and delete operations. (check-in: [98387f05] user: dan branch: ota-update, size: 25352)
2014-09-03
19:30
[3e05e3fa] part of check-in [209f672e] 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: [209f672e] user: dan branch: ota-update, size: 24223)
2014-09-02
19:59
[ad558218] part of check-in [2954ab50] Add an experimental extension for applying bulk updates to databases. (check-in: [2954ab50] user: dan branch: ota-update, size: 22619) Added