SQLite User Forum

Today In History
Login

This Day In History For 2025-06-05

1 Year Ago (more context)

2024-06-05
23:59 Reply: Retrieving the value of the auto-incrementing primary key. artifact: 07ac7ff8a2 user: ogogon
23:31 Reply: Corrupt Database Options artifact: 2b1e982c6d user: larrybr
23:15 Edit: Corrupt Database Options artifact: 8e4d8f2309 user: rsolomon
23:14 Post: Corrupt Database Options artifact: 1d119f6764 user: rsolomon
21:56 Reply: ATTACH appended database? artifact: cd3a958f74 user: larrybr
21:33 Post: ATTACH appended database? artifact: 118b648002 user: martin2020
14:22 Reply: A doc fix about SEH compiling artifact: 568611ed86 user: stephan
08:13 Reply: Electron App - Javascript Error: The specified proceedure could not be found for sqlite3 node module artifact: 86ec7677e1 user: stephan
07:04 Post: Electron App - Javascript Error: The specified proceedure could not be found for sqlite3 node module artifact: 315a3bc4ed user: yashroynext
05:07 Reply: Potential Vulnerability Report 2 potential vulnerability found in SQLite version 3.46.0 artifact: 326b71a100 user: Desmond
02:24 Reply: Retrieving the value of the auto-incrementing primary key. artifact: 6bfc5d59cc user: slavin

2 Years Ago (more context)

2023-06-05
21:20 Edit reply: .param lquoted iterals artifact: 2001abb759 user: AAsk1902
21:10 Reply: Delete triggers and constraints artifact: aec919a60d user: kmedcalf
21:09 Reply: .param lquoted iterals artifact: 0845918078 user: AAsk1902
20:19 Post: Delete triggers and constraints artifact: 6a02ca8acd user: Hardy
19:47 Reply: (Deleted) artifact: a37574e27e user: kmedcalf
18:45 Edit reply: Need someone who can convert SQLite 4 to excel artifact: 97bf35d099 user: AAsk1902
18:42 Edit reply: Need someone who can convert SQLite 4 to excel artifact: 6e01826f3a user: AAsk1902
18:39 Reply: Need someone who can convert SQLite 4 to excel artifact: 874abb7d29 user: AAsk1902
18:16 Reply: Need someone who can convert SQLite 4 to excel artifact: 613784c347 user: stephan
17:03 Reply: (Deleted) artifact: 3c3edf31e8 user: stk2si
16:26 Post: Need someone who can convert SQLite 4 to excel artifact: d7c1bb2bc2 user: kevink
16:04 Reply: (Deleted) artifact: 1a7e7f74ce user: sqlitening
15:54 Edit reply: .param lquoted iterals artifact: c39a2f0143 user: kmedcalf
15:54 Reply: .param lquoted iterals artifact: eecdb2502c user: kmedcalf
15:44 Reply: (Deleted) artifact: 74afd061a0 user: kmedcalf
15:31 Reply: Reverse function seems to work, missing in documentation? artifact: 88f614882e user: kmedcalf
15:06 Edit reply: Feature Request: shell prompt for query parameters artifact: 1d3e66e0a1 user: larrybr
15:04 Reply: Feature Request: shell prompt for query parameters artifact: a809034564 user: larrybr
14:32 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: f00ed57860 user: larrybr
12:57 Edit reply: .param lquoted iterals artifact: 1297af432d user: dkfellows
12:12 Reply: .param lquoted iterals artifact: 0a38fe5bec user: dkfellows
11:29 Reply: Parameter binding fails with nested query in WASM OO API artifact: f8f487b60b user: stephan
11:29 Reply: (Deleted) artifact: 7273fd436a user: dvdraymond
11:15 Reply: (Deleted) artifact: 802b31a54c user: gunter_hick
11:03 Reply: (Deleted) artifact: e7eca17b22 user: dvdraymond
10:42 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: a277728a37 user: dan
10:42 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: 0773d80972 user: dan
10:04 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: d427709a10 user: drh
08:54 Reply: Reverse function seems to work, missing in documentation? artifact: 2149060091 user: dkfellows
08:44 Reply: .param lquoted iterals artifact: 73c1dddf44 user: AAsk1902
08:38 Reply: .param lquoted iterals artifact: 248b37c94c user: dkfellows
08:35 Reply: Feature Request: shell prompt for query parameters artifact: 6a7df7f20d user: dkfellows
08:20 Reply: .param lquoted iterals artifact: f0d578a8a8 user: AAsk1902
07:46 Reply: Reverse function seems to work, missing in documentation? artifact: c8a22e1ff0 user: ralfbertling
07:28 Reply: (Deleted) artifact: 91afcc4df0 user: gunter_hick
07:06 Reply: .param lquoted iterals artifact: c47d6b5fdb user: lexfiend
06:26 Edit reply: (Deleted) artifact: e662a06e0d user: stk2si
06:25 Delete reply: (Deleted) artifact: 81e2bfe0e6 user: stk2si
06:21 Delete reply: (Deleted) artifact: 81d4762da3 user: stk2si
06:19 Reply: (Deleted) artifact: 9907de8a25 user: stk2si
06:18 Reply: .param lquoted iterals artifact: 76a70b47a0 user: AAsk1902
06:05 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: fe716aa913 user: junwha0511
06:01 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 7dba59bc3e user: junwha0511
05:59 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: ae5b34e0e4 user: junwha0511
05:57 Reply: (Deleted) artifact: 20df7b2c79 user: stk2si
05:52 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: a918b95e45 user: larrybr
05:48 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: 2c2faefd9a user: junwha0511
05:27 Reply: (Deleted) artifact: fbbd16720b user: gunter_hick
05:08 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 12ef846c74 user: junwha0511
05:06 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: def365188a user: junwha0511
05:05 Edit reply: Use After Free and Double Free bugs in dbstatus.test artifact: 8c8aeff659 user: junwha0511
05:05 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: bb591a6d0f user: junwha0511
05:03 Post: (Deleted) artifact: 3ba6772f42 user: stk2si
04:58 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: c3758d1548 user: larrybr
04:23 Reply: Use After Free and Double Free bugs in dbstatus.test artifact: 60d38a23e2 user: junwha0511
03:37 Reply: .param lquoted iterals artifact: e16c0be6c4 user: lexfiend

