]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
15 months agoNew #ifdefs to omit code that is unused when SQLITE_USE_LONG DOUBLE is defined.
drh [Tue, 1 Oct 2024 19:10:47 +0000 (19:10 +0000)] 
New #ifdefs to omit code that is unused when SQLITE_USE_LONG DOUBLE is defined.

FossilOrigin-Name: 98066e2d226e7d2eceec1931a1432baea956f49bf3c708d8a6d511fa4e864ca3

15 months agoAnother comment about the LONGDOUBLE wasm topic. No code changes.
stephan [Tue, 1 Oct 2024 17:57:55 +0000 (17:57 +0000)] 
Another comment about the LONGDOUBLE wasm topic. No code changes.

FossilOrigin-Name: 1755831cb1ac58241e0b11d8d003b5eca39b65aa3cb84229b215662028b1b3c0

15 months agoUse the new SQLITE_USE_LONG_DOUBLE to disable long-double support in WASM builds...
stephan [Tue, 1 Oct 2024 17:08:23 +0000 (17:08 +0000)] 
Use the new SQLITE_USE_LONG_DOUBLE to disable long-double support in WASM builds, as they cannot be represented in JS and this saves approximately 5.5kb in the resulting wasm file.

FossilOrigin-Name: fa7b56f776b715d061581fad6f04b871504ff5d808e7364419d1d6cdef82c5ee

15 months agoAdd compile-time option -DSQLITE_USE_LONG_DOUBLE=0 to omit all attempts to use
drh [Tue, 1 Oct 2024 16:55:30 +0000 (16:55 +0000)] 
Add compile-time option -DSQLITE_USE_LONG_DOUBLE=0 to omit all attempts to use
"long double".  Or =1 to omit attempts to use the Dekker algorithms to achieve
high-resolution floating point.

FossilOrigin-Name: ca5964ef70efad3332e0bf9c158eb5fd5006d3022051d1ac506c097c427735a1

15 months agoGet more of the CLI utils building.
stephan [Tue, 1 Oct 2024 13:40:59 +0000 (13:40 +0000)] 
Get more of the CLI utils building.

FossilOrigin-Name: 6838b7b5d6130b1e0af9a71ad2c5922b1ef35f082907dffeed03811e1e62406f

15 months agoCorrect missing LDFLAGS_ZLIB for libsqlite3.so.
stephan [Tue, 1 Oct 2024 11:09:50 +0000 (11:09 +0000)] 
Correct missing LDFLAGS_ZLIB for libsqlite3.so.

FossilOrigin-Name: 98bbba3a05734e080a0c8c51fac0368436809d4ff3c39959a51970400b4470cb

15 months agoFix reversed logic in the build/target/host names in several hwaci-* functions.
stephan [Tue, 1 Oct 2024 11:04:02 +0000 (11:04 +0000)] 
Fix reversed logic in the build/target/host names in several hwaci-* functions.

FossilOrigin-Name: fde7257ad9ce84be6d907be3c6d277b04dd9466ee6828bfded4cfefc86db22db

15 months agoAdd an #if'd-out block to sqlite3-wasm.c mentioning the LONGDOUBLE_TYPE, as brought...
stephan [Tue, 1 Oct 2024 10:49:30 +0000 (10:49 +0000)] 
Add an #if'd-out block to sqlite3-wasm.c mentioning the LONGDOUBLE_TYPE, as brought up in [forum:cbfb0d0ac0a4e349 | forum post cbfb0d0ac]. No functional changes.

FossilOrigin-Name: 0b83e8f1ef53b35a9dda0740b4922b8691428f7484f3058833a961f3f8d0b178

15 months agoAdd static library build. Get build working (for a given value of working) with the...
stephan [Mon, 30 Sep 2024 19:01:41 +0000 (19:01 +0000)] 
Add static library build. Get build working (for a given value of working) with the --disable-amalgamation flag.

FossilOrigin-Name: ddfda58004fa3e43c4f2d497c6feecbea3b195d14196bf179f4aafd21ea089ea

15 months agoFix the character width tables for the CLI such that all unicode code-points
drh [Mon, 30 Sep 2024 18:19:38 +0000 (18:19 +0000)] 
Fix the character width tables for the CLI such that all unicode code-points
less than 0x300 have a width of 1.  This is in fact the case for Mac, Ubuntu,
and Windows.

FossilOrigin-Name: f0c5a86fefecded07e098e1326dd54c72504b0bb480f710e395d4041a322dfcb

15 months agoMore generic build tinkering.
stephan [Mon, 30 Sep 2024 17:44:41 +0000 (17:44 +0000)] 
More generic build tinkering.

FossilOrigin-Name: 433bfc790258e1d2e7c9ea4839a9edb25dde0b99d1e888d1e2a4cf669825fb79

