- 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
- 49d4026 Add test case that should have been part of previous commit. by dan ยท 3 years ago
- 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
- 8c69637 Remove SQLITE_EXPERIMENTAL tag from sqlite3_vtab_collation() and fix a related doc typo. by stephan ยท 3 years ago
- fe8ecfd Remove obsolete "experimental" comments on the virtual-table interface by drh ยท 3 years ago
- 95ade3b Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b]. by drh ยท 3 years ago
- b542298 Use the smaller estimated row size for searching IPK tables, but use the by drh ยท 3 years ago qp-tuning
- 8af6d71 Fix safe mode authorizer callback to reject disallowed UDFs. Reported at [forum:/forumpost/07beac8056151b2f|Forum post 07beac8056151b2f]. by larrybr ยท 3 years ago
- a81c5b3 Export sqlite3_result_zeroblob/zeroblob64() to wasm. by stephan ยท 3 years ago
- 1d8f4e6 Increase the nominal row size for IPK index lookups slightly, for better by drh ยท 3 years ago
- 878b44c Add TOTAL rows to the output generated by tool/vdbe_profile.tcl. by drh ยท 3 years ago
- fcf4243 Add a test case to show that ticket [e8b674241947eb3b] has been fixed. by drh ยท 3 years ago
- e4fa479 Further improvements to the estimated cost of sorting. Take into account by drh ยท 3 years ago
- 9baafda Correct a memory leak in tester1.js. by stephan ยท 3 years ago
- cbcc08d sqlite3.wasm.allocFromTypedArray() now optionally accepts an ArrayBuffer as its argument. by stephan ยท 3 years ago
- 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
- 54ac04c Doc typo fix for SQLITE_MAX_ALLOCATION_SIZE in malloc.c. No code changes. by stephan ยท 3 years ago
- 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
- 85ef4e4 JavaScript: add sqlite3.wasm.realloc(), sqlite3.capi.SQLITE_MAX_ALLOCATION_SIZE, and related tests. by stephan ยท 3 years ago
- 2564ca7 wasm build: rename the path to the wasm docs checkout, for clarity and consistency. by stephan ยท 3 years ago
- 1369d6b wasm snapshot and doc-related build automation tweaks. by stephan ยท 3 years ago
- 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
- 1edd0a0 Tuning the query planner by adjusting the weights that predict the relative by drh ยท 3 years ago
- 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
- 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
- d2603ad For the sqlite3_bind and sqlite3_result interfaces for UTF16 strings, round by drh ยท 3 years ago
- 8b5d7fd Use sqlite3_result_int64() instead of sqlite3_result_int() when returning by drh ยท 3 years ago
- 80ea1f4 Minor touchups to the JS test index page and test server push rules. by stephan ยท 3 years ago
- 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
- d09414e wasm: after building snapshot zip file, emit instructions for pushing it to the test server. by stephan ยท 3 years ago
- 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
- 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
- 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
- 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
- 31892c2 Remove extraneous/unused sqlite3.oo1.version object. Add httpd makefile target. by stephan ยท 3 years ago
- 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
- 9ec1a7a Reformulate and simplify some JS tests related to the previous checkin. by stephan ยท 3 years ago
- 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
- 85ec20a Add a testcase() macro to verify that the case of a NOT NULL error message by drh ยท 3 years ago
- 75fba2f Fix an over-zealous assert() reported by Yong Heng. by drh ยท 3 years ago
- 2a75765 Attempt to rationalize the bits associated with ".wheretrace". Provide by drh ยท 3 years ago
- 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
- a42281a Always use nanosleep() (instead of usleep() or sleep) if the by drh ยท 3 years ago
- 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
- 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
- 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
- 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
- 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
- d0945f4 Doc and logging text tweaks in the OPFS async proxy and test app. by stephan ยท 3 years ago
- 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
- 6e86d55 OPFS speedtest1: hide a currently-broken/to-fix WASMFS-build link. by stephan ยท 3 years ago
- 7741f34 Change the handling of hwtime.h to make it easier to compile performance by drh ยท 3 years ago
- 3c3896c Fix legacy build system main.mk to include basexx.c in testfixture builds. by dan ยท 3 years ago
- a302e68 Rename one instance of opfs.OpfsDb to oo1.OpfsDb, as per [0c5c51f4fb04]. by stephan ยท 3 years, 1 month ago
- ceedef8 Minor internal cleanups and docs in the OPFS sqlite3_vfs. by stephan ยท 3 years, 1 month ago
- 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
- 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
- d3fc2e6 Check-in [8d5b76593d82b3a5] contained an error that was causing some obscure by drh ยท 3 years, 1 month ago
- 0b0070f Get ext/misc/basexx.c into the testfixture.exe build for MSC. by larrybr ยท 3 years, 1 month ago
- 5b046da Fix harmless compiler warnings. by drh ยท 3 years, 1 month ago
- 57ba01d Implementation of enhancement request [695a1a53dea6b240]: The query planner by drh ยท 3 years, 1 month ago
- 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
- cbb9585 Test cases added derived from the enhancment ticket. by drh ยท 3 years, 1 month ago covering-indexed-expr
- 8ffa77f Merge trunk changes into covering-index-expr branch. by drh ยท 3 years, 1 month ago
- 84606c9 Rework the covering index checking routine, whereIsCoveringIndex(), so that by drh ยท 3 years, 1 month ago
- e862b5f Add (optional) base64 and base85 UDF extensions. by larrybr ยท 3 years, 1 month ago
- d8d68a5 Sync w/trunk, zap surplus space. by larrybr ยท 3 years, 1 month ago base_convert
- 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
- c1ca183 Conform CLI .trace arg handling to its help. by larrybr ยท 3 years, 1 month ago
- 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
- 9d34152 Better reporting of when the WHERE clause analysis thinks that an index by drh ยท 3 years, 1 month ago
- 217e77d Show which AggInfo.aCol an Expr node represents in the tree trace debugging by drh ยท 3 years, 1 month ago
- 8beb7f5 Merge trunk fixes into the covering-indexed-expr branch. by drh ยท 3 years, 1 month ago
- 743c9ec Fix an incorrect assertion-fault in the "TREETRACE" debugging logic on by drh ยท 3 years, 1 month ago
- 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
- 6e71186 Experimental changes to help the query planner detect when an expression by drh ยท 3 years, 1 month ago
- 902ea83 Relax restriction (8) on the push-down optimization so that it only applies by drh ยท 3 years, 1 month ago
- 49d400b Fix #ifdefs so that restrictions (8) and (9) of the push-down optimization by drh ยท 3 years, 1 month ago
- ae5cfda Immprove the query planner such that it is able to make use of indexed by drh ยท 3 years, 1 month ago
- 23f61a4 Add restriction (9) to the push-down optimization: If the subquery is by drh ยท 3 years, 1 month ago
- bedbb1b Remove a redundant assert() statement. by drh ยท 3 years, 1 month ago agg-with-indexed-expr
- f5d0656 Improve the robustness of the updateAccumulator() routine against OOM. by drh ยท 3 years, 1 month ago
- 7960da0 Improved comments. Add assert()s to verify that the AggInfo structure by drh ยท 3 years, 1 month ago
- 8683c09 Correctly deal with IF-NULL-ROW operators when dealing with by drh ยท 3 years, 1 month ago
- 472de14 Speed up base85() conversions and sync w/trunk. by larrybr ยท 3 years, 1 month ago
- e644f7c Take care not to try to add comments to a TK_AGG_COLUMN opcode that does by drh ยท 3 years, 1 month ago
- 594357f Change a NEVER() into an assert(). by drh ยท 3 years, 1 month ago
- eb84c81 Fix a test case in fts3expr4.test to account for different locales. by dan ยท 3 years, 1 month ago
- df5d06d More work on the OPFS concurrency testing app. by stephan ยท 3 years, 1 month ago opfs-unlock-asap
- 6b86b33 JS documentation cleanups. No code changes. by stephan ยท 3 years, 1 month ago
- 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
- c25f5ea Add NEVER() and ALWAYS() macros on branches that are believed to be unreachable. by drh ยท 3 years, 1 month ago
- b669bb5 New test cases. Fix the logic so that it works for GROUP BY aggregates by drh ยท 3 years, 1 month ago
- 9b9017d Speed up base64 conversions, and add test with more data for the baseNN conversion to grind. by larrybr ยท 3 years, 1 month ago
- 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
- 4b1555a Merge the latest trunk changes into the agg-with-indexed-expr branch to by drh ยท 3 years, 1 month ago
- 9b80cb5 Add explanatory comment to the new optimization. And add a test case. by drh ยท 3 years, 1 month ago
- f1ce4f4 Minor JS doc updates. by stephan ยท 3 years, 1 month ago
- 875db41 Add optional zSchema argument to sqlite3_js_db_export(). by stephan ยท 3 years, 1 month ago
- 056a715 OPFS concurrency test: add a URL flag to enable/disable unlock-asap mode. by stephan ยท 3 years, 1 month ago