SQLite User Forum

Today In History
Login

This Day In History For 2024-03-28

1 Year Ago (more context)

2023-03-28
22:05 Reply: Does SQLite WASM include the zipfile support? artifact: 2bd725f67c user: stephan
21:17 Reply: Very slow query needs help to be faster artifact: d6b3bc45a4 user: dvdraymond
20:54 Reply: SQLITE_LOCKED from WAL_CHECKPOINT artifact: aa6022f7c1 user: Nikratio
20:51 Edit: SQLITE_LOCKED from WAL_CHECKPOINT artifact: 6d71cfc1cd user: Nikratio
20:50 Reply: CROSS JOIN doc bug? artifact: fe6013a487 user: bjoern
20:47 Reply: Very slow query needs help to be faster artifact: 4256368054 user: bjoern
20:47 Post: Does SQLite WASM include the zipfile support? artifact: 542011d1ea user: mandolyte
20:35 Reply: SQLITE_LOCKED from WAL_CHECKPOINT artifact: e631bf0634 user: dan
20:29 Post: SQLITE_LOCKED from WAL_CHECKPOINT artifact: 9e1ad35f07 user: Nikratio
20:27 Post: Very slow query needs help to be faster artifact: cab91315de user: jicman
20:13 Reply: update two columns on another table when an update happen on the table artifact: 418c6a86cb user: JLHainaut
20:04 Reply: optimize with External Content Table and Vacuum Question artifact: 5fbcb9b398 user: dan
18:53 Edit reply: CROSS JOIN doc bug? artifact: 82f756f693 user: kmedcalf
18:51 Reply: CROSS JOIN doc bug? artifact: 41a45feec4 user: kmedcalf
18:24 Post: CROSS JOIN doc bug? artifact: 73686851c9 user: howardk
18:08 Reply: SQLite Wasm for Safari And Firefox progress artifact: f95958ac8d user: stephan
18:04 Reply: SQLite Wasm for Safari And Firefox progress artifact: baf234eeff user: burtan
18:01 Reply: Is this an incorrect optimization? artifact: 420e68fc11 user: anonymous
17:10 Reply: Order of rows in RTree query artifact: f04073e9b3 user: anonymous
16:08 Reply: Assertion failure in agginfoPersistExprCb function artifact: 62cc8c93e9 user: songliu
15:43 Post: optimize with External Content Table and Vacuum Question artifact: 76ba8d931b user: JerContact
15:24 Reply: Order of rows in RTree query artifact: fb9fb42f51 user: drh
14:37 Reply: HELP with SQL query artifact: 3450261603 user: dvdraymond
14:34 Post: Order of rows in RTree query artifact: 40a0686741 user: anonymous
14:31 Reply: HELP with SQL query artifact: 2da128ee85 user: dvdraymond
14:25 Reply: HELP with SQL query artifact: e906d9c558 user: jicman
14:10 Reply: Poor performance of SQLite on GCP artifact: 391f2b4c76 user: kmedcalf
14:07 Reply: Poor performance of SQLite on GCP artifact: 249d80299f user: kmedcalf
14:04 Reply: Poor performance of SQLite on GCP artifact: 8c0760578c user: kmedcalf
13:51 Post: HELP with SQL query artifact: b2299073a2 user: anonymous
13:44 Reply: SQLite Wasm for Safari And Firefox progress artifact: 4aebe5cca4 user: stephan
13:44 Reply: Poor performance of SQLite on GCP artifact: 51ba477025 user: ddevienne
13:35 Reply: Poor performance of SQLite on GCP artifact: bce1f2db49 user: wyoung
13:33 Reply: SQLite Wasm for Safari And Firefox progress artifact: d742c9f21a user: burtan
13:15 Reply: SQLite Wasm for Safari And Firefox progress artifact: 14a9560547 user: burtan
13:13 Reply: Poor performance of SQLite on GCP artifact: b2853374f5 user: anonymous
12:55 Post: Assertion failure in agginfoPersistExprCb function artifact: bad532820c user: songliu
12:50 Reply: SQLite Wasm for Safari And Firefox progress artifact: b2f08c8a65 user: stephan
12:42 Reply: Uniqueidentifier column artifact: f8048b93b1 user: knu
12:27 Reply: Poor performance of SQLite on GCP artifact: 8328ca79a2 user: wyoung
12:24 Reply: Assertion failure in sqlite3WhereEnd function artifact: f8b3a3cdbd user: songliu
12:11 Reply: Is this an incorrect optimization? artifact: 10c4a57e7d user: ddevienne
11:57 Reply: Is this an incorrect optimization? artifact: 2de0e50db1 user: drh
11:52 Reply: Is this an incorrect optimization? artifact: 3d59bb5c5c user: ddevienne
11:37 Reply: Is this an incorrect optimization? artifact: f2a7f4ee5c user: drh
11:24 Reply: Assertion failure in sqlite3WhereEnd function artifact: e7a13d3885 user: drh
11:18 Reply: SQLite Wasm for Safari And Firefox progress artifact: 3396af0bac user: burtan
10:40 Reply: update two columns on another table when an update happen on the table artifact: 00cc510429 user: yanalroot
10:13 Reply: Is this an optimization in ORDER BY clause with a PRIMARY column artifact: e9a44cabe6 user: drh
08:44 Post: Is this an incorrect optimization? artifact: 60f85edfaf user: John-Jove
07:44 Post: Is this an optimization in ORDER BY clause with a PRIMARY column artifact: a2bde2b8f9 user: John-Jove
06:18 Reply: Poor performance of SQLite on GCP artifact: 2841defb25 user: anonymous
04:35 Edit reply: Uniqueidentifier column artifact: 17096badd6 user: stephan
04:35 Edit reply: Uniqueidentifier column artifact: a12e455cfa user: stephan
04:25 Reply: Uniqueidentifier column artifact: 72787e3f6b user: anonymous
01:17 Reply: Incorrect results produced by last trunk version artifact: 8ec7c6907e user: ChiZhang
01:14 Reply: Is there such a PRAGMA/SQLTE command? artifact: 07e5f45b46 user: kmedcalf
01:11 Reply: Is there such a PRAGMA/SQLTE command? artifact: bd6457b66f user: kmedcalf
00:56 Reply: Poor performance of SQLite on GCP artifact: adfcc078ce user: kmedcalf

