database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-10-21 11:13:54 +03:00
Code Activity
30,539 Commits 1,600 Branches 184 Tags
ext-to-core
Commit Graph

30539 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
9444c29094 Fix the makefile so that "<tt>test/testrunner.tcl release --buildonly</tt>" 
works on mac.  Apparently broken by [b7751d144330593b].

FossilOrigin-Name: 023365228f3264c53263b649365e7c133d8633010baf6e050fdee044a40454dd
 2025-09-24 20:44:33 +00:00
stephan
6d3ae03f1e Get the tester1 worker1/promiser demos building again. Show WASM heap usage in tester1 if. 
FossilOrigin-Name: 6691a84872f823c95b0bdc3db8e12d21c9561aa1e1ce1d787a977f2c5ef8225a
 2025-09-24 20:39:08 +00:00
drh
b8a62d9da7 Add an assert() to fix a harmless compiler warning in the session extension. 
FossilOrigin-Name: d77b8ad96c695594668cd7019c7f607fe5efa5474dde0ece8b621051cf88a0b5
 2025-09-24 20:09:48 +00:00
drh
1ecc36a2b0 Fix a harmless compiler warning in FTS5. 
FossilOrigin-Name: 89f8d02075a7b265b1f0226a0f878903e1dce27ff1ac2e8a2d62d450b9b4ec76
 2025-09-24 19:51:07 +00:00
drh
2c88a2ffb5 Rework the set_table_name() function in the CLI to use modern APIs. 
[forum:/forumpost/2baa4acd64|Forum post 2baa4acd64].

FossilOrigin-Name: 821cc0e421bc14a68ebaee507e38a900e0c84ff6ba7ee95bf796cad387755232
 2025-09-24 19:10:58 +00:00
drh
96bb92e70c Special case the "decimal(-0.0)" output to show exactly 0.0, just as it 
does for positive zero. 
[forum:/forumpost/adc719d88d56ab22|Forum post adc719d88].

FossilOrigin-Name: 9ca4163bd93d78be5e4daf2b5d2b920d54d038c6fa8217dd2add0be0da6cd6b0
 2025-09-24 17:49:09 +00:00
stephan
892109542b Generate 64-bit variants of tester1.js/html. Enhance c-pp to accept multiple input files. 
FossilOrigin-Name: ef6c55e4499957fb46b213540786e5d3928ec096eae1fe759066ed011518e7a2
 2025-09-24 17:46:08 +00:00
drh
68353d0531 Fix a harmless compiler warning in IEEE754. 
FossilOrigin-Name: 7f72308322cd1f238e6c725ec6bff44ed42fb2619f3f52afe38e2faad838a63f
 2025-09-24 17:38:13 +00:00
drh
2abc502ebc Additional short-circuit optimizations for AND/OR operators. Also fix 
bugs in prior implementations (such as [0083d5169a46104a]).

FossilOrigin-Name: 63b686fe4cb1d5d82dd3a399aaafd1dfcbda533ca83b46ed2bc2750baa7f251d
 2025-09-24 17:07:15 +00:00
drh
dc90d7055c Simplification to the AND/OR short-circuit logic. 
FossilOrigin-Name: 7be555a3b8500c43c2f30171af26bcda9bcb68f41992b792228218a56315e7c4
 2025-09-24 16:26:44 +00:00
dan
2364fe3b38 Improve performance of window function queries that use "BETWEEN :x FOLLOWING AND :y FOLLOWING" where :y is a very large number. 
FossilOrigin-Name: 1f0b7143575634929c0f77bafa888f0be2dd83f0c6c3deadd8299ac4ab8a8c01
 2025-09-24 16:10:46 +00:00
drh
1f030eac9f Fixes to short-circuit AND/OR evaluation. 
FossilOrigin-Name: bc4cadbd60b97d000d2e8be843acab9d82ddf10a8125fd9cc0ae101bb9850091
 2025-09-24 14:43:42 +00:00
