๐ŸŒ AIๆœ็ดข & ไปฃ็† ไธป้กต
  1. 9ab1598 Add optional feature: A CLI continuation prompt which reflects open lexemes and parens, similarly to PG shell. by larrybr ยท 3 years ago dynamic_prompt
  2. 49d4026 Add test case that should have been part of previous commit. by dan ยท 3 years ago
  3. 27ef91b Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. by dan ยท 3 years ago
  4. 8c69637 Remove SQLITE_EXPERIMENTAL tag from sqlite3_vtab_collation() and fix a related doc typo. by stephan ยท 3 years ago
  5. fe8ecfd Remove obsolete "experimental" comments on the virtual-table interface by drh ยท 3 years ago
  6. 95ade3b Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b]. by drh ยท 3 years ago
  7. b542298 Use the smaller estimated row size for searching IPK tables, but use the by drh ยท 3 years ago qp-tuning
  8. 8af6d71 Fix safe mode authorizer callback to reject disallowed UDFs. Reported at [forum:/forumpost/07beac8056151b2f|Forum post 07beac8056151b2f]. by larrybr ยท 3 years ago
  9. a81c5b3 Export sqlite3_result_zeroblob/zeroblob64() to wasm. by stephan ยท 3 years ago
  10. 1d8f4e6 Increase the nominal row size for IPK index lookups slightly, for better by drh ยท 3 years ago
  11. 878b44c Add TOTAL rows to the output generated by tool/vdbe_profile.tcl. by drh ยท 3 years ago
  12. fcf4243 Add a test case to show that ticket [e8b674241947eb3b] has been fixed. by drh ยท 3 years ago
  13. e4fa479 Further improvements to the estimated cost of sorting. Take into account by drh ยท 3 years ago
  14. 9baafda Correct a memory leak in tester1.js. by stephan ยท 3 years ago
  15. cbcc08d sqlite3.wasm.allocFromTypedArray() now optionally accepts an ArrayBuffer as its argument. by stephan ยท 3 years ago
  16. 09c27a5 Rename wasm.xWrap.resultAdapter() X:free entries to X:dealloc for consistency with wasm.dealloc(). Add an undocumented feature to replace wasm.alloc/dealloc/realloc() with the C-standard allocators (after an allocator misuse led down a several-hour rabbit hole trying to discover a mis-free() violation). Related test updates. by stephan ยท 3 years ago
  17. 54ac04c Doc typo fix for SQLITE_MAX_ALLOCATION_SIZE in malloc.c. No code changes. by stephan ยท 3 years ago
  18. fed255d Move kvvfs xRead()/xWrite() buffer from function-local stack memory to heap memory to accommodate changes in emsdk 3.1.27. by stephan ยท 3 years ago
  19. 85ef4e4 JavaScript: add sqlite3.wasm.realloc(), sqlite3.capi.SQLITE_MAX_ALLOCATION_SIZE, and related tests. by stephan ยท 3 years ago
  20. 2564ca7 wasm build: rename the path to the wasm docs checkout, for clarity and consistency. by stephan ยท 3 years ago
  21. 1369d6b wasm snapshot and doc-related build automation tweaks. by stephan ยท 3 years ago
  22. a37fed0 Rework the oo1.DB's distinct-per-VFS post-open() step to accept either a batch of SQL or a callback function. Increase OPFS's busy timeout to 10s. by stephan ยท 3 years ago
  23. 1edd0a0 Tuning the query planner by adjusting the weights that predict the relative by drh ยท 3 years ago
  24. bb4e4a4 Minor internal tweaks to the OPFS VFS. Resolve a missing result code which lead to a null deref in xFileSize(). by stephan ยท 3 years ago
  25. 95bc4d6 OPFS VFS: translate createSyncAccessHandle() exceptions which appear to be locking violations to SQLITE_BUSY. This seems to improve concurrency considerably even with a reduced retry count of 5 (was 6). by stephan ยท 3 years ago
  26. d2603ad For the sqlite3_bind and sqlite3_result interfaces for UTF16 strings, round by drh ยท 3 years ago
  27. 8b5d7fd Use sqlite3_result_int64() instead of sqlite3_result_int() when returning by drh ยท 3 years ago
  28. 80ea1f4 Minor touchups to the JS test index page and test server push rules. by stephan ยท 3 years ago
  29. 5ad4e89 wasm builds: explicitly set a default stack size because emsdk 3.1.27 reduced it from 4MB to only 64kb, leading to memory corruption when kvvfs is used (it requires at least twice that for I/O). by stephan ยท 3 years ago
  30. d09414e wasm: after building snapshot zip file, emit instructions for pushing it to the test server. by stephan ยท 3 years ago
  31. 1078ee0 Correct the problem which triggered the rollback in [7eec635562f6]: an incorrect default db page size (not a multiple of 512 bytes). by stephan ยท 3 years ago
  32. 20f0128 Roll back the SQLITE_DEFAULT_PAGE_SIZE part of [c260895faacb34] because kvvfs does not work at all with a page size of 8kb. by stephan ยท 3 years ago
  33. f3409db sqlite3-wasm.c: code legibility and coding style tweaks. Increase SQLITE_DEFAULT_PAGE_SIZE from 4k to 8k, as that improves OPFS speedtest1 performance by roughly 12%. by stephan ยท 3 years ago
  34. cc70dfe Expand JS tests for db export/import and document reason it cannot currently work with kvvfs. Fix a minor JS build dependencies bug. Update page title with PASS/FAIL prefix for tester1.js to improve overview when launching multiple test tabs. Add ability of tester1 should-run-test predicates to report why a given test is disabled. by stephan ยท 3 years ago
  35. 31892c2 Remove extraneous/unused sqlite3.oo1.version object. Add httpd makefile target. by stephan ยท 3 years ago
  36. 919dbc8 sqlite3_js_create_file() now accepts an ArrayBuffer data source. Add test for OPFS-based export/re-import. The (sqlite3*) argument converter now optionally accepts sqlite3.oo1.DB instances. by stephan ยท 3 years ago
  37. 9ec1a7a Reformulate and simplify some JS tests related to the previous checkin. by stephan ยท 3 years ago
  38. 2b21995 Expand "sqlite3_vfs*" JS-to-WASM function argument conversions to accept VFS names (JS strings) and capi.sqlite3_vfs instances. Implement sqlite3_js_vfs_create_file() to facilitate creation of file-upload features which store the file in VFS-specific storage (where possible, e.g. "unix" and "opfs" VFSes). Correct an argument type check in the SQLite3Error and WasmAllocError constructors. by stephan ยท 3 years ago
  39. 85ec20a Add a testcase() macro to verify that the case of a NOT NULL error message by drh ยท 3 years ago
  40. 75fba2f Fix an over-zealous assert() reported by Yong Heng. by drh ยท 3 years ago
  41. 2a75765 Attempt to rationalize the bits associated with ".wheretrace". Provide by drh ยท 3 years ago
  42. ec192e0 Rename some JS files from X.js to X.c-pp.js to keep the maintainer, and downstream build customizers, aware that those files contain constructs specific to the c-pp preprocessor and will not run as-is in JS. by stephan ยท 3 years ago
  43. a42281a Always use nanosleep() (instead of usleep() or sleep) if the by drh ยท 3 years ago
  44. 8ae9545 Install sqlite3_malloc/sqlite3_free() as the JS-side WASM allocator (as opposed to replacing C-level's malloc()/free() with them). All tests work and this eliminates the potential for allocator discrepancies when using the (de)serialize APIs. by stephan ยท 3 years ago
  45. c5141c9 Simplify how the OPFS VFS async proxy copies initial state sent to it from the synchronous side of the connection. Make the lock-wait time a multiple of the wait-loop timeout interval. by stephan ยท 3 years ago
  46. e7f5118 OPFS VFS: remove an invalid TODO and fix a property name typo which caused xCheckReservedLock() to always report false. by stephan ยท 3 years ago
  47. 36a0163 Rename some OPFS JS files. Prevent JS bindings of sqlite3_uri_...() from performing JS-to-C-string argument conversion on their first argument, as doing so is specifically illegal. by stephan ยท 3 years ago
  48. ad4f782 Refactor a significant chunk of the OPFS sqlite3_vfs init code into sqlite3.VfsHelper, and internal-use-only API encapsulating code relevant to creating new VFSes in JS. Intended to assist in pending experimentation with an alternative OPFS VFS. by stephan ยท 3 years ago
  49. d0945f4 Doc and logging text tweaks in the OPFS async proxy and test app. by stephan ยท 3 years ago
  50. 72ee096 sqlite3.oo1.OpfsDb: default to journal_mode=persist, as current tests show it to be marginally faster than truncate/delete in Chrome v109. Also increase default busy_timeout from 2 seconds to 3, admittedly on a whim. by stephan ยท 3 years ago
  51. 6e86d55 OPFS speedtest1: hide a currently-broken/to-fix WASMFS-build link. by stephan ยท 3 years ago
  52. 7741f34 Change the handling of hwtime.h to make it easier to compile performance by drh ยท 3 years ago
  53. 3c3896c Fix legacy build system main.mk to include basexx.c in testfixture builds. by dan ยท 3 years ago
  54. a302e68 Rename one instance of opfs.OpfsDb to oo1.OpfsDb, as per [0c5c51f4fb04]. by stephan ยท 3 years, 1 month ago
  55. ceedef8 Minor internal cleanups and docs in the OPFS sqlite3_vfs. by stephan ยท 3 years, 1 month ago
  56. 0418476 Internal restructuring of the OPFS sqlite3_vfs in order to facilitate certain experimentation and improve error reporting/hints if it cannot be activated. Deprecate the name sqlite3.opfs.OpfsDb, preferring sqlite3.oo1.OpfsDb for consistency with JsStorageDb and any future DB subclasses. by stephan ยท 3 years, 1 month ago
  57. e6b0154 Add an explicit warning about the current API-instability of the sqlite3.opfs namespace, which may need to be eliminated based on re-thinking of how the OPFS sqlite3_vfs is registered. Comment changes only - no code. by stephan ยท 3 years, 1 month ago
  58. d3fc2e6 Check-in [8d5b76593d82b3a5] contained an error that was causing some obscure by drh ยท 3 years, 1 month ago
  59. 0b0070f Get ext/misc/basexx.c into the testfixture.exe build for MSC. by larrybr ยท 3 years, 1 month ago
  60. 5b046da Fix harmless compiler warnings. by drh ยท 3 years, 1 month ago
  61. 57ba01d Implementation of enhancement request [695a1a53dea6b240]: The query planner by drh ยท 3 years, 1 month ago
  62. 1b3d13e Add the SQLITE_FCNTL_RESET_CACHE verb. Use it to ensure that the page cache is purged before and after a the recovery extension is run. by dan ยท 3 years, 1 month ago
  63. cbb9585 Test cases added derived from the enhancment ticket. by drh ยท 3 years, 1 month ago covering-indexed-expr
  64. 8ffa77f Merge trunk changes into covering-index-expr branch. by drh ยท 3 years, 1 month ago
  65. 84606c9 Rework the covering index checking routine, whereIsCoveringIndex(), so that by drh ยท 3 years, 1 month ago
  66. e862b5f Add (optional) base64 and base85 UDF extensions. by larrybr ยท 3 years, 1 month ago
  67. d8d68a5 Sync w/trunk, zap surplus space. by larrybr ยท 3 years, 1 month ago base_convert
  68. abbfa7a Ensure the RETURNING clause is honoured when a row of a temp table is updated by an ON CONFLICT clause. by dan ยท 3 years, 1 month ago
  69. c1ca183 Conform CLI .trace arg handling to its help. by larrybr ยท 3 years, 1 month ago
  70. ca9309c Document an OPFS API change in Chrome v108 which does not break our code but does change several formerly async methods to synchronous. No code changes. by stephan ยท 3 years, 1 month ago
  71. 9d34152 Better reporting of when the WHERE clause analysis thinks that an index by drh ยท 3 years, 1 month ago
  72. 217e77d Show which AggInfo.aCol an Expr node represents in the tree trace debugging by drh ยท 3 years, 1 month ago
  73. 8beb7f5 Merge trunk fixes into the covering-indexed-expr branch. by drh ยท 3 years, 1 month ago
  74. 743c9ec Fix an incorrect assertion-fault in the "TREETRACE" debugging logic on by drh ยท 3 years, 1 month ago
  75. 4245667 OPFS VFS: add the opfs-unlock-asap=1 URI flag which tells the VFS to release implicit locks ASAP instead of during VFS idle time. This improves concurrency notably in the test app but brings a significant performance penalty in speedtest1 (roughly 4x slowdown). This is not the final word in OPFS concurrency, but gets us a step further. by stephan ยท 3 years, 1 month ago
  76. 6e71186 Experimental changes to help the query planner detect when an expression by drh ยท 3 years, 1 month ago
  77. 902ea83 Relax restriction (8) on the push-down optimization so that it only applies by drh ยท 3 years, 1 month ago
  78. 49d400b Fix #ifdefs so that restrictions (8) and (9) of the push-down optimization by drh ยท 3 years, 1 month ago
  79. ae5cfda Immprove the query planner such that it is able to make use of indexed by drh ยท 3 years, 1 month ago
  80. 23f61a4 Add restriction (9) to the push-down optimization: If the subquery is by drh ยท 3 years, 1 month ago
  81. bedbb1b Remove a redundant assert() statement. by drh ยท 3 years, 1 month ago agg-with-indexed-expr
  82. f5d0656 Improve the robustness of the updateAccumulator() routine against OOM. by drh ยท 3 years, 1 month ago
  83. 7960da0 Improved comments. Add assert()s to verify that the AggInfo structure by drh ยท 3 years, 1 month ago
  84. 8683c09 Correctly deal with IF-NULL-ROW operators when dealing with by drh ยท 3 years, 1 month ago
  85. 472de14 Speed up base85() conversions and sync w/trunk. by larrybr ยท 3 years, 1 month ago
  86. e644f7c Take care not to try to add comments to a TK_AGG_COLUMN opcode that does by drh ยท 3 years, 1 month ago
  87. 594357f Change a NEVER() into an assert(). by drh ยท 3 years, 1 month ago
  88. eb84c81 Fix a test case in fts3expr4.test to account for different locales. by dan ยท 3 years, 1 month ago
  89. df5d06d More work on the OPFS concurrency testing app. by stephan ยท 3 years, 1 month ago opfs-unlock-asap
  90. 6b86b33 JS documentation cleanups. No code changes. by stephan ยท 3 years, 1 month ago
  91. 647b0dd Update multiplex3.test to account for the fact that the multiplexor xDelete method may return an error even if it manages to delete the first chunk of a file. by dan ยท 3 years, 1 month ago
  92. c25f5ea Add NEVER() and ALWAYS() macros on branches that are believed to be unreachable. by drh ยท 3 years, 1 month ago
  93. b669bb5 New test cases. Fix the logic so that it works for GROUP BY aggregates by drh ยท 3 years, 1 month ago
  94. 9b9017d Speed up base64 conversions, and add test with more data for the baseNN conversion to grind. by larrybr ยท 3 years, 1 month ago
  95. f46091d Add sqlite3.oo1.DB.prototype.checkRc() and tests for both that method and its class-level counterpart. by stephan ยท 3 years, 1 month ago
  96. 4b1555a Merge the latest trunk changes into the agg-with-indexed-expr branch to by drh ยท 3 years, 1 month ago
  97. 9b80cb5 Add explanatory comment to the new optimization. And add a test case. by drh ยท 3 years, 1 month ago
  98. f1ce4f4 Minor JS doc updates. by stephan ยท 3 years, 1 month ago
  99. 875db41 Add optional zSchema argument to sqlite3_js_db_export(). by stephan ยท 3 years, 1 month ago
  100. 056a715 OPFS concurrency test: add a URL flag to enable/disable unlock-asap mode. by stephan ยท 3 years, 1 month ago