SQLite User Forum

Today In History
Login

This Day In History For 2024-03-27

1 Year Ago (more context)

2023-03-27
23:59 Reply: A more useful sqlite3_complete artifact: bf8d2ec2e5 user: anonymous
23:30 Post: A more useful sqlite3_complete artifact: 666f572d3c user: rogerbinns
22:12 Edit: Assertion failure in sqlite3WhereEnd function artifact: dc3b92cfa0 user: songliu
22:06 Reply: Schema-less SQLite artifact: fc8a373e78 user: marcob
21:55 Post: Assertion failure in sqlite3WhereEnd function artifact: 38dceb5cb8 user: songliu
21:02 Reply: subscribing to queries / an inverted database artifact: 431a1cb1e2 user: tantaman
20:28 Reply: Sharing a database across processes and threads. artifact: 6157fd6d1d user: mkorobkom
20:15 Reply: Schema-less SQLite artifact: 20f03d2b30 user: steida
20:04 Reply: Uniqueidentifier column artifact: f4b620ef42 user: knu
20:01 Reply: Schema-less SQLite artifact: c08ac7e941 user: anonymous
19:53 Reply: SQLite Wasm for Safari And Firefox progress artifact: 077fe894a0 user: stephan
19:39 Reply: Is there such a PRAGMA/SQLTE command? artifact: 1e26cf4052 user: oneeyeman
19:35 Reply: SQLite Wasm for Safari And Firefox progress artifact: e3ec46d132 user: stephan
19:26 Reply: Poor performance of SQLite on GCP artifact: 9c0bca7bd4 user: larrybr
19:19 Reply: SQLite Wasm for Safari And Firefox progress artifact: c48ab5b11a user: steida
19:18 Edit reply: Is there such a PRAGMA/SQLTE command? artifact: bb8d109d6b user: larrybr
19:16 Reply: Is there such a PRAGMA/SQLTE command? artifact: de5be1d185 user: larrybr
19:02 Edit reply: subscribing to queries / an inverted database artifact: 56d5e16c34 user: tantaman
19:00 Reply: subscribing to queries / an inverted database artifact: e2da3029e7 user: tantaman
18:59 Edit reply: subscribing to queries / an inverted database artifact: b387e63dba user: tantaman
18:57 Reply: subscribing to queries / an inverted database artifact: dca87b5b87 user: tantaman
18:57 Reply: Is there such a PRAGMA/SQLTE command? artifact: d7bd640d2a user: oneeyeman
18:54 Reply: Poor performance of SQLite on GCP artifact: 5de9b6079d user: horsey
18:53 Reply: Poor performance of SQLite on GCP artifact: feb17622d0 user: anonymous
18:52 Reply: Schema-less SQLite artifact: 37af41cec5 user: steida
18:51 Reply: subscribing to queries / an inverted database artifact: 8256267177 user: tantaman
18:49 Edit reply: Poor performance of SQLite on GCP artifact: 61cdb943d7 user: tantaman
18:49 Reply: Poor performance of SQLite on GCP artifact: adef4842da user: horsey
18:49 Reply: Is there such a PRAGMA/SQLTE command? artifact: 23311cdc2f user: larrybr
18:48 Edit reply: Poor performance of SQLite on GCP artifact: 40a4241219 user: tantaman
18:47 Reply: Uniqueidentifier column artifact: 83293a169b user: anonymous
18:46 Reply: Poor performance of SQLite on GCP artifact: 0f309db70a user: tantaman
18:39 Reply: Is there such a PRAGMA/SQLTE command? artifact: 954103ba91 user: oneeyeman
18:35 Reply: Telescoping the integer primary keys? artifact: 0f66071afd user: kmedcalf
18:31 Reply: Is there such a PRAGMA/SQLTE command? artifact: c2e3081388 user: larrybr
18:17 Edit: Is there such a PRAGMA/SQLTE command? artifact: 636b1f609a user: oneeyeman
18:16 Reply: Poor performance of SQLite on GCP artifact: 2ff5a15f1b user: kmedcalf
18:16 Post: Is there such a PRAGMA/SQLTE command? artifact: 87ea5a17a1 user: oneeyeman
18:16 Reply: Telescoping the integer primary keys? artifact: 75d41017d6 user: ddevienne
18:07 Edit reply: Telescoping the integer primary keys? artifact: 5563f29ece user: kmedcalf
18:03 Reply: Telescoping the integer primary keys? artifact: e492b2c4c5 user: kmedcalf
17:59 Reply: Poor performance of SQLite on GCP artifact: 11b5238cda user: horsey
17:59 Reply: Poor performance of SQLite on GCP artifact: ae2c3d89f6 user: jicman
17:45 Reply: Poor performance of SQLite on GCP artifact: 116d20c183 user: kmedcalf
17:39 Reply: Poor performance of SQLite on GCP artifact: 7606777af0 user: kmedcalf
17:27 Reply: Telescoping the integer primary keys? artifact: ea55e8b737 user: ddevienne
17:24 Post: Poor performance of SQLite on GCP artifact: c0e709c0c8 user: horsey
17:15 Reply: Telescoping the integer primary keys? artifact: fd206a5f7e user: nji9nji9
17:06 Edit reply: Telescoping the integer primary keys? artifact: 6474ba7adb user: kmedcalf
16:49 Reply: Telescoping the integer primary keys? artifact: 5c06dbb31c user: kmedcalf
16:15 Reply: Telescoping the integer primary keys? artifact: ed9e2c014b user: kmedcalf
16:06 Reply: subscribing to queries / an inverted database artifact: 049044a8c7 user: slavin
15:54 Reply: Telescoping the integer primary keys? artifact: b77f40ea97 user: nji9nji9
15:46 Reply: subscribing to queries / an inverted database artifact: 962a4cd42b user: ddevienne
15:37 Reply: Uniqueidentifier column artifact: f29270f984 user: ddevienne
14:41 Reply: subscribing to queries / an inverted database artifact: a71051833d user: kmedcalf
14:31 Reply: The craziest thing I ever used SQLite for: partial file deduplication artifact: c529642319 user: anonymous
14:20 Reply: subscribing to queries / an inverted database artifact: 147df7a6de user: anonymous
14:04 Reply: Telescoping the integer primary keys? artifact: baba55bc2c user: kmedcalf
13:44 Post: subscribing to queries / an inverted database artifact: a8601f38c7 user: tantaman
12:57 Reply: SQLite Wasm for Safari And Firefox progress artifact: 82b8c882f4 user: stephan
12:54 Edit reply: Schema-less SQLite artifact: cbef18c939 user: tantaman
12:53 Reply: SQLite Wasm for Safari And Firefox progress artifact: 429dabf700 user: stephan
12:52 Reply: Uniqueidentifier column artifact: 5364c46be4 user: anonymous
12:43 Reply: SQLite Wasm for Safari And Firefox progress artifact: a708c98dcb user: burtan
12:24 Reply: Uniqueidentifier column artifact: f1ec98f39e user: slavin
12:13 Edit reply: select + union + order by substr() fails artifact: af3ee89bd4 user: lexfiend
12:12 Reply: select + union + order by substr() fails artifact: 271a66d70c user: lexfiend
12:11 Reply: Schema-less SQLite artifact: 731f090538 user: tantaman
11:53 Reply: SQLite Wasm for Safari And Firefox progress artifact: 49afa68e9e user: burtan
11:52 Reply: Incorrect results produced by last trunk version artifact: 582d89bfde user: drh
11:26 Edit reply: Telescoping the integer primary keys? artifact: adc418114d user: nji9nji9
11:18 Reply: bitwise operators on blobs artifact: 5c27e7c936 user: lexfiend
11:04 Reply: Telescoping the integer primary keys? artifact: 8b86adcaab user: nji9nji9
10:12 Reply: The craziest thing I ever used SQLite for: partial file deduplication artifact: a09abd748c user: drh
09:37 Reply: Telescoping the integer primary keys? artifact: 7752d0e0f8 user: ddevienne
09:17 Post: bitwise operators on blobs artifact: 3c99e85735 user: ddevienne
09:13 Reply: Uniqueidentifier column artifact: e9b7a6a5fb user: ddevienne
08:59 Reply: Telescoping the integer primary keys? artifact: 78542a1124 user: nji9nji9
08:25 Edit reply: Uniqueidentifier column artifact: b11e808ff5 user: ddevienne
08:22 Reply: Uniqueidentifier column artifact: adaa663b02 user: ddevienne
07:40 Reply: select + union + order by substr() fails artifact: 2575754e07 user: ddevienne
07:38 Post: Column aliases inside FROM artifact: 8bb91711c8 user: anonymous
07:32 Reply: SQLite Wasm for Safari And Firefox progress artifact: aafdf02b72 user: burtan
06:08 Post: Uniqueidentifier column artifact: 3b7319c608 user: anonymous
02:17 Post: Incorrect results produced by last trunk version artifact: ab0f2e97b2 user: ChiZhang
02:07 Post: select + union + order by substr() fails artifact: f72131485f user: dmausner
01:01 Reply: Import csv file artifact: 6aa7ba1414 user: kmedcalf
00:48 Reply: Import csv file artifact: 2b420821fc user: mhnsqlite
00:27 Reply: Import csv file artifact: f6ca5eeaf2 user: kmedcalf
00:05 Post: Bug: vtab xSync/xCommit called without xBegin artifact: e97aa532cf user: bjoern