15 months agoIn fts5, avoid starting a new merge of level L if there exists already an ongoing...
dan [Mon, 30 Sep 2024 17:28:45 +0000 (17:28 +0000)] 
In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L.

FossilOrigin-Name: 350c6e75ce3c1e81458d1baa73045df489284206e8b279ab3c2f5e3d011c262a

15 months agoGeneric build tinkering.
stephan [Mon, 30 Sep 2024 14:33:36 +0000 (14:33 +0000)] 
Generic build tinkering.

FossilOrigin-Name: b6c1772ce0278988ecaea485c4feb8b0919fa1530f0c53b8321d9bd2277b5acd

15 months agoRationalize some of the new code on this branch.
dan [Sat, 28 Sep 2024 20:45:11 +0000 (20:45 +0000)] 
Rationalize some of the new code on this branch.

FossilOrigin-Name: 66f209ba40e7de49b304d7931ff38a4994038452aab08e9347286a234c6f7075

15 months agoFix the CLI so that the --bom option only outputs a single BOM, not two.
drh [Sat, 28 Sep 2024 19:52:38 +0000 (19:52 +0000)] 
Fix the CLI so that the --bom option only outputs a single BOM, not two.

FossilOrigin-Name: 76b6331e6a705a420a64820a18214f07cf4c1d5151e7158d6fff09964e63f352

15 months agoMerge trunk changes into this branch. fts5-contentless-unindexed
dan [Sat, 28 Sep 2024 15:20:13 +0000 (15:20 +0000)] 
Merge trunk changes into this branch.

FossilOrigin-Name: 81d48df62ccf8b56e7adbc5327103e8ab5499bb22e587c4f0d0780a66adbdb67

15 months agoAdd another missing mkdir to the wasm build process.
stephan [Sat, 28 Sep 2024 15:13:49 +0000 (15:13 +0000)] 
Add another missing mkdir to the wasm build process.

FossilOrigin-Name: e815055b321085deda8607ac3279ef1a1c890fe3bf9d9b9c0a74028e87857a7d

15 months agoAdd tests for DELETE on contentless, contentless-delete and contentless-unindexed...
dan [Sat, 28 Sep 2024 15:09:43 +0000 (15:09 +0000)] 
Add tests for DELETE on contentless, contentless-delete and contentless-unindexed fts5 tables.

FossilOrigin-Name: 74832fffb61d5e09ff256622cc9aa1fd2c40d30324c410bd6a8c688f0506a536

15 months agoGet libsqlite3.so building.
stephan [Sat, 28 Sep 2024 14:51:10 +0000 (14:51 +0000)] 
Get libsqlite3.so building.

FossilOrigin-Name: c65e3679e0d28e980bb555b47f31690b27915d9ff0850f598e3bed528b18ca1d

15 months agoComplete a line of documentation which was interrupted mid-sentence.
stephan [Sat, 28 Sep 2024 13:51:47 +0000 (13:51 +0000)] 
Complete a line of documentation which was interrupted mid-sentence.

FossilOrigin-Name: c9cbbeda3d1ec4215396aaaf94428b829c4f53329431fa61251914c195f8a9a1

15 months agowasm: move the makefile-eval-generated fiddle rules into mkwasmbuilds.c. Squelch...
stephan [Sat, 28 Sep 2024 12:01:10 +0000 (12:01 +0000)] 
wasm: move the makefile-eval-generated fiddle rules into mkwasmbuilds.c. Squelch some warnings from grep when running 'make clean' on a clean tree.

FossilOrigin-Name: 0485d1360b0dbf9987d16ab1df47b6b7a25595881581799f87889f6d4eeb60f4

15 months agoEnsure that the temporary build dir is mkdir'd by wasm deps which depend on it.
stephan [Sat, 28 Sep 2024 11:23:09 +0000 (11:23 +0000)] 
Ensure that the temporary build dir is mkdir'd by wasm deps which depend on it.

FossilOrigin-Name: cabdf9797281090ab3f95c9f4c2a79878d1c64d1f2a09e433e2309abe5e19e59

15 months agoFor wasm builds: automatically use higher optimization (but slower build) levels...
stephan [Sat, 28 Sep 2024 11:03:00 +0000 (11:03 +0000)] 
For wasm builds: automatically use higher optimization (but slower build) levels when a target related to deliverables (as opposed to dev mode) is explicitly invoked.

FossilOrigin-Name: 45361ab9744ccac3419d97fe8951838f14bd28220e3f7f747b39e46cfc3b5a1d

15 months agoLatest upstream autosetup for a --help fix on QNX.
stephan [Sat, 28 Sep 2024 00:41:34 +0000 (00:41 +0000)] 
Latest upstream autosetup for a --help fix on QNX.

FossilOrigin-Name: b9faebbb543fb3a03f46dd4defe28ffa0c32a9a46ed73912f93b86e41f3db04a

