SQLite User Forum

Today In History
Login

This Day In History For 2025-06-08

1 Year Ago (more context)

2024-06-08
22:20 Reply: xCheckReservedLock doc and possible WebAssembly bug artifact: e2c886b9bf user: stephan
21:54 Reply: Is the indentation of "explain <query>" a feature of the sqlite shell? artifact: 9d9aa43aa0 user: drh
21:40 Reply: Is the indentation of "explain <query>" a feature of the sqlite shell? artifact: 0ffa8bd328 user: _blgl_
20:46 Edit: Is the indentation of "explain <query>" a feature of the sqlite shell? artifact: dd07f0f2f4 user: rene-n
20:38 Post: Is the indentation of "explain <query>" a feature of the sqlite shell? artifact: bf1f70003f user: rene-n
17:25 Post: Use transient in-memory SQLite database as inter-thread communication channel? artifact: e57853f3a5 user: martin2020
17:25 Post: xCheckReservedLock doc and possible WebAssembly bug artifact: a2f573b00c user: rhashimoto
14:20 Reply: Intuitions about the page cache with multiple connections artifact: 9ccbb523bd user: anonymous
14:03 Reply: ATTACH appended database? artifact: c708b2b548 user: martin2020
13:37 Reply: Intuitions about the page cache with multiple connections artifact: 2fb8d7de7e user: Vanilagy
13:16 Edit reply: How to make sqlite use merge sort? artifact: 5b1803aeee user: slavin
10:18 Reply: WASM: Error getting sync handle for xWrite artifact: c9c0688ac1 user: stephan
09:12 Reply: Add option for a process exclusive mode to open files on Windows artifact: 1c23034fd6 user: anonymous

2 Years Ago (more context)

2023-06-08
19:36 Reply: sqlite3_recover_run Sementation Fault (3410200) artifact: 5b82c9c2fb user: bramankp
18:47 Reply: sqlite3_recover_run Sementation Fault (3410200) artifact: b7b37f19e8 user: dan
18:24 Reply: sqlite3_recover_run Sementation Fault (3410200) artifact: cdeeed88c9 user: bramankp
17:53 Reply: Option to make SQLite stricter with non-aggregate columns artifact: 7ed06b3839 user: jkreibich
17:03 Reply: Option to make SQLite stricter with non-aggregate columns artifact: 83029caa7d user: kmedcalf
16:54 Reply: Option to make SQLite stricter with non-aggregate columns artifact: c562f4bc4b user: deonb
16:40 Reply: Option to make SQLite stricter with non-aggregate columns artifact: b44a847424 user: lcarlp
16:37 Reply: (Deleted) artifact: b7fe2b379f user: kmedcalf
15:30 Reply: Option to make SQLite stricter with non-aggregate columns artifact: 7abdaf67eb user: kmedcalf
15:11 Reply: (Deleted) artifact: f27a3ad275 user: sqlitening
14:31 Reply: Option to make SQLite stricter with non-aggregate columns artifact: 77321da4a0 user: anonymous
14:26 Reply: sqlite3_recover_run Sementation Fault (3410200) artifact: 3cd36e9a6d user: bramankp
14:16 Post: sqlite3_recover_run Sementation Fault (3410200) artifact: e7432a2c04 user: bramankp
11:21 Edit: Option to make SQLite stricter with non-aggregate columns artifact: 7481d2a6df user: yannsalmon
11:21 Post: Option to make SQLite stricter with non-aggregate columns artifact: 3a5775ee80 user: yannsalmon
07:18 Reply: .param lquoted iterals artifact: 6d07f08326 user: dkfellows

3 Years Ago (more context)