3 Years Ago (more context)

2022-06-05
23:09 Reply: Does vacuum ever result in data loss artifact: 5e78505eb4 user: RichardDamon
22:56 Reply: Does vacuum ever result in data loss artifact: 0633df6afd user: larrybr
22:43 Post: Does vacuum ever result in data loss artifact: 3bd787a793 user: daveryderoxford1
20:30 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 32588ee654 user: anonymous
20:20 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 13e01de407 user: zzzeek
20:02 Reply: bug:sqlite crash when I enter a sql query artifact: c385df2f76 user: drh
19:40 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 6e51b5142b user: anonymous
17:49 Edit reply: SQLAR table - add default mtime - request for ENH. artifact: 4593e9f4cc user: midijohnny
17:45 Reply: SQLAR table - add default mtime - request for ENH. artifact: c7cea2685d user: midijohnny
17:19 Reply: dbinfo usage artifact: 2312c2f392 user: slavin
17:16 Reply: SQLAR table - add default mtime - request for ENH. artifact: a78646b365 user: slavin
17:01 Reply: dbinfo usage artifact: 78e24881df user: Trudge
16:39 Reply: dbinfo usage artifact: 76011ac1f0 user: larrybr
16:18 Post: dbinfo usage artifact: d64d67dc95 user: Trudge
14:20 Reply: Experience with SQLite as a store of Files and Images artifact: 59894f6f7d user: Trudge
14:11 Reply: Experience with SQLite as a store of Files and Images artifact: d6c84524f0 user: anonymous
14:06 Reply: Small bug report for documentation artifact: da7de0db6d user: larrybr
13:14 Reply: Database is locking under Lazarus artifact: 6e295e2caf user: Graham77
12:19 Post: Small bug report for documentation artifact: 5dc6f352a4 user: anonymous
11:30 Edit: SQLAR table - add default mtime - request for ENH. artifact: f878644a43 user: midijohnny
11:29 Post: SQLAR table - add default mtime - request for ENH. artifact: 8ce7674fff user: midijohnny
10:31 Reply: bug:sqlite crash when I enter a sql query artifact: f29eebe708 user: drh
09:37 Reply: Database is locking under Lazarus artifact: ab373bcaa9 user: cuz
08:59 Edit reply: Experience with SQLite as a store of Files and Images artifact: a02a8bc478 user: midijohnny
08:59 Reply: Experience with SQLite as a store of Files and Images artifact: 21c7a759f9 user: midijohnny
08:52 Post: bug:sqlite crash when I enter a sql query artifact: dabe25e03e user: 2339762641
05:14 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 5d889e4387 user: kmedcalf
03:38 Reply: bug: sqlite3_changes returns incorrect value for UPDATE..RETURNING when table was dropped/created a second time on connection artifact: 81f8de89a2 user: slavin
02:55 Reply: Database is locking under Lazarus artifact: eefce8729a user: Graham77
02:50 Reply: Database is locking under Lazarus artifact: df25e232f0 user: Graham77

