This Day In History For 2025-10-14
1 Year Ago (more context)
2024-10-14
| ||
23:11 | • Reply: Extremely slow enumeration by primary key in large table artifact: 3e513dbe51 user: drh | |
22:37 | • Post: Extremely slow enumeration by primary key in large table artifact: 972dcc7367 user: snej | |
22:36 | • Reply: Optimizing SQLite for readonly low latency queries artifact: 446ad7a420 user: sqlitening | |
19:25 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: c3af3fcea0 user: jicman | |
18:58 | • Reply: Dump cannot be imported artifact: 9d23513241 user: blackbit | |
18:30 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: 3afcfedb6b user: drh | |
18:27 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: 84dc7640fa user: drh | |
15:44 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: e89e336bf8 user: jicman | |
15:43 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: ce18e974f0 user: jicman | |
14:13 | • Reply: Support artifact: 40049a121c user: slavin | |
14:09 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: 72de424221 user: stephan | |
14:03 | • Reply: fts5TriTokenize sometimes reads past the end of non-null terminated input strings artifact: b13a700ac2 user: rogerbinns | |
13:51 | • Reply: Can't build Windows sqlite3.exe using cygwin artifact: 341d433091 user: jicman | |
11:50 | • Reply: Dump cannot be imported artifact: e38fc2a438 user: drh | |
07:43 | • Reply: Optimizing SQLite for readonly low latency queries artifact: 6dcac9fdf1 user: ralfbertling | |
02:06 | • Reply: Support artifact: 96567fdff6 user: drh | |
02:04 | • Edit reply: Support artifact: dd32981e91 user: stephan | |
02:03 | • Reply: Support artifact: 63d9139c0b user: stephan | |
01:31 | • Post: Support artifact: 65b701e884 user: anonymous | |
01:16 | • Reply: .expert Broken Error Message artifact: 3fc3730852 user: stephan | |
00:23 | • Reply: .expert Broken Error Message artifact: 14bc68adb5 user: SeverKetor | |
2 Years Ago (more context)
2023-10-14
| ||
23:29 | • Reply: UNIQUE column allowing only a single NULL value artifact: 85ed54b672 user: anonymous | |
21:28 | • Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 2e5bd2f1f6 user: drh | |
21:06 | • Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 6dd4fb9a32 user: stephan | |
20:55 | • Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 0dff924953 user: Clothears | |
20:48 | • Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 97f35a0453 user: stephan | |
20:40 | • Reply: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 1571492553 user: larrybr | |
20:32 | • Post: RFC: is there a semantic difference between NULL and a 0-length blob? artifact: 96c1152d35 user: stephan | |
19:59 | • Reply: How does SQLite store tables and delete rows? artifact: 7cb92e55df user: drh | |
19:59 | • Reply: How does SQLite store tables and delete rows? artifact: 88344e1167 user: stephan | |
19:48 | • Post: How does SQLite store tables and delete rows? artifact: 600044d7b7 user: anonymous | |
19:17 | • Reply: UNIQUE column allowing only a single NULL value artifact: 489d623e0a user: larrybr | |
19:06 | • Reply: (Deleted) artifact: 003816e968 user: JLHainaut | |
19:02 | • Reply: dynamic date query with COUNT and Python artifact: b4a61711f2 user: larrybr | |
18:59 | • Reply: UNIQUE column allowing only a single NULL value artifact: 948691691c user: younique | |
18:46 | • Reply: UNIQUE column allowing only a single NULL value artifact: c19eadcc92 user: younique | |
18:07 | • Post: dynamic date query with COUNT and Python artifact: 16d7598ff4 user: anonymous | |
16:35 | • Reply: Error Opening Sqlite artifact: 0a059729b8 user: larrybr | |
15:24 | • Post: Error Opening Sqlite artifact: e12a0a16fd user: PaterB | |
14:12 | • Edit reply: Experience with SQLite as a store of Files and Images artifact: 618cc6e288 user: stephan | |
13:44 | • Reply: Experience with SQLite as a store of Files and Images artifact: 4c04dfc49e user: drh | |
12:26 | • Reply: UNIQUE column allowing only a single NULL value artifact: 08c60d3075 user: anonymous | |
12:24 | • Reply: Experience with SQLite as a store of Files and Images artifact: a4bc623ee3 user: slavin | |
08:51 | • Reply: UNIQUE column allowing only a single NULL value artifact: 362ddf0be9 user: lifepillar | |
01:33 | • Post: Update config.{sub,guess} artifact: 90017582f5 user: anonymous | |
3 Years Ago (more context)
2022-10-14
| ||
23:15 | • Reply: System.Data.SQLite on macOS using C# ? artifact: 22d2124dac user: npalardy | |
21:55 | • Reply: finding rows that contain a non-numeric character artifact: 80b61841bb user: anonymous | |
21:44 | • Reply: finding rows that contain a non-numeric character artifact: c4dfa27f35 user: cleverly | |
20:53 | • Edit reply: finding rows that contain a non-numeric character artifact: 598f4b0c1a user: punkish | |
20:35 | • Reply: finding rows that contain a non-numeric character artifact: 587762cb21 user: punkish | |
20:32 | • Reply: finding rows that contain a non-numeric character artifact: 4014c0a860 user: punkish | |
20:31 | • Reply: finding rows that contain a non-numeric character artifact: 7b28a08e37 user: cleverly | |
20:29 | • Reply: finding rows that contain a non-numeric character artifact: da843cbfe4 user: chrisjlocke1 | |
20:20 | • Reply: finding rows that contain a non-numeric character artifact: 60fb641eba user: punkish | |
20:13 | • Reply: finding rows that contain a non-numeric character artifact: 66d368784d user: cleverly | |
19:46 | • Post: finding rows that contain a non-numeric character artifact: 8d476ada6f user: punkish | |
18:38 | • Edit reply: Persist query plans? artifact: d96122c249 user: jicman | |
18:36 | • Edit reply: Persist query plans? artifact: 6fab786d8f user: jicman | |
17:36 | • Reply: Persist query plans? artifact: ab489f3957 user: jicman | |
17:04 | • Reply: Persist query plans? artifact: 49268ef6b9 user: chrisjlocke1 | |
16:55 | • Reply: Persist query plans? artifact: cdf457f793 user: dvdraymond | |
16:48 | • Reply: Persist query plans? artifact: af110b1fa6 user: Clothears | |
16:26 | • Reply: Persist query plans? artifact: e5723126c8 user: biodrool | |
16:18 | • Reply: Persist query plans? artifact: 69a57ccbed user: dvdraymond | |
15:55 | • Post: Persist query plans? artifact: 083de03448 user: biodrool | |
15:12 | • Reply: Bug Report and Patch: LIKE operator mishandles U+0080 artifact: 05b33caf05 user: dan | |
12:29 | • Edit reply: sqlite3_update_hook - which changes are consiered? artifact: 524b9656ce user: jtheisen42 | |
12:15 | • Reply: sqlite3_update_hook - which changes are consiered? artifact: 2a3c3c9d97 user: jtheisen42 | |
12:00 | • Post: Bug Report and Patch: LIKE operator mishandles U+0080 artifact: 61bf7ccbdf user: chys00 | |
11:29 | • Reply: sqlite3_update_hook - which changes are consiered? artifact: dbba5f96e8 user: ddevienne | |
11:13 | • Reply: sqlite3_update_hook - which changes are consiered? artifact: 83cba5700f user: gunter_hick | |
06:15 | • Reply: System.Data.SQLite on macOS using C# ? artifact: 644a9f278a user: chrisjlocke1 | |
02:32 | • Post: sqlite3_update_hook - which changes are consiered? artifact: 58794c2d2d user: jtheisen42 | |
4 Years Ago (more context)
2021-10-14
| ||
20:50 | • Edit reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: 12b7857bbb user: mistachkin | |
18:15 | • Reply: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: eeaefb84ec user: mistachkin | |
15:27 | • Reply: sqlite .archive can't handle big files? artifact: 91ecd7cf73 user: schmitzu | |
15:06 | • Reply: sqlite .archive can't handle big files? artifact: e64e94a17a user: stephan | |
15:01 | • Post: sqlite .archive can't handle big files? artifact: 7d167e2a80 user: schmitzu | |
14:59 | • Reply: Pragma_Function_List() artifact: bba5790bc0 user: stephan | |
14:49 | • Edit reply: Pragma_Function_List() artifact: 65f256e964 user: ddevienne | |
14:47 | • Reply: Pragma_Function_List() artifact: 130b2f8c14 user: anonymous | |
14:46 | • Reply: binary .dump format artifact: b6eae8e5c9 user: RichardDamon | |
14:33 | • Edit reply: binary .dump format artifact: 698355ddf8 user: slavin | |
14:33 | • Reply: binary .dump format artifact: 7501594306 user: slavin | |
14:04 | • Reply: Pragma_Function_List() artifact: 48b468b7e4 user: drh | |
13:43 | • Reply: Pragma_Function_List() artifact: 7872a4aa18 user: ddevienne | |
13:22 | • Post: Pragma_Function_List() artifact: 76ab9d8b72 user: anonymous | |
12:07 | • Reply: binary .dump format artifact: 46fee948f9 user: RichardDamon | |
11:58 | • Reply: sqldiff for Windows 10 x 64 bits artifact: 1b2b1a1424 user: knu | |
11:47 | • Reply: binary .dump format artifact: 0a013984da user: ddevienne | |
10:10 | • Edit reply: binary .dump format artifact: 442587d3b7 user: slavin | |
10:08 | • Reply: binary .dump format artifact: 02470db818 user: slavin | |
09:06 | • Post: sqldiff for Windows 10 x 64 bits artifact: 31ba540c4a user: anonymous | |
09:03 | • Post: SQLiteDataReader.GetName() with UseUTF16Encoding option fails on Linux artifact: 1d1c43493a user: acatanzaro | |
06:54 | • Reply: inconsistent output: insert on conflict with returning artifact: 9cc8c73efc user: ddevienne | |
06:05 | • Reply: Different time spent in Windows and Linux artifact: ba83948884 user: Lyalot | |
03:18 | • Reply: SIGBUS in sqlite artifact: cf32387473 user: liziqi | |
5 Years Ago (more context)
2020-10-14
| ||
18:16 | • Reply: WHERE a IN (SELECT non-existing column ) artifact: 5f1d43a20d user: kmedcalf | |
18:07 | • Reply: WHERE a IN (SELECT non-existing column ) artifact: af72711e97 user: drh | |
17:57 | • Post: WHERE a IN (SELECT non-existing column ) artifact: 0125cd068c user: moskvich412 | |
16:57 | • Post: 'SQL logic error no such module: fts5' artifact: 05b8e74d07 user: zrzr23 | |
16:38 | • Reply: update-from on without rowid virtual tables artifact: 42def3a589 user: kev82 | |
15:38 | • Reply: update-from on without rowid virtual tables artifact: 8798cb45bb user: drh | |
13:58 | • Reply: Lack of abstraction ability in SQLite artifact: c267198590 user: cuz | |
13:51 | • Reply: Lack of abstraction ability in SQLite artifact: 773d63a809 user: gunter_hick | |
13:39 | • Reply: update-from on without rowid virtual tables artifact: fd6418cedd user: gunter_hick | |
13:37 | • Reply: Lack of abstraction ability in SQLite artifact: a1b9ccc564 user: knu | |
13:06 | • Reply: update-from on without rowid virtual tables artifact: 51489c3df8 user: kev82 | |
12:43 | • Reply: Error: near line 1: no such module: fts5 artifact: 9b0a4b210c user: mattkuine | |
12:37 | • Reply: update-from on without rowid virtual tables artifact: 1f56f76e9b user: gunter_hick | |
10:47 | • Reply: update-from on without rowid virtual tables artifact: 9a8d5c6845 user: kev82 | |
09:14 | • Edit reply: update-from on without rowid virtual tables artifact: b0c63169e6 user: gunter_hick | |
09:11 | • Reply: update-from on without rowid virtual tables artifact: dd39544eb3 user: gunter_hick | |
08:58 | • Post: Lack of abstraction ability in SQLite artifact: 1042988a22 user: mattkuine | |
08:12 | • Reply: update-from on without rowid virtual tables artifact: 89099ee832 user: kev82 | |
07:07 | • Edit reply: update-from on without rowid virtual tables artifact: 2395594044 user: kev82 | |