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 | |