SQLite User Forum

Today In History
Login

This Day In History For 2025-06-04

1 Year Ago (more context)

2024-06-04
18:42 Reply: artificial intelligence as indexing artifact: 87d55c8b44 user: anonymous
18:07 Reply: UPDATE multiple values in column FROM JSON object artifact: 2d4a29f321 user: maraca
16:26 Reply: Retrieving the value of the auto-incrementing primary key. artifact: 520a726778 user: Clothears
15:25 Reply: Retrieving the value of the auto-incrementing primary key. artifact: af420786c2 user: ogogon
15:18 Reply: artificial intelligence as indexing artifact: 5fb7a8003b user: moskvich412
14:42 Edit reply: Retrieving the value of the auto-incrementing primary key. artifact: 17f7c17afe user: ddevienne
14:39 Reply: Retrieving the value of the auto-incrementing primary key. artifact: 7c4ea6cb8e user: ddevienne
14:25 Edit: Retrieving the value of the auto-incrementing primary key. artifact: cec4ac89e8 user: ogogon
14:22 Post: Retrieving the value of the auto-incrementing primary key. artifact: b9b3759b2a user: ogogon
14:03 Reply: artificial intelligence as indexing artifact: 80ad9c2acb user: rogerbinns
11:19 Reply: Potential Vulnerability Report 2 potential vulnerability found in SQLite version 3.46.0 artifact: 222e849cd3 user: Desmond
10:26 Post: A doc fix about SEH compiling artifact: 3bbb92c395 user: Maxulite
10:12 Reply: Potential Vulnerability Report 2 potential vulnerability found in SQLite version 3.46.0 artifact: c8063f7d35 user: stephan
07:34 Post: Potential Vulnerability Report 2 potential vulnerability found in SQLite version 3.46.0 artifact: b3ee82acbf user: Desmond
05:28 Edit reply: Inconsistent docs for the ->> operator artifact: 6178d9970e user: PChemGuy
05:21 Edit reply: Inconsistent docs for the ->> operator artifact: b23adbf1c3 user: PChemGuy
04:10 Reply: Inconsistent docs for the ->> operator artifact: 3ded3dbce1 user: PChemGuy
03:12 Reply: Add support for -quiet option? artifact: 38e5963213 user: anonymous
02:21 Reply: DROP COLUMN artifact: 759c230b05 user: anonymous
02:20 Reply: DROP COLUMN artifact: c0042e2140 user: anonymous

2 Years Ago (more context)

2023-06-04
21:39 Reply: Parameter binding fails with nested query in WASM OO API artifact: 8158967d96 user: stephan
21:19 Post: Parameter binding fails with nested query in WASM OO API artifact: 40ce55bdf5 user: agile_assembler
20:14 Reply: download error. artifact: e48c831f69 user: larrybr
20:08 Reply: download error. artifact: cb7eab28a8 user: stephan
20:03 Post: download error. artifact: 5fd3d0042c user: anonymous
17:56 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: e2a95940b1 user: drh
17:52 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: 43ad46adb9 user: junwha0511
17:52 Delete reply: Use After Free and Double Free bugs in dbstatus.test artifact: 1d1fb98d0a user: junwha0511
17:52 Delete reply: Use After Free and Double Free bugs in dbstatus.test artifact: 6cdaf9defc user: junwha0511
17:50 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 553caa6810 user: junwha0511
17:49 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 661e926012 user: junwha0511
17:47 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: f5e1e3d9e9 user: junwha0511
17:46 Edit: Use After Free and Double Free bugs in dbstatus.test artifact: 6b06a34d81 user: junwha0511
17:42 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 5a4bb10c7a user: junwha0511
17:40 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: 1fa12cda03 user: junwha0511
17:00 Reply: .param lquoted iterals artifact: f9c55b55f3 user: larrybr
16:34 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: f2e7301e37 user: drh
15:24 Edit: Use After Free and Double Free bugs in dbstatus.test artifact: 4f8901b0bf user: junwha0511
15:18 Post: Use After Free and Double Free bugs in dbstatus.test artifact: 67f86ef3fc user: junwha0511
13:27 Edit reply: .param lquoted iterals artifact: 296b696266 user: kmedcalf
13:26 Edit reply: .param lquoted iterals artifact: 8df634374c user: kmedcalf
13:24 Reply: .param lquoted iterals artifact: ccea0a9149 user: kmedcalf
11:24 Reply: .param lquoted iterals artifact: d4b25877ff user: jake
10:58 Edit: .param lquoted iterals artifact: c1a9080a85 user: AAsk1902
10:56 Edit: .param lquoted iterals artifact: e94f0cb322 user: AAsk1902
10:55 Edit: .param lquoted iterals artifact: 280b6d65ea user: AAsk1902
10:53 Post: .param lquoted iterals artifact: cc295c297b user: AAsk1902
00:16 Reply: Suggestion: JSON support artifact: 1f8c81b6a6 user: larrybr

