๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. eddfa98 Improvements to the description of the OPFLAG_TYPEOFARG option to OP_Column. by drh ยท 3 years, 2 months ago isnull-opt
  2. bd1c634 Adjust the implementation of sqlite3VdbeTypeofColumn() to make it easier by drh ยท 3 years, 2 months ago
  3. e995d2c Proposed optimization to the IS NULL and NOT NULL operators that avoids by drh ยท 3 years, 2 months ago
  4. 1ffb6be Updates to the fuzzer query invariant checker - tracking changes made by drh ยท 3 years, 2 months ago
  5. 131aa13 Changes to Makefile.msc to fix the build on Windows following the previous by drh ยท 3 years, 2 months ago
  6. c9e992a Merge fiddle-opfs branch into trunk. by stephan ยท 3 years, 2 months ago
  7. 7be51f5 Merge trunk into fiddle-opfs as a preliminary step for a clean merge in the other direction. by stephan ยท 3 years, 2 months ago fiddle-opfs
  8. 402da26 Add initial infrastructure for setting up function/regression tests for the JS/WASM APIs. by stephan ยท 3 years, 2 months ago
  9. b75971e Minor doc cleanups and corrections in sqlite3-wasm.c by stephan ยท 3 years, 2 months ago
  10. 181f7e8 Correct mismatched H1 tags in test code. Minor CSS tweaks. by stephan ยท 3 years, 2 months ago
  11. 47996ea Add the sqlite3_value_encoding() interface. by drh ยท 3 years, 2 months ago
  12. c2777ab Enhance the OP_IsType opcode so that it is slightly smaller and faster and by drh ยท 3 years, 2 months ago
  13. 7d23d15 Improved the ability of the CLI to handle very long input lines. by drh ยท 3 years, 2 months ago
  14. 7747ffb Enhance the "PRAGMA integrity_check" statement so that it verifies datatype by drh ยท 3 years, 2 months ago
  15. c9ef12f Code clean-up for the integrity_check enhancement. by drh ยท 3 years, 2 months ago integrity_check_datatypes
  16. db6940a Fix corner-case bugs in the new integrity_check logic. All tests pass now. by drh ยท 3 years, 2 months ago
  17. 49d77ee An attempt to enhance PRAGMA integrity check so that it does data type by drh ยท 3 years, 2 months ago
  18. 005c9d8 Improved detection of database corrupting when moving pages on an by drh ยท 3 years, 2 months ago
  19. 50661c5 Remove some extraneous debug output. by stephan ยท 3 years, 2 months ago
  20. d8897d9 Remove a now-unnecessary --cachesize flag for the OPFS sqlite3_vfs speedtest1-worker.html invocation. by stephan ยท 3 years, 2 months ago
  21. ff891b4 Minor cleaups in the post-init async phase of sqlite3 module initialization. by stephan ยท 3 years, 2 months ago
  22. 392fd3c Remove ext/wasm/kvvfs.make which was inadvertently resurrected in [92b500da70a3]. by stephan ยท 3 years, 2 months ago
  23. 4fbf90e Refactor kvvfs JS bits to make use of [ea370b9b05f7ed7eaa]. At main-thread startup, if kvvfs is available, replace the kvvfs I/O methods with JS impls. Checkin part 2 of 2, to account for cherrypicking [ea370b9b05f7ed7eaa] into the kv-vfs branch. by stephan ยท 3 years, 2 months ago
  24. d35b558 Refactor os_kv.c so that the kvvfs read/write/delete methods can be swapped out at runtime by JS implementations. This eliminates the kvvfs dependency on Emscripten. Checkin part 1 of 2, to account for cherrypicking. by stephan ยท 3 years, 2 months ago
  25. d655572 Add -DSQLITE_OS_KV_OPTIONAL to speedtest1 flags for kvvfs testing purposes. by stephan ยท 3 years, 2 months ago
  26. 211a1a7 When casting an odd-length BLOB into a TEXT with encoding UTF16, omit the by drh ยท 3 years, 2 months ago
  27. 73c586b Fix a problem causing the seek-scan optimization to skip over valid rows that could occur when it is used with expressions of the form (a IN (?,?..) AND b >= ?). dbsqlfuzz ab1db6dc0efb04cba1cd3431ee6da4894fdc4520. by dan ยท 3 years, 2 months ago
  28. 8a2254f Improved tracing output for showing all registers used by the by drh ยท 3 years, 2 months ago
  29. 73ac958 Fix a problem that occurred when using a bloom filter to optimize an (ipk = ?) lookup in the case where the RHS of the expression is a TEXT value. First reported by [forum:/forumpost/f61a8b7053|forum post f61a8b7053]. by dan ยท 3 years, 2 months ago
  30. 9a55773 Replace time-based auto-unlock of opfs sync handles with lock acquisition/release via sqlite3_io_methods::xLock/xUnlock(). by stephan ยท 3 years, 2 months ago
  31. 2eca061 Attempt to clarify the operation of the xLock and xUnlock VFS I/O methods. by drh ยท 3 years, 2 months ago
  32. ed3182f Tweaks to the opfs async wait/relinquish times. by stephan ยท 3 years, 2 months ago
  33. a4b2f41 Change the name of the autoconf-generated configuration file from "config.h" by drh ยท 3 years, 2 months ago
  34. 98e120f Update ext/wasm/api/README.md to account for recent changes. by stephan ยท 3 years, 2 months ago
  35. c7fb48d OPFS async proxy: add a wait-and-retry policy to the get-sync-handle step to help account for cross-tab locking. by stephan ยท 3 years, 2 months ago
  36. f6b6188 Update the 'start in speedtest kvvfs' link in speedtest1-worker to account for recent changes. by stephan ยท 3 years, 2 months ago
  37. 2716cd2 Minor pstack doc update. by stephan ยท 3 years, 2 months ago
  38. 2b776ee Minor cleanups and additions in sqlite3.capi.wasm.pstack. by stephan ยท 3 years, 2 months ago
  39. 3c272ba Add a test/debug mechanism to shut down the OPFS async listener so that it can be inspected (it normally can't be because its tight event-listening loop ties up the thread) and then restarted. by stephan ยท 3 years, 2 months ago
  40. 88838f6 Set default page cache size to 16mb in wasm builds. Fix an off-by-one counter in sqlite3_wasm_enum_json(). Minor coding style conformance tweaks. by stephan ยท 3 years, 2 months ago
  41. faf6a07 Add a --cachesize flag to the speedtest1-worker-opfs link in index.html because opfs is much faster with that. by stephan ยท 3 years, 2 months ago
  42. 8d9e595 Minor JS doc updates and typo fixes. by stephan ยท 3 years, 2 months ago
  43. d234902 Add configurable cache_size to batch-runner and speedtest1-worker. Add SQL tracing to demo-123.js just for demonstration's sake. by stephan ยท 3 years, 2 months ago
  44. 4b07469 Omit WAL mode from the wasm build. by stephan ยท 3 years, 2 months ago
  45. 16292a5 Adjust the --help output for speedtest1 to clarify that the argument to by drh ยท 3 years, 2 months ago
  46. 277c7d3 Copy all of the fiddle-opfs changes to speedtest1 into trunk. by drh ยท 3 years, 2 months ago
  47. 57956a9 Resolve/remove a TODO. by stephan ยท 3 years, 2 months ago
  48. 3044e77 Add the --vfs option to speedtest1. by drh ยท 3 years, 2 months ago
  49. 4f5bbed Export sqlite3_trace_v2() to wasm and use it to ensure that the new per-VFS post-open SQL support in the DB ctor works. Default opfs vfs to journal_mode=truncate, as it's faster in that mode. Add 't' DB open-mode flag to enable SQL tracing to console.log(). by stephan ยท 3 years, 2 months ago
  50. a4c357f Reimplement fiddle_reset_db() so that it works with all VFSes. by stephan ยท 3 years, 2 months ago
  51. 5f0b67c Experimentally relinquish the OPFS VFS sync access handle when the db is idle and reacquire it on demand, the goal being to help alleviate cross-tab locking issues. by stephan ยท 3 years, 2 months ago
  52. 33ded6e Add journal=MODE to the list of supported URL flags for speedtest1-worker.html. by stephan ยท 3 years, 2 months ago
  53. 7ff8da8 OPFS VFS now lazily opens its sync access handle, as a step towards experimenting with relinquishing it during idle times to help avoid cross-tab and page-reload locking issues. by stephan ยท 3 years, 2 months ago
  54. bdfd7ea Partial revert of [a82e6faaa642] to remove the 'I' alias for 'j' wasm function signature letter. In hindsight, that change seems premature. by stephan ยท 3 years, 2 months ago
  55. ef9cd12 Minor JS API tweaks prompted by documenting them. by stephan ยท 3 years, 2 months ago
  56. 510a9d1 More cleanups in the UDF argument and result handling, in particular int64. Consolidate some duplicate int64/bigint range checking code. Expose the UDF low-level utilities (arg/result conversion) to client code. Add the sqlite3_context pointer to the JS-side UDF wrappers for API consistency. by stephan ยท 3 years, 2 months ago
  57. 65e6522 Minor doc typo fix in sqlite.h.in. by stephan ยท 3 years, 2 months ago
  58. 92ede96 JS: clean up create_function() wrapper and add support for create_window_function(). Eliminate an extraneous blob copy when a UDF returns a blob. Make use of newfound JS-fu to clean up how sqlite3ApiBootstrap() config is initialized. by stephan ยท 3 years, 2 months ago
  59. 9892883 js: implement a hand-written wrapper for sqlite3_create_function_v2() which converts, if necessary, JS-function-type args to WASM function wrappers. Replace DB.createFunction() impl with the new one. by stephan ยท 3 years, 2 months ago
  60. 9fdce59 Doc typo fixes. by stephan ยท 3 years, 2 months ago
  61. 63e9ec2f More fleshing out of sqlite3.capi.wasm.pstack. by stephan ยท 3 years, 2 months ago
  62. 6479c5a Document the roles of the new (this past week) JS files added to the build process. by stephan ยท 3 years, 2 months ago
  63. 193ee11 General internal cleanups in the oo1 API. by stephan ยท 3 years, 2 months ago
  64. 7d34b8d Performance optimization in sqlite3_prepare() (discovered while working by drh ยท 3 years, 2 months ago
  65. f064a3b Correct fiddle db export breakage caused by a post-testing API change made in [1fa019c88dea]. by stephan ยท 3 years, 2 months ago
  66. f446af5 Pedantic constness tweak. by stephan ยท 3 years, 2 months ago
  67. 3afad4d wasm: correct a memleak caused by a shadowed var in the previous checkin. Add a stack-like allocator, sqlite3.capi.wasm.pstack, as a faster way of managing short-lived pointers (like the one which got shadowed). by stephan ยท 3 years, 2 months ago
  68. 3278142 Fiddle: fix makefile dependency issue and duplicate inclusion of post-js.js. Reimplement db export using sqlite3_serialize(). by stephan ยท 3 years, 2 months ago
  69. be9d203 Merge trunk into fiddle-opfs branch. by stephan ยท 3 years, 2 months ago
  70. c9099d2 Tweak sqlite3-worker1.js to be able to load either sqlite3.js or sqlite3-wasmfs.js, noting that the latter still does not load in a Worker because of an Emscripten loader bug. by stephan ยท 3 years, 2 months ago
  71. 7424aef Replace the Parse.disableVtab field with Parse.prepFlags for increased by drh ยท 3 years, 2 months ago
  72. 6167d5c Note two wasm-related potential TODOs. by stephan ยท 3 years, 2 months ago
  73. 8c1a4b8 Remove a couple of weird quirks of the Worker1 and Promiser APIs. The Worker1 (now undocumented) unlink capability needs to be reevaluated to work equivalently for all storage backends. by stephan ยท 3 years, 2 months ago
  74. ae589b6 Tweaks to the Worker1 and Promiser APIs prompted by documenting them. by stephan ยท 3 years, 2 months ago
  75. 7bc6a81 Remove one of the NEVER() macros added by [5166acf3f0040459] because it by drh ยท 3 years, 2 months ago
  76. 1337a22 New test cases in fuzzdata8.db by drh ยท 3 years, 2 months ago
  77. 2d3261f Fix a bug in the demoDelete fix from [d76a301e22e05722]. by drh ยท 3 years, 2 months ago
  78. 0a803bd Add NEVER() to two error-detection tests that were made unreachable by by drh ยท 3 years, 2 months ago
  79. e67a0f4 Add JS wrapper for sqlite3_exec() which knows how to handle a JS callback. Add some console.error() reporting of module-load failures, as they otherwise often get silently swallowed up by the loader's mechanisms. Add 'flexible-string' JS-to-WASM argument converter which performs more X-to-string conversions than the 'string' arg converter does. by stephan ยท 3 years, 2 months ago
  80. ad658b2 Better handle a case of database corruption where a b-tree page is one of its own ancestor pages. by dan ยท 3 years, 2 months ago
  81. d18f1bb Add sqlite3.version object. Add more state to the Worker #1 config-get response, including sqlite3.version. by stephan ยท 3 years, 2 months ago
  82. 07c0b72 Add oo1.JsStorageDb.clearStorage/storageSize() methods, copies of capi.sqlite3_web_kvvfs_clear/size(). by stephan ยท 3 years, 2 months ago
  83. 359d623 batch-runner.js: force WebSQL batches to not abort for a failed statement (necessary for apples-to-apples-ish benchmark comparisons). by stephan ยท 3 years, 2 months ago
  84. cb57716 Improvements to the "demoDelete" method in the demovfs, suggested by by drh ยท 3 years, 2 months ago
  85. dc6ae60 Expose sqlite3_msize() to wasm. by stephan ยท 3 years, 2 months ago
  86. f6c686c Add oo1.JsStorageDb() as a convenience wrapper for oo1.DB(...,'kvvfs'). Minor doc cleanups. by stephan ยท 3 years, 2 months ago
  87. 53d4e01 wasm: expose sqlite3_de/serialize(), sqlite3_malloc/free() and friends, noting that the former explicitly lies on use of the latter for memory management so is not generically safe for use in wasm. by stephan ยท 3 years, 2 months ago
  88. f71c954 Add JS infrastructure to ostensibly allow us to customize the wasm imports, which will hypothetically allow us to eliminate the dependency on EM_JS(), but the corresponding Emscripten glue-level feature currently breaks fatally with WASMFS builds so it's disabled. by stephan ยท 3 years, 2 months ago
  89. b0ccf50 Ensure that the wasm builds always, even when passing -Ox flags from the CLI, use -g3 to avoid problems caused by symbol minification with optimization levels -O2 and higher. by stephan ยท 3 years, 2 months ago
  90. eb97743 Finish eliminating explicit Emscripten module dependencies in test code and fiddle. The only remnant in public code is the Emscripten-generated module load/init interface. by stephan ยท 3 years, 2 months ago
  91. b94a986 Rework the Emscripten-emitted module loader/init function such that it passes on the sqlite3 module, instead of the Emscripten module, to the first then() of sqlite3InitModule()'s returned Promise. This eliminates any need to mention the Emscripten module object in client-side code unless they want to configure it in advance for loading-status reports. by stephan ยท 3 years, 2 months ago
  92. 31474ce Fix misuse of the sqlite3_set_auxdata() interface in the ICU extension. by drh ยท 3 years, 3 months ago
  93. 4b884bb Wasm: expose sqlite3_exec() and use it to simplify the db-reset logic in batch-runner.js a bit. by stephan ยท 3 years, 3 months ago
  94. cb22bd8 More work on batch-runner.html/js to facilitate speed comparisons between various VFSes and WebSQL. by stephan ยท 3 years, 3 months ago
  95. 5ad3631 Correct duplicate copies of sqlite3-api.js being embedded in the wasmfs-based builds. by stephan ยท 3 years, 3 months ago
  96. d980118 Work around broken -Os wasm builds by adding the -g3 flag. Unrelated documentation tweaks. by stephan ยท 3 years, 3 months ago
  97. 489a8a9 Minor doc correction. by stephan ยท 3 years, 3 months ago
  98. 5d48e0c Provide the SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting the by drh ยท 3 years, 3 months ago
  99. 6559e0a Comment the -O2 wasm builds as being broken (mysteriously missing JS bits). by stephan ยท 3 years, 3 months ago
  100. 5b9973d WASM API renaming. Reworked JS API bootstrap's async post-init into a generic mechanism, no longer OPFS-specific. by stephan ยท 3 years, 3 months ago