bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • e822005684 wasm: make pre-js.c-pp.js a no-op in bundler-friendly builds. stephan 2026-01-20 18:01:56 +00:00
  • bb56ddc4e3 wasm: a potential workaround for cases such as [forum:1eec339854c935bd|forum post 1eec339854c935bd], where client-local needs require overriding Emscripten config defaults (which we very intentionally do not document or support for reasons explained in that thread). This is untested because it requires a special-needs setup, but it doesn't break anything for run-of-the-mill cases. stephan 2026-01-20 17:10:22 +00:00
  • ec13fcecd2 Minor fixes. Tests are passing now. drh 2026-01-20 15:07:28 +00:00
  • d4dc275ebc Add an SQLITE_API_ARMOR check to sqlite3_get_clientdata(), per request in [forum:a011a001f4|forum post a011a001f4]. stephan 2026-01-20 10:57:44 +00:00
  • f4a613aa46 Minor doc updates in mkwasmbuilds.c. stephan 2026-01-19 22:20:12 +00:00
  • d50161a3cd wasm: remove the bundler-friend builds from the 'all' target, as they're only needed for the 'npm' target. stephan 2026-01-19 22:01:10 +00:00
  • 4eb307cf46 Minor doc touchups in the opfs-sahpool VFS. No functional changes. stephan 2026-01-19 21:57:32 +00:00
  • 0af76f6caa Be more aggressive about using a sort-and-merge to compute the UNION of two SELECT statements. Experimental branch. This check-in is failing some tests. drh 2026-01-19 19:51:03 +00:00
  • 8c4e315e19 Add two new JSON functions: json_array_insert() and jsonb_array_insert(). Patterned after the json_array_insert() function of MySQL. [forum:/forumpost/2026-01-17T10:40:39z|Forum thread 2026-01-17T10:40:39z]. drh 2026-01-19 11:44:59 +00:00
  • 4720c16223 Raise an error if any PATH argument to json_array_insert() is not the path of an array element. Add some test cases for json_array_insert(). json_array_insert drh 2026-01-17 19:01:37 +00:00
  • 6f3a679a7d Add new SQL function: json_array_insert(). Suggested in [forum:/forumpost/2026-01-17T10:40:39z|forum thread 2026-01-17T10:40:39z]. This check-in seems to work, but contains no test cases. Also, no error is raised if the PATH does not reference an array. Prototype only. drh 2026-01-17 14:23:28 +00:00
  • 4b9def1903 Fix further problems with deleting from corrupt fts5 databases in secure-delete mode. dan 2026-01-16 20:04:04 +00:00
  • 9dff6ac96e Try to prevent false positives in fuzzinvariants.c due to scalar subqueries. drh 2026-01-16 17:48:46 +00:00
  • 4dd1a202de The optimization at [8bdda827a3d26800] is incorrect for the case where one of the two expressions has been commuted such that the collating sequence has changed. This check-in fixes the problem. Problem reported by [forum:/forumpost/2026-01-16T11:35:28Z|forum post 2026-01-16T11:35:28Z]. drh 2026-01-16 15:53:20 +00:00
  • cd8aee7946 Change the copyright on the tool/dbtotxt.c source code file to the standard SQLite blessing. drh 2026-01-16 12:13:42 +00:00
  • 90942efd21 Fix an error in new test script fts5corrupt9.test. dan 2026-01-15 17:17:00 +00:00
  • bae4055493 Fix a buffer overrun that could occur when deleting rows in secure-delete mode from a strategically corrupted fts5 database. dan 2026-01-15 17:15:30 +00:00
  • 248ee2f7cc Avoid unsigned integer overflow in the delta_apply() extension function. Not part of any standard deliverable. [forum:/forumpost/d41879b367c7f7ec|Forum thread d41879b367c7f7ec]. dan 2026-01-15 17:12:57 +00:00
  • 5ba53751af Prevent a malicious delta from causing an integer overflow in the fossildelta extension. This code is not used in the SQLite core. dan 2026-01-15 17:11:33 +00:00
  • bcc496e526 Add extra test for handling corrupt delta records in rbu. artiphishell dan 2026-01-15 17:00:58 +00:00
  • ce83fd80ad Fix a buffer overrun that could occur when deleting rows in secure-delete mode from a strategically corrupted fts5 database. dan 2026-01-15 16:09:35 +00:00
  • 43eb1d4d22 Adjust the output of the fuzzcheck test program so that testrunner.tcl can capture the number of tests run even when the --slice option is used. drh 2026-01-14 19:22:36 +00:00
  • abdfd3312a Update sessions module so that it takes the db mutex before, instead of just after, opening a savepoint when generating a changeset. dan 2026-01-14 17:52:27 +00:00
  • c1975b6a6f Improve some of the documentation comments for the new code on this branch. dan 2026-01-14 17:02:22 +00:00
  • de88171c4c Merge latest trunk changes into this branch. dan 2026-01-14 16:01:28 +00:00
  • 613cf76c2f Add tests for edge cases in the new code on this branch. dan 2026-01-14 15:27:26 +00:00
  • f3cf1238bc Guard against oversized index entries in databases larger than 2GiB. drh 2026-01-14 13:49:27 +00:00
  • e5fba7f094 Guard against oversized index entries in databases larger than 2GiB. drh 2026-01-14 13:43:32 +00:00
  • c289cf57a7 Allow the APIs on this branch to be used to create patchsets as well as changesets. dan 2026-01-13 19:59:47 +00:00
  • bdf61095bb Increase the version number to 3.51.3 drh 2026-01-13 02:43:26 +00:00
  • 15cd670486 Fix integer overflow problems and error reporting memory leaks in the zipfile extension. drh 2026-01-13 02:39:52 +00:00
  • 35b9709d46 Fix integer overflow problems and error reporting memory leaks in the zipfile extension. [forum:/forumpost/2026-01-13T00:09:06Z|Forum post 2026-01-13T00:09:06Z]. drh 2026-01-13 02:35:19 +00:00
  • 4b12a38ffb Fix an OOB read in the sessions module that could occur while processing a corrupt changeset. dan 2026-01-12 20:16:04 +00:00
  • 9a341c1edb Avoid unsigned integer overflow in the delta_apply() extension function. Not part of any standard deliverable. [forum:/forumpost/d41879b367c7f7ec|Forum thread d41879b367c7f7ec]. drh 2026-01-12 19:56:00 +00:00
  • 9f78d22870 Fix an infinite loop in the sessions module that could occur when processing a corrupt changeset blob. dan 2026-01-12 19:13:09 +00:00
  • c3a7168abe Merge the latest trunk enhancements into the reuse-schema branch. drh 2026-01-12 17:41:49 +00:00
  • e34ccf85cf Merge all the latest trunk enhancements into the bedrock branch. drh 2026-01-12 17:18:58 +00:00
  • a87cf441bb Merge the latest trunk enhancements into the wal2 branch drh 2026-01-12 17:05:15 +00:00
  • 817c509365 Add an API to the sessions module to add changes one at a time to an sqlite3_changegroup object. dan 2026-01-12 16:39:27 +00:00
  • 3e5264e8b9 Merge the latest trunk enhancements into the begin-concurrent branch. drh 2026-01-12 16:12:37 +00:00
  • bc2101b44e wasm: filter the custom Module.instantiateWasm() out of node builds, per request from the npm project. stephan 2026-01-12 15:43:18 +00:00
  • 6444f694a6 Improved documentation (in the header comment) for tmstmpvfs.c. drh 2026-01-12 14:45:55 +00:00
  • a87d7c00f4 Add sqlite3_carray_bind() to sqlite3_api_routines. [forum:257e642a4c|Forum post 257e642a4c]. stephan 2026-01-11 21:18:23 +00:00
  • 428c2656ff Add the @preserve tag to the standalone file sqlite3-opfs-async-proxy.js. stephan 2026-01-11 16:21:32 +00:00
  • ef7379c906 Because of the risk of false positives and ancient compiler versions, do not assume that clang automatically supports -MJ for compile-commands output. i.e. make --compile-commands completely opt-in instead of sometimes-assumed. stephan 2026-01-11 15:29:56 +00:00
  • c1d9d3e611 Remove a now-extraneous JS file. stephan 2026-01-11 15:24:35 +00:00
  • 9ab2a2af1b wasm: add @preserve tags to two comment blocks (license header and build version info) so that the npm tools know to retain those comments when minifying. stephan 2026-01-11 14:14:16 +00:00
  • bbe575f21d Merge trunk into the almost-forgotten compile-commands branch. stephan 2026-01-11 00:20:24 +00:00
  • 2f47a58c5d Update speedtest.md to point out xdg-open on Linux. stephan 2026-01-10 14:12:40 +00:00
  • 644c42f3a4 Fix a help text typo in speedtest1.tcl, pointed out off-list by BrickViking. stephan 2026-01-10 00:38:00 +00:00
  • 2a215595bc Merge the 3.51.2 changes into the reuse-schema-3.51 branch drh 2026-01-09 20:04:30 +00:00
  • aef151ada7 Add the 'npm' ext/wasm makefile target to create npm-bundle.zip for use by the downstream npm package. This target is intended to become their path for pulling npm-relevant deliverables, rather than the canonical downloads, and they have our/my commitment not to break it without involving them first. stephan 2026-01-09 19:44:31 +00:00
  • 0ad6c6c440 Fix the wasm snapshot build's zipfile name to include '-snapshot' and correct the update-docs target for recent build refactoring. stephan 2026-01-09 18:42:27 +00:00
  • ba76c160c7 Version 3.51.2 version-3.51.2 drh 2026-01-09 17:27:48 +00:00
  • f3e0993b9d To ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1);" to fuzzcheck.c. dan 2026-01-09 16:21:26 +00:00
  • c51f318f6a Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter. drh 2026-01-09 16:01:51 +00:00
  • 3a621d8a58 Fix potential OOB read on the undocumented test function rtreenode() in the RTREE extension. drh 2026-01-09 00:45:41 +00:00
  • 4b93124b6b Fix potential OOB read on the undocumented test function rtreenode() that is part of the RTREE extension, as described in [forum:/forumpost/2026-01-08T23:32:19Z|forum post 2026-01-08T23:32:19Z]. The problem is almost certainly harmless since any memory allocation will be a multiple of 8 bytes, and once the input buffer size gets rounded up to the next multiple of 8 bytes, the access will still be within bounds. Nevertheless, it still needs to be fixed. drh 2026-01-09 00:41:35 +00:00
  • 1d49bbc25e Enhance VACUUM INTO so that if a URI filename is used as the target and that filename as a reserve=N query parameter with N between 0 and 255, then the reserve amount for the generated database copy is set to N. This simplifies making a copy of a database file with a reduced or reset reserve. drh 2026-01-08 20:29:02 +00:00
  • 4b4d07253f In the reserve=N query parameter on the VACUUM INTO target file, the parameter is a silent no-op if N is out of range. reset-reserve drh 2026-01-08 20:20:03 +00:00
  • c34d561940 Change the name of the log file for tmstmpvfs.c to be an ISO8601 date/time, for improved readability and situational awareness. drh 2026-01-08 18:55:49 +00:00
  • 22c99e01ff Fix the sqlite3-worker1.mjs (ESM, non-bundler) build and have demo-worker1-promiser use that file rather than the vanilla one, as a test case. Delete the global symbol installed by that file in ESM and bundler builds, as it's unnecessary there. The first change should resolve [https://github.com/sqlite/sqlite-wasm/issues/123|downstream sqlite-wasm/issues/123], with thanks to Jure Rotar for his help. stephan 2026-01-08 18:15:23 +00:00
  • 0a10cdb663 Merge all the latest trunk changes into the reset-reserve branch. drh 2026-01-08 18:14:29 +00:00
  • 5df3efe6f4 Fix an off-by-one error in the page number of ELOG_CKPT_PAGE log messages in tmstmpvfs.c drh 2026-01-08 17:52:42 +00:00
  • cc4a404048 Add a missing #if check for SQLITE_OMIT_LOAD_EXTENSION to shell.c.in, trigged by the fiddle build. stephan 2026-01-08 15:26:19 +00:00
  • 403c153dfa Minor bug fixes in tmstmpvfs.c, showdb.c, and showtmlog.c. drh 2026-01-08 15:25:04 +00:00
  • 784bceae33 Remove an obsolete '32-bit' label from tester1-worker. stephan 2026-01-08 15:06:28 +00:00
  • 92730d21ff Fix the --size X flag for speedtest1.html when X=0 and force the job size to 5 for kvvfs so that it doesn't block the main thread for too awful long. stephan 2026-01-08 15:03:00 +00:00
  • 22b08034aa Enhance the --vfs command-line option to the CLI such that if the argument is not a valid VFS name, but is the name of a file, attempt to load that file as an extension, which presumably adds the desired VFS. drh 2026-01-08 13:43:15 +00:00
  • c219d3002f In the showdb utility, the -tmstmp option works without -csv for the pgidx command. drh 2026-01-08 13:20:36 +00:00
  • 9f9ee82b62 Fix ESCALE typo in shell.c, reported in [forum:b8f6a41c8b|forum post b8f6a41c8b]. stephan 2026-01-08 12:43:21 +00:00
  • 67429703bf Do not show LIKE wildcards on table names in the output of the ".schema" command in the CLI. [forum:/info/6ebb57b41691293d|Forum post 6ebb57b41691293d]. drh 2026-01-08 12:39:49 +00:00
  • c0420cd8e4 Add the showtmlog utility for decoding the tmstmpvfs log files. Fix tmstmpvfs so that it records timestamps in milliseconds since the Unix epoch, not in JDN milliseconds. drh 2026-01-08 12:22:50 +00:00
  • e46b51e234 Improve showdb so that it does a better job of handling reserve-bytes. Add the --tmstmp option that causes pgidx to interpret tmstmpvfs tags if they are available. drh 2026-01-08 01:37:13 +00:00
  • 8a2be4b739 Add the tmstmpvfs.c extension to trunk. It is not a part of any deliverable and can easily be removed later, if found to not be desirable. drh 2026-01-08 00:41:12 +00:00
  • ad4b08dcab Add the --csv option to the "pgidx" option to the "showdb" utility. drh 2026-01-07 23:46:44 +00:00
  • bba40a9c9b Enhance the VACUUM INTO command such that if the target file is a URI with a reserve=N query parameter, then the reserve_bytes value is set to N provided that N is within the allowed range. This can even reduce the size of the reserve, all the way to zero. This provides a way to remove reserve from a database without having to do a complete dump/restore. drh 2026-01-07 21:19:42 +00:00
  • ef5d9952eb Fix the static build. timestamp-vfs drh 2026-01-07 19:06:11 +00:00
  • 0b5f8766fd Improvements to logging. Better log-file names. Log files are in a subdirectory named after the database. Only connections that write to the database create logs. Better documentation in the header comment. drh 2026-01-07 18:45:23 +00:00
  • 03c0ac435e Enhance QRF so that it terminates more quickly if it encounters an OOM or oversize string error, and fix it so that it reports such errors. drh 2026-01-07 16:19:18 +00:00
  • 242a9347f8 Add the -p or --port option to sqlite3_rsync. drh 2026-01-06 21:39:12 +00:00
  • 8fe0385661 Documentation tweaks. drh 2026-01-06 21:18:42 +00:00
  • d3c9cce43c Enhance the timestamp-vfs prototype so that it also keeps an event log. drh 2026-01-06 20:51:06 +00:00
  • bcf1c8d6e3 Update to the sqlite3_get_clientdata() documentation. No code changes. drh 2026-01-06 13:00:24 +00:00
  • 55f258bd27 Update the regexp extension so that the "-" character may be escaped with a backslash. Forum post [forum:c5e7358f82 | c5e7358f82]. dan 2026-01-05 18:29:07 +00:00
  • bb4428e605 Add the experimental tmstmpvfs.c extension that adds a timestamp and other debugging information on each page of a database as that page is written, if the database is configured for exactly 16 bytes of reserve space. drh 2026-01-05 17:28:33 +00:00
  • b1e9111249 Fix an uninitialized var use reported in [forum:88561a4a1e|forum post 88561a4a1e]. stephan 2026-01-04 11:05:05 +00:00
  • b8c49d6f62 Fix yet another bug in the EXISTS-to-JOIN optimization. drh 2026-01-03 15:22:08 +00:00
  • 904abc85cf Fix yet another bug in the [/info/e33da6d5dc964db8|EXISTS-to-JOIN] optimization, reported by [forum:/forumpost/2026-01-03T14:05:48z|forum post 2026-01-03T14:05:48z]. drh 2026-01-03 15:11:07 +00:00
  • 0ed2541168 Minor change to an #if in the Windows VFS, which I am told will allow SQLite to be compiled for 64-bit Windows7. drh 2026-01-02 19:42:55 +00:00
  • a303f7914d Ensure that loops created by the exists-to-join optimization use unique cursor numbers, even if the EXISTS expression in the WHERE clause is a copy of an expression from the result-set of the SELECT. drh 2026-01-02 18:53:50 +00:00
  • a0cc06b66b Ensure that loops created by the exists-to-join optimization use unique cursor numbers, even if the EXISTS expression in the WHERE clause is a copy of an expression from the result-set of the SELECT. dbsqlfuzz 4f6a5213cf74fcf2a8a3e48abc2333100348c38e. dan 2026-01-02 17:10:40 +00:00
  • 2b112e0907 Change the shelltest target on the windows makefile to use testrunner.tcl drh 2026-01-02 00:23:22 +00:00
  • b0a1ed2980 Further improvements to testrunner.tcl documentation. drh 2026-01-01 21:35:25 +00:00
  • 6e8afa79e7 Updates to the testrunner documentation. drh 2026-01-01 15:41:50 +00:00
  • db4d8946ef Verify the effect of "--titles on" in the "insert" mode in the CLI. drh 2025-12-31 20:43:31 +00:00
  • f395df1307 The header setting from the legacy ".headers" dot-command takes precedence over the current ".mode" setting, for backwards compatibility. [forum:/forumpost/2025-12-31T19:14:24z|Forum post 2025-12-31T19:14:24z]. drh 2025-12-31 20:35:16 +00:00
  • 02e38b4d21 In the (completely unused, as far as I know) btreeinfo.c extension (not a part of any standard build) do a better job of detecting corrupt database files and provide better error messages when corruption is detected. [forum:/forumpost/e66a458339|Forum post e66a458339]. drh 2025-12-31 19:45:45 +00:00
  • 632632ced3 Use 64-bit integers to track memory allocation sizes in the CSV extension. drh 2025-12-31 18:46:13 +00:00
  • 6789770822 Use 64-bit integers to track memory allocation sizes in the CSV extension. [forum:/forumpost/e66a458339|Forum post e66a458339]. drh 2025-12-31 18:30:45 +00:00