3 Years Ago (more context)

2022-06-04
22:13 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 1db2223c35 user: kmedcalf
21:13 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 397abefa91 user: zzzeek
18:02 Reply: Experience with SQLite as a store of Files and Images artifact: 7898f44548 user: stephan
17:49 Reply: Experience with SQLite as a store of Files and Images artifact: 068438001c user: Trudge
17:45 Reply: Considering using SQLite, question about support artifact: 2e1ee33594 user: Trudge
17:19 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 4693ec6723 user: kmedcalf
15:48 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 04fd9f50f6 user: zzzeek
12:41 Post: WAL File Grows Past Auto Checkpoint Limit artifact: 915267efb1 user: abarr6
05:06 Edit reply: Considering using SQLite, question about support artifact: 4292989aaf user: stephan
05:05 Reply: Considering using SQLite, question about support artifact: 3cdae939d8 user: stephan
03:57 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: 65bc2559d1 user: vinser
03:19 Delete reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: 89e603bf91 user: vinser
03:18 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: 14e5a5df96 user: vinser
03:13 Edit reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: a2207a4df7 user: vinser
02:03 Reply: SQLite FTS5 SELECT doesn't MATCH Ukrainian 'Усмiшки' artifact: 1538f46b9a user: vinser
01:50 Reply: Considering using SQLite, question about support artifact: 68f2244c4f user: slavin

4 Years Ago (more context)

2021-06-04
21:19 Edit reply: Setting TOP variable does not set tcl scripts correctly artifact: 3e312b2d2b user: larrybr
21:16 Reply: Windows Build Instructions Are Not Current artifact: 5e3c2607c8 user: larrybr
21:13 Reply: Setting TOP variable does not set tcl scripts correctly artifact: a401ddf867 user: larrybr
20:27 Post: Setting TOP variable does not set tcl scripts correctly artifact: ea17133117 user: anonymous
20:20 Post: Windows Build Instructions Are Not Current artifact: 36a58d9f5e user: anonymous
19:34 Reply: Broken logical NOT in ext/misc/regexp.c artifact: d0b9108a0b user: andse-t610
18:29 Reply: Query performance regression after v3.33.0 (OP_SeekScan?) artifact: ef9582f06f user: drh
16:19 Reply: Broken logical NOT in ext/misc/regexp.c artifact: 9b8c234f4d user: drh
15:05 Edit: Broken logical NOT in ext/misc/regexp.c artifact: 9104f0d9e7 user: andse-t610
14:57 Post: Broken logical NOT in ext/misc/regexp.c artifact: 3fa09346c1 user: andse-t610
14:26 Reply: conversion of literal values, or lack thereof artifact: 88f42578fc user: drh
12:49 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 8711fd9380 user: andse-t610
12:33 Post: conversion of literal values, or lack thereof artifact: 0ff4ede3e1 user: pooryorick
11:46 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 231c09ed3c user: drh
11:40 Reply: Anton Dyachenko artifact: 12032ed896 user: slavin
11:06 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 4a68fe4b04 user: andse-t610
10:39 Reply: Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization artifact: 46e5440d75 user: andse-t610
05:36 Reply: The CopySQLiteInteropFiles target in the NuGet package no longer works in Visual Studio 16.10 artifact: a6f909f1a4 user: sparkplug
03:35 Reply: memory vs mmap artifact: a4430ed5bb user: kerravon
03:18 Reply: memory vs mmap artifact: 8054573692 user: kerravon
02:07 Reply: Typo on the draft release notes? artifact: ab165b3ded user: anonymous

5 Years Ago (more context)

