This Day In History For 2024-04-13
1 Year Ago (more context)
|
2023-04-13
| ||
| 20:39 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 53c5ccd70d user: jicman | |
| 20:23 | • Reply: A new option, possibly, for CLI: -utf8 artifact: ca00630ae0 user: larrybr | |
| 20:03 | • Reply: A new option, possibly, for CLI: -utf8 artifact: e840c52d22 user: jicman | |
| 20:01 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 1c0e71db90 user: jicman | |
| 19:57 | • Post: Windows Page Code 65001 makes CLI hang artifact: 15c9dacbdc user: jicman | |
| 19:37 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 615abb2d2a user: larrybr | |
| 19:31 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 041bc6195c user: larrybr | |
| 19:28 | • Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: df1407acb9 user: anonymous | |
| 19:23 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 2f95def83d user: larrybr | |
| 18:57 | • Edit reply: A new option, possibly, for CLI: -utf8 artifact: a211ff6518 user: jicman | |
| 18:50 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 59a6c9d4dc user: jicman | |
| 18:40 | • Reply: C-APP ERROR: SQLITE_SCHEMA no such table artifact: 9954027135 user: sqlitevexee | |
| 17:59 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 9898838d28 user: larrybr | |
| 17:52 | • Reply: sqlite Update not work correctly but not return error artifact: 81d32c11d9 user: larrybr | |
| 17:40 | • Post: sqlite Update not work correctly but not return error artifact: ff8c67c67b user: faustf | |
| 17:07 | • Reply: C-APP ERROR: SQLITE_SCHEMA no such table artifact: c7b79477e3 user: TripeHound | |
| 16:40 | • Post: C-APP ERROR: SQLITE_SCHEMA no such table artifact: 43a8363bff user: sqlitevexee | |
| 16:39 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 1d3ed3f814 user: anonymous | |
| 15:33 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 45e85d6aac user: jicman | |
| 15:14 | • Reply: A new option, possibly, for CLI: -utf8 artifact: cd993cd930 user: larrybr | |
| 15:05 | • Edit reply: A new option, possibly, for CLI: -utf8 artifact: 9e806ce225 user: jicman | |
| 14:55 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 74f06224c8 user: lexfiend | |
| 14:40 | • Post: Assertion failure in sqlite3ExprAffinity function (2) artifact: ff3840145a user: songliu | |
| 13:58 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 9aaf36e585 user: jicman | |
| 13:44 | • Reply: A new option, possibly, for CLI: -utf8 artifact: f4b69421b5 user: jicman | |
| 07:34 | • Reply: .shell deficiency artifact: 829fda0109 user: hanche | |
| 02:59 | • Reply: How can a window function replace this subquery to form a grouping? artifact: 4b3f8d99ce user: 1codedebugger | |
| 01:58 | • Reply: How can a window function replace this subquery to form a grouping? artifact: 175a927f40 user: 1codedebugger | |
| 00:16 | • Reply: .shell deficiency artifact: 2dcf092a86 user: ldo289 | |
| 00:11 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: f9d272fb5b user: ldo289 | |
2 Years Ago (more context)
|
2022-04-13
| ||
| 23:11 | • Reply: Learning SQLite Virtual tables artifact: 56c38d13a7 user: larrybr | |
| 21:15 | • Reply: Learning SQLite Virtual tables artifact: 5c5106b9ce user: anonymous | |
| 19:57 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: b026e62066 user: kmedcalf | |
| 19:51 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 859fb4b20a user: kmedcalf | |
| 19:41 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: c2488c3a3a user: kmedcalf | |
| 19:33 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 49b74cbc87 user: kmedcalf | |
| 18:21 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: ebbe594eae user: vijayst | |
| 17:17 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 8f8e6d6eff user: kmedcalf | |
| 17:17 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 06238255ff user: vijayst | |
| 17:11 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 877f7e14a5 user: vijayst | |
| 17:10 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: c57910dfd9 user: kmedcalf | |
| 17:05 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 57d6037e5c user: vijayst | |
| 17:01 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 94ebc48c8a user: vijayst | |
| 16:55 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 32f7d71a81 user: vijayst | |
| 16:54 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: cafdb2e4f1 user: vijayst | |
| 16:54 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: b942d1824f user: vijayst | |
| 16:52 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 3daaafa91e user: vijayst | |
| 16:50 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 6b5b58c259 user: vijayst | |
| 14:53 | • Reply: SQLDiff and column removal artifact: d8ecbfc97a user: larrybr | |
| 14:42 | • Reply: Incorrect query result in sqlite 3.38.2 artifact: 7130ae535c user: larrybr | |
| 13:18 | • Post: Documentation: does CHECKPOINT_RESTART blocks readers ? artifact: b47a1958fe user: aureliar | |
| 12:02 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 0d28563bf9 user: cuz | |
| 12:00 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 3b7b939c9f user: gunter_hick | |
| 11:59 | • Edit reply: Incorrect query result in sqlite 3.38.2 artifact: 734c8c5335 user: tiep.vu | |
| 11:38 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 93a781f0cf user: vijayst | |
| 11:36 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 8d067e9980 user: vijayst | |
| 11:35 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 510c773b40 user: vijayst | |
| 11:31 | • Reply: Incorrect query result in sqlite 3.38.2 artifact: 733b62c39d user: tiep.vu | |
| 09:21 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 2823eae3d8 user: gunter_hick | |
| 09:14 | • Reply: SQLite schema based on SQL Server DB schema artifact: 92529b9b86 user: ddevienne | |
| 08:53 | • Reply: SQLite schema based on SQL Server DB schema artifact: 3762762642 user: ddevienne | |
| 08:42 | • Reply: Two ways to ALTER TABLE CHANGE COLUMN artifact: 28bc07c71f user: cuz | |
| 08:37 | • Reply: SQLite schema based on SQL Server DB schema artifact: a912dbab64 user: averageasker | |
| 08:22 | • Post: Two ways to ALTER TABLE CHANGE COLUMN artifact: f6356d7b75 user: anonymous | |
| 08:10 | • Reply: SQLite schema based on SQL Server DB schema artifact: 6313061454 user: wyoung | |
| 07:55 | • Reply: SQLite schema based on SQL Server DB schema artifact: ee01e4b077 user: stephan | |
| 07:53 | • Reply: SQLDiff and column removal artifact: 52c1202bfe user: stephan | |
| 07:51 | • Edit: (Deleted) artifact: cba7b91b55 user: stephan | |
| 07:30 | • Reply: SQLDiff and column removal artifact: c393ade87e user: averageasker | |
| 07:26 | • Post: SQLite schema based on SQL Server DB schema artifact: 3af8ec58f0 user: averageasker | |
| 07:19 | • Reply: Calculated value using two foreign table values? artifact: a9ba8b3b7c user: cuz | |
| 07:19 | • Post: (Deleted) artifact: b69c584865 user: averageasker | |
| 07:10 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 990b4d4c34 user: vijayst | |
| 07:06 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: f98031738f user: vijayst | |
| 07:01 | • Reply: SQLDiff and column removal artifact: 8264c81e34 user: wyoung | |
| 06:39 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 551db42800 user: gunter_hick | |
| 06:32 | • Post: SQLDiff and column removal artifact: 1aaeea8ccb user: averageasker | |
| 05:43 | • Reply: Calculated value using two foreign table values? artifact: f95771976f user: gunter_hick | |
| 05:31 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: deb78214ed user: vijayst | |
| 05:29 | • Edit: SQLite query takes a longer time for retrieving TEXT fields artifact: a407f85f18 user: vijayst | |
| 05:19 | • Reply: Incorrect query result in sqlite 3.38.2 artifact: a11897a1a8 user: gunter_hick | |
| 04:46 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: e876102faf user: wyoung | |
| 04:24 | • Reply: Learning SQLite Virtual tables artifact: e4e899654d user: larrybr | |
| 03:32 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 1676b79be3 user: wyoung | |
| 02:15 | • Edit reply: Calculated value using two foreign table values? artifact: cc9e0f5891 user: slavin | |
| 02:14 | • Reply: Calculated value using two foreign table values? artifact: 45d44e3ed4 user: slavin | |
| 01:53 | • Reply: Possible bug: Unable to find an entry point artifact: d44eda3468 user: cguardia | |
| 01:46 | • Post: SQLite query takes a longer time for retrieving TEXT fields artifact: de7e571097 user: vijayst | |
| 01:13 | • Reply: Calculated value using two foreign table values? artifact: 570f8a6630 user: kmedcalf | |
3 Years Ago (more context)
|
2021-04-13
| ||
| 23:44 | • Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: 9cb906da7f user: drh | |
| 23:20 | • Reply: Regression: Mixing AND with OR results in no rows returned artifact: 3ff04c191c user: anonymous | |
| 20:53 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: a3f116d2d8 user: kmedcalf | |
| 19:48 | • Reply: Pragma compile_options does not show some options artifact: 8b5d81a30a user: anonymous | |
| 19:27 | • Reply: how DISTINCT remove the duplicate rows? artifact: 698d575bbe user: anonymous | |
| 19:24 | • Reply: index misuse? artifact: 5251fcede3 user: anonymous | |
| 19:09 | • Reply: how DISTINCT remove the duplicate rows? artifact: 128bf07196 user: kmedcalf | |
| 19:02 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 065476f522 user: anonymous | |
| 18:58 | • Reply: Pragma compile_options does not show some options artifact: f587a007f3 user: kmedcalf | |
| 18:58 | • Reply: how DISTINCT remove the duplicate rows? artifact: 71cfe8f5d9 user: larrybr | |
| 18:51 | • Reply: how DISTINCT remove the duplicate rows? artifact: 4f99c1d7a6 user: anonymous | |
| 18:51 | • Reply: Pragma compile_options does not show some options artifact: 87ac14fdde user: larrybr | |
| 18:43 | • Reply: Regression: Mixing AND with OR results in no rows returned artifact: d36426225c user: drh | |
| 18:41 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 2be0240464 user: kmedcalf | |
| 18:34 | • Reply: Pragma compile_options does not show some options artifact: 13a7754152 user: anonymous | |
| 18:29 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: ec3bfe7246 user: anonymous | |
| 18:29 | • Reply: how DISTINCT remove the duplicate rows? artifact: 15523825c1 user: kmedcalf | |
| 18:27 | • Reply: how DISTINCT remove the duplicate rows? artifact: 1a0a47cb17 user: kmedcalf | |
| 18:25 | • Edit reply: Regression: Mixing AND with OR results in no rows returned artifact: d23189d7c0 user: drh | |
| 18:22 | • Post: Delete columns?? artifact: 0d2aaa651f user: larshgf | |
| 18:18 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 481013e484 user: anonymous | |
| 18:12 | • Reply: how DISTINCT remove the duplicate rows? artifact: 977e054183 user: anonymous | |
| 18:11 | • Reply: Pragma compile_options does not show some options artifact: 4e1d13385f user: anonymous | |
| 18:08 | • Edit reply: Select of text that matches scientific notation format automatically converted to number artifact: c0241f21ed user: kmedcalf | |
| 18:06 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 064fc53aeb user: kmedcalf | |
| 17:58 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: d5524555e5 user: billwade | |
| 17:58 | • Reply: how DISTINCT remove the duplicate rows? artifact: bd2555df20 user: dvdraymond | |
| 17:54 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 4ece302a22 user: anonymous | |
| 17:38 | • Post: how DISTINCT remove the duplicate rows? artifact: befd52d034 user: anonymous | |
| 17:36 | • Post: Select of text that matches scientific notation format automatically converted to number artifact: e0d0b22e62 user: anonymous | |
| 17:30 | • Reply: Typos on https://sqlite.com/cli.html page artifact: 77c59c83f1 user: larrybr | |
| 17:13 | • Reply: Noob Question artifact: e2371a5f0f user: anonymous | |
| 16:43 | • Post: Typos on https://sqlite.com/cli.html page artifact: e6ba917f72 user: squenson | |
| 14:54 | • Reply: Saving Wikipedia to SQLite artifact: a7e765e668 user: slavin | |
| 14:24 | • Reply: Noob Question artifact: 15918f10bb user: slavin | |
| 13:30 | • Reply: Creating in-memory DB from a bunch of bytes artifact: 4187040acf user: gonzus | |
| 13:01 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: cc6a7f156e user: dvdraymond | |
| 12:58 | • Reply: how to do arithmetic calculations on real/decimal/double in sqlite artifact: 8c2136ca90 user: Hardy | |
| 12:48 | • Reply: Creating in-memory DB from a bunch of bytes artifact: 61b9c210e1 user: anonymous | |
| 12:44 | • Reply: Only Column Names read from table artifact: 8ae906bae9 user: anonymous | |
| 12:29 | • Post: Creating in-memory DB from a bunch of bytes artifact: f2bd23c4c0 user: gonzus | |
| 12:17 | • Reply: count strings with same length artifact: e6e107d431 user: jdennis | |
| 12:10 | • Reply: count strings with same length artifact: 573eebdcaf user: anonymous | |
| 10:42 | • Reply: Only Column Names read from table artifact: 2bc0899a1c user: wyoung | |
| 10:24 | • Reply: Only Column Names read from table artifact: 03c38a2379 user: yuvraj.jambhle | |
| 10:18 | • Reply: Only Column Names read from table artifact: c8c526127e user: yuvraj.jambhle | |
| 09:10 | • Reply: count strings with same length artifact: 70d5f48ae0 user: anonymous | |
| 08:04 | • Reply: Regression: Mixing AND with OR results in no rows returned artifact: cf871a9531 user: odubaj | |
| 07:52 | • Post: count strings with same length artifact: 90c97956af user: Ane.Pap | |
| 07:06 | • Reply: Saving Wikipedia to SQLite artifact: 005b81734e user: jkreibich | |
| 07:05 | • Reply: how to do arithmetic calculations on real/decimal/double in sqlite artifact: 02c8b795cd user: wyoung | |
| 06:49 | • Reply: how to do arithmetic calculations on real/decimal/double in sqlite artifact: c97029eadf user: kmedcalf | |
| 03:06 | • Post: how to do arithmetic calculations on real/decimal/double in sqlite artifact: 0b97339195 user: bharad78 | |
| 01:30 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: a0bea06001 user: casaderobison | |
| 01:06 | • Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 69cf3e96ec user: dab | |
4 Years Ago (more context)
|
2020-04-13
| ||
| 23:02 | • Post: doc: prepare.html: nByte performance advantage? artifact: 017f147754 user: ma11hew28 | |
| 22:23 | • Post: Fix typo in doc: limits.html artifact: 623bfc1c14 user: ma11hew28 | |
| 22:04 | • Reply: Troubleshooting corrupt indexes artifact: 0cccae3a2c user: drh | |
| 22:03 | • Reply: Troubleshooting corrupt indexes artifact: 01ef46ab89 user: drh | |
| 21:59 | • Reply: Troubleshooting corrupt indexes artifact: eea9e361ba user: snej | |
| 21:02 | • Reply: Troubleshooting corrupt indexes artifact: 6a1436bc57 user: drh | |
| 21:01 | • Reply: How does one search this forum? artifact: 62f36d902f user: drh | |
| 20:54 | • Reply: How does one search this forum? artifact: 0fe6305dcc user: anonymous | |
| 19:23 | • Post: Troubleshooting corrupt indexes artifact: 0ac5e1d60e user: snej | |
| 19:13 | • Reply: Retrieve match context with FTS5 artifact: bc88f900b7 user: davidgf | |
| 18:50 | • Reply: Retrieve match context with FTS5 artifact: 2bb8044583 user: davidgf | |
| 11:31 | • Edit reply: How to use BLOB in C program artifact: 6d030d0f61 user: kmedcalf | |
| 11:30 | • Reply: How to use BLOB in C program artifact: 7d02bb3804 user: kmedcalf | |
| 09:36 | • Edit reply: When will/were recent "sqlite3.31.1 new security issues CVEs" be addressed? artifact: 6c512820c2 user: drh | |
| 09:35 | • Reply: When will/were recent "sqlite3.31.1 new security issues CVEs" be addressed? artifact: 2227276024 user: drh | |
| 08:45 | • Reply: When will/were recent "sqlite3.31.1 new security issues CVEs" be addressed? artifact: c79c498de2 user: stephan | |
| 08:33 | • Post: When will/were recent "sqlite3.31.1 new security issues CVEs" be addressed? artifact: 87f68eab61 user: SuYinHoneywell | |
| 07:11 | • Reply: pivot requery SQLITE artifact: 5f1eeba486 user: anonymous | |
| 01:26 | • Reply: How to use BLOB in C program artifact: 9fcd53a5a1 user: LarryBrasfield | |
| 01:10 | • Reply: How to use BLOB in C program artifact: c19ae29ba7 user: LarryBrasfield | |