SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 most recent check-ins

2025-02-26
19:22
Teach testrunner how to run local binaries which have a .exe extension. Also teach it to recognized mingw environments (but actually building the test programs there currently doesn't work). (Leaf check-in: e2bd23f2 user: stephan tags: trunk)
18:31
Teach testrunner.tcl to identify an msys environment. (check-in: e9f777ce user: stephan tags: trunk)
17:11
Undo part of [69e83ab859c], as that order of operations breaks the --prefix=... configure flag. Found a workaround for the library version and OS/environment info being emitted when --help. (check-in: cd2a84a7 user: stephan tags: trunk)
16:15
configure: extend the readline detection a bit so that it can find readline on termux environments without having to be told where it is. Fix a typo in a libedit-related message. (check-in: 52f528c4 user: stephan tags: trunk)
09:14
Shift some bootstrapping configure bits to avoid emitting extra output if --help is specified. (check-in: 69e83ab8 user: stephan tags: trunk)
03:32
Merge trunk into the sahpool-digest branch. (Leaf check-in: fc1eeb7d user: stephan tags: sahpool-digest)
03:20
Fix a bug in mkwasmbuilds.c, introduced in [e4539ebebd89], which caused sqlite3.wasm to get deleted directly after it was built. (check-in: 1a72d1d1 user: stephan tags: trunk)
03:03
More work on the sahpool digest fix. New/fixed versions can read legacy (no digest) files but the reverse is only possible in limited circumstances (when files originated from a legacy version). The burning question is whether the real fix would be to remove this digest check altogether, as it only applies in a very limited context, and the fact that it was broken for some 18 months unnoticed suggests that its value might not be worth the CPU cycles. (check-in: 0df62b77 user: stephan tags: sahpool-digest)
2025-02-25
21:16
Disable some misuse tests that sometimes cause segfaults during "make releasetest". (check-in: 5856251a user: drh tags: trunk)
20:55
Approximately 50 typo fixes, spanning the whole tree, contributed via forum post 006c8fa165083ac3 and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. (check-in: af928818 user: stephan tags: trunk)
20:36
Fix a test case that was broken when the default --escape type was changed by the previous check-in. (check-in: 5f2531e0 user: drh tags: trunk)
20:10
Change the default control-character escape algorithm from "symbol" to "ascii", since the "ascii" algorithm works even on terminals that do not support unicode. (check-in: d3532049 user: drh tags: trunk)
20:02
Fix harmless "unused parameter" compiler warnings. (check-in: 7a68a3ea user: drh tags: trunk)
18:10
Improved help messages for the --escape option in the CLI. (check-in: e6784af6 user: drh tags: trunk)
16:48
Configure script cosmetics: emit the host/build system info before the directory info. (Leaf check-in: 9d5b97dd user: stephan tags: branch-3.49)
16:39
Configure script cosmetics: emit the host/build system info before the directory info. (Edit: this mysteriously broke the --prefix=... flag again) (Edit - no, it didn't - it was a test methodology failure.) (check-in: 6f0b6d95 user: stephan tags: trunk)
16:17
Diverse configure tweaks to better support package maintainers on the unix-on-windows environments like msys2, cygwin, and mingw, based largely on feedback in forum posts e6cf2bbb70da2922 and 828fdfe9041fd725. (check-in: 144aacfd user: stephan tags: branch-3.49)
16:11
Restructure [826bad10e9ccd6f71e] as that structure mysteriously breaks the --prefix=... configure flag. (check-in: d284230f user: stephan tags: trunk)
15:57
Enhancements to help avoid problems in the CLI when trying display content that contains ANSI escape codes: (1) Add the --escape MODE option to the CLI where MODE is one of "symbol", "ascii", "off" where the default is "symbol". (2) Add the unistr() SQL function. (3) Add the unistr_quote() SQL function. (4) Add the %#Q and %#q conversions in the built-in printf. (check-in: e3e509ae user: drh tags: trunk)
15:54
Diverse configure tweaks to better support package maintainers on the unix-on-windows environments like msys2, cygwin, and mingw, based largely on feedback in forum posts e6cf2bbb70da2922 and 828fdfe9041fd725. (check-in: 85b56fb0 user: stephan tags: trunk)
15:27
Reinstate the assert() removed by [0f6223b8]. Avoid holding a wal-mode write lock after the transaction has been rolled back if an IO error occurs while restarting the wal file. (check-in: 277e150d user: dan tags: trunk)
13:33
Fix a test script problem causing errors with Tcl 9. (check-in: dbec2c47 user: dan tags: trunk)
12:18
Small performance improvement for the new %#Q conversion in printf. (Closed-Leaf check-in: 17e44078 user: drh tags: unistr)
12:11
Update the autoconf Makefile for nmake to support SETLK_TIMEOUT. (check-in: 46909fe3 user: drh tags: trunk)
11:48
Avoid running certain tests in walsetlk2.test if SQLITE_ENABLE_SETLK_TIMEOUT is set to 2, not 1. (check-in: 86788c08 user: dan tags: trunk)
11:47
Consolidate two different UTF8 encoders into a single subroutine. (check-in: 6208e494 user: drh tags: unistr)
11:29
Remove an assert() added by [e88212b1] that is sometimes false. (check-in: 0f6223b8 user: dan tags: trunk)
2025-02-24
23:34
Fix the new shellA.test test script so that it works with Valgrind. (check-in: c3949852 user: drh tags: unistr)
21:27
Support SQLITE_ENABLE_SETLK_TIMEOUT on windows. (check-in: e88212b1 user: dan tags: trunk)
20:53
Slightly simplify auto.def and autoconf/auto.def. (Closed-Leaf check-in: d84f591b user: stephan tags: configure-dll-support)
20:13
Use an assert() to fix a harmless (false-positive) scan-build warning in the CLI. (check-in: 4c56cd73 user: drh tags: unistr)
18:45
autoconf/auto.def: remove a define which made superfluous by [b8bf966628c0]. Add a check/status message for whether to statically link the library into the CLI shell. (check-in: df95e908 user: stephan tags: configure-dll-support)
18:14
configure: in autoconf build if both --disable-shared and --disable-static-shell are used together, ignore the former and emit a notice to that effect. (check-in: b8bf9666 user: stephan tags: configure-dll-support)
17:50
Only use unistr() in columnar formats when strictly needed. Do not use unistr() in insert mode when --escape is off. More test cases. (check-in: e029828d user: drh tags: unistr)
13:51
Add the unistr_quote() function that works like quote(), but also escape control characters using unistr() if necessary. (check-in: e99e37b5 user: drh tags: unistr)
13:27
Bug fix and initial test-case infrastructure for control-character escaping in the CLI. (check-in: c8099977 user: drh tags: unistr)
12:41
Ongoing work to get all the quoting and escaping variations in the CLI working correctly. (check-in: b77aea93 user: drh tags: unistr)
12:19
Configure doc tweaks. Move the package version/build dir output so that it does not appear at the start of --help text, but otherwise still appears before the first output from low-level config initialization. (check-in: 826bad10 user: stephan tags: configure-dll-support)
11:21
Further consolidation of auto.def and autoconf/auto.def. Note in configure --help that --disable-largefile is a legacy option which has no effect on the library but may influence the generated sqlite_cfg.h. (check-in: 17fd6836 user: stephan tags: configure-dll-support)
10:52
Merge latest changes from trunk into this branch. (Closed-Leaf check-in: 55324d1c user: dan tags: win32-enable-setlk)
10:30
Move the configure output about the SQLite version and build dirs up, so that they appear before any tests for the C compiler and such. (check-in: 83e0f3d1 user: stephan tags: configure-dll-support)
08:42
Further consolidation of the main auto.def and the autoconf auto.def content into sqlite-config.tcl. (check-in: 76a4efa9 user: stephan tags: configure-dll-support)
07:06
Configure-internal doc tweaks. Fix the distclean rules for libsqlite3.dll.a on msys/cygwin/mingw, broken when the DLL basename was changed for those platforms. (check-in: 8641e2c7 user: stephan tags: configure-dll-support)
05:10
Add some internal notes about potential changes for the rpath flag handling. (check-in: 6f904f06 user: stephan tags: configure-dll-support)
04:47
Update jimsh0.c from upstream autosetup to address autosetup ticket #75, triggered by this build in the Gentoo project. (check-in: ffd05de8 user: stephan tags: configure-dll-support)
00:40
Make column output modes in the CLI responsive to the --escape setting. (check-in: 14ff5557 user: drh tags: unistr)
00:18
Three different --escape modes: symbol, ascii, off. (check-in: b5adb52f user: drh tags: unistr)
2025-02-23
20:50
Further improvements to control-character escapes in the CLI. (check-in: 9c2f974c user: drh tags: unistr)
20:20
Work toward VT100-safe output from the CLI by default. (check-in: 44c44620 user: drh tags: unistr)
17:55
Add (disabled) infrastructure for disabling use of the rpath linker flag. This is a proactive precautionary measure because how the rpath is used does not match up with what the unix-on-windows environments do with their DLLs. (check-in: 38ba8e83 user: stephan tags: configure-dll-support)
17:24
Internal cleanups to how certain linker flags are tested. (check-in: 6743e3e5 user: stephan tags: configure-dll-support)
15:34
Internal configure doc cleanups. Apply the [5ecbe7ddc4] unix-on-windows DLL install dir fix to the canonical build. (check-in: 51b9812d user: stephan tags: configure-dll-support)
11:48
The %#Q conversion now adds unistr('...') around the converted string if escape characters were inserted. %#w now works just like %w as escape sequences inside of identifiers are not recognized. (check-in: 997391d4 user: drh tags: unistr)
00:09
Enhance the %Q, %q, and %w printf conversions so that if the alternate-form flag # is present, they transform backslash and control characters into unistr()-style backslash escape codes. (check-in: ffbfcc2b user: drh tags: unistr)
2025-02-22
23:18
Prototype implementation of the unistr() SQL function. (check-in: 7cc302de user: drh tags: unistr)
17:33
Update the help text to account for [35b1c32f80b9]. (check-in: f2e7355d user: stephan tags: configure-dll-support)
17:30
Replace --dll-basename=none with --dll-basename=default. (check-in: 35b1c32f user: stephan tags: configure-dll-support)
16:44
Tamp down various harmless compiler warnings. Use "int" in places instead of "u16" or "i16" since the compiler complains less and generates faster code. (check-in: 742827f0 user: drh tags: trunk)
16:31
On unix-on-windows platforms, if either of --out-implib or --dll-basename are not provided, auto-enable them. Add the 'none' special value to those flags to specifically disable the environment-specific handling of those flags. (check-in: 48640080 user: stephan tags: configure-dll-support)
14:58
Ensure that [08c9e56f60] uses an absolute path when appending .exe to mksourceid. (check-in: 906d27f7 user: stephan tags: configure-dll-support)
14:53
Random non-functional configure script cleanups. (check-in: 2ee73109 user: stephan tags: configure-dll-support)
14:53
tool/mksqlite3h.tcl: when invoking the mksourceid binary, add a .exe to it, if needed, to appease msys2. (check-in: 08c9e56f user: stephan tags: configure-dll-support)
11:40
Fix an incorrect assert added by [d7729dbbf231d57c]. (check-in: eeea1127 user: drh tags: trunk)
00:01
Fix installation rules for import lib in the autoconf bundle, broken by recent refactoring in this branch. (check-in: 95b71fc7 user: stephan tags: configure-dll-support)
2025-02-21
23:43
Rename configure-defined ENABLE_SHARED/STATIC makefile vars to ENABLE_LIB_... so that they're consistent between the canonical and autoconf builds (baby steps towards further configure code consolidation). (check-in: a7647fd0 user: stephan tags: configure-dll-support)
23:27
Configure docs/help text tweaks. No functional changes. (check-in: 701cc1af user: stephan tags: configure-dll-support)
22:46
Only use the platform-specific --dll-basename if that option is explicitly provided, else use libsqlite3. (check-in: 69bacfdc user: stephan tags: configure-dll-support)
22:39
Don't quote dir name in makefile deps, as the quotes are part of the name in that context. (check-in: b0b9e925 user: stephan tags: configure-dll-support)
22:35
Ensure that the prefix/bin dir exists on msys/cygwin installations before installing the DLL there. (check-in: 5ecbe7dd user: stephan tags: configure-dll-support)
21:58
Add --dll-basename flag to give clients control over the DLL's base name. Split the DLL installation makefile rules into digestible, platform-specific chunks. On Windows-side Unix-like environments, install the DLL into the bin dir. Requires testing and feedback from those platforms' package maintainers to confirm it follows the expectated conventions. (check-in: 8d5fed80 user: stephan tags: configure-dll-support)
20:35
The number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN. But the actual number of columns in the implementation might need to be twice as much to account for the primary key at the end. Ensure that the code is able to deal with this. This is a correction to check-in [d7729dbbf231d57c]. (check-in: 5822feec user: drh tags: trunk)
20:28
Extend --out-implib to optionally specify the import lib's name. Add as-yet-unused internals for specifying the DLL's base name (which differs across the Windows-side Unix-esque environments). (check-in: 12a55d34 user: stephan tags: configure-dll-support)
20:22
Makefile-internal var renaming in prep for pending portability-related changes in the handling of DLLs. No functional/build interface changes. (check-in: ebf41fc9 user: stephan tags: trunk)
17:03
Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need to use more than SQLITE_LIMIT_COLUMN columns and raise an error. Also include some unrelated compiler warning fixes. (check-in: d7729dbb user: drh tags: trunk)
03:22
configure: in several places where support for -Wl,... linker flags are checked, ensure that the check invokes the linker (not just the compiler) to avoid false positives. This allows us to remove the AIX-specific handling and --disable-rpath bits added in [a15e0f680], as well as make several similar checks more robust. (check-in: 47c43fcb user: stephan tags: branch-3.49)
03:19
configure: in several places where support for -Wl,... linker flags are checked, ensure that the check invokes the linker (not just the compiler) to avoid false positives. This allows us to remove the AIX-specific handling and --disable-rpath bits added in [a15e0f680], as well as make several similar checks more robust. (check-in: 4e81e2c7 user: stephan tags: trunk)
2025-02-20
17:16
Bump VERSION to 3.49.2. (check-in: eaa2503e user: stephan tags: branch-3.49)
17:15
configure: automatically fail the check for rpath on AIX systems and provide a --disable-rpath flag as a fallback for use on platforms which pass the configure-time rpath check but then fail at link-time. Based on discussion in forum thread ae5bd8a84b. (check-in: b6603986 user: stephan tags: branch-3.49)
17:14
configure: automatically fail the check for rpath on AIX systems and provide a --disable-rpath flag as a fallback for use on platforms which pass the configure-time rpath check but then fail at link-time. Based on discussion in forum thread ae5bd8a84b. (check-in: a15e0f68 user: stephan tags: trunk)
16:47
Fix autoconf bundle to honor the --disable-static and --disable-shared flags, as reported in forum post ae5bd8a84b. Problem introduced in 3.49.0. (check-in: e5ea86dc user: stephan tags: branch-3.49)
16:45
Fix autoconf bundle to honor the --disable-static and --disable-shared flags, as reported in forum post ae5bd8a84b. Problem introduced in 3.49.0. (check-in: 56027220 user: stephan tags: trunk)
12:34
Experimental prototype for "PRAGMA loadall(TABLE_OR_INDEX)". (Leaf check-in: f24e4d7b user: drh tags: pragma-loadall)
05:39
wasm: do not build the (untested/unsupported) node-for-node build by default, to cut build time by about 15%. Adjacent cleanups in mkwasmbuilds.c. (check-in: e4539ebe user: stephan tags: trunk)
04:45
wasm makefile docs: make explicit that the node.js-for-node.js builds (as opposed to the node.js-for-browser builds) are both untested and unsupported. (check-in: e1f18488 user: stephan tags: trunk)
04:14
Add the pause/unpause capability to the opfs-sahpool VFS, as discussed in forum thread fe8cdb8431c. Summary: this gives clients a way to eke some degree of multi-page/tab/Worker concurrency out of this VFS but requires that coordination to be implemented client-side, e.g. via a SharedWorker or WebLocks. (check-in: b5dbd521 user: stephan tags: trunk)
03:27
configure: when running proj-check-function-in-lib, strip -Werror from CFLAGS for the duration of the test. This enables CFLAGS='-Wall -Werror' and the like to be passed to configure without breaking these configure-time checks. (check-in: 4ae9d6c6 user: stephan tags: trunk)
2025-02-19
13:05
Increase default CLI shell .prompt buffer length to 128 bytes, based on discussion in forum post 362f185a6aa. (check-in: 628407f0 user: stephan tags: trunk)
13:02
Slight tweak to the CLI shell help output to help convey that it can accept multiple SQL arguments, as suggested in forum post 20e617feee. (check-in: 82fc6707 user: stephan tags: trunk)
00:18
Version 3.44.4 (Leaf check-in: f1e31fd9 user: drh tags: release, branch-3.44, version-3.44.4)
2025-02-18
20:27
Add the SQLITE_MEM5_FAILOVER compile-time option, which if enabled allows MEMSYS5 to go out to the system heap if it is unable to fulfill an allocation request. (Leaf check-in: bdd8617b user: drh tags: mem5-failover)
18:05
Cherry pick recent fixes into branch-3.44. (check-in: 75bbd094 user: drh tags: branch-3.44)
15:11
Have SQLITE_FTS5_ENABLE_TEST_MI builds avoid reading the database schema from within sqlite3_open(). (check-in: 15dc524f user: dan tags: trunk)
14:56
Merge the latest trunk enhancements into the reuse-schema branch. (Leaf check-in: b2bf0630 user: drh tags: reuse-schema)
14:48
Merge the latest trunk enhancements into the bedrock branch. (Leaf check-in: c09656c6 user: drh tags: bedrock)
14:38
Merge all the latest trunk enhancements into the wal2 branch. (Leaf check-in: bd465165 user: drh tags: wal2)
14:37
Merge all the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 3c87a6d1 user: drh tags: begin-concurrent)
13:38
Version 3.49.1 (check-in: 873d4e27 user: drh tags: release, branch-3.49, version-3.49.1)
01:16
Update path on the web server for test/snapshot instances of fiddle. (check-in: 57caa313 user: stephan tags: trunk)
2025-02-17
20:13
Add an ORDER BY to a test case for skip-scan to make the output consistent. (check-in: 9c9c1941 user: drh tags: trunk)
19:44
Fix problems in test script fkey6.test. (check-in: 088e4765 user: dan tags: trunk)