15 months agoMinor makefile doc fixes. No functional changes.
stephan [Sat, 28 Sep 2024 00:39:19 +0000 (00:39 +0000)] 
Minor makefile doc fixes. No functional changes.

FossilOrigin-Name: b3ad58e1fc73941f2d32bab0e0fac0b95849ae69f84788a431e65bb072e42db5

15 months agoMerge trunk into autosetup branch for latest wasm pieces.
stephan [Sat, 28 Sep 2024 00:37:23 +0000 (00:37 +0000)] 
Merge trunk into autosetup branch for latest wasm pieces.

FossilOrigin-Name: c3877d1241f946b470a7a4868f13e1106e8aac4851d4bc5a64c90e0569444b81

15 months agoMerge wasm-build-rework branch into trunk. Summary: 1) add optional bare-bones build...
stephan [Sat, 28 Sep 2024 00:02:52 +0000 (00:02 +0000)] 
Merge wasm-build-rework branch into trunk. Summary: 1) add optional bare-bones build, stripped of many optional library features, 2) replace much of the hyper-spaghetti wasm-specific makefile code with a more legible static code generator.

FossilOrigin-Name: 208c27714646c9bc26eef11266086a71da04bc24e87078de0955e7beb68a821e

15 months agoFix fiddle build broken by recent build-level reworks. Remove a stale reference to... wasm-build-rework
stephan [Fri, 27 Sep 2024 23:45:40 +0000 (23:45 +0000)] 
Fix fiddle build broken by recent build-level reworks. Remove a stale reference to an old CSS file.

FossilOrigin-Name: f904b3b7842da036c3e8423bae02cdf207573c92dc379a601eae289eb3c5f547

15 months agoExtra test cases for UPDATEs of contentless tables.
dan [Fri, 27 Sep 2024 19:21:09 +0000 (19:21 +0000)] 
Extra test cases for UPDATEs of contentless tables.

FossilOrigin-Name: 4d11d844de3edd82f022c36381ca7f14a546a608293c329b91e7f041cec82ff5

15 months agoFix a problem with UPDATE statements that modify the rowid of contentless_delete...
dan [Fri, 27 Sep 2024 19:10:54 +0000 (19:10 +0000)] 
Fix a problem with UPDATE statements that modify the rowid of contentless_delete=1 tables.

FossilOrigin-Name: d69abca82145465c85241a12322986f22bf12ffe42f86c2c8e8e2f2a77d53bf8

15 months agoFix a problem with UPDATEs that do not modify all UNINDEXED columns of a contentless_...
dan [Fri, 27 Sep 2024 18:32:52 +0000 (18:32 +0000)] 
Fix a problem with UPDATEs that do not modify all UNINDEXED columns of a contentless_delete=1, contentless_unindexed=1 table.

FossilOrigin-Name: b6b1db8d343d3e55c3a5589af3ec629762e06c6b689b77defd445347198cb2e7

15 months agoMerge trunk into the autosetup branch.
stephan [Fri, 27 Sep 2024 16:43:47 +0000 (16:43 +0000)] 
Merge trunk into the autosetup branch.

FossilOrigin-Name: 9586ea204c705430d63e3757f80009a152b89573a75c6862e407062be8ef346c

15 months agoSquash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post...
stephan [Fri, 27 Sep 2024 16:20:03 +0000 (16:20 +0000)] 
Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8].

FossilOrigin-Name: e74fce93c518296bdb0a4273cd5fd3f785d37d27750ca456b61a3502135775f9

15 months agoAdd basic libreadline detection and build CLI shell.
stephan [Fri, 27 Sep 2024 13:29:50 +0000 (13:29 +0000)] 
Add basic libreadline detection and build CLI shell.

FossilOrigin-Name: 2ba7ab562580667bc9249f2d1f2402c605553d5583eec497398abe6d196c83d4

15 months agoGeneral tinkering and cleanups in the autosetup bits.
stephan [Fri, 27 Sep 2024 12:15:14 +0000 (12:15 +0000)] 
General tinkering and cleanups in the autosetup bits.

FossilOrigin-Name: a290e3b15de75f6a0a4975b5747449525fb2b58b3947b8ca0ab64a4d3cca228e

15 months agoMerge trunk changes into this branch.
dan [Fri, 27 Sep 2024 11:35:22 +0000 (11:35 +0000)] 
Merge trunk changes into this branch.

FossilOrigin-Name: 4a26a4e0015bc42b1d007def3750caf7baefe429270a295cc2f4499c98c07247

15 months agoAllow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing...
dan [Fri, 27 Sep 2024 10:57:41 +0000 (10:57 +0000)] 
Allow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing to come.

FossilOrigin-Name: cd36d66c88d7282eb0a3ccde5713253f72f5843e451b2693b71adfdae28b41fb

