This Day In History For 2025-12-05
1 Year Ago (more context)
2024-12-05
| ||
23:53 | Fix the build of sqlite3_analyzer.exe on Windows that was broken by check-in [80f3bf8c2ee31ba1]. (check-in: 223f47b2db user: drh tags: trunk) | |
19:45 | Add logging to report on occasions when loading the ANALYZE data is slow. (check-in: 5f9f6764e9 user: dan tags: cf8f1552-commit-instr) | |
16:52 | Use an inline asm "ret stosp" instruction instead of a memset() when a writer is required to zero a hash table. (check-in: c10fa6af8b user: dan tags: cf8f1552-commit-instr) | |
16:47 | • Edit [40aafd458593c17a|40aafd4585]: Move to branch cf8f1552-commit-instr. (artifact: 7eb6bf4a24 user: dan) | |
11:34 | • Edit [40aafd458593c17a|40aafd4585]: Move to branch wal2-zero-hash-in-ckpter. (artifact: d73862b13d user: dan) | |
2 Years Ago (more context)
2023-12-05
| ||
19:45 | Rework the JSON functions so that they use the JSONB format internally. The original JsonNode parse tree design is removed. All JSON functions that accept text JSON also accept JSONB. New functions generate JSONB. (check-in: 7f0c79b94e user: drh tags: trunk) | |
19:24 | Use extra assert() statement to silence harmless static analyzer warnings. (Closed-Leaf check-in: 174c2b2eef user: drh tags: jsonb) | |
18:36 | Further tests for the new code on this branch. (check-in: 59d008b6c2 user: dan tags: fts5-token-data) | |
18:28 | Miscellaneous comment cleanup and typo fixes. (check-in: 59446dc0bd user: drh tags: jsonb) | |
12:52 | Use strspn() to accelerate whitespace bypass in the JSON parser. (check-in: 843197df08 user: drh tags: jsonb) | |
12:22 | Small performance gain by unwinding the string literal delimiter search loop in the JSON parser by one more level. (check-in: 4c587feac1 user: drh tags: jsonb) | |
12:20 | Clean up the JSONB performance test script. (check-in: 905301075a user: drh tags: jsonb) | |
01:44 | Use an assert() to fix a harmless static analyzer warning. (check-in: a249ca657e user: drh tags: jsonb) | |
00:17 | Fix OOM and corrupt JSONB handling in json_patch(). (check-in: 1910feb0b7 user: drh tags: jsonb) | |
3 Years Ago (more context)
2022-12-05
| ||
19:16 | • Edit [009462f2344b1f46|009462f234]: Mark "Closed". (artifact: dc65e0bc0b user: dan) | |
19:16 | Enhance the sqlite3_stmt_scanstatus() API and add sqlite3_stmt_scanstatus_v2(). For creation of enhanced query performance reports. (check-in: 4893b4e3ea user: dan tags: trunk) | |
18:52 | Update comments in sqlite.h.in to account for sqlite3_stmt_scanstatus_v2(). (Closed-Leaf check-in: 009462f234 user: dan tags: scanstatus_v2) | |
18:26 | Merge latest trunk changes. (check-in: 1a72777b12 user: dan tags: scanstatus_v2) | |
18:19 | Add loops and rows counters to "USE TEMP B-TREE FOR ORDER BY" records. Also fix the sqliteHwtime() function so that it returns a 64-bit value. (check-in: 41a0e05e8c user: dan tags: scanstatus_v2) | |
17:31 | • Ticket [73ebbb3a3d] View ought not be materialized status still Open with 6 other changes (artifact: 1faa067bd6 user: drh) | |
15:05 | Remove two features of jaccwabyt which were fundamentally flawed, along with approx. 250 lines of unit tests which heavily relied on them. Thankfully, none of the sqlite3.js-level code used those bits. (check-in: a190abc307 user: stephan tags: wasm-vtab) | |
14:32 | Jaccwabyt (JS) doc updates. (check-in: a329a809b5 user: stephan tags: wasm-vtab) | |
14:24 | • Edit [15f0be8a640e7bfa|15f0be8a64]: Edit check-in comment. (artifact: 39a3161a5d user: drh) | |
14:23 | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. (check-in: d18cce37b5 user: drh tags: branch-3.40) | |
14:20 | Regenerate the configure script so that it includes the correct patch number. (check-in: e2ae2ea195 user: drh tags: branch-3.40) | |
14:20 | Add test case that should have been part of previous commit. (check-in: dc7dd2d3e5 user: dan tags: trunk) | |
14:13 | Expose sqlite3_get/set_auxdata() to wasm. Minor test app CSS tweaks. (check-in: 44659ad32a user: stephan tags: wasm-vtab) | |
14:12 | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. Forum post 5adb92e2baca3678. (check-in: 15f0be8a64 user: dan tags: trunk) | |
13:33 | Export collation-related APIs and strncmp()/strnicmp() to wasm. (check-in: c3c56d9b94 user: stephan tags: wasm-vtab) | |
13:12 | Export sqlite3_vtab_collation() to wasm. Rename 'flexible-string' JS argument adapter to 'string:flexible' for consistency. (check-in: 15f8042fdd user: stephan tags: wasm-vtab) | |
13:07 | Remove SQLITE_EXPERIMENTAL tag from sqlite3_vtab_collation() and fix a related doc typo. (check-in: 35d670b359 user: stephan tags: trunk) | |
11:54 | Rename 'static-string' argument adapter to 'string:static'. Replace JS unit tests which were lost via editing a generated copy of tester1.js instead of the original tester1.c-pp.js input file. (check-in: 9d81d51d5a user: stephan tags: wasm-vtab) | |
11:30 | Export sqlite3_bind/value/result_pointer() to wasm. Add 'static-string' argument converter to support the lifetime requirements of bind/result_pointer()'s string argument. Correct an endless loop in wasm.cstrlen() when passed a non-C-string argument. (check-in: a94552434a user: stephan tags: wasm-vtab) | |
10:50 | Remove obsolete "experimental" comments on the virtual-table interface documentation in sqlite.h.in. (check-in: 28fc32abdc user: drh tags: trunk) | |
07:51 | More work on the JS side of the virtual table APIs. (check-in: cb9881ec00 user: stephan tags: wasm-vtab) | |
05:45 | Remove some dead code. Improve some error checks and comments. (check-in: 6712fbe46a user: stephan tags: wasm-vtab) | |
05:30 | Initial infrastructure for adding virtual table/table-valued function support to WASM. (check-in: c202d7a039 user: stephan tags: wasm-vtab) | |
02:53 | • Fixed ticket [e8b6742419]: Query planner chooses an inefficient algorithm. plus 5 other changes (artifact: a9db5f9587 user: drh) | |
02:52 | Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b]. (check-in: 1b779afa3e user: drh tags: trunk) | |
02:42 | Use the smaller estimated row size for searching IPK tables, but use the original larger row size estimate for scanning, since the leaves can have large rows. (Closed-Leaf check-in: df3818997b user: drh tags: qp-tuning) | |
4 Years Ago (more context)
2021-12-05
| ||
20:19 | Run as many Bloom filters as possible before index lookups. (check-in: 06f6fefd67 user: drh tags: bloom-filter) | |
00:45 | Try to run all Bloom filters before any Seeks. This gives a small performance gain on the Star-Schema Benchmark. (check-in: 5be2470f87 user: drh tags: bloom-filter) | |
10 Years Ago (more context)
2015-12-05
| ||
20:51 | Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). (check-in: 0715eb00aa user: dan tags: snapshot-get) | |
20 Years Ago (more context)
2005-12-05
| ||
22:22 | Update mailing list hyperlink on the support page. (CVS 2799) (check-in: 41a7aeeeb4 user: drh tags: trunk) | |
13:20 | Make sure sqlite3_result_text can handle text strings with embedded '\000' characters. (CVS 2798) (check-in: 9d6057cd14 user: drh tags: trunk) | |