Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
94 check-ins using file src/func.c version cffa6edb4a
|
2023-07-25
| ||
| 16:48 | Add extra test for 'deletemerge'. (check-in: bc33cff420 user: dan tags: fts5-contentless-delete) | |
| 15:48 | Change the name of the fts5 'delete-automerge' option to 'deletemerge'. And add tests for it. (check-in: 1079300db2 user: dan tags: fts5-contentless-delete) | |
| 13:53 | Further tests for 'delete-automerge'. (check-in: ca26c7a37a user: dan tags: fts5-contentless-delete) | |
|
2023-07-24
| ||
| 19:13 | Add the fts5 'delete-automerge' integer option. A level is eligible for auto-merging if it has a greater than or equal percentage of its entries deleted by tombstones than the 'delete-automerge' option. Default value is 10. (check-in: b314be66b9 user: dan tags: fts5-contentless-delete) | |
|
2023-07-22
| ||
| 19:47 | Integrate contentless delete with auto-merge. (check-in: 85c1589ab1 user: dan tags: fts5-contentless-delete) | |
|
2023-07-21
| ||
| 21:10 | Fix fts5 incremental optimization so that it too can handle an index that consists of a single segment with one or more tombstone hash pages. (check-in: e61c9b083f user: dan tags: fts5-contentless-delete) | |
| 19:33 | Ensure the fts5 'optimize' command correctly rewrites any index that consists of a single segment and one or more tombstone hash pages. (check-in: f4926006b3 user: dan tags: fts5-contentless-delete) | |
| 10:51 | Minor internal cleanups in the opfs-sahpool VFS. (Closed-Leaf check-in: 74ad31e290 user: stephan tags: opfs-sahpool) | |
| 09:10 | Internal cleanups in the async part of the JS library bootstrap phase. (check-in: b6d57ab637 user: stephan tags: opfs-sahpool) | |
|
2023-07-20
| ||
| 23:25 | Minor internal cleanups in JS code. (check-in: 21a2ca9fc4 user: stephan tags: opfs-sahpool) | |
| 20:29 | Fix some divide-by-zero errors that could occur when handling corrupt tombstone hash records. (check-in: 7567ca0676 user: dan tags: fts5-contentless-delete) | |
| 20:09 | Avoid an infinite loop that could be entered when dealing with corrupt fts5 tombstone hash pages. (check-in: 69ce2ce035 user: dan tags: fts5-contentless-delete) | |
| 16:07 | Add tests and fixes for the new code on this branch. (check-in: 5aac50e92e user: dan tags: fts5-contentless-delete) | |
| 09:06 | Filter the OPFS VFSes out of the sqlite3-node.mjs build. Add another level of subdirectory to the sahpool to later enable transparent support of client-provided files under the VFS's root dir. Rework the awkward sahpool-via-oo1 mapping. (check-in: 080a4d0aba user: stephan tags: opfs-sahpool) | |
|
2023-07-19
| ||
| 18:47 | Fix various issues with code added to this branch. (check-in: 8d09011fa2 user: dan tags: fts5-contentless-delete) | |
| 17:47 | More internal refactoring and docs for opfs-sahpool. (check-in: 64ccf6177a user: stephan tags: opfs-sahpool) | |
| 17:46 | Update the development-over-ssh docs for the wasm build. (check-in: 500109bd0a user: stephan tags: opfs-sahpool) | |
| 13:31 | Major restructuring of opfs-sahpool to improve maintainability and hopefully make it easier to reuse these pieces in the upcoming JSPI-based VFS experiment. (check-in: 534481cd0c user: stephan tags: opfs-sahpool) | |
| 11:33 | Appearance and legibility improvements for tester1.js. (check-in: 4fd3ed1b64 user: stephan tags: opfs-sahpool) | |
| 08:18 | Internal refactoring in opfs-sahpool. Move OPFS tests to the end of tester1.c-cpp.js. (check-in: 6bd5a7413d user: stephan tags: opfs-sahpool) | |
|
2023-07-18
| ||
| 21:06 | Do not use the viewscan optimization on a query that has only a single loop, as the cost adjustments can cause problems for outer queries. Proposed fix for the performance regression reported by forum post 64d36440e473516c. (check-in: 76152ad2ff user: drh tags: trunk) | |
| 20:41 | Improved ".wheretrace" for the VIEWSCAN optimization. (check-in: 27057ea76b user: drh tags: trunk) | |
| 19:52 | Fix various problems with fts5 contentless_delete=1 tables. (check-in: 0d005112b8 user: dan tags: fts5-contentless-delete) | |
| 19:47 | More opfs-sahpool tests. (check-in: 60713fa9c4 user: stephan tags: opfs-sahpool) | |
| 19:27 | Fix a shadowed var in opfs-sahpool and add more tests. (check-in: 9c8a73aff0 user: stephan tags: opfs-sahpool) | |
| 18:52 | Further refactoring of opfs-sahpool and start integrating it into tester1.c-pp.js. (check-in: 91c7892349 user: stephan tags: opfs-sahpool) | |
| 17:43 | Merge the FTS5 memory leak fix from trunk. (check-in: fb65cb73d7 user: drh tags: fts5-contentless-delete) | |
| 17:29 | Enhance the sqlite3_stmt_explain() interface so that avoids unnecessary reprepare operations. (check-in: 050f773add user: drh tags: sqlite3_stmt_explain) | |
| 16:29 | Fix memory leak in fts5 introduced by [def41225]. (check-in: 4dcad2db74 user: dan tags: trunk) | |
| 16:24 | Major restructuring of the opfs-sahpool bits to better support multiple instances per app (each sandboxed from each other). Eliminate the pesky promise resolution race condition when two such instances are loaded in parallel. (check-in: 95e5fa498f user: stephan tags: opfs-sahpool) | |
| 15:06 | Experimental (untested, non-working) changes that try reduce the number of reprepares generated by sqlite3_stmt_explain(). I think I see an easier way to do this now, so I'm parking this experiment on a branch to pursue the new idea. (Closed-Leaf check-in: c2fba6a632 user: drh tags: sqlite3-stmt-explain-opt1) | |
| 13:55 | Merge trunk changes with this branch. (check-in: 5f66eb4e26 user: dan tags: fts5-contentless-delete) | |
| 13:55 | Fix a buffer overrun in fts5 that could occur in 'secure-delete' mode when dealing with corrupt database records. (check-in: def41225b2 user: dan tags: trunk) | |
| 12:09 | Refactor opfs-sahpool to support multiple instances, each with a separate VFS name and directory. (check-in: d036eaf6ac user: stephan tags: opfs-sahpool) | |
|
2023-07-17
| ||
| 18:40 | Fix cases where a row is inserted into a contentless_delete=1 fts5 table and then deleted within the same transaction. (check-in: d928856a22 user: dan tags: fts5-contentless-delete) | |
| 17:59 | Do not allow the 'delete' command to be used on contentless_delete=1 fts5 tables. (check-in: cc694b8340 user: dan tags: fts5-contentless-delete) | |
| 11:47 | Merge trunk changes into this branch. (check-in: c4fb2f2ea0 user: dan tags: fts5-contentless-delete) | |
| 07:43 | Another -DSQLITE_TEMP_STORE=3 to 2 change for the wasm build. (check-in: 5ad8f9987c user: stephan tags: opfs-sahpool) | |
| 07:14 | sahpool vfs: rename defaultCapacity to initialCapacity, per feedback. (check-in: 2c9c95d087 user: stephan tags: opfs-sahpool) | |
| 07:13 | Change wasm build's -DSQLITE_TEMP_STORE=3 to -DSQLITE_TEMP_STORE=2, primarily so that clients can optionally shift temp files from memory to OPFS storage. (check-in: 764430e804 user: stephan tags: opfs-sahpool) | |
|
2023-07-16
| ||
| 21:07 | Remove an extraneous JS script import. (check-in: 5a205b2591 user: stephan tags: opfs-sahpool) | |
| 20:42 | Add sqlite3-vfs-opfs-sahpool.js to ext/wasm/api/README.md. (check-in: 58d0520104 user: stephan tags: opfs-sahpool) | |
| 20:20 | Minor doc tweaks. (check-in: 0cb0d7a9e7 user: stephan tags: opfs-sahpool) | |
| 19:29 | Correct a missing assignment. Minor doc additions. (check-in: 1c4957d0ef user: stephan tags: opfs-sahpool) | |
| 19:20 | Doc tweaks only, no code changes. (check-in: 044c28dffd user: stephan tags: opfs-sahpool) | |
| 17:51 | Add a way to remove the opfs-sahpool's persistent state from OPFS or unlink() an individual file. Doc cleanups. (check-in: 80982daac3 user: stephan tags: opfs-sahpool) | |
| 16:52 | Move SAH pool configuration options from the library-level config to a config passed to the VFS install routine. Extend and document the PoolUtil object. (check-in: d2ed99556f user: stephan tags: opfs-sahpool) | |
| 14:07 | speedtest1.js: only install opfs-sahpool if it's provided via --vfs flag, to avoid locking errors in concurrent speedtest1 tabs with other VFSes. Add opfs-sahpool reserveMinimumCapacity(). (check-in: aa94c8abfb user: stephan tags: opfs-sahpool) | |
| 12:02 | During "opfs" VFS init, check for URL param opfs-disable and, if set, do not install the VFS. Added per forum suggestion to provide a way to help rule out misinteraction between the "opfs" and "opfs-sahpool" VFSes. (check-in: 29905b7a75 user: stephan tags: opfs-sahpool) | |
| 11:49 | Micro-optimizations in opfs-sahpool. (check-in: 52f23db948 user: stephan tags: opfs-sahpool) | |
| 10:02 | Redefine what the opfs-sahpool installation promise resolves to. Fix addCapacity(). Add utility methods to import/export files. (check-in: 809c6f4de3 user: stephan tags: opfs-sahpool) | |
|
2023-07-15
| ||
| 21:08 | Minor cleanups in the opfs-sahpool VFS. (check-in: 279e090709 user: stephan tags: opfs-sahpool) | |
| 19:08 | Correct opfs-sahpool VFS after the pebkac involving the previous speedtest1 runs. Make that VFS explicitly opt-in to avoid certain unfortunate locking situations. (check-in: 41bf1fe31f user: stephan tags: opfs-sahpool) | |
| 18:57 | Store large tombstone hash tables in multiple database records. Ensure the same hash tables handle rowid 0. (check-in: 4410e60d0c user: dan tags: fts5-contentless-delete) | |
| 16:48 | Add the experimental sqlite3_stmt_explain(S,E) interface. (check-in: 5683743ddf user: drh tags: sqlite3_stmt_explain) | |
| 16:30 | speedtest1 JS: only add --memdb flag by default if no --vfs is provided. (check-in: 676ffe6280 user: stephan tags: opfs-sahpool) | |
| 11:37 | Rename opfs-sahpool removeCapacity() to reduceCapacity(). (check-in: fff68e9f25 user: stephan tags: opfs-sahpool) | |
| 11:23 | opfs-sahpool VFS now seems to work, in that it runs fine (and blazingly fast) in speedtest1. Add sqlite3.config options for the high-level configurable parts of opfs-sahpool. (check-in: 5d92d5f4d8 user: stephan tags: opfs-sahpool) | |
| 01:02 | More work on porting the sahpool bits. Revert to random backing-store names because it works better with the capacity-reduction algorithm. (check-in: b4e005fd38 user: stephan tags: opfs-sahpool) | |
|
2023-07-14
| ||
| 23:02 | Switch opfs-sahpool to use deterministic backing-store file names. Delay VFS registration until after the pool's files are all opened. Fail vfs init if the client's OPFS API has an async FileSystemSyncAccessHandle.close() method (indicating that it's outdated). (check-in: 7c6697eded user: stephan tags: opfs-sahpool) | |
| 21:48 | Integrate the opfs-sahpool VFS into the JS build and get it loading (but it's still far from functional). (check-in: ef96e6b586 user: stephan tags: opfs-sahpool) | |
| 21:17 | Initial sketches for an alternate OPFS VFS which uses a pool of pre-opened SyncAccessHandles to bypass the need for a dedicated I/O worker and the COOP/COEP HTTP response headers. Currently completely non-functional. (check-in: a93de9f2a5 user: stephan tags: opfs-sahpool) | |
| 21:06 | Minor internal cleanups in the OPFS VFS. (check-in: 984d491eb3 user: stephan tags: trunk) | |
| 12:21 | Minor wasm build cleanups. (check-in: 816b503f09 user: stephan tags: trunk) | |
|
2023-07-13
| ||
| 18:35 | Reintroduce WASMFS+OPFS support, albeit as a separate (less portable) WASM build. (check-in: 7e4c594e95 user: stephan tags: trunk) | |
| 18:13 | Minor cleanups related to reintroducing wasmfs support. (Closed-Leaf check-in: 6918a927b5 user: stephan tags: wasmfs-2023) | |
| 17:27 | More work on the wasmfs build and its test apps. (check-in: 953b855719 user: stephan tags: wasmfs-2023) | |
| 16:33 | Get speedtest1 wasmfs variant running again. (check-in: 0f77e031da user: stephan tags: wasmfs-2023) | |
| 14:49 | Fix an off-by-one error in tests for cells overflowing the end of pages. The error is completely harmless for the default page cache, but might cause false-positive SQLITE_CORRUPT errors in systems that use an application-defined page caches that pack pages tightly together in memory. (check-in: ce6793e954 user: drh tags: trunk) | |
| 14:08 | Significant surgery on the wasm build on the way to incorporating wasmfs as a first-class build option. (check-in: 215c37fce3 user: stephan tags: wasmfs-2023) | |
| 10:41 | More work on the wasmfs build. Resolve the inconsistent argument type passed to sqlite3InitModule() in such builds. (check-in: 4850a9e2d2 user: stephan tags: wasmfs-2023) | |
| 04:54 | Minor cleanups in the wasmfs build. (check-in: f64477f210 user: stephan tags: wasmfs-2023) | |
| 04:26 | Get wasmfs build and its bare-bones test app working again, albeit currently in ES6 mode only. (check-in: 647761ed42 user: stephan tags: wasmfs-2023) | |
| 03:46 | Replace 'self' with 'globalThis' in some JS test code. (check-in: 53eeffc9b1 user: stephan tags: trunk) | |
| 01:51 | JS: change the default OPFS VFS journal mode from PERSIST to DELETE, as DELETE is faster in current browsers. (check-in: a061a43e36 user: stephan tags: trunk) | |
| 01:48 | Remove obsolete ext/wasm/api/sqlite3-wasi.h. (check-in: f661a6e0c1 user: stephan tags: trunk) | |
|
2023-07-12
| ||
| 20:24 | Avoid a case of an infinite loop in fts5 when dealing with corrupt records. (check-in: 0e801f11cd user: dan tags: fts5-contentless-delete) | |
| 19:34 | Fix a crash that may occur when handling corrupt records in contentless_delete=1 mode. (check-in: 74d7610a8e user: dan tags: fts5-contentless-delete) | |
| 18:38 | Get access to SQL functions and virtual tables used for debugging and analysis of FTS5 using SQLITE_FTS5_DEBUG and without the need for SQLITE_TEST. (check-in: 383de8e225 user: drh tags: fts5-contentless-delete) | |
| 09:30 | Internal JS doc fix. (check-in: 7c5ea02205 user: stephan tags: trunk) | |
| 09:16 | Correct handling of the speedtest1 --without-rowid flag in the HTML front-end to speedtest1.wasm. Reduce default speedtest1-with-OPFS workload size in ext/wasm/index.html to speed up manual testing. (check-in: 2daba2cdd3 user: stephan tags: trunk) | |
|
2023-07-11
| ||
| 20:57 | Have contentless_delete=1 tables support REPLACE statements. (check-in: 2f553a660e user: dan tags: fts5-contentless-delete) | |
| 20:19 | Have contentless_delete=1 tables support regular DELETE statements, instead of just the special INSERT syntax. (check-in: fffb861690 user: dan tags: fts5-contentless-delete) | |
| 19:54 | Reduce divergence between branches: trunk and wal-shm-exceptions. (check-in: d38ed6b1fc user: drh tags: trunk) | |
| 18:55 | Use a hash-table instead of a flat list to store tombstone rowids. (check-in: 948267b066 user: dan tags: fts5-contentless-delete) | |
| 15:52 | Get fault injection for testing working correctly. Other code clean-up. (check-in: ff492277ed user: drh tags: wal-shm-exceptions) | |
|
2023-07-10
| ||
| 20:44 | Begin adding support for deleting rows from contentless fts5 tables. (check-in: e513bea84d user: dan tags: fts5-contentless-delete) | |
| 19:21 | Minor style changes to the previous MSVC makefile changes on this branch. (check-in: 4c950872c8 user: mistachkin tags: wal-shm-exceptions) | |
| 19:13 | Compile for SEH if the USE_SEH=1 option is specified on the nmake command line. (check-in: 0e67a82f6c user: drh tags: wal-shm-exceptions) | |
| 18:16 | Fix a warning. Unclear yet if the code is correct this way or not. (check-in: 2df4fd76ef user: drh tags: wal-shm-exceptions) | |
| 18:05 | Merge the latest trunk enhancements into the wal-shm-exceptions branch. (check-in: f655d08d01 user: drh tags: wal-shm-exceptions) | |
|
2023-07-08
| ||
| 19:28 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 7a9cb6f4f4 user: drh tags: reuse-schema) | |
| 19:09 | Merge all the latest trunk enhancements into the wal2 branch. (check-in: f07936535f user: drh tags: wal2) | |
| 17:42 | Always use the "LL" suffix on 64-bit integer literals. (check-in: 07d95ed60f user: drh tags: trunk) | |