4 Years Ago (more context)

2021-06-05
23:59 Reply: FileIO extension artifact: 9c8decca92 user: anonymous
20:04 Post: Transaction level triggers? artifact: da3a75f46f user: anonymous
17:23 Reply: Opening DB from readonly filesystem (btrfs snapshot) artifact: 78f687573d user: Anchor
15:36 Reply: Anton Dyachenko artifact: 0ea0bd34a0 user: slavin
14:40 Reply: Query performance regression after v3.33.0 (OP_SeekScan?) artifact: 8c53a4c826 user: drh
14:35 Reply: Opening DB from readonly filesystem (btrfs snapshot) artifact: 42bcda311d user: dan
12:46 Reply: Query performance regression after v3.33.0 (OP_SeekScan?) artifact: 614a4f7cc7 user: dnamlin
11:47 Reply: Anton Dyachenko artifact: d4856d3e08 user: knu
11:40 Reply: Opening DB from readonly filesystem (btrfs snapshot) artifact: d339187fc0 user: wyoung
11:28 Post: Opening DB from readonly filesystem (btrfs snapshot) artifact: 1fd528d317 user: Anchor
11:04 Edit reply: FileIO extension artifact: 6ea1be078a user: wyoung
10:57 Reply: FileIO extension artifact: 21b9fd63bb user: wyoung
10:30 Reply: FileIO extension artifact: 4a85f72acb user: anonymous
04:32 Reply: FileIO extension artifact: 0c733d7bd2 user: anonymous
03:52 Reply: Anton Dyachenko artifact: 3a95b423dc user: anonymous
02:04 Post: FileIO extension artifact: 5cd55adf39 user: anonymous

5 Years Ago (more context)