2 Years Ago (more context)

2022-03-28
23:11 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: 64671596d4 user: anonymous
22:50 Reply: Excel formulas in SQLITE artifact: 2fbb41aecc user: anonymous
15:25 Reply: How to escape parameters artifact: 2388649378 user: anonymous
11:17 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: 1bdf0f1be0 user: anonymous
10:33 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: ba8943ac47 user: anonymous
08:16 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: e090564de1 user: anonymous
07:48 Reply: How to escape parameters artifact: a6c4d7ec9d user: sqweek
07:17 Edit reply: How to escape parameters artifact: 97e08bbd61 user: bokwoon
07:16 Reply: How to escape parameters artifact: aebe52cb1d user: bokwoon
06:59 Reply: RFE: destructor fp for sqlite3_index_info.idxStr artifact: 2b281179c1 user: gunter_hick

3 Years Ago (more context)

2021-03-28
22:58 Edit reply: Query Contraint with an if clause? artifact: 8d9efbec4b user: kmedcalf
22:00 Reply: "ERROR ON LOAD EXTENSION" artifact: 700586f957 user: kmedcalf
21:14 Reply: Query Contraint with an if clause? artifact: 6056ad879f user: kmedcalf
21:07 Reply: "ERROR ON LOAD EXTENSION" artifact: 4d2cb4617a user: BenediktRothe
20:54 Reply: Query Contraint with an if clause? artifact: db8f9ffbc2 user: samrusso4
20:38 Reply: Query Contraint with an if clause? artifact: cc3a8818d2 user: samrusso4
19:31 Reply: "ERROR ON LOAD EXTENSION" artifact: 21355ed4b1 user: kmedcalf
19:22 Reply: "ERROR ON LOAD EXTENSION" artifact: 2c92c0c10c user: kmedcalf
19:08 Reply: Query Contraint with an if clause? artifact: 1d60147f5f user: kmedcalf
17:54 Edit reply: "ERROR ON LOAD EXTENSION" artifact: 520b30e47f user: larrybr
15:50 Reply: "ERROR ON LOAD EXTENSION" artifact: 320b084e06 user: anonymous
13:03 Reply: "ERROR ON LOAD EXTENSION" artifact: 415c4b5dbc user: larrybr
12:48 Post: "ERROR ON LOAD EXTENSION" artifact: 4c8eb1ae31 user: BenediktRothe
12:20 Edit reply: Query Contraint with an if clause? artifact: b1141f0f84 user: slavin
12:20 Edit reply: Query Contraint with an if clause? artifact: 3edf200a8c user: slavin
12:19 Reply: Query Contraint with an if clause? artifact: d2a1f5e24d user: slavin
12:14 Reply: Novice question about running UTF-8 on CLI from file. artifact: 5792632b04 user: slavin
10:44 Post: Query Contraint with an if clause? artifact: fc45379a23 user: samrusso4

4 Years Ago (more context)

2020-03-28
23:38 Reply: feature request: Add option to UNIQUE constrain to treat NULLs as distinct artifact: 84475108b9 user: kmedcalf
23:33 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 8081d6bc16 user: kmedcalf
21:54 Post: feature request: Add option to UNIQUE constrain to treat NULLs as distinct artifact: eea57652c6 user: anonymous
21:15 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: f6e605cb6a user: slavin
20:24 Post: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 2c440868be user: PongoZ
17:09 Reply: 3.31.1: docs as PDF? artifact: def5198152 user: KlaasZ4usVanBv
17:04 Reply: 3.31.1: docs as PDF? artifact: 6f43cc62fd user: KlaasZ4usVanBv
16:14 Reply: 3.31.1: docs as PDF? artifact: 0fc89292a5 user: luuk
15:28 Reply: 3.31.1: docs as PDF? artifact: 198bea5ea0 user: richs
15:25 Reply: 3.31.1: docs as PDF? artifact: 2f4d15c423 user: richs
14:41 Reply: 3.31.1: docs as PDF? artifact: 21ad5cf208 user: anonymous
12:37 Reply: 3.31.1: docs as PDF? artifact: e3632f5171 user: drh
12:08 Reply: Compilation error on MSVC when using strict floating-point behavior artifact: 1574ede538 user: drh
09:57 Post: Compilation error on MSVC when using strict floating-point behavior artifact: 3afbec7e58 user: anonymous