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