15 months agoRename TCL_GENERATOR to BTCL for consistency with BCC/TCC.
stephan [Fri, 27 Sep 2024 09:40:55 +0000 (09:40 +0000)] 
Rename TCL_GENERATOR to BTCL for consistency with BCC/TCC.

FossilOrigin-Name: a7ff8f3c2c86f435a08d568a07f019a59dcca8f66a719d242289fa0c7097c2af

15 months agoDisable the optional extending of JimTCL on the grounds of YAGNI.
stephan [Fri, 27 Sep 2024 03:16:01 +0000 (03:16 +0000)] 
Disable the optional extending of JimTCL on the grounds of YAGNI.

FossilOrigin-Name: f395c269d55c2b5ceb074f26d0b63f65b1f04ec513fe203c7e73e3a876b1f055

15 months agoGeneral auto.def cleanups, mostly around JimTCL. Swap out impl for the sqlite_cfg...
stephan [Fri, 27 Sep 2024 03:04:16 +0000 (03:04 +0000)] 
General auto.def cleanups, mostly around JimTCL. Swap out impl for the sqlite_cfg.h generator - this approach is lower-maintenance (requires no hand-maintained template) but may not be compatible with expectations.

FossilOrigin-Name: da197946dbaacedb6e74827db9b5dd195d4aaf78ad9411a14aca732ab77917c6

15 months agoTweak build to fall back to system-side tclsh if we cannot find realpath() or _fullpa...
stephan [Fri, 27 Sep 2024 02:35:41 +0000 (02:35 +0000)] 
Tweak build to fall back to system-side tclsh if we cannot find realpath() or _fullpath() for JimTCL (needed for some of the code generator scripts to work).

FossilOrigin-Name: b31dbb9945d0ac5e22d146565443bcdc0dd1a1c83034cfb5867b2303ada2bdea

15 months agoRun all of the TCL-based code generators using JimTCL.
stephan [Fri, 27 Sep 2024 01:42:52 +0000 (01:42 +0000)] 
Run all of the TCL-based code generators using JimTCL.

FossilOrigin-Name: 3193b86a91d8096be68cb83133c7665129694521d7da81bf725e285c229271f7

15 months agoGenerate sqlite3.h/.c with jimsh, somewhat to my surprise.
stephan [Fri, 27 Sep 2024 01:30:34 +0000 (01:30 +0000)] 
Generate sqlite3.h/.c with jimsh, somewhat to my surprise.

FossilOrigin-Name: c365d8e1f7aa19e424f60f976db683c3ccb489900124811541e02d47f9a1cbe3

15 months agoExperimentally build shell.c using the autosetup-provided JimTCL.
stephan [Fri, 27 Sep 2024 01:25:49 +0000 (01:25 +0000)] 
Experimentally build shell.c using the autosetup-provided JimTCL.

FossilOrigin-Name: 5bd62cdbc4b188a59c83fb04685f9967d6a5270772eb48f950a5d86409eb8a1b

15 months agoRemove some gratuitous overengineering before it can spread.
stephan [Fri, 27 Sep 2024 01:04:09 +0000 (01:04 +0000)] 
Remove some gratuitous overengineering before it can spread.

FossilOrigin-Name: 94340011ed903434cd12ca982f226c548f7ec43019d449b4ee12e18ec886fb27

15 months agoGet the generated .c/.h files generating.
stephan [Fri, 27 Sep 2024 01:00:32 +0000 (01:00 +0000)] 
Get the generated .c/.h files generating.

FossilOrigin-Name: e890c8508da4e126f43c61f809f750d6cb2d7d01600fe2173fbcd7dabbfce0fd

15 months agoFix a harmless compiler warning in the CLI.
drh [Thu, 26 Sep 2024 22:25:13 +0000 (22:25 +0000)] 
Fix a harmless compiler warning in the CLI.

FossilOrigin-Name: 27ef1909bb0c4d9470c6074b40500632c68341127a079a3eb3b6a19dbfb2aeac

15 months agoRe-indent some tcl code.
stephan [Thu, 26 Sep 2024 21:09:22 +0000 (21:09 +0000)] 
Re-indent some tcl code.

FossilOrigin-Name: 34ea629a07bfb00c86df7c62462bf2d699347c34dcb7656c86f5f76b52d33b30

15 months agoLatest hwaci-common.tcl after refactoring to facilitate including a copy in the libfo...
stephan [Thu, 26 Sep 2024 21:08:00 +0000 (21:08 +0000)] 
Latest hwaci-common.tcl after refactoring to facilitate including a copy in the libfossil tree.

FossilOrigin-Name: feea65bcd54f9266445bc4d65ea5e3cfadee8e3abff5b682e31cdc0034354fbf

