This Day In History For 2024-04-08
1 Year Ago (more context)
|
2023-04-08
| ||
| 21:25 | • Reply: How do I escape punctuation in full text queries artifact: 3ab6266986 user: ldo289 | |
| 21:23 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 3fdd36b7f1 user: ldo289 | |
| 21:12 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 8c03b0e06b user: ldo289 | |
| 14:57 | • Reply: How to get the local timezone offset and name? artifact: b8e268313b user: larrybr | |
| 14:41 | • Reply: Support Binary representation like 0b01 artifact: d099590cdf user: DenisTRUFFAUT | |
| 14:07 | • Reply: ANN Database Designer artifact: af15a9be41 user: kmedcalf | |
| 13:38 | • Edit reply: How to get the local timezone offset and name? artifact: 43f739a1b4 user: kmedcalf | |
| 13:19 | • Reply: ANN Database Designer artifact: 0f98243abd user: slavin | |
| 12:23 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: fc60e61418 user: larrybr | |
| 12:19 | • Edit reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 0ca0a21514 user: drh | |
| 12:17 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 5ff3a97c62 user: drh | |
| 10:28 | • Reply: "UNION" + "WITH"? artifact: ac1b8888b1 user: midijohnny | |
| 08:35 | • Post: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: bee7e1ba77 user: macsql20 | |
| 04:33 | • Reply: ANN Database Designer artifact: 9deafe5426 user: anonymous | |
| 03:46 | • Reply: How to get the local timezone offset and name? artifact: 6217b95e3a user: lexfiend | |
| 02:55 | • Reply: ANN Database Designer artifact: 33b7c8176a user: wyoung | |
| 02:16 | • Reply: ANN Database Designer artifact: 0a1fdebbdc user: anonymous | |
2 Years Ago (more context)
|
2022-04-08
| ||
| 23:38 | • Post: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 14db09d7e7 user: anonymous | |
| 22:38 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: d3bc553a6b user: bjoern | |
| 20:38 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 814bae2ed7 user: midijohnny | |
| 20:35 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 2d2347dca0 user: midijohnny | |
| 18:00 | • Reply: caching SQLite database. artifact: 8a31c7439d user: bjoern | |
| 17:57 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: 0961365aeb user: bjoern | |
| 17:55 | • Edit reply: High level C interface to sqlite3 artifact: c4e840039d user: vman59 | |
| 17:40 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 32b06db530 user: bjoern | |
| 17:35 | • Edit reply: High level C interface to sqlite3 artifact: c0e877e8bd user: vman59 | |
| 17:35 | • Reply: How do I remove column wraps? artifact: 0908a826a9 user: kmedcalf | |
| 17:32 | • Post: RFE: add pragma_schema_version.schema column artifact: 59e33625ec user: bjoern | |
| 17:31 | • Edit reply: High level C interface to sqlite3 artifact: ed8df35242 user: vman59 | |
| 17:28 | • Reply: High level C interface to sqlite3 artifact: e0edc333e7 user: vman59 | |
| 17:18 | • Reply: integrity_check(100) calls progress callback millions of times. artifact: 1e37dee52c user: macsql20 | |
| 16:50 | • Post: .show artifact: cbd46a8e86 user: anonymous | |
| 16:43 | • Edit reply: Error: SQLite query - no such function: monthname artifact: 425ae59177 user: kmedcalf | |
| 16:41 | • Reply: Error: SQLite query - no such function: monthname artifact: a7a738a6ff user: kmedcalf | |
| 16:40 | • Reply: How do I remove column wraps? artifact: 10fc96c514 user: anonymous | |
| 16:27 | • Reply: Error: SQLite query - no such function: monthname artifact: aee494f743 user: EricTsau | |
| 16:22 | • Reply: Error: SQLite query - no such function: monthname artifact: e5b355b687 user: kmedcalf | |
| 16:11 | • Reply: Error: SQLite query - no such function: monthname artifact: be48829fdf user: EricTsau | |
| 16:04 | • Reply: How do I remove column wraps? artifact: 82d5527a1a user: kmedcalf | |
| 15:52 | • Reply: sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value artifact: 77bcdf4ac2 user: anonymous | |
| 15:34 | • Post: High level C interface to sqlite3 artifact: d2d4cc1b73 user: Markus | |
| 15:34 | • Reply: integrity_check(100) calls progress callback millions of times. artifact: 762866218f user: macsql20 | |
| 15:25 | • Reply: How do I remove column wraps? artifact: ca57ee4eb1 user: anonymous | |
| 15:10 | • Post: sqlite3_exec() function return values not described artifact: b777e373e4 user: kjames3411 | |
| 15:08 | • Post: Dropping rtree tables artifact: 800437aba7 user: hashbackup | |
| 14:58 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 9dcb632366 user: kmedcalf | |
| 13:28 | • Reply: SQL for update lat lon for same addresses artifact: 318b987bc1 user: RBSmissaert | |
| 13:16 | • Reply: How do I remove column wraps? artifact: 52bb5987f0 user: Clothears | |
| 12:31 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 8a3f9e6e39 user: riyaz-ali | |
| 12:26 | • Reply: How do I remove column wraps? artifact: 7734a8a196 user: cuz | |
| 09:44 | • Reply: Error: SQLite query - no such function: monthname artifact: 485c8c0919 user: anonymous | |
| 09:14 | • Reply: Error: SQLite query - no such function: monthname artifact: e8b35deacc user: cuz | |
| 09:09 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: e068041cd7 user: ddevienne | |
| 09:02 | • Reply: Is it actually possible to limit SQLITE3 memory usage? artifact: 6d3b372a04 user: ddevienne | |
| 08:47 | • Edit reply: How do I remove column wraps? artifact: ba561b57a8 user: midijohnny | |
| 08:46 | • Edit reply: How do I remove column wraps? artifact: 1d9f3bcc79 user: midijohnny | |
| 08:45 | • Edit reply: How do I remove column wraps? artifact: c6fd90b16f user: midijohnny | |
| 08:41 | • Reply: How do I remove column wraps? artifact: d5b2edb825 user: anonymous | |
| 08:26 | • Reply: pragma_table_info - JOIN/FROM order - different behaviour. artifact: 3171094ed0 user: midijohnny | |
| 08:16 | • Reply: How do I remove column wraps? artifact: 69eda1f441 user: anonymous | |
| 08:05 | • Edit reply: How do I remove column wraps? artifact: d4daa89aba user: midijohnny | |
| 08:01 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: e8ff886dee user: riyaz-ali | |
| 07:59 | • Reply: How do I remove column wraps? artifact: e25f46d1be user: midijohnny | |
| 07:56 | • Reply: How do I remove column wraps? artifact: dc29fe0767 user: midijohnny | |
| 07:52 | • Edit reply: How do I remove column wraps? artifact: 6ccc408553 user: midijohnny | |
| 07:51 | • Edit reply: How do I remove column wraps? artifact: 709daeb781 user: midijohnny | |
| 07:47 | • Reply: How do I remove column wraps? artifact: 6a1ede84ce user: anonymous | |
| 07:13 | • Reply: How do I remove column wraps? artifact: 89110fbda1 user: anonymous | |
| 06:34 | • Edit reply: Error: SQLite query - no such function: monthname artifact: 964264e3af user: sqlitening | |
| 06:22 | • Edit reply: Error: SQLite query - no such function: monthname artifact: 23e70ea507 user: sqlitening | |
| 06:18 | • Edit reply: Error: SQLite query - no such function: monthname artifact: fbc600e07c user: sqlitening | |
| 06:16 | • Reply: Error: SQLite query - no such function: monthname artifact: 42e8898471 user: sqlitening | |
| 05:40 | • Reply: How do I remove column wraps? artifact: 50768e2969 user: gunter_hick | |
| 05:33 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 31a5bcf770 user: gunter_hick | |
| 05:17 | • Reply: SQLite does not invoke xBegin for SELECT queries on virtual tables artifact: 033d6245f3 user: riyaz-ali | |
| 05:15 | • Reply: Is it actually possible to limit SQLITE3 memory usage? artifact: b50c6151b6 user: larrybr | |
| 04:56 | • Reply: Error: SQLite query - no such function: monthname artifact: 430ae4488c user: hanche | |
| 03:07 | • Post: Error: SQLite query - no such function: monthname artifact: ef6aa89877 user: anonymous | |
| 01:49 | • Edit reply: SQL for update lat lon for same addresses artifact: d0aa6e0f5b user: kmedcalf | |
| 01:40 | • Reply: How do I remove column wraps? artifact: 21bdcf7a39 user: larrybr | |
| 00:37 | • Reply: SQL for update lat lon for same addresses artifact: aac3c20bf6 user: kmedcalf | |
3 Years Ago (more context)
|
2021-04-08
| ||
| 23:50 | • Reply: Impact analysis for "larger-databases" change artifact: 3d651caefd user: anonymous | |
| 23:22 | • Post: json_contains Function Idea artifact: e419e520d0 user: SeverKetor | |
| 21:58 | • Post: how to pre allocate my SQLite database to a certain size artifact: 1a4e37b176 user: researchstudent2021 | |
| 21:36 | • Post: VACUUM resets journal_mode wal2 to delete artifact: e3acdc2a75 user: w.oertl | |
| 20:02 | • Reply: impact of cache_size artifact: 8c519c5a89 user: kmedcalf | |
| 19:35 | • Reply: impact of cache_size artifact: d171f6971b user: kasztelan77 | |
| 18:34 | • Reply: misuse not detected artifact: 10ae48a9f3 user: antlor | |
| 18:29 | • Reply: misuse not detected artifact: e65a82f871 user: kmedcalf | |
| 18:23 | • Edit reply: misuse not detected artifact: 3cff7a2806 user: kmedcalf | |
| 18:11 | • Reply: misuse not detected artifact: e18f1eff37 user: kmedcalf | |
| 17:24 | • Post: misuse not detected artifact: b941b3a1e7 user: antlor | |
| 17:15 | • Reply: index misuse? artifact: d8368bfda4 user: dan | |
| 16:55 | • Edit reply: index misuse? artifact: fde1020273 user: wulian | |
| 16:53 | • Reply: index misuse? artifact: 6891eac881 user: wulian | |
| 16:08 | • Reply: index misuse? artifact: 6a41d6f506 user: Hardy | |
| 16:02 | • Edit reply: index misuse? artifact: b6b5f9b5e0 user: dan | |
| 16:01 | • Edit reply: index misuse? artifact: 744d2dec09 user: dan | |
| 15:56 | • Reply: index misuse? artifact: 84c5a8ba1e user: dan | |
| 15:46 | • Edit reply: index misuse? artifact: 031ddbfc35 user: wulian | |
| 14:47 | • Reply: index misuse? artifact: 20689df109 user: wulian | |
| 12:15 | • Reply: index misuse? artifact: 3ac87a7dc7 user: gunter_hick | |
| 11:35 | • Reply: index misuse? artifact: 8770f890e2 user: wulian | |
| 11:18 | • Reply: index misuse? artifact: 0824edd0e3 user: dan | |
| 07:26 | • Edit: index misuse? artifact: 1c0afcbc0d user: wulian | |
| 07:13 | • Post: index misuse? artifact: 0ea95130f5 user: wulian | |
| 04:40 | • Reply: Impact analysis for "larger-databases" change artifact: 5fc05f511e user: KevinYouren | |
| 04:05 | • Reply: Impact analysis for "larger-databases" change artifact: 0ccdefc28f user: ThanksRyan | |
| 03:39 | • Reply: Saving Wikipedia to SQLite artifact: 46f5004bfc user: ThanksRyan | |
| 01:37 | • Post: Impact analysis for "larger-databases" change artifact: b9f269a42e user: KevinYouren | |
| 01:12 | • Edit reply: Query triggers Segmentation Fault artifact: ba2189d29e user: LY1598773890 | |
| 01:10 | • Reply: Query triggers Segmentation Fault artifact: 5412f98c86 user: LY1598773890 | |
4 Years Ago (more context)
|
2020-04-08
| ||
| 22:52 | • Reply: Bug in ALTER TABLE ADD COLUMN artifact: ffa5244727 user: dfgriggs | |
| 22:43 | • Reply: Please explain the error on insert artifact: b667e0c686 user: doug9forester | |
| 22:39 | • Reply: Explicitly specifying the function calling convention in the public functions artifact: 32f637f5de user: std_haxxer | |
| 22:35 | • Reply: Explicitly specifying the function calling convention in the public functions artifact: baa88ee9de user: std_haxxer | |
| 21:43 | • Post: Retrieve match context with FTS5 artifact: 2c59f9da21 user: davidgf | |
| 17:03 | • Reply: alter table RENAME COLUMN took 3 hours artifact: c42121c26b user: lcarlp | |
| 16:34 | • Reply: Quick lookup of like terms in FS5 index artifact: 77a7c7617e user: bbtmike | |
| 15:12 | • Reply: Quick lookup of like terms in FS5 index artifact: 5ac896f660 user: dan | |
| 15:05 | • Post: Bug in ALTER TABLE ADD COLUMN artifact: 21c7b443aa user: PeterJanRoes | |
| 14:55 | • Reply: Explicitly specifying the function calling convention in the public functions artifact: 2438e82a4d user: drh | |
| 12:51 | • Reply: Select every nth record from table artifact: d7209d7840 user: dvdraymond | |
| 10:35 | • Reply: Please explain the error on insert artifact: 43812b8a92 user: kmedcalf | |
| 09:50 | • Reply: Please explain the error on insert artifact: f581f80dfa user: gunter_hick | |
| 09:38 | • Reply: Please explain the error on insert artifact: ea8805e974 user: gunter_hick | |
| 06:23 | • Reply: Explicitly specifying the function calling convention in the public functions artifact: ff24c2baa0 user: gunter_hick | |
| 06:07 | • Reply: Please explain the error on insert artifact: b5460455d1 user: doug9forester | |
| 05:41 | • Post: Explicitly specifying the function calling convention in the public functions artifact: a7bc3defff user: std_haxxer | |
| 05:06 | • Reply: How to upgrade sqlite3 version artifact: 85710bca75 user: kmedcalf | |
| 05:01 | • Reply: Please explain the error on insert artifact: 4f9ba989f1 user: kmedcalf | |
| 04:27 | • Post: Please explain the error on insert artifact: 735db586f4 user: doug9forester | |
| 04:01 | • Reply: alter table RENAME COLUMN took 3 hours artifact: bee587c7d5 user: wyoung | |
| 00:10 | • Post: How to upgrade sqlite3 version artifact: da1c60ad62 user: anonymous | |