2020-06-05
23:51 Reply: What version of Sqlite am I using? artifact: 1bab6eb035 user: anonymous
21:59 Reply: What version of Sqlite am I using? artifact: 7ace077428 user: LarryBrasfield
21:49 Reply: What version of Sqlite am I using? artifact: 414ac66284 user: anonymous
21:16 Post: What version of Sqlite am I using? artifact: bc302e4eaf user: doug9forester
19:56 Reply: Database WAL snapshot artifact: 6ce9d6d81d user: wmertens
19:23 Reply: Database WAL snapshot artifact: a1e093524f user: kmedcalf
18:32 Reply: Index question 2 artifact: e8e229c974 user: kmedcalf
17:57 Reply: Index question 2 artifact: c05a383d49 user: doug9forester
17:24 Reply: How to stop emails artifact: 606d05ac3d user: stephan
17:23 Reply: How to stop emails artifact: c081423e51 user: BernardoSulzbach
17:16 Post: How to stop emails artifact: 8afe685565 user: pizzipie
16:31 Reply: Database WAL snapshot artifact: bd15a8545c user: ddevienne
16:13 Reply: Database WAL snapshot artifact: f16413bb76 user: kmedcalf
15:49 Reply: Index question 2 artifact: 8ed9f82f37 user: kmedcalf
15:41 Reply: How to not to overwrite a row if the key exists? artifact: c41e48bdef user: kmedcalf
15:34 Reply: Database WAL snapshot artifact: aefb20931f user: mtijink
15:28 Reply: Database WAL snapshot artifact: ae351f8eb9 user: ddevienne
15:17 Reply: SQL compliance on Wikipedia artifact: e320eb9dd1 user: slavin
15:10 Reply: Database WAL snapshot artifact: 3b6d6c3bb5 user: kmedcalf
14:43 Reply: How to not to overwrite a row if the key exists? artifact: eae18c1b63 user: 6kEs4Majrd
14:43 Reply: Index question 2 artifact: c329e52935 user: ddevienne
14:40 Post: Index question 2 artifact: b348d45c09 user: doug9forester
14:07 Reply: Non primary key alias to rowid artifact: efeaf6f61c user: RichardDamon
14:04 Reply: How to not to overwrite a row if the key exists? artifact: f13dc431f9 user: cuz
14:00 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 69e3bb00bd user: 6kEs4Majrd
13:56 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 01fb49df7f user: 6kEs4Majrd
13:03 Reply: How to not to overwrite a row if the key exists? artifact: a0693a9e8a user: 6kEs4Majrd
12:51 Post: Database WAL snapshot artifact: d927316988 user: mtijink
12:47 Reply: index question artifact: f7757de15d user: dvdraymond
12:40 Reply: index question artifact: ca24b2946a user: luuk
12:37 Reply: index question artifact: 30aa68b339 user: luuk
12:19 Reply: index question artifact: 5277f1b57e user: dvdraymond
10:45 Reply: index question artifact: 9cdebd3ab6 user: LarryBrasfield
09:43 Reply: Non primary key alias to rowid artifact: f5b76570c2 user: marcob
08:30 Delete reply: Non primary key alias to rowid artifact: 5b800bf445 user: kmedcalf
08:23 Reply: Non primary key alias to rowid artifact: c203fecff1 user: kmedcalf
08:17 Reply: Non primary key alias to rowid artifact: 9c1c7252a0 user: kmedcalf
08:13 Reply: Non primary key alias to rowid artifact: a8e034845d user: kmedcalf
07:22 Reply: index question artifact: c960b43378 user: kmedcalf
07:06 Reply: Non primary key alias to rowid artifact: 662bd435ff user: marcob
06:58 Edit reply: How to not to overwrite a row if the key exists? artifact: 3d316d12af user: kmedcalf
06:53 Reply: How to not to overwrite a row if the key exists? artifact: bea0ac6bbf user: kmedcalf
06:53 Reply: Non primary key alias to rowid artifact: feea5f94b7 user: marcob
06:48 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 89a4340ad6 user: TripeHound
06:27 Post: index question artifact: ddbd0b4d75 user: doug9forester
06:26 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 869e4689ba user: kmedcalf
05:56 Reply: How to not to overwrite a row if the key exists? artifact: 6e464242cd user: wyoung
05:15 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 2787e066f9 user: 6kEs4Majrd
03:38 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 59c616d545 user: kmedcalf
03:36 Reply: How to not to overwrite a row if the key exists? artifact: 200b5af38f user: kmedcalf
02:27 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 147f135331 user: 6kEs4Majrd