15 months agoAdd the ext/misc/sqlite3_stdio.c portability interface and incorporate it
drh [Thu, 26 Sep 2024 19:38:34 +0000 (19:38 +0000)] 
Add the ext/misc/sqlite3_stdio.c portability interface and incorporate it
into the CLI, sqldiff, and sqlite3_analyzer.  Enhance the CLI with the new
".www" dot-command and related options on .once and .output.

FossilOrigin-Name: f97f9944b829a49da12786f934da0a5ad51591afd6d8a19a4a0835f51bbdbff2

15 months agoProvide SQLITE_U8TEXT_ONLY and SQLITE_U8TEXT_STDIO compile-time options cli-stdlib
drh [Thu, 26 Sep 2024 19:16:20 +0000 (19:16 +0000)] 
Provide SQLITE_U8TEXT_ONLY and SQLITE_U8TEXT_STDIO compile-time options
to the sqlite3_stdio.c module.

FossilOrigin-Name: f31588520e3f45b50dcaa9eecab17f52ebb56bb53d0f9bdb88cc596d1a156353

15 months agoGet lemon building. Re-indent hwaci-common.tcl for consistency.
stephan [Thu, 26 Sep 2024 18:40:07 +0000 (18:40 +0000)] 
Get lemon building. Re-indent hwaci-common.tcl for consistency.

FossilOrigin-Name: 53dc33d5e20062e8c4c9856349bbc143c858327ef41f356ffcc574b36d0cc73c

15 months agoResolve a harmless compiler warning in QNX builds.
stephan [Thu, 26 Sep 2024 18:13:10 +0000 (18:13 +0000)] 
Resolve a harmless compiler warning in QNX builds.

FossilOrigin-Name: 2916460179c6089375188c6e4e3cff1fca5bbbbb7280a10c919e09e75d1f11f8

15 months agoWhen possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get().
dan [Thu, 26 Sep 2024 18:02:17 +0000 (18:02 +0000)] 
When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get().

FossilOrigin-Name: 34b6ac3d76dbc6819778ec2a0f81cbcdcc0cd1a6303381d97f1c479e4ecdd132

15 months agoDo not remove *.def in the cleanup rules because auto.def is a required part of autos...
stephan [Thu, 26 Sep 2024 14:09:23 +0000 (14:09 +0000)] 
Do not remove *.def in the cleanup rules because auto.def is a required part of autosetup. Remove the .o vs .obj detection/distinction because the Unix-like Windows environments use .o.

FossilOrigin-Name: 65eb1072e297f01ba4ce21fe644f709e75ebaec5307764b549efceafb88f6ebf

15 months agoClarification of the meaning of the nByte parameter to sqlite3_prepare().
drh [Thu, 26 Sep 2024 13:12:19 +0000 (13:12 +0000)] 
Clarification of the meaning of the nByte parameter to sqlite3_prepare().
Comment and documentation change only - no changes to the code.

FossilOrigin-Name: 92d71eee4f3a5edb3877c108d14972d80654982b0de3e635d9d008e9d3b6591f

15 months agoCleanups of the --with-wasi-sdk bits. Straighten out VERSION vs RELEASE.
stephan [Thu, 26 Sep 2024 12:16:46 +0000 (12:16 +0000)] 
Cleanups of the --with-wasi-sdk bits. Straighten out VERSION vs RELEASE.

FossilOrigin-Name: 7638f3ad1588ff16c2980763c6c4c1386a711acd64adb21c465f186a47bc975d

15 months agoMerge current trunk into this branch.
stephan [Thu, 26 Sep 2024 08:53:37 +0000 (08:53 +0000)] 
Merge current trunk into this branch.

FossilOrigin-Name: 683a9e1e2f68a5c34fe524867576a4405fa2460880ad0bf4c07799744fea4192

15 months agoRemove a misled acrobatics related to cross-compilation, based on suggestions from...
stephan [Thu, 26 Sep 2024 08:25:10 +0000 (08:25 +0000)] 
Remove a misled acrobatics related to cross-compilation, based on suggestions from Steve Bennett. Add a quick-n-dirty placeholder check for tclsh to move that part along.

FossilOrigin-Name: c419168938b009b2cf8a42a01272971497b5329792ccb8cef235f47ab5f142e2

15 months agoFix shell test cases to account for recent additions to the ".help" output.
drh [Thu, 26 Sep 2024 01:29:22 +0000 (01:29 +0000)] 
Fix shell test cases to account for recent additions to the ".help" output.

FossilOrigin-Name: 54c22bc6165affbea0d1166a0912d19939300ccc4ae33a6b2ed8c510ab61c574

15 months agoTime for a break.
stephan [Wed, 25 Sep 2024 23:09:38 +0000 (23:09 +0000)] 
Time for a break.

FossilOrigin-Name: 1d29cd9095595b7b027b90d644dc4767fde0b6f98316c0eb82014b7aad6770d7

