/ Timeline
Login

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

100 most recent check-ins that include changes to files matching 'ext/ota/*'

2015-07-27
10:46
Merge latest trunk changes with this branch. check-in: 5ec933c2 user: dan tags: fts5-btree-index
2015-07-23
21:59
Merge all changes in the latest 3.8.11 beta into the sessions branch. Changes include the rename of OTA to RBU, the WITHOUT-ROWID-OR-Skipscan fix, and improvements to pcache1. check-in: 7f0ee770 user: drh tags: sessions
20:44
Change the name of the OTA extension to RBU: Resumable Bulk Update. check-in: 017c5019 user: drh tags: trunk
2015-07-14
22:43
Amplify the comment on renderLogMsg() that explains the problems associated with calling sqlite3_log() from deep within the memory allocator. check-in: a73d7128 user: drh tags: trunk
15:39
Merge trunk changes, including the addition of FTS5 and pcache1 performance enhancements. check-in: db4cbefb user: drh tags: sessions
2015-07-07
19:07
Add a test case to verify that "PRAGMA data_version" works as expected when an OTA client writes to the database. check-in: 6441f2dc user: dan tags: trunk
2015-06-30
16:29
Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. check-in: 39936b33 user: drh tags: sessions
2015-06-29
15:41
Fix minor problems in the ota demo application. check-in: 6aaaec6e user: dan tags: trunk
2015-06-02
18:07
Merge latest trunk changes with this branch. check-in: c9ffda4a user: dan tags: fts5
2015-05-19
22:42
Merge recent trunk changes, include the R-Tree enhancement that allows 8-byte BLOB arguments to geometry functions, and the fix for the TEXT affinity problem that could cause corrupt indexes. check-in: 0a0de8b7 user: drh tags: sessions
17:48
Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. check-in: c74e0bc4 user: dan tags: trunk
16:50
Merge the ota-update branch with trunk. check-in: 08e2864e user: dan tags: trunk
16:22
Allow OTA update state data to be stored in a database separate from the OTA update database. check-in: 5af8db56 user: dan tags: ota-update
2015-04-23
19:38
Fix a problem in the "ota" utility program causing it to crash if SQLite failed to open the target database. check-in: a1a2b4a2 user: dan tags: ota-update
19:18
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 tags: ota-update
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. check-in: baee3556 user: dan tags: ota-update
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
16:29
Fix a memory leak in sqlite3ota.c that can follow an OOM error. check-in: c3dc15e7 user: dan tags: ota-update
08:36
Have OTA always specify SQLITE_CONFIG_URI when opening databases. Fix a test issue causing otacrash.test to fail. check-in: 0d0e5ec0 user: dan tags: ota-update
2015-04-16
18:49
Be sure to release any xShmLock locks held when closing an OTA handle. check-in: d0fba72a user: dan tags: ota-update
14:33
Fix a mismatched printf() argument and format specifier. Add ota files to Makefile.in. check-in: 5db810a8 user: dan tags: ota-update
10:55
Avoid attempting to rename the *-oal file while it is still open. check-in: 658c3b0c user: dan tags: ota-update
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. check-in: 6326fd32 user: dan tags: ota-update
2015-03-23
17:10
Fix a broken assert() in the ota module. check-in: 858de8a5 user: dan tags: ota-update
2015-03-18
20:03
Allow whereShortCut() to use the PRIMARY KEY index of a WITHOUT ROWID table to optimize a vector of "IS" operators in a WHERE clause. check-in: 52e73eec user: dan tags: ota-update
19:04
Clarify that OTA is unable to update or delete rows with NULL values in primary key fields. check-in: 2e7c1e0a user: dan tags: ota-update
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. check-in: 46119e8d user: dan tags: ota-update
14:07
Add comments to sqlite3ota.h to make it clear that passing NULL in place of a parent VFS name to sqlite3ota_create_vfs() causes the new VFS to use the system default as its parent. check-in: 158c1a48 user: dan tags: ota-update
13:43
Fix a typo in sqlite3ota.h. check-in: 04087dec user: dan tags: ota-update
2015-02-23
20:09
Fix building with ENABLE_OTA and OMIT_LOAD_EXTENSION. check-in: d6d21ff5 user: dan tags: ota-update
15:41
Change SQLITE_FCNTL_ZIPVFS_PAGER to SQLITE_FCNTL_ZIPVFS. check-in: f7865b94 user: dan tags: ota-update
15:02
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 tags: ota-update
12:22
Improve tests for resuming ota updates following power failures. Fix a problem revealed by the same. check-in: 1cb675e5 user: dan tags: ota-update
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. check-in: 6d5ed70d user: dan tags: ota-update
2015-02-20
14:36
Add some missing comments and fix other minor code issues in sqlite3ota.c. check-in: 718fd8b6 user: dan tags: ota-update
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. check-in: 9c8682d6 user: dan tags: ota-update
18:06
Update various documentation comments in sqlite3ota.c and sqlite3ota.h. check-in: 60e0a46b user: dan tags: ota-update
13:36
Add tests for a couple of previously untested branches in the ota code. check-in: a3c1bc5d user: dan tags: ota-update
2015-02-18
20:17
Add new file ota12.test, containing tests for applying ota updates to live databases with other active reader/writer clients. check-in: 0864d127 user: dan tags: ota-update
20:16
Add ota tests to increase code coverage. Fix some minor issues in error handling within the ota code. check-in: 2b10c5d2 user: dan tags: ota-update
17:40
Fix a problem with OTA updates in the presence of database readers. check-in: 144bb29f user: dan tags: ota-update
2015-02-17
20:49
Improve test coverage of ota code a bit. check-in: a438fa6c user: dan tags: ota-update
2015-02-16
21:13
Add extra tests and fixes for ota. check-in: e0b71519 user: dan tags: ota-update
11:48
Add further tests and fixes for ota. check-in: 62dc1fff user: dan tags: ota-update
06:27
Move tcl test code from sqlite3ota.c to new file ext/ota/test_ota.c. check-in: f20779a6 user: dan tags: ota-update
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. check-in: b64a11a7 user: dan tags: ota-update
2015-02-11
17:05
Merge the ota-update-no-pager_ota_mode branch into this one. check-in: 71887cd9 user: dan tags: ota-update
16:54
Merge latest trunk changes with this branch. Closed-Leaf check-in: 0b63e8dc user: dan tags: ota-update-no-pager_ota_mode
16:25
Ensure that an error is reported if an attempt is made to update a wal mode database via ota. check-in: 6fc5d4d2 user: dan tags: ota-update-no-pager_ota_mode
2015-02-10
20:00
Further tweaks to work with zipvfs. check-in: 0f152416 user: dan tags: ota-update-no-pager_ota_mode
17:08
Add documentation and test cases for sqlite3ota_create_vfs(). Also code to detect errors in zipvfs/ota setup. check-in: e7296681 user: dan tags: ota-update-no-pager_ota_mode
2015-02-09
20:07
Add the sqlite3ota_create_vfs() and sqlite3ota_destroy_vfs() functions. check-in: 96443ecb user: dan tags: ota-update-no-pager_ota_mode
2015-02-07
20:20
Add comments to explain the role of the ota vfs. check-in: 7bb63363 user: dan tags: ota-update-no-pager_ota_mode
19:17
Remove "PRAGMA pager_ota_mode". check-in: 8ac58e46 user: dan tags: ota-update-no-pager_ota_mode
2015-02-06
00:31
Revise the way that the index structure for a WITHOUT ROWID table is discovered. check-in: 7f10a0ea user: drh tags: ota-update
2015-02-05
17:46
Change a comment in sqlite3ota.h to make it clear that it is not possible to insert a NULL value into an INTEGER PRIMARY KEY column using ota. check-in: a5e86bea user: dan tags: ota-update
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. check-in: 74e073dd user: dan tags: ota-update
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. check-in: 50ecdfc4 user: drh tags: ota-update
2015-02-04
19:20
Fix the error messages returned by ota if an update violates a unique constraint. check-in: c4845a3b user: dan tags: ota-update
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. check-in: 1db198cc user: dan tags: ota-update
11:08
Fix a memory leak that could follow an OOM error in ota. check-in: 0d5415f2 user: dan tags: ota-update
2015-02-03
18:43
Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . check-in: a21fefb7 user: dan tags: ota-update
15:56
Remove "PRAGMA ota_mode". check-in: 1c111447 user: dan tags: ota-update
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. check-in: cdaeab46 user: dan tags: ota-update
2015-01-30
16:36
Merge all recent trunk changes, and especially the SQLITE_TESTCTRL_INITMODE enhancement. check-in: 36436dde user: drh tags: ota-update
2014-12-08
07:28
Update comments in sqlite3ota.h to remove the "must have PRIMARY KEY" restriction. check-in: 088a41eb user: dan tags: ota-update
07:22
Extra tests for the ota_rowid column. check-in: 46069393 user: dan tags: ota-update
2014-12-06
19:30
Allow the ota extension to write to tables with no PRIMARY KEY declaration. check-in: ba59a7e2 user: dan tags: ota-update
2014-11-27
18:09
Update ota so that the hidden columns of virtual tables may be written. check-in: ccee9996 user: dan tags: ota-update
2014-11-22
09:09
Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. check-in: 600cefdd user: dan tags: ota-update
2014-11-21
11:22
Changes to comments in sqlite3ota.h. check-in: 14139542 user: dan tags: ota-update
10:46
Add support for updating virtual tables via ota. check-in: 4dfcfe54 user: dan tags: ota-update
2014-11-20
19:19
Add the "ota_delta()" feature for delta-compressed updates. check-in: c64dcd17 user: dan tags: ota-update
17:37
Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. check-in: 55066a11 user: dan tags: ota-update
15:11
Updates to support zipvfs in pass-through mode. check-in: 556c3de5 user: dan tags: ota-update
2014-11-17
18:35
Add tests for WITHOUT ROWID tables with composite primary keys. check-in: 712d413d user: dan tags: ota-update
15:07
Fix a problem with the parameters to an OP_Affinity in one of the VM programs generated by sqlite3_index_writer() that was causing an OOB read. check-in: 447b33b3 user: dan tags: ota-update
2014-10-22
15:33
Add tests to check error handling in OTA. check-in: ec7321ae user: dan tags: ota-update
2014-10-21
19:35
Test that sqlite3ota_open() works with URI paths. Fix some other issues. check-in: 6fd09854 user: dan tags: ota-update
18:09
Add tests for another application writing the database while an ota update is ongoing. check-in: 2402baa0 user: dan tags: ota-update
2014-10-20
16:24
Have the ota extension perform an incremental checkpoint after generating the wal file. check-in: 0bf1301a user: dan tags: ota-update
2014-09-19
18:08
Add further tests to ota5.test. Add "ota.test", for running all ota tests. check-in: 95ffdaa5 user: dan tags: ota-update
15:06
Add extra tests for the ota extension. check-in: 1e468fe1 user: dan tags: ota-update
2014-09-18
17:57
Update the ota extension to support SQLITE_ENABLE_8_3_NAMES builds. check-in: 718da6de user: dan tags: ota-update
16:38
Use quotes instead of angle-brackets to include sqlite3.h from sqlite3ota.h. check-in: fce9c6cc user: dan tags: ota-update
15:57
Remove some c++isms from sqlite3ota.c. check-in: 0da1862b user: dan tags: ota-update
15:22
Add new file ext/ota/README.txt, containing notes regarding the implementation of the ota extension. check-in: 3c6e1cbb user: dan tags: ota-update
14:48
Add an API to query an ota handle for the total number of key/value operations performed so far. check-in: e3943fa7 user: dan tags: ota-update
11:15
Fix an ota bug causing attempts to write to tables with more than 8 columns to fail. check-in: 7da98ca2 user: dan tags: ota-update
2014-09-17
19:05
Fix an unintialized variable problem in sqlite3ota.c. check-in: 01268607 user: dan tags: ota-update
15:20
Add tests and fixes for "PRAGMA ota_mode". check-in: 39df35c4 user: dan tags: ota-update
2014-09-16
20:02
Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. check-in: decaccc3 user: dan tags: ota-update
2014-09-15
19:34
Remove the experimental sqlite3_transaction_save() and restore() APIs. check-in: 48d201cd user: dan tags: ota-update
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. check-in: 79f24184 user: dan tags: ota-update
14:54
Ensure the correct collation sequences are used when sorting data in sqlite3ota.c. check-in: 473a72d7 user: dan tags: ota-update
12:18
Have the sqlite3_index_writer() VMs check that the final values of records inserted into indexes on rowid tables are integers. check-in: cca376bf user: dan tags: ota-update
10:44
Add OP_Affinity opcodes to the VMs generated by sqlite3_index_writer(). check-in: b9b38cb8 user: dan tags: ota-update
2014-09-08
17:50
Add support for update statements to sqlite3ota.c. check-in: e109b27e user: dan tags: ota-update