2 Years Ago (more context)

2022-03-27
20:37 Reply: Incorrect 3.38.2 win64 download artifact: 55c4b376f8 user: gabrielepx
14:24 Post: RFE: destructor fp for sqlite3_index_info.idxStr artifact: 1bd67ca9a4 user: bjoern
11:01 Reply: How to escape parameters artifact: 5f12459a9a user: anonymous
08:21 Reply: Excel formulas in SQLITE artifact: 75ad1f4c87 user: anonymous
02:27 Post: Incorrect 3.38.2 win64 download artifact: f0f7826e23 user: anonymous
01:15 Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: 50ed003616 user: anonymous
00:24 Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: ecde02f778 user: drh
00:02 Reply: NULL vs null in ->, ->> and json_extract() as per JSON1.html doc section 4.5 artifact: 12d5533dc0 user: anonymous

3 Years Ago (more context)

2021-03-27
23:50 Reply: Error: near "returning": syntax error artifact: 81e71caee1 user: larrybr
23:07 Reply: Error: near "returning": syntax error artifact: a6ead566ab user: anonymous
22:57 Reply: Window function is not functioning as expected artifact: f697df233b user: anonymous
22:45 Reply: Window function is not functioning as expected artifact: 203b6fa957 user: anonymous
21:47 Edit reply: Error: near "returning": syntax error artifact: 167d1851c9 user: Clothears
21:45 Reply: Error: near "returning": syntax error artifact: a4dde39b61 user: Clothears
21:24 Post: Error: near "returning": syntax error artifact: b7ed4a7b3e user: anonymous
20:34 Reply: Window function is not functioning as expected artifact: d35402c815 user: kmedcalf
19:56 Post: (Deleted) artifact: f2b97bd99d user: 1codedebugger
17:47 Reply: Novice question about running UTF-8 on CLI from file. artifact: 937727cc4e user: 1codedebugger
17:40 Reply: Novice question about running UTF-8 on CLI from file. artifact: 3125bd3704 user: hanche
16:24 Reply: Novice question about running UTF-8 on CLI from file. artifact: 2c1b69927e user: Trudge
15:03 Reply: Window function is not functioning as expected artifact: 4435537103 user: balaji
14:49 Reply: Novice question about running UTF-8 on CLI from file. artifact: ad6d5f92c7 user: TripeHound
13:20 Post: CLI manual could be clearer on which commands support pipes artifact: 77528f770c user: ilkkachu
11:19 Reply: Novice question about running UTF-8 on CLI from file. artifact: f91e8d58ef user: cuz
11:09 Reply: Window function is not functioning as expected artifact: 74f22b6905 user: anonymous
08:47 Reply: Window function is not functioning as expected artifact: d4c5405c84 user: anonymous
04:47 Reply: Novice question about running UTF-8 on CLI from file. artifact: 7ef72b1b51 user: 1codedebugger
04:22 Reply: Novice question about running UTF-8 on CLI from file. artifact: 9b30198744 user: kmedcalf
04:02 Post: Novice question about running UTF-8 on CLI from file. artifact: 1e5222a094 user: 1codedebugger
02:20 Reply: Window function is not functioning as expected artifact: 04b2d31b62 user: kmedcalf
02:19 Reply: Window function is not functioning as expected artifact: 7020671f37 user: balaji
02:14 Reply: SQLite Version 3.35.0 - Beta 1 artifact: a42cf4ada9 user: malbrain
02:09 Reply: Window function is not functioning as expected artifact: ef21c03784 user: balaji
01:56 Reply: Window function is not functioning as expected artifact: 3820dff397 user: kmedcalf
01:53 Reply: How to set the column separator for the CSV extension in the CLI? artifact: 50e41b6c60 user: rbucker
01:29 Post: Window function is not functioning as expected artifact: 9ef6bd86db user: balaji