15 months agoIntegrate the configure-time Emscripten bits.
stephan [Wed, 25 Sep 2024 22:13:49 +0000 (22:13 +0000)] 
Integrate the configure-time Emscripten bits.

FossilOrigin-Name: 456125a14454180d608d8f5bc651aa4350958cdd14f4011ef540beb278ca2d51

15 months agoChange the way tokendata indexes are collected for prefix queries.
dan [Wed, 25 Sep 2024 18:55:11 +0000 (18:55 +0000)] 
Change the way tokendata indexes are collected for prefix queries.

FossilOrigin-Name: 204ddf4e726b695dd12ab4a945ec2461655aa0bcc38b74e970f07ed2ac43c6ff

15 months agoFurther streamlining of auto.def.
stephan [Wed, 25 Sep 2024 18:03:26 +0000 (18:03 +0000)] 
Further streamlining of auto.def.

FossilOrigin-Name: 74d12433599e2f189d8d0a44be834651531ac5a215bf42de386053cd00d29162

15 months agoAlways show HTML table headers in ".www" output mode.
drh [Wed, 25 Sep 2024 16:11:27 +0000 (16:11 +0000)] 
Always show HTML table headers in ".www" output mode.

FossilOrigin-Name: 660ca5ce6600d897cc2b00b9d39e5d993c1c0e71ec0d5dc706246c053a163281

15 months agoAdd the --plain option to the ".www" dot-command.
drh [Wed, 25 Sep 2024 15:55:52 +0000 (15:55 +0000)] 
Add the --plain option to the ".www" dot-command.

FossilOrigin-Name: a9209519f612e66cfe11c89e70efd8285a0185ac0d3e5795846aafbd05d7a21f

15 months agoHave the zipfile and fileio extensions use sqlite3_stdio.c when it is
drh [Wed, 25 Sep 2024 15:26:37 +0000 (15:26 +0000)] 
Have the zipfile and fileio extensions use sqlite3_stdio.c when it is
available - such as when those extensions are preloaded into the CLI.

FossilOrigin-Name: 74bbb2b2b4507d9acbd91209a2ce341968e9ff64f3aebe9e817bfe488d39ae03

15 months agoImprove common feature flag handling a bit.
stephan [Wed, 25 Sep 2024 14:58:09 +0000 (14:58 +0000)] 
Improve common feature flag handling a bit.

FossilOrigin-Name: 8716c35eaa168677a10de7b4aa55d35c54035f5e685cc1a5890b940a41cc6ff7

15 months agoLots of work on auto.def and the utility tcl lib. Still lots more to do.
stephan [Wed, 25 Sep 2024 14:38:46 +0000 (14:38 +0000)] 
Lots of work on auto.def and the utility tcl lib. Still lots more to do.

FossilOrigin-Name: 2141527a38ca8170e79b5b5e664378f0d8464055119f5b986e5d7b1be75e919e

15 months agoRedirect timer output just like any other text.
drh [Wed, 25 Sep 2024 14:09:47 +0000 (14:09 +0000)] 
Redirect timer output just like any other text.

FossilOrigin-Name: 3b5ae21074958788b23ccf449e52fbbad1f81779e07a6ca62ad8395f88a37286

15 months agoImprovements to ".www" and ".output -w" so that text that is not part of
drh [Wed, 25 Sep 2024 13:56:05 +0000 (13:56 +0000)] 
Improvements to ".www" and ".output -w" so that text that is not part of
query output is shown using <pre>.

FossilOrigin-Name: f8ef65c52305b2180ec56760f5762ac5638584cd504c79d57e86f61736901aa4

15 months agoAdd the "www" output mode that include <table> in the HTML output.
drh [Wed, 25 Sep 2024 13:29:03 +0000 (13:29 +0000)] 
Add the "www" output mode that include <table> in the HTML output.
Add the ".www" command and the "-w" option to ".once".

FossilOrigin-Name: b06fd9e6bcce09f12c994dc34f329a8d267ea0601bb07c9b00903c5017d55d42

15 months agoAlways include a UTF-8 BOM at the beginning of the output CSV when using
drh [Wed, 25 Sep 2024 12:56:44 +0000 (12:56 +0000)] 
Always include a UTF-8 BOM at the beginning of the output CSV when using
the ".excel" command on Windows, as the actual Excel program requires the
BOM in order to work correctly.

FossilOrigin-Name: 04727fc00207325a76a5d5f20549c00232810ac727dedb70bc9e8112e60b3f56

15 months agoChange --enable-tempstore to --with-tempstore to avoid the uphill (and losing) battle...
stephan [Wed, 25 Sep 2024 12:16:13 +0000 (12:16 +0000)] 
Change --enable-tempstore to --with-tempstore to avoid the uphill (and losing) battle with autosetup's built-in handling of the --enable/--disable prefixes.

FossilOrigin-Name: 8bea45fbbf8557760e792cdfcede72afa9e25dd7b90e4ce3297efebe8d0cfb1c