2022-06-08
21:46 Edit reply: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 91ac9b9dc6 user: thesamesam
21:45 Edit reply: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 5a2db490d4 user: thesamesam
18:07 Post: JSON Merge Patch a set of rows artifact: af098c32b4 user: anonymous
16:33 Reply: Duplicate column name Importe didn't see CR/LF artifact: ae18888e17 user: larrybr
15:34 Edit reply: Duplicate column name Importe didn't see CR/LF artifact: 7a58f6bc5b user: Gael4429
15:33 Reply: Duplicate column name Importe didn't see CR/LF artifact: 83037ab7be user: Gael4429
15:30 Reply: How SQLite Works: documentation typo artifact: a38fa8730c user: r-ricci
15:11 Post: How SQLite Works: documentation typo artifact: 30037127c6 user: r-ricci
15:07 Edit: Database locked exception in Mutlithread App artifact: 86f7b126e4 user: kannang
14:56 Edit: Database locked exception in Mutlithread App artifact: b27b53d5c7 user: kannang
14:46 Reply: Duplicate column name Importe didn't see CR/LF artifact: fd63402e39 user: larrybr
14:28 Post: Duplicate column name Importe didn't see CR/LF artifact: 452202731e user: Gael4429
14:05 Post: Database locked exception in Mutlithread App artifact: b567b43818 user: kannang
13:55 Reply: getting "no suck table" error artifact: 2ae1661514 user: larrybr
13:33 Reply: Unexpected Result by RIGHT JOIN with INDEX artifact: 0e35064abd user: bajinsheng
13:29 Edit reply: getting "no suck table" error artifact: a002d11ad9 user: rbucker
13:27 Reply: getting "no suck table" error artifact: 474eb1c39a user: rbucker
12:50 Reply: Unexpected Result by RIGHT JOIN with INDEX artifact: 19ed84f6c5 user: drh
11:45 Edit: getting "no suck table" error artifact: de0f08a8e9 user: drh
11:35 Reply: constraint names not used in foreign key error messages artifact: 906926b4af user: dkfellows
11:34 Edit: Unexpected Result by RIGHT JOIN with INDEX artifact: c4676c4956 user: bajinsheng
11:34 Reply: constraint names not used in foreign key error messages artifact: 3de9dc17fe user: dkfellows
11:34 Reply: constraint names not used in foreign key error messages artifact: d00aae4847 user: stephan
11:24 Reply: constraint names not used in foreign key error messages artifact: 26c886864e user: drh
11:20 Post: constraint names not used in foreign key error messages artifact: 0d4309b9c3 user: dkfellows
10:14 Reply: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 62b4321277 user: thesamesam
09:58 Edit: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 3664dfe988 user: thesamesam
09:56 Edit: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: aa5cc0ea18 user: thesamesam
09:55 Edit: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: ad4b1bb31d user: thesamesam
09:52 Edit: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 96e6a51137 user: thesamesam
09:50 Edit: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 08e47be357 user: thesamesam
08:21 Post: veryquick.test test hangs on HPPA (after e_blobclose.test) artifact: 6e6c6e759b user: thesamesam
05:47 Post: Unexpected Result by RIGHT JOIN with INDEX artifact: ceda8c61f0 user: bajinsheng
05:43 Reply: Unexpected Result by ORDER BY artifact: ef18a06f8c user: bajinsheng
04:45 Reply: getting "no suck table" error artifact: 188d5ab066 user: slavin
03:13 Reply: Get SQLITE_READONLY when using UPDATE command artifact: 2a58499e16 user: jdennis
02:45 Edit: getting "no suck table" error artifact: 4f014ae248 user: rbucker
02:44 Post: getting "no suck table" error artifact: 4493a58ead user: rbucker

4 Years Ago (more context)

2021-06-08
21:45 Reply: Requesting optimization for index expression case artifact: ec2dac5ff7 user: deonb
20:44 Reply: Requesting optimization for index expression case artifact: 8fc7c5d0b7 user: kmedcalf
20:20 Reply: Requesting optimization for index expression case artifact: 780b44cc6b user: drh
20:14 Reply: Requesting optimization for index expression case artifact: 763512b641 user: deonb
19:10 Reply: Feature request: Stored Procedures artifact: b7ea1c20fa user: anonymous
19:09 Reply: Requesting optimization for index expression case artifact: d615acf5a8 user: drh
19:01 Post: Requesting optimization for index expression case artifact: c63c0442c8 user: deonb
17:57 Reply: Interpreting output from showdb artifact: 7906c85e96 user: drh
15:27 Edit: (Deleted) artifact: f5ba56a8d9 user: Chanda
15:26 Reply: (Deleted) artifact: 709ddc07e2 user: Chanda
13:58 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: 747402a7a0 user: walter
13:50 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: 77e5ff29fd user: larrybr
13:48 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: 41cf48541f user: walter
13:45 Reply: (Deleted) artifact: 6170119742 user: larrybr
13:20 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: e567b8456f user: larrybr
12:59 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: af87d67fb1 user: walter
12:45 Reply: Interpreting output from showdb artifact: a60ea5a4d4 user: jbulow
12:41 Post: (Deleted) artifact: 47858c99f7 user: Chanda
12:18 Reply: Interpreting output from showdb artifact: 7dbfb55eb4 user: drh
12:09 Edit: how to use dbstat table in a trigger? artifact: f52ba49e3e user: drh
12:04 Reply: how to download older version artifact: fa8a6c6ace user: drh
11:59 Reply: how to use dbstat table in a trigger? artifact: ff7b9ea437 user: drh
11:53 Reply: Feature request: Stored Procedures artifact: d22b2c1eab user: ddevienne
11:32 Reply: Feature request: Stored Procedures artifact: a720247d2f user: CecilWesterhof
11:31 Reply: Anton Dyachenko artifact: 678a922d99 user: anonymous
11:31 Post: how to download older version artifact: 525e120238 user: anonymous
11:11 Post: Interpreting output from showdb artifact: 22836be0e2 user: jbulow
10:36 Reply: Docker JDBC 3.34.0 -> 3.35.0 artifact: ab5c55e930 user: wyoung
10:24 Reply: The CopySQLiteInteropFiles target in the NuGet package no longer works in Visual Studio 16.10 artifact: 40a5f81eb1 user: anonymous
09:42 Reply: Transaction level triggers? artifact: f45a35abb3 user: anonymous
06:56 Post: how to use dbstat table in a trigger? artifact: 3850f283ce user: loki1993
06:23 Post: Docker JDBC 3.34.0 -> 3.35.0 artifact: ceece56ade user: walter

