aboutsummaryrefslogtreecommitdiff
path: root/ext/wasm/api/sqlite3-api-oo1.js
Commit message (Collapse)AuthorAge
* Rename some JS files for consistency. This affects only the build process, ↵stephan2024-07-10
| | | | | not the deliverables. FossilOrigin-Name: bcef3f71a2f68768819d9f716f2c29e752fb173df1506469c8669d95ecc2ff50
* JS error message and doc typos reported in the forum. No code changes.stephan2024-05-18
| | | FossilOrigin-Name: 1a073f9acfb691eebf4a8cc78a72ff47ebbb6aba4acede6755fa3faefae48f2b
* Minor touchups in JS docs and exception messages.stephan2024-04-23
| | | FossilOrigin-Name: 9e7fc9370dfca121244f7a2941e8de629b277f1799f8de08a43ff1d86f94b6f5
* Minor cleanups to [8fbda563d2f5].stephan2024-04-22
| | | FossilOrigin-Name: 5ee2594b657b96aea9e482a175820dcbacfa9298da45b38cf17f39ad076d3f7f
* Extend the JS/WASM SEE build support by (A) filtering SEE-related bits out ↵stephan2024-04-22
| | | | | of the JS when not building with SEE and (B) accepting an optional key/textkey/hexkey option to the sqlite3.oo1.DB and subclass constructors to create/open SEE-encrypted databases with. Demonstrate SEE in the test app using the kvvfs. This obviates the changes made in [5c505ee8a7]. FossilOrigin-Name: 8fbda563d2f56f8dd3f695a5711e4356de79035f332270db45d4b33ed52fdfd2
* For sqlite3.oo1.DB JavaScript classes, bypass execution of any on-open() SQL ↵stephan2024-04-22
| | | | | in SEE-capable builds because it would necessarily run before the client has an opportunity to provide their decryption key, which would leave the db handle in an unusable state and cause the ctor to throw. This currently affects only the OPFS VFSes. We may want to consider extending the ctor options object to optionally accept an SEE key and apply it when opening the db. FossilOrigin-Name: 5c505ee8a73f4b4a7053d98a12024d98340676f6ae9982311f9f88a9b46c8ae2
* Optimize sqlite3.oo1.DB.exec() for the rowMode='object' case to avoid ↵stephan2024-04-04
| | | | | converting the object property keys (column names) from native code to JS for each row. This speeds up large data sets considerably and addresses the report in [forum:3632183d2470617d|forum post 3632183d2470617d]. FossilOrigin-Name: 8b41ef8690001eb299f5b7182c28f5318333bff5b505e1d59d6e6f4556b1c759
* WASM: various build cleanups and add initial infrastructure for a build ↵stephan2024-01-01
| | | | | which elides the oo1 API and its dependents (worker1 and promiser). Sidebar: an attempt was made to move generation of the build rules to an external script, but the mixed-mode make/script was even less legible than the $(eval) indirection going on in the makefile. FossilOrigin-Name: 563d313163c02b398ae85b7c2ed231019a14e006726f09a7c1f294a58bf4363f
* Extend detection of the INSERT...RETURNING locking case to the ↵stephan2023-05-19
| | | | | DB.selectValue(s)/selectArray/selectObject() family of functions. Add tests for INSERT/UPDATE...RETURNING with those functions. FossilOrigin-Name: 3181c50540df0eff6cb5db79bb477c469bb7b73b0692260ba600db200fcef4ac
* Minor doc typo fix.stephan2023-05-19
| | | FossilOrigin-Name: 4533be08786306a4fcb4b21458444dffd0fa2764ebb2538313f3a16d9324cacc
* oo1.Stmt.finalize() no longer throws, but instead returns the same as the C ↵stephan2023-05-19
| | | | | API. oo1.DB.exec() now triggers the INSERT...RETURNING locking failure as an exception via reset() instead of finalize(). Some code-adjacent internal API renaming for clarity's sake. FossilOrigin-Name: 4ee6b3aa531b980acea4c4b58ee256e765c5105100468928def3d4c9825fa9bc
* sqlite3.oo1.Stmt.reset() now throws if sqlite3_reset() returns non-zero, ↵stephan2023-05-19
| | | | | analog to [f23eb5c6d365]. FossilOrigin-Name: 487ae12c9a21e5862bd590bbb1030c39734657d52136cf67b98c7545e6ecbe1c
* Add a basic INSERT RETURNING test for the oo1.DB.exec() API.stephan2023-05-19
| | | FossilOrigin-Name: d29d62cf7658aeb49f3c8a5d0b0809d945ebc9b79379a255eb88f771d2a2c430
* sqlite3.oo1.Stmt.finalize() now throws if sqlite3_finalize() returns ↵stephan2023-05-19
| | | | | non-zero. This is intended to address the INSERT RETURNING case covered in [forum:36f7a2e7494897df|forum post 36f7a2e7494897df]. FossilOrigin-Name: f23eb5c6d36546ee1e181a03660e0b2dc8005bba24bee8bae594b0c78bd152cd
* Doc typo fix. No code changes.stephan2023-05-10
| | | FossilOrigin-Name: e841b142f583e49350c7cdd14dc4da72434cc67c7b521ae741e03e37e785d7e0
* Resolve the JS-side corner case reported in [forum:7774b773937cbe0a | forum ↵stephan2023-05-10
| | | | | post 7774b773937cbe0a] by not caching oo1.Stmt.columnCount. FossilOrigin-Name: c3d25c3a25e79e01c4ad0cf11f7dc3b0fb1932f3bcd04935a728ef62f7e07cf1
* Replace use of 'self' in JS code with 'globalThis', as that works in ↵stephan2023-03-07
| | | | | browsers and node environments. Avoid using globalThis.location if it's not set (e.g. in node). Based on feedback in [forum:ac7a94d4f77db235|forum post ac7a94d4f77db235]. Minor JS build tweaks. FossilOrigin-Name: dbbe8f25e58738c10b6192d41f1e3886983871f17631cbc45ce626d3f05a6e26
* Add capability to override the JS's use of console.log/debug/warn/error() ↵stephan2023-02-06
| | | | | with client-provided versions via the bootstrap-time config object. FossilOrigin-Name: c54f29d8e55419eaa9168e799dab5030e89063b13d8390a50616606422d164dc
* Enhance oo1.DB.exec() to simplify returning whole result sets.stephan2023-01-28
| | | FossilOrigin-Name: 7b168ee2af09f04b41a6ef4c14ccaddc0c9b0bfe9dc1e6a86d8f5317606bd78d
* Add a feature idea note to DB.exec(), derived from a forum discussion.stephan2023-01-27
| | | FossilOrigin-Name: 792f43209c4b6e85386b6b3906814b7f2ad310d50ba563b3fd1cb37e55adf8db
* Add an optional argument to oo1.DB.transaction() to specify an explicit ↵stephan2022-12-27
| | | | | BEGIN qualifier. FossilOrigin-Name: 507335c12b1dbe21d180cf6f0a0deb4cc737417acb44c8f1d8fac98b86f62b01
* Correct some internal-use JS docs and update the 'string:flexible' type ↵stephan2022-12-26
| | | | | conversion to accept an ArrayBuffer (as it was recently documented to). FossilOrigin-Name: eff5d3bec29043cc1182bbb5229040dac5ff50264d025e354736bb63b4bc97a0
* Minor internal API doc correction and extend a test for oo1.DB.selectValues().stephan2022-12-25
| | | FossilOrigin-Name: b7295b1ca700945ae4e89be69f954dce9960e8975664e620898392b2cc78d452
* Add sqlite3.oo1.DB.selectValues(). Correct a logic error which could cause ↵stephan2022-12-25
| | | | | DB.selectValue(), DB.selectArray(), and DB.selectObject() to fail to finalize a statement if a call to bind() failed. Add more session API tests. FossilOrigin-Name: 6adc8a10146190037d55d3328d2f78aa5233559f88d4aa70fbbf9e10145b9b6c
* Add the address of the associated db handle to the sqlite3_trace_v2() output ↵stephan2022-12-25
| | | | | originating from sqlite3.oo1.DB's trace flag. FossilOrigin-Name: 0a36568c5a3db56a8ad23fd8abc672c5a7f1abed55984d902842ffd3ebb816e8
* Replace JS-side use of SQLITE_TRANSIENT with the new SQLITE_WASM_DEALLOC, ↵stephan2022-12-24
| | | | | reducing the amount allocation/copying required by sqlite3_bind_blob/text() and sqlite3_result_blob/text(). Remove the 'experimental' log message from the virtual table tests. FossilOrigin-Name: ffe2999a91a7dec129a38afb675fe9e539d7c347886bfea85cba55f6367d54d1
* Extend oo1.Stmt.bind() to accept ArrayBuffer instances to bind as blobs.stephan2022-12-24
| | | FossilOrigin-Name: f76bd30137fbff981625ffcb28cddd5e8651803dfc3f2d8d7801ead33496311d
* Add a test for the (failure) case of client-level code calling the oo1.Stmt ↵stephan2022-12-24
| | | | | constructor directly. FossilOrigin-Name: 6a37874db04f3b4842994ad17fc74cb6222f8ea0fa1315a23aff1ffa69bcd12a
* oo1.DB.exec() rowMode="$columnName": a minor optimization and a preemtive ↵stephan2022-12-24
| | | | | fix for a hypothetical corner-case bug. FossilOrigin-Name: 0b2df22bd92914708ad0851d0401ad2cf3edb1968b88b2c07fe40792a731c5ba
* If sqlite3.oo1.DB.exec()'s callback returns a literal false, stop step()ing ↵stephan2022-12-24
| | | | | over results as if the end of the result set had been reached. Unrelated minor code-adjacent cleanups. FossilOrigin-Name: 33a58c8ece3b37a8edc3434af36643e2d489a53a672d778c5b77e66666045c30
* Reimplement JS's sqlite3_bind_text/blob() with hand-written bindings to ↵stephan2022-12-23
| | | | | permit more flexible inputs. Add automated JS-to-C function conversion to sqlite3_busy_handler(). sqlite3.wasm.xWrap()'s '*' argument conversion no longer treats JS strings as C-strings: those conversions require explicit opt-in via the 'string' converter (or equivalent). FossilOrigin-Name: 96ba44946b3e88b6aa305c4363cbbfeab0d9120b3d8c4d2587d68b9293ea7cc6
* Internal JS cleanups. Correct part of [ac136925a645] to account for the ↵stephan2022-12-23
| | | | | eTextRep flag being able to hold flags other than the encoding. FossilOrigin-Name: 1dfc03ab1e0269807beef27bf884ab9ead7553d4a5f6ed213f812d7fa052045f
* Add convenience variants of sqlite3.wasm.peek/poke() for each numeric type ↵stephan2022-12-14
| | | | | to help reduce errors related to typos in the final argument (type-name strings). If wasm.xWrap.FuncPtrAdapter is called as a function, instead of a constructor, it now behaves as if it were called as a constructor (previously it threw an exception). FossilOrigin-Name: 14e3fc01b929fa3f9a2fdbd93deb4a8aad58c111d46369c772def0437152fa75
* A micro-optimization in sqlite3.oo1.DB.exec(). Changed the rowMode option of ↵stephan2022-12-14
| | | | | that method to only accept $X instead of $X, @X, and :X, as the extra options are entirely superfluous and may lead to confusion. FossilOrigin-Name: 82a6c7fdf59729c182545b15c084b136e34513f340e87a7b6e5aa199117357b0
* Extend the sqlite3.wasm function pointer argument converter to be able to ↵stephan2022-12-13
| | | | | handle the "two-layered context" of sqlite3_create_collation() and friends and make use of FuncPtrAdapter to perform JS-to-WASM function conversion for them. FossilOrigin-Name: 0a60b7215e433f8c50027c70731b11e58d74c90ec5903e66ae42f9c98e40b044
* Rename the oft-used, verbose sqlite3.wasm.get/setMemValue() and ↵stephan2022-12-09
| | | | | get/setPtrValue() to peek/poke() and peek/pokePtr(). The old names are retained as aliases just in case any client code actually uses them, but they are now deprecated. FossilOrigin-Name: ad0a8139b0b025f8e9d2eca0c303557ef10fdfab8c8b65afb08c510a804073d5
* Export sqlite3_status() and sqlite3_stmt_status() to wasm. Expand the ↵stephan2022-12-09
| | | | | arg/return semantics of wasm.get/setPtrValue() and get/setMemValue() to simplify handling of multiple pointers. FossilOrigin-Name: e144fd5c88fa4151429a2fef3daf389588402e158267f0afa0dfd142527d76b9
* Got JS non-eponymous vtable working thanks to a hint from Dan.stephan2022-12-08
| | | FossilOrigin-Name: 750719b4981df62fa2ff3665e6f559ec760609ad2493495628295ad9ae6024fc
* Rename wasm.cstringToJs() to wasm.cstrToJs() for consistency with other ↵stephan2022-12-06
| | | | | wasm.cstr... APIs. FossilOrigin-Name: cbf483ea0ba3e6dc08ad7ed654380f818544b4c3cedfdb8aa848a83298268ceb
* Add a demonstration sqlite3_vtab/module implemented in JS, based on ↵stephan2022-12-06
| | | | | ext/misc/templatevtab.c. Add oo1.selectArrays() and selectObjects(). FossilOrigin-Name: 60482c97e02bc4cafefef281be0cf0bc8c5c53232162829c137f3f7a80cdc534
* Export sqlite3_vtab_collation() to wasm. Rename 'flexible-string' JS ↵stephan2022-12-05
| | | | | argument adapter to 'string:flexible' for consistency. FossilOrigin-Name: 15f8042fddaeabab43dd187c463d3ccc56758cbf19bf2ca4837d9087a4850c1a
* Rework the oo1.DB's distinct-per-VFS post-open() step to accept either a ↵stephan2022-12-03
| | | | | batch of SQL or a callback function. Increase OPFS's busy timeout to 10s. FossilOrigin-Name: 9feefe253ac487cb52be6bdf91bdd305963266716baa08f2bf9505954ee76321
* Remove extraneous/unused sqlite3.oo1.version object. Add httpd makefile target.stephan2022-12-02
| | | FossilOrigin-Name: 8e4d30ac033a6d9019a7eeedfe788dc0120f565cef2ae8f09d2bf32eb94d8a33
* OPFS VFS: add the opfs-unlock-asap=1 URI flag which tells the VFS to release ↵stephan2022-11-26
|\ | | | | | | | | 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. FossilOrigin-Name: 9542f9ce9e023b489e2d93661f719fb0751c1e28f72fded9d3c2156d5777e7b1
| * Initial infrastructure for adding a mode to the OPFS VFS which causes ↵stephan2022-11-23
| | | | | | | | | | implicit locks to be released ASAP, which increases concurrency at the cost of performance. FossilOrigin-Name: c5b7a9715a13b696ab3ee965aa0a310f59b65f07cecd72faa2e3504bfd8eb632
* | Add sqlite3.oo1.DB.prototype.checkRc() and tests for both that method and ↵stephan2022-11-24
|/ | | | | its class-level counterpart. FossilOrigin-Name: f7eaa6ba2147bfd6dbdc2444d0f919d846aa7f9b68cccab17ef585ffdacf3d60
* Minor internal cleanups in the js pieces.stephan2022-11-01
| | | FossilOrigin-Name: 271391b4e32220ab4c32d69f579ecd2b03eb99da898955a1ef8fffc27216719d
* Significant cleanups and expansion of the sqlite3.opfs utilities. Add ↵stephan2022-11-01
| | | | | oo1.DB.dbVfsName(). Add VFS name to worker1:open's arguments and result. FossilOrigin-Name: 86a341d7e061f946b39e8647ddd4743013b851b33ae9e6e755d8dbc53fba5286
* Add oo1.DB.exec() 'returnValue' option, which specifies what exec() should ↵stephan2022-10-31
| | | | | return. Defaults to the db object and enables direct return of the result rows array or a list of the individual SQL statements. Other code-adjacent internal cleanups. FossilOrigin-Name: 69d36a6aa5e2cd79d26c0fd3e0d20fe8838fd1be97db07725233bfff1dfe6643
* Add oo1.DB.selectArray() and selectObject().stephan2022-10-30
| | | FossilOrigin-Name: 7660db2a2e9c4f3a6a9343d6929744ad0f4be6820976411f9080165491da59b7
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-08 19:54:48 +0000