15 months agoPrevent regular DELETE and UPDATE statements from running against contentless_unindex...
dan [Wed, 25 Sep 2024 12:03:08 +0000 (12:03 +0000)] 
Prevent regular DELETE and UPDATE statements from running against contentless_unindexed=1 tables that are not also contentless_delete=1.

FossilOrigin-Name: 21539e9d0d57fdc762affbce9220d1bb1ca009d9dc751b4ccfe63eecbbe2f575

15 months agoFix stray fputs() calls in the CLI.
drh [Wed, 25 Sep 2024 11:38:00 +0000 (11:38 +0000)] 
Fix stray fputs() calls in the CLI.

FossilOrigin-Name: 1ee3fa0f0e87a61b5700abd56547c4acefe999317b0d53d66d890d9e09d8b7d9

15 months agoUse sqlite3_fgets() instead of fgetc() to end the startup debugging pause
drh [Wed, 25 Sep 2024 11:27:59 +0000 (11:27 +0000)] 
Use sqlite3_fgets() instead of fgetc() to end the startup debugging pause
in the CLI.

FossilOrigin-Name: 869b3c05e852a797b5801a81d30a1f7955c31afad0274327f7af2284b555f23a

15 months agoMerge trunk enhancements, and especially the zero- and double-width character
drh [Wed, 25 Sep 2024 09:43:05 +0000 (09:43 +0000)] 
Merge trunk enhancements, and especially the zero- and double-width character
processing for columnar outputs into the cli-stdlib branch.

FossilOrigin-Name: d6262a4bcd7b0334b23ae4d194ca2bce7c6554ee6c678666b24c830e4c14a467

15 months agoIn the CLI, for columnar output formats, try to account for the presence of
drh [Wed, 25 Sep 2024 09:39:11 +0000 (09:39 +0000)] 
In the CLI, for columnar output formats, try to account for the presence of
zero-width and double-width characters in the output and adjust column widths
accordingly.

FossilOrigin-Name: 9592b9ba3ad7a842cdd4c4010da278485a6fdec7e811bda01ebe640162a8c3b6

15 months agoImprovements to comments on data structures and subroutines. variable-width-char
drh [Wed, 25 Sep 2024 09:33:14 +0000 (09:33 +0000)] 
Improvements to comments on data structures and subroutines.

FossilOrigin-Name: b217e3004b58af0e777726bdd652b999ad41815261299ef4ce8f8d2f6b0afe8d

15 months agoBaby steps towards a working auto.def.
stephan [Wed, 25 Sep 2024 08:04:14 +0000 (08:04 +0000)] 
Baby steps towards a working auto.def.

FossilOrigin-Name: c223dbb4fb8e800089752617c6c986b6c80be0d180e9d1610f28cf95253e5674

15 months agoAdd --enable-tempstore support and document some of the weirdness of trying to use...
stephan [Wed, 25 Sep 2024 07:30:54 +0000 (07:30 +0000)] 
Add --enable-tempstore support and document some of the weirdness of trying to use an explicit prefix of --enable with non-boolean flags (autosetup unconditionally handles --enable and --disable prefixes on its own and always treats them as boolean flags).

FossilOrigin-Name: fe6fa4ce5271c6265985574e1c406dda5b57f0dc360626800b6173a8f054bdab

15 months agoRe-enable the --enable-all bits after figuring out that autosetup(options) is not...
stephan [Wed, 25 Sep 2024 06:25:33 +0000 (06:25 +0000)] 
Re-enable the --enable-all bits after figuring out that autosetup(options) is not a dict, but a list.

FossilOrigin-Name: beb2a12045447586cc74f243d4f519c967595d929abe6330c2b1049897e8eaad

15 months agoDisable with --enable-all bits, as the helper function it uses is dying for reasons...
stephan [Wed, 25 Sep 2024 06:07:54 +0000 (06:07 +0000)] 
Disable with --enable-all bits, as the helper function it uses is dying for reasons beyond my meager tcl-fu.

FossilOrigin-Name: d2b883120e7ab374092d2bdef0faa22eaa9639cb103f9fbbbbfd16639fbfd323

15 months agoCorrect some copy/paste errors in the previous checkin.
stephan [Wed, 25 Sep 2024 04:34:16 +0000 (04:34 +0000)] 
Correct some copy/paste errors in the previous checkin.

FossilOrigin-Name: 9752768d8a83052cb69fa07d51e2c82e710c20482cc02c33a4412ffdfa3dc699

15 months agoGet --enable-all flag essentially working.
stephan [Wed, 25 Sep 2024 04:20:58 +0000 (04:20 +0000)] 
Get --enable-all flag essentially working.

FossilOrigin-Name: 0a49436c983848c3d88f3f5ec33fb9ac31cce62e94bf515ab1c357a10f5cd515

