SQLite

Today In History
Login

This Day In History For 2025-05-30

1 Year Ago (more context)

2024-05-30
21:54
Back out [dcc2bb2c562e97e090174], as it breaks the --with-wasi-sdk builds. (check-in: 62199562c2 user: stephan tags: trunk)
17:56
Remove the unconditional SQLITE_OMIT_WAL when building in wasi-sdk mode, per requests in the forum. (check-in: dcc2bb2c56 user: stephan tags: trunk)
13:27
Ensure that the second pass call to wherePathSolver() always reports a positive value for the estimated number of output rows. This fixes a long-standing (though exceedingly minor) problem that was only revealed by a new assert() added yesterday. dbsqlfuzz 545d6debc2da496ab2b915e33ea34d9a35a935df (check-in: a47c644fef user: drh tags: trunk)
11:33 Edit [33ad9d8a3c13c2c9|33ad9d8a3c]: Mark "Closed" with note "Failed experiment.". (artifact: 7261aa309e user: stephan)
11:25
Experimentally enable linenoise multiline mode in shell.c. (Closed-Leaf check-in: 33ad9d8a3c user: stephan tags: linenoise-multiline)
11:14
Update shell.c to use the msteve fork of linenoise, per /chat discussion. (check-in: ee92fa8366 user: stephan tags: trunk)

2 Years Ago (more context)

2023-05-30
16:40
Enhancements to date/time functions: (1) Add support for time-shift modifiers of the form (+|-)YYYY-MM-DD HH:MM:SS.SSS (2) Add the timediff(A,B) SQL function that returns the time-shift modifier sufficient to move B to A. (check-in: 574bf370b0 user: drh tags: trunk)
14:46
Simplifications to the new timediff() logic. (Closed-Leaf check-in: d6954259bd user: drh tags: timediff)
14:10
Minor tweak to the OPFS async proxy to attempt to account for a spurious high-load console error message which was reported via the sqlite-wasm npm project. (check-in: a61467d1fb user: stephan tags: trunk)
13:27
Minor internal JS doc fix. No code changes. (check-in: 68abee3c1b user: stephan tags: trunk)
11:51
New test cases for the timediff enhancements. (check-in: f14633ce6d user: drh tags: timediff)
11:14 Edit [fa9237a8ab803ca3|fa9237a8ab]: Edit check-in comment. (artifact: 5cc3db677b user: drh)
11:13
Allow date/time modifiers of the form (+/-)YYYY-MM-DD without the following HH:MM:SS.SSS. (check-in: fa9237a8ab user: drh tags: timediff)
02:50
Problems fixed. All tests are passing now. (check-in: cff293b0a7 user: drh tags: timediff)
02:16
Improvements to the timediff() function. Test cases added. Not all test cases are passing. (check-in: 2cf6518140 user: drh tags: timediff)

3 Years Ago (more context)

2022-05-30
17:33
For an outer join, then ON-clause constraints need to be evaluated at just the right moment - not too early and not too late. Fix for the problem reported by forum post 3902c7b833. (check-in: 3869fd9a2b user: drh tags: trunk)

5 Years Ago (more context)

2020-05-30
15:34
Draw the dashes below the headers in "explain" mode in the CLI. (check-in: c6b7833ac7 user: drh tags: trunk)
00:30
Improved VDBE comments on the ANALYZE code generator. This change also fixes a harmless use of an uninitialized integer variable as an input to the %d format on a VDBE comment. (check-in: 1cb248a3fc user: drh tags: trunk)

10 Years Ago (more context)

2015-05-30
22:57
Updates to configure.ac to help it find where the TCL libraries hidden on Ubuntu 14.04. (check-in: c864ff912d user: drh tags: trunk)
22:05
Fix minor typo in comment. No changes to code. (check-in: 73fc058b3a user: mistachkin tags: trunk)
11:49
Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: e008c3c8e2 user: dan tags: fts5)

15 Years Ago (more context)

2010-05-30
19:55
Initial code for incremental checkpoint in WAL mode. This check-in compiles on unix and runs as long as you do not engage WAL mode. WAL mode crashes and burns. Consider this check-in a baseline implementation for getting the new capability up and running. (check-in: ef3ba7a17f user: drh tags: wal-incr-ckpt)

25 Years Ago (more context)

2000-05-30
20:17
:-) (CVS 19) (check-in: 03725ce5ae user: drh tags: trunk)
19:22
:-) (CVS 18) (check-in: 2d41caec80 user: drh tags: trunk)
18:45
loads the complete ACD database! (CVS 17) (check-in: 97a0fb780e user: drh tags: trunk)
17:30
:-) (CVS 16) (check-in: b56d1b9c0f user: drh tags: trunk)
16:27
:-) (CVS 15) (check-in: 8d66c7355d user: drh tags: trunk)
13:44
:-) (CVS 14) (check-in: 1bb8ee8d9f user: drh tags: trunk)
03:28
:-) (CVS 13) (check-in: 191a7f484e user: drh tags: trunk)
03:12
:-) (CVS 12) (check-in: 20f2811fc1 user: drh tags: trunk)
00:51
:-) (CVS 11) (check-in: 9818723ee1 user: drh tags: trunk)
00:05
:-) (CVS 10) (check-in: 1c1d9c0d4a user: drh tags: trunk)