4 Years Ago (more context)

2020-03-27
21:36 Post: 3.31.1: docs as PDF? artifact: ec2c2ac4df user: richs
19:38 Reply: Anonymous posting should be disabled on SQLite Forum artifact: edb4e19385 user: anonymous
19:23 Reply: Daily activity alert grouped by thread artifact: 1c84171145 user: rallets
19:04 Reply: Natural sort order artifact: 8c501ae681 user: drh
18:50 Reply: Natural sort order artifact: be3cda8e78 user: drh
18:30 Reply: Daily activity alert grouped by thread artifact: f7d00546cd user: andreas-kupries
18:26 Reply: Anonymous posting should be disabled on SQLite Forum artifact: c5fd9ff572 user: ddevienne
18:25 Reply: Natural sort order artifact: 4cf020bfca user: andreas-kupries
18:12 Reply: Natural sort order artifact: c8946dc808 user: slavin
17:39 Reply: Natural sort order artifact: d5cf6c6317 user: GSnyder
16:51 Edit reply: Natural sort order artifact: c3b97c9fdb user: drh
16:50 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 368371d0ed user: anonymous
16:45 Reply: Natural sort order artifact: a02ab91c95 user: hatfinch
16:42 Edit reply: Natural sort order artifact: f6ccb9a5f8 user: ddevienne
16:40 Reply: Natural sort order artifact: 2af900a459 user: ddevienne
16:34 Reply: SQLite Forum: "Unsubscribe" link artifact: 0d558c9540 user: drh
16:28 Reply: SQLite Forum: "Unsubscribe" link artifact: 1ba2686ff4 user: drh
16:28 Reply: API to get / set memory DB? artifact: 8a7c40410d user: ddevienne
16:11 Reply: API to get / set memory DB? artifact: 8fa6809f06 user: drh
16:09 Post: SQLite Forum: "Unsubscribe" link artifact: 61cd0f8121 user: StephenC
16:07 Post: API to get / set memory DB? artifact: 882d7e72d2 user: ddevienne
16:06 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 640d043870 user: Clothears
16:03 Reply: Natural sort order artifact: 7fc899c651 user: drh
15:46 Reply: Anonymous posting should be disabled on SQLite Forum artifact: ffa4dfa0e3 user: ddevienne
15:38 Reply: Natural sort order artifact: 607d928d33 user: stephan
15:27 Edit reply: Natural sort order artifact: 03b358afb2 user: drh
15:25 Reply: Natural sort order artifact: 2d80e3b892 user: drh
14:34 Post: Natural sort order artifact: cff93834d2 user: anonymous
14:25 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 34419a5a74 user: stephan
14:11 Reply: Quoting is hard artifact: 86b5082d8d user: stephan
13:42 Post: Getting virtual table function in schema. artifact: 933c87e78b user: vman59
13:37 Reply: Quoting is hard artifact: 3f9870a33a user: resuna
13:26 Edit reply: Anonymous posting should be disabled on SQLite Forum artifact: 7a6ef03a59 user: ddevienne
13:25 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 096e626a69 user: cuz
13:25 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 9f86f94286 user: ddevienne
13:23 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 2e82b9486d user: ddevienne
12:34 Post: docs: minor typo artifact: 116ce9ed94 user: missinglink
12:29 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 0fd3ed86fe user: drh
12:23 Post: Daily activity alert grouped by thread artifact: d6b0e73638 user: rallets
12:18 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 132e994b9a user: stephan
11:28 Reply: Anonymous posting should be disabled on SQLite Forum artifact: 9fc0266f94 user: cuz
10:57 Post: Anonymous posting should be disabled on SQLite Forum artifact: 7558b20946 user: ddevienne
09:56 Reply: When will/were recent "sqlite3 new security issues CVEs" be addressed? artifact: eeaf9cf9c2 user: anonymous
09:24 Post: Custom Collation of a calculated field artifact: df1aafaa43 user: DaveBlake
07:42 Reply: Insert or ignore in a trigger artifact: 3c0634eb13 user: kmedcalf
06:04 Reply: Insert or ignore in a trigger artifact: 39c8be6ae8 user: Jan
01:11 Reply: the fallback column affinity should be BLOB, not NUMERIC artifact: 2028dc039e user: anonymous