15 months agoGet several of the --enable/--disable configure flags working.
stephan [Wed, 25 Sep 2024 03:37:34 +0000 (03:37 +0000)] 
Get several of the --enable/--disable configure flags working.

FossilOrigin-Name: fd16d53d3a95cd4f5f81f4b1b09955f04c89116586aa16fa01627ae4904d587b

15 months agoTesting libfossil checkin fix for inheritance of privateness.
stephan [Wed, 25 Sep 2024 02:00:09 +0000 (02:00 +0000)] 
Testing libfossil checkin fix for inheritance of privateness.

FossilOrigin-Name: 4b104926bf0862a5088e51549c2d688c2af649d45bf0e396cc48e171bed06b0a

15 months agoGet skeleton auto.def running, but it doesn't really do much except some standard...
stephan [Wed, 25 Sep 2024 01:39:39 +0000 (01:39 +0000)] 
Get skeleton auto.def running, but it doesn't really do much except some standard boilerplate stuff.

FossilOrigin-Name: e707634cf755346752bb83b7be5d0c683e39d6e0a497846019323fed31c08b9d

15 months agoMinor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by...
stephan [Tue, 24 Sep 2024 21:54:37 +0000 (21:54 +0000)] 
Minor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by Emscripten-side changes.

FossilOrigin-Name: 5ccc85d8f5809d961602dff557dca1ed34f5db61203912387272034e4da02614

15 months agoInitial pristine autosetup bits.
stephan [Tue, 24 Sep 2024 21:08:49 +0000 (21:08 +0000)] 
Initial pristine autosetup bits.

FossilOrigin-Name: dfb1e7f0cce9bc79c43eee7208cad0e2df562b2bc9705d3a36fd78f86c75495b

15 months agoFix over-length lines in the shell source code.
drh [Tue, 24 Sep 2024 19:47:12 +0000 (19:47 +0000)] 
Fix over-length lines in the shell source code.

FossilOrigin-Name: f3fdf76a0d3abeb5202f2b6f26318815396da7df680073955bde60b13f84e797

15 months agoFix error messages in the shell.
drh [Tue, 24 Sep 2024 19:19:53 +0000 (19:19 +0000)] 
Fix error messages in the shell.

FossilOrigin-Name: aeef82e974c24071e3211588001a92c7f122fbaf02d9dcf7fa5aaf30d2729f64

15 months agoGet fiddle working again on this branch.
drh [Tue, 24 Sep 2024 18:01:50 +0000 (18:01 +0000)] 
Get fiddle working again on this branch.

FossilOrigin-Name: 0f228317c6ea1388d82df46f44c166b2aa9be63361ff9b81569ebee63c930f2e

15 months agoPort sqlite3_analyzer.exe to use sqlite3_stdio.
drh [Tue, 24 Sep 2024 17:49:06 +0000 (17:49 +0000)] 
Port sqlite3_analyzer.exe to use sqlite3_stdio.

FossilOrigin-Name: 7c1c1226d803dbaf8e75085b1cc2aad88aef4c3168288e587c8c736633d09054

15 months agoPort sqldiff over to use sqlite3_stdio.
drh [Tue, 24 Sep 2024 17:40:54 +0000 (17:40 +0000)] 
Port sqldiff over to use sqlite3_stdio.

FossilOrigin-Name: 18f784c47d4252bc3696a7e084a1afb9f51f006cf2021292f2103531b8235226

15 months agoGet output redirection working again in the CLI.
drh [Tue, 24 Sep 2024 16:09:50 +0000 (16:09 +0000)] 
Get output redirection working again in the CLI.

FossilOrigin-Name: 086034c3508d95e4f620c5e0580fae770e85410b0c8bd94f600fc0fd25088947

15 months agoMerge trunk changes into this branch.
dan [Tue, 24 Sep 2024 15:43:52 +0000 (15:43 +0000)] 
Merge trunk changes into this branch.

FossilOrigin-Name: 9945206e6e26a48a49b9747650d299eb983cc21a3a61c621cd81f0bbc85a74d7

15 months agoFix a memory leak in sqlite3expert.c introduced by [f1d76c86].
dan [Tue, 24 Sep 2024 15:11:34 +0000 (15:11 +0000)] 
Fix a memory leak in sqlite3expert.c introduced by [f1d76c86].

FossilOrigin-Name: 42bb941584a1ac922ee6b0b6ecadce71c9259555563cf49913a6f820f3f9b887

15 months agoAdd the sqlite3_stdio.h library for Windows console I/O.
drh [Tue, 24 Sep 2024 13:46:32 +0000 (13:46 +0000)] 
Add the sqlite3_stdio.h library for Windows console I/O.

FossilOrigin-Name: fcd0ecffc9889f8c855ea340f075ec42cdca482df82d6e67dc9c32613e8d5846