2020-06-04
23:38 Reply: Non primary key alias to rowid artifact: f6c90dc3f4 user: kmedcalf
23:32 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 3beed2e7a2 user: kmedcalf
23:26 Reply: select in order artifact: a426b97b30 user: kmedcalf
23:09 Post: How to not to overwrite a row if the key exists? artifact: e43fdc7c65 user: 6kEs4Majrd
19:17 Reply: Non primary key alias to rowid artifact: 10a0190c92 user: RichardDamon
18:25 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 4c4a6382b8 user: 6kEs4Majrd
18:20 Reply: Min/max and index usage? artifact: ce5c0ca7f5 user: gwaldron
18:13 Reply: SQL compliance on Wikipedia artifact: 29b964c06d user: anonymous
17:46 Reply: select in order artifact: d9a28d61eb user: resuna
17:12 Reply: Non primary key alias to rowid artifact: 4c3d137a09 user: marcob
17:08 Reply: Non primary key alias to rowid artifact: e591bad9c8 user: marcob
16:45 Reply: Min/max and index usage? artifact: bb865a9927 user: drh
16:32 Post: Min/max and index usage? artifact: 2dee98f8b7 user: gwaldron
15:53 Reply: How to generate split amalgamation code in current release? artifact: 121c634d7d user: curmudgeon
15:32 Edit reply: Non primary key alias to rowid artifact: 2e3666f630 user: kmedcalf
15:23 Reply: Non primary key alias to rowid artifact: 79428a8551 user: kmedcalf
14:55 Reply: Non primary key alias to rowid artifact: 4c0acffd51 user: RichardDamon
14:34 Edit reply: Non primary key alias to rowid artifact: 9ba9ab9c7d user: kmedcalf
14:34 Reply: Non primary key alias to rowid artifact: ac4cd17326 user: marcob
14:28 Reply: Non primary key alias to rowid artifact: 05de6b422d user: kmedcalf
14:23 Edit: Non primary key alias to rowid artifact: 622d013b11 user: marcob
14:13 Reply: Problems related to writing following queries can someone write all these queries? artifact: f497bd1a01 user: kmedcalf
14:09 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: a5746fb174 user: kmedcalf
13:55 Reply: Non primary key alias to rowid artifact: d547994810 user: dvdraymond
13:23 Reply: Problems related to writing following queries can someone write all these queries? artifact: f51ccca4e6 user: LarryBrasfield
12:41 Post: Why libsqlite3.a and libsqlite3.a.dylib is not build? artifact: 1498a5a68b user: my_sqlite2020
12:36 Reply: Non primary key alias to rowid artifact: f47200f1c5 user: RichardDamon
12:36 Post: How to generate split amalgamation code in current release? artifact: 9e3b6584a4 user: my_sqlite2020
12:20 Edit: Caution: clang-11.0.0 miscompiled SQLite artifact: 296b7c1e02 user: drh
12:01 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 9dad5cb85f user: 6kEs4Majrd
11:46 Post: Problems related to writing following queries can someone write all these queries? artifact: 4cc4cd6a99 user: anonymous
11:35 Reply: Non primary key alias to rowid artifact: d0935296b7 user: gunter_hick
10:47 Reply: Sd card mount/unmount artifact: 990db6e080 user: ayagmur75
10:29 Edit: Caution: clang-11.0.0 miscompiled SQLite artifact: 510dac1a54 user: drh
09:30 Post: Non primary key alias to rowid artifact: df09d93498 user: marcob
09:17 Post: Sd card mount/unmount artifact: 98bab5671b user: ayagmur75
07:58 Post: Cannot compile 3.32.1 with SQLITE_OMIT_EXPLAIN artifact: 057d2bc5d4 user: anonymous
06:59 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 8a7f276c0b user: cladisch
06:44 Reply: SELECT * Column Sequence / Order (not ORDER BY) artifact: 9bb0773815 user: gunter_hick
06:17 Reply: Is there a way to wait until the database is available? artifact: 352b350748 user: gunter_hick
06:08 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: e5db7c3075 user: gunter_hick
03:34 Post: Caution: clang-11.0.0 miscompiled SQLite artifact: e7e828bb6f user: drh
02:11 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: c8e6f96d76 user: 6kEs4Majrd
00:58 Reply: Problem with select from Sqlite Expo. I can't save the array returned by the query through the hook function artifact: 9023287b20 user: LarryBrasfield
00:25 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 931be182c2 user: stephan
00:13 Post: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: db4c917a7b user: 6kEs4Majrd