SQLite

Today In History
Login

This Day In History For 2025-10-01

1 Year Ago (more context)

2024-10-01
20:38
Rationalize code further. And add tests. (check-in: 0ca002a4ab user: dan tags: fts5-tokendata-prefix)
20:29
Remove all code that makes use of the C-language "long double" datatype. (check-in: f622b52024 user: drh tags: omit-long-double)
19:10
New #ifdefs to omit code that is unused when SQLITE_USE_LONG DOUBLE is defined. (check-in: 98066e2d22 user: drh tags: trunk)
17:57
Another comment about the LONGDOUBLE wasm topic. No code changes. (check-in: 1755831cb1 user: stephan tags: trunk)
17:08
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. (check-in: fa7b56f776 user: stephan tags: trunk)
16:55
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. (check-in: ca5964ef70 user: drh tags: trunk)
13:40
Get more of the CLI utils building. (check-in: 6838b7b5d6 user: stephan tags: autosetup)
11:09
Correct missing LDFLAGS_ZLIB for libsqlite3.so. (check-in: 98bbba3a05 user: stephan tags: autosetup)
11:04
Fix reversed logic in the build/target/host names in several hwaci-* functions. (check-in: fde7257ad9 user: stephan tags: autosetup)
10:49
Add an #if'd-out block to sqlite3-wasm.c mentioning the LONGDOUBLE_TYPE, as brought up in forum post cbfb0d0ac. No functional changes. (check-in: 0b83e8f1ef user: stephan tags: trunk)

2 Years Ago (more context)

2023-10-01
18:59
Fix problems following OOM in JSONB parsing. (check-in: 0d8cd6b5fb user: drh tags: jsonb)
12:15
Add JNI binding for sqlite3_normalized_sql(). (check-in: 2532e5662a user: stephan tags: trunk)
11:53
Make JNI binding of sqlite3_value_frombind() return boolean instead of int and add tests for it. (check-in: 906e2ed3e9 user: stephan tags: trunk)

3 Years Ago (more context)

2022-10-01
20:27
Performance optimization in sqlite3_prepare() (discovered while working on the stmt-cache branch). (check-in: cd494240cc user: drh tags: trunk)
19:21
Correct fiddle db export breakage caused by a post-testing API change made in [1fa019c88dea]. (check-in: e73cc44ec3 user: stephan tags: fiddle-opfs)
18:55
Pedantic constness tweak. (check-in: c8a173cf16 user: stephan tags: fiddle-opfs)
18:47
wasm: correct a memleak caused by a shadowed var in the previous checkin. Add a stack-like allocator, sqlite3.capi.wasm.pstack, as a faster way of managing short-lived pointers (like the one which got shadowed). (check-in: 1fa019c88d user: stephan tags: fiddle-opfs)
16:01
Fiddle: fix makefile dependency issue and duplicate inclusion of post-js.js. Reimplement db export using sqlite3_serialize(). (check-in: 29db7de792 user: stephan tags: fiddle-opfs)
13:45
Merge trunk into fiddle-opfs branch. (check-in: 64ebcbe416 user: stephan tags: fiddle-opfs)
13:38
Tweak sqlite3-worker1.js to be able to load either sqlite3.js or sqlite3-wasmfs.js, noting that the latter still does not load in a Worker because of an Emscripten loader bug. (check-in: 000ef7059b user: stephan tags: fiddle-opfs)
13:28
Merge the Parse.prepFlags change from trunk. (Leaf check-in: c8d77f3980 user: drh tags: stmt-cache)
13:17
Replace the Parse.disableVtab field with Parse.prepFlags for increased generality, a small size reduction, and a small performance increase. (check-in: b7da0bcdf7 user: drh tags: trunk)
12:04
Note two wasm-related potential TODOs. (check-in: 5636e82864 user: stephan tags: fiddle-opfs)
12:00
Merge the latest trunk enhancements into the stmt-cache branch. (check-in: 7812aea6ea user: drh tags: stmt-cache)

4 Years Ago (more context)