stephan
36baed3e2e Add docs to mkwasmbuilds.c explaining the purpose of each of the builds. Remove some inadvertent copy/paste hard tabs in some C-side makefile code. 
FossilOrigin-Name: a2bd965e103026ff5c722357ed9e3432172bbc19d267e718ebd4a876eca41742
 2025-09-24 13:59:53 +00:00
drh
ca574fa1d5 Factor out the code that handles AND and OR short-circuiting into a 
separate subroutine, for performance and legibility.

FossilOrigin-Name: cab84a65c3825c59f3a7a750f4983563ce7ad007125cbcf35c187326289fea89
 2025-09-24 13:10:55 +00:00
drh
feeacfb897 Fix incorrect buffer size computation for the base64() extension function. 
[forum:/forumpost/b1993c858f|Forum post b1993c858f].

FossilOrigin-Name: 603efcd404f0013559ca5bd936fc39481a3aa33a10340bac27b751b6b286d0b7
 2025-09-24 12:01:50 +00:00
drh
b927708437 Restrict the size of the LIMIT on a generate_series() query to avoid 
an integer overflow when computing the final output value.
[forum:/forumpost/479bfb0d3b|Forum post 479bfb0d3b].

FossilOrigin-Name: 266aacb4759945f7cf7a258014620f21225261246edc08e6e71ff5292baf22f3
 2025-09-24 11:12:26 +00:00
stephan
8d93e83461 Cosmetic build tweaks. 
FossilOrigin-Name: 431725330d6c63575dbf3404664a7af33d4d87c569560e99c18de93eb4d73935
 2025-09-24 07:31:19 +00:00
stephan
205257791c Fix the positioning of the wasm-bare-bones flag init. 
FossilOrigin-Name: f5167fb3615efc180e69333f99d82d6afc1d190e7f37b6a701895de00502d8c8
 2025-09-24 07:00:37 +00:00
stephan
4500a87c95 In speedtest1, always use fatal_error() to exit fatally, instead of an fprintf/exit() pair, so that stdout/stderr get flushed consistently (which is significant for the WASM build). 
FossilOrigin-Name: 1bd15cb343f6ce57f108291a8ed0f3ee2046932591d44edec133fe3ea43a2ef0
 2025-09-24 06:59:47 +00:00
stephan
5c01f3fb83 Further wasm build refactoring. Get speedtest1 building again. 
FossilOrigin-Name: 5434307dcd927686ce827da22de55020c4b431f888ac81ae3634d458ad0b563d
 2025-09-24 06:43:24 +00:00
stephan
e779baa099 Move some of the generated wasm makefile utility code out of C and into util.make. 
FossilOrigin-Name: a2935758f534b51cac3d2e5ece74b369c806e3a994781744708e1590b9c32542
 2025-09-24 04:58:14 +00:00
stephan
3b56f296e9 Generic build simplifications. 
FossilOrigin-Name: 61648610c3e454fce77b78e6f6be1b71e27bb9587af03ae5c0e083eac7158a64
 2025-09-24 03:05:31 +00:00
stephan
0dee14a559 Get fiddle building properly again and fiddle/fiddle.debug building in parallel. 
FossilOrigin-Name: 85fe9c6155f72583cea46d38bf5e040623d71fb5317ff9373421dbfdb179b2b0
 2025-09-24 01:50:08 +00:00
drh
9300c4a13c Improved short-circuit evaluation of AND and OR. All appears to work, but 
there are still testing and performance issues to be worked out.

FossilOrigin-Name: 0d4447aa61848deecf9170afce031f7b353b91d58474f3f094ce34e46be7f99e
 2025-09-24 00:13:28 +00:00
stephan
ac37661a16 Get fiddle/fiddle.debug building again but they're incomplete and don't run. 
FossilOrigin-Name: d725a075bc3303c5a26c4014f57162235cebc6491425083b4d80936de8f07fb0
 2025-09-23 23:22:31 +00:00
drh
cac1ef709f Improvements to short-circuit evaluation of AND and OR operators. 
This is a partial and incomplete response to
[forum:/forumpost/f5adeb59ff77c056|forum post f5adeb59ff77c056].