5 Years Ago (more context)

2020-06-08
23:45 Reply: Updating unique columns feature request artifact: 7384961324 user: slavin
21:26 Reply: PRAGMA wal_checkpoint and sync artifact: 202d7594c6 user: anonymous
21:25 Reply: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" artifact: 84ab43e2b5 user: codeservice
21:03 Reply: Updating unique columns feature request artifact: 9bb57562b9 user: LarryBrasfield
20:57 Reply: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" artifact: 3e27027253 user: wyoung
20:51 Reply: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" artifact: b40f76d94c user: codeservice
20:45 Reply: Updating unique columns feature request artifact: 89f49fa96b user: wyoung
20:43 Reply: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" artifact: b910540124 user: wyoung
20:39 Post: Updating unique columns feature request artifact: fd9b663672 user: younique
20:24 Post: java.lang.UnsatisfiedLinkError: dlopen failed: cannot locate symbol "__atomic_store_4" artifact: 513dbeebd8 user: codeservice
20:14 Reply: Is it safe to VACUUM on a new database connection? artifact: ee12082f14 user: wyoung
20:07 Reply: Native math function support for SQLite artifact: f9e6545b9e user: younique
19:37 Reply: Problem with select from Sqlite Expo. I can't save the array returned by the query through the hook function artifact: 4e5c0ea7fc user: example-user
18:18 Post: DB operation inside commit hook / enforce explicit INTEGER PRIMARY KEY column artifact: 60d3620eef user: sn0wbl1nd
17:42 Reply: Native math function support for SQLite artifact: 22c922aee1 user: anonymous
16:35 Reply: Is it safe to VACUUM on a new database connection? artifact: 4fd69e1fc1 user: slavin
14:47 Post: Measuring CPU usage in SQLite artifact: dbaac9f65b user: anonymous
13:52 Reply: Min/max and index usage? artifact: 630ceae880 user: cuz
13:41 Edit reply: attach-stmt syntax documentation ? artifact: 576fb2f597 user: rchapman
13:32 Edit: Closed, answered myself Cannot select from newly created tables with Python 3 connector artifact: 8f431ab094 user: zhangysh1995
13:31 Reply: Min/max and index usage? artifact: 5be1567a24 user: itandetnik
13:31 Reply: Closed, answered myself Cannot select from newly created tables with Python 3 connector artifact: d851579e31 user: zhangysh1995
13:30 Reply: Min/max and index usage? artifact: d1c778ad8b user: cuz
13:27 Reply: Automated Tests artifact: 4096210b98 user: drh
13:18 Reply: Password-protected databases no longer work with 1.113, no rollback possible artifact: daf6a9a9e0 user: stephan
13:14 Reply: Min/max and index usage? artifact: 5ff06cbcab user: zhangysh1995
13:14 Reply: tcl / db eval error artifact: 6b629cb915 user: resuna
13:05 Reply: Automated Tests artifact: 8f3f80cf86 user: swdev1
12:59 Reply: Password-protected databases no longer work with 1.113, no rollback possible artifact: 67fa59f3b7 user: tagelus
12:02 Post: Closed, answered myself Cannot select from newly created tables with Python 3 connector artifact: c55c1dbf94 user: zhangysh1995
11:41 Reply: Automated Tests artifact: a6d0faccdc user: wyoung
11:37 Reply: Native math function support for SQLite artifact: 003dcda074 user: wyoung
11:25 Post: Automated Tests artifact: 5c788f5ae0 user: swdev1
08:07 Post: doc improvement suggestion, perhaps a deficiency artifact: 1b8149ecf6 user: LarryBrasfield
07:45 Edit reply: Native math function support for SQLite artifact: 0722ddbe86 user: LarryBrasfield
06:55 Reply: Native math function support for SQLite artifact: 75af95cc67 user: gunter_hick
06:45 Reply: Database WAL snapshot artifact: b9795370ec user: mtijink
04:29 Reply: Is it safe to VACUUM on a new database connection? artifact: 1440dae4e8 user: sqweek
03:59 Post: Is it safe to VACUUM on a new database connection? artifact: b238495f2a user: anonymous