2021-10-01
22:52 Edit [f47f7f78227830c0|f47f7f7822]: Edit check-in comment. (artifact: 3245ee4f27 user: drh)
22:49 Edit [86f9c07a4fbbba1e|86f9c07a4f]: Mark "Closed". (artifact: fa89ff23df user: drh)
22:48
Fix a problem with group_concat() when it is used as a window function with a sliding window, as described by forum thread ccf3b5673ba852cf. (check-in: f47f7f7822 user: drh tags: trunk)
21:01
Fix harmless compiler warnings. (check-in: 94b59691ee user: drh tags: trunk)
20:39
Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: 2f7c946c5f user: dan tags: trunk)
17:06
Fix a potential write outside of array bounds in the --hexdb decoder of the CLI when given corrupt input. (check-in: c7fdd775bb user: drh tags: trunk)
15:05
Fix a buffer overread in fts5 that could occur when processing an "ORDER BY rowid DESC" query against corrupt database records. (check-in: fe098a9334 user: dan tags: trunk)
02:45
Remove unreachable branches in the fixed group_concat() code. (Closed-Leaf check-in: 8bd721c29e user: drh tags: group_concat-fix-legacy)
02:16
Merge updates from trunk (check-in: 35351371c5 user: drh tags: group_concat-fix-legacy)
00:25
Fixes to the version of "varsep" group_concat so that (1) it builds under separate compilation and (2) omits tabs in source code and (3) runs faster than trunk. This variant of the group_concat_varsep branch might be preferred over the tip because it preserves (undocumented) legacy behavior about the position of separators relative to terms. (check-in: 04399cf964 user: drh tags: group_concat-fix-legacy)

5 Years Ago (more context)

2020-10-01
17:24
Add experimental "trigram" tokenizer to fts5. (check-in: c4e8ec7907 user: dan tags: trunk)
17:15
Add the -trigram option to the fts5txt2db.tcl script. (Closed-Leaf check-in: a394dd2602 user: dan tags: fts5-trigram)
16:10
Add tests for the trigram tokenizer. Fix minor issues. (check-in: 897ced99b4 user: dan tags: fts5-trigram)
15:46
Fix the OP_SeekScan opcode so that its variable names do not cause problems for the test/vdbe-compress.tcl script. (check-in: 7a78274a07 user: drh tags: trunk)
14:38
Remove a debugging printf() accidentally left in the previous check-in. (check-in: e9d1efa597 user: drh tags: trunk)
14:36 Fixed ticket [2d5a316356]: Segmentation fault in CROSS JOIN and the rtree extension plus 3 other changes (artifact: ea3a828515 user: drh)
14:36
The IN-early-out optimization does not work for virtual tables. Do not try to use it there. Fix for ticket [2d5a3163563d559f]. Test cases in TH3. (check-in: dbec6910d9 user: drh tags: trunk)
13:33 Ticket [2d5a316356] Segmentation fault in CROSS JOIN and the rtree extension status still Open with 6 other changes (artifact: 5275fb849f user: drh)
11:35 New ticket [2d5a316356]. (artifact: 2ee12a62ed user: mrigger)

10 Years Ago (more context)

2015-10-01
18:31
Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. (check-in: 6f90839e91 user: dan tags: trunk)
16:35
Changes to the sesssions module ensure that tables appear within changesets and patchsets in the same order that they were attached to the sessions object. (check-in: 7695890230 user: dan tags: sessions)

15 Years Ago (more context)

2010-10-01
20:45
Backport the RTree implementation from the trunk into the 3.6.23 branch. The code for the application-defined query boxes is still present but is disabled. The reason for this backport is to take advantage of recent enhancements to robustness to database corruption. (check-in: 854b23c117 user: drh tags: branch-3.6.23)
19:04
Add tests for CHECK and UNIQUE constraints to e_createtable.test. (check-in: fb8db5581d user: dan tags: trunk)
17:23
Add #ifndef USE_SYSTEM_SQLITE...#endif around the bundled SQLite library for the TCL bindings. (check-in: 8d85584a4e user: drh tags: trunk)
15:14 Edit [efda3104800c1e10|efda310480]: Change background color to "#ffc0d0". Mark "Closed". Timestamp 2010-10-01 15:11:09. (artifact: 6ac8f95c27 user: drh)
15:14 Edit [efda3104800c1e10|efda310480]: Move to branch mistake. Edit check-in comment. Timestamp 2010-10-01 15:11:09. (artifact: 2f176a65ca user: drh)
15:11
Not true: For a zeroblob, the Mem.z pointer can be null: The Mem.z pointer can never been NULL for a string or blob, even a zero-length string or blob. Assert this fact. (Closed-Leaf check-in: efda310480 user: drh tags: mistake)
13:28
Updates to the showjournal.c utility in order to bring it up to version 3. (check-in: fa97d89546 user: drh tags: trunk)