FossilOrigin-Name: cea8bf79e18d55a8658e48a967cd0b7970b6f88badb769cfbb1f66ab24fb9ec8
 2025-09-23 17:00:53 +00:00
drh
611ffbc981 In the ieee754 extension, render -0.0 as 'ieee754(-1,-3071)' instead of 
'ieee754(1,-3071)' as that makes the sign clearer.  Both strings still
convert back to -0.0.  Note that negative zero
and positive zero are distinct values in ieee754.
[forum:/forumpost/1eab7e4a08|Forum post 1eab7e4a08].

FossilOrigin-Name: 136188c161a8a2d5166798fcbd341bd1d3f81da7291011f806d6b2153544832c
 2025-09-23 16:01:45 +00:00
stephan
cfce9b6a11 Get most of the wasm build (re)working and much prettier. 
FossilOrigin-Name: a5a7890c75003a637a227b700dc342f4f4a24bd368b216bdb168b4ddfbe8f015
 2025-09-23 13:49:44 +00:00
stephan
a07871d332 Cosmetic wasm build tweaks. Fixed wasm-opt use, broken by this branch's refactoring. 
FossilOrigin-Name: 4d7eff2afbcf023291bc1133c4413d1ea44f4096bb515e4bcd40bc8fc8d2a591
 2025-09-23 10:46:17 +00:00
stephan
5c0850f8b8 Make it easier to pick out which parallel build messages belong to which wasm build. 
FossilOrigin-Name: 913af3dd6a8da577ef19b0d82c8afec0c626d7fa5fddbdf418d2eb16c3050ab1
 2025-09-23 08:44:07 +00:00
stephan
ebb99967c2 More build restructuring. 
FossilOrigin-Name: 7bee8ee76380b2c1beb320b55042f149c22f872c70b58461652fa5bcbf6ad3c7
 2025-09-23 08:23:23 +00:00
stephan
aa5b8f9d47 Create each distinct wasm build into its own dir, instead of all going to in jswasm/sqlite3.wasm, so that the build can now run in parallel. 
FossilOrigin-Name: 47526a75f2ad85100b1eae7ab1cf9a9dddd4430a99f7a30aa0c16548d1db9d33
 2025-09-23 06:31:24 +00:00
stephan
91b1b0de2b Start reworking the wasm build (again) with an eye towards simplifying it. Currently only the canonical and esm builds work, not fiddle, speedtest, nor the bundler stuff. 
FossilOrigin-Name: 102c4a35b86405273d1f7e9e34466c9deed7831099a8207b6f48746b998193f9
 2025-09-23 05:10:19 +00:00
stephan
12f17d41f9 Add makefile target '64bit' to ext/wasm/GNUmakefile to build the 64-bit bundles. It does not yet generate copies of the test apps to load/test them, pending other reworking of the build. 
FossilOrigin-Name: 3e2ea990ad76f9e68d514568f53eaa692a1eb11695fceb1bcc58cea00605fff9
 2025-09-23 02:04:07 +00:00
stephan
a8bddde325 Slight correction to the diagram in the previous checkin. 
FossilOrigin-Name: 6455af2703e78fb9b6df19cf4b46873d98ec91c3302dc0093a362d03ac48da91
 2025-09-23 00:24:58 +00:00
stephan
b19c14742d Add a high-level diagram showing how sqlite3.js gets assembled. 
FossilOrigin-Name: e0dfa1e62ba6d71abe1f48969eb6f53c83f2c28d47b996ee223587d923cc282f
 2025-09-22 23:48:05 +00:00
stephan
e55a29f5fd Refactor and simplify the JS API bootstrap steps. 
FossilOrigin-Name: a4f36fd93738f985d2c757c69eddca092732ce6148af98eb2595f9abe0d4fa44
 2025-09-22 21:04:24 +00:00
stephan
cfa48c17f7 Update ext/wasm/api/README.md for recent changes. 
FossilOrigin-Name: 03b70686939e5f9ad984220a31674c23a1beb19f040c6327f24e23f0378555da
 2025-09-22 18:05:10 +00:00
stephan
1ab3d7eafd Cleanups and docs in the internal parts of the JS lib bootstrapping. More tinkering with the custom (but still disabled) wasm file loader. 
FossilOrigin-Name: 35651d9ab5529da915500fc50ca3833a004d0b7a19d98e8fbf39234d94697aec
 2025-09-22 17:29:52 +00:00
drh
6ba22a75f3 Revise [a4430d262b3e129d] to preserve legacy behavior of the imposter 
test-control.  The control argument must be 2 now to get read-only behavior.
The control argument of 1 goes back to the prior read/write behavior.

FossilOrigin-Name: 3e7ede2e6dc9ac8e746dafe0ecb5379044631e753e951f9ab97ec84addbd830a
 2025-09-22 17:28:08 +00:00
stephan
2ea861a245 In wasm.ptr.coerce(), treat the undefined value the same as 0 for Number-type pointers for consistency with the BigInt coercion. The bindings have long treated both null and undefined as === 0 for pointer operations. 
FossilOrigin-Name: ef73bb1ddae28c6a0b462a2a840bfaaec3fc70d843e9ab6c53097281ffc85a78
 2025-09-22 13:13:02 +00:00
stephan
34d92f4ac6 Minor doc updates. No functional changes. 
FossilOrigin-Name: 9c67299b452a2b19b5f4285feb975b30864a9415ccf62b7c7ebb1587a6545b33
 2025-09-22 11:52:06 +00:00
stephan
8eefa2725b Rework the JS/WASM pieces for compatibility with both 32-bit and 64-bit WASM environments. This affects only the browser-side components, not the --with-wasi-sdk build nor the core library. 
FossilOrigin-Name: 8ac367686fecd2e3ff1f4b4565e9f206a64237744e381704693df2e6efbe235a
 2025-09-22 11:41:15 +00:00
dan
65551b5456 Fix a problem with handling of 4-byte utf-8 characters in the shell tool (not the sqlite library). Forum post [forum:/forumpost/184b372388 | 184b372388]. 
FossilOrigin-Name: f3e845cf38fc364bfa3f8d433b668f884d11286c823d87ee0ed124a991c94e14
 2025-09-22 10:48:10 +00:00
stephan
5a2e3c4af2 Experimenting with a custom wasm loader, but don't enable it without an explicit build flag. The goal here is to make the WebAssembly.Module object available internally (the default loader hides it from us). 
FossilOrigin-Name: e5f0256feab95c30a8e3e1e69963fb3e25ed2da296aff5bc6646fe96a76c0b81
 2025-09-22 02:40:06 +00:00
stephan
1d49644650 Minor internal optimizations in the wasm glue. 
FossilOrigin-Name: fb053a27d94f9caedfddf28680e13836343745376e84c8008641df6bb517cd8b
 2025-09-21 23:15:12 +00:00
stephan
1e01174ac3 A minor optimization in wasm.realloc(). 
FossilOrigin-Name: 6a070f450ac9ee3d4d6a3e05ef8fa2071a684181ea160805e236c3bba226510a
 2025-09-21 22:17:13 +00:00
stephan
60633a852d Remove some stale makefile comments. Add a little widget to fiddle's toolbar which shows whether it's running in 32- or 64-bit mode. Reduce fiddle's starting memory to 8MB. 
FossilOrigin-Name: e99730f96e13f7497a871fdcc5eaa4187835f005a759f0fc79bbfe982f454437
 2025-09-21 22:08:05 +00:00
stephan
589855f40e Improve db-close-time cleanup in the face of WASM environments which wrap wasm.exports in nullary wrappers. 
FossilOrigin-Name: fbb63634eab83fda0090fe2c38bda735b497fd6e57dd36344559962e396dbb17
 2025-09-21 21:37:44 +00:00
stephan
e6db55f0e2 Fix a Number/BigInt descrepancy in oo1.DB() when passed a WASM-string db filename. Consolidate some duplicated internal code and adjacent minor cleanups. 
FossilOrigin-Name: d078aff7817ccd4f891024e55703519307a53815d472086bf3d42b2be28698b3
 2025-09-21 21:17:41 +00:00