This Day In History For 2024-04-19
1 Year Ago (more context)
|
2023-04-19
| ||
| 22:33 | • Edit reply: SQLite on a Server artifact: 73f9bb81b0 user: chrisjlocke1 | |
| 22:32 | • Reply: SQLite on a Server artifact: dbddf0a6c7 user: chrisjlocke1 | |
| 22:21 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: f20a7f6a11 user: drh | |
| 21:02 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 25ba487dca user: capnsqueakers | |
| 20:48 | • Reply: SQLite on a Server artifact: 4b844fa992 user: anonymous | |
| 20:47 | • Reply: SQLite on a Server artifact: 28d2d29de7 user: anonymous | |
| 20:24 | • Reply: A new option, possibly, for CLI: -utf8 artifact: bc7e13ffa9 user: florian.balmer | |
| 19:57 | • Reply: SQLite on a Server artifact: d7d6b71a02 user: chrisjlocke1 | |
| 19:43 | • Reply: SQLite on a Server artifact: 90d4ee4580 user: anonymous | |
| 19:03 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: daf8f15fe1 user: wyoung | |
| 19:02 | • Reply: SQLite on a Server artifact: efd2b90812 user: Clothears | |
| 18:22 | • Reply: SQLite on a Server artifact: 1bda021d8c user: anonymous | |
| 18:18 | • Reply: SQLite on a Server artifact: 43a2df4c82 user: anonymous | |
| 18:13 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 319fe66096 user: ddevienne | |
| 17:58 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: cbdf6c45e1 user: larrybr | |
| 17:42 | • Reply: SQLITE SEE License artifact: 205f9c3182 user: anonymous | |
| 17:25 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 6c50ff0d91 user: capnsqueakers | |
| 17:20 | • Reply: SQLite on a Server artifact: 04ac2d724d user: dvdraymond | |
| 17:19 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 9e2265da94 user: larrybr | |
| 17:19 | • Reply: SQLite on a Server artifact: ea866efb79 user: chrisjlocke1 | |
| 17:19 | • Reply: Segmentation fault in sqlite3OsFileSize function artifact: 3e2b3d5299 user: songliu | |
| 17:10 | • Reply: Segmentation fault in sqlite3OsFileSize function artifact: 128f2e207f user: dan | |
| 17:03 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 241e241779 user: capnsqueakers | |
| 16:45 | • Reply: SQLite on a Server artifact: 7582734c7f user: anonymous | |
| 16:39 | • Reply: SQLite on a Server artifact: 6b8e73499c user: larrybr | |
| 16:37 | • Reply: SQLite on a Server artifact: 3fb1d8a8f9 user: anonymous | |
| 16:25 | • Reply: SQLite on a Server artifact: 74a4dda117 user: alexgarciaxyz | |
| 16:19 | • Edit reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 53f57b0d02 user: larrybr | |
| 16:13 | • Reply: sqlite3_step() seems to grab new file descriptors on open database artifact: 92ca5b07e8 user: larrybr | |
| 16:11 | • Post: SQLite on a Server artifact: 180c75c471 user: anonymous | |
| 15:48 | • Post: sqlite3_step() seems to grab new file descriptors on open database artifact: 13e487c539 user: capnsqueakers | |
| 15:47 | • Post: Segmentation fault in sqlite3OsFileSize function artifact: 679b4de86e user: songliu | |
| 14:02 | • Edit reply: Hi, I don't know SQL but I need to contact an admin on this site artifact: 0091a53a75 user: drh | |
| 13:53 | • Reply: Hi, I don't know SQL but I need to contact an admin on this site artifact: 990d8cf5a6 user: drh | |
| 13:41 | • Reply: Hi, I don't know SQL but I need to contact an admin on this site artifact: da17b8fdb3 user: slavin | |
| 13:27 | • Reply: Different behavior between insert and prepare commands artifact: a3e1720d26 user: larrybr | |
| 13:13 | • Reply: CTRL-C behavior in shell artifact: b6d88a9c66 user: florian.balmer | |
| 13:09 | • Edit reply: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: 70bebe002e user: punkish | |
| 13:08 | • Reply: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: c9715ba04e user: punkish | |
| 12:53 | • Reply: Different behavior between insert and prepare commands artifact: 96929d38d3 user: anonymous | |
| 12:49 | • Reply: Different behavior between insert and prepare commands artifact: 24fec9e52b user: anonymous | |
| 12:48 | • Reply: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: c99503095c user: dfgriggs | |
| 12:48 | • Reply: No download file for Apple Silicon exists in the download page artifact: ad56855141 user: drh | |
| 12:41 | • Post: No download file for Apple Silicon exists in the download page artifact: 53e36cf1ed user: anonymous | |
| 12:07 | • Reply: Different behavior between insert and prepare commands artifact: 253995f302 user: drh | |
| 11:59 | • Reply: Different behavior between insert and prepare commands artifact: 3aff8a4c58 user: anonymous | |
| 11:35 | • Post: PVS-Studio Warnings artifact: fc98845c06 user: tnodir | |
| 11:28 | • Reply: SQLITE SEE License artifact: f5c0576bc6 user: larrybr | |
| 11:17 | • Reply: SQLITE SEE License artifact: 06d153e479 user: anonymous | |
| 11:05 | • Reply: CTRL-C behavior in shell artifact: 0114b87a96 user: larrybr | |
| 11:04 | • Delete reply: CTRL-C behavior in shell artifact: 605a0ea3c1 user: larrybr | |
| 11:03 | • Delete reply: CTRL-C behavior in shell artifact: e48f74a79a user: larrybr | |
| 10:57 | • Reply: SQLITE SEE License artifact: 1b628590e8 user: larrybr | |
| 08:33 | • Reply: comparing rtree and geopoly for the same geographies artifact: f8a271f47f user: punkish | |
| 08:30 | • Edit: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: 7ac048534b user: punkish | |
| 08:27 | • Post: comparing (dis)advantages of ATTACHED vs all-in-one db artifact: b7d0d26749 user: punkish | |
| 07:59 | • Reply: comparing rtree and geopoly for the same geographies artifact: 45d2b40abf user: sqweek | |
| 07:43 | • Reply: CTRL-C behavior in shell artifact: 14d51631c0 user: florian.balmer | |
| 07:35 | • Post: SQLITE SEE License artifact: 192016c874 user: anonymous | |
| 07:31 | • Reply: CTRL-C behavior in shell artifact: 41acd8a9e4 user: florian.balmer | |
| 07:31 | • Reply: CTRL-C behavior in shell artifact: 2bc7dee4c7 user: florian.balmer | |
| 05:41 | • Reply: Different behavior between insert and prepare commands artifact: 7390902eb7 user: gunter_hick | |
| 05:17 | • Reply: How can a window function replace this subquery to form a grouping? artifact: b335f74c93 user: 1codedebugger | |
| 01:45 | • Reply: docsrc patch for pages/testing.in artifact: 89e61f9d0b user: stephan | |
| 01:41 | • Reply: docsrc patch for pages/testing.in artifact: b583be2f08 user: larrybr | |
| 01:39 | • Reply: docsrc patch for pages/testing.in artifact: 239b6aa2a7 user: brickviking | |
| 01:22 | • Post: Assertion failure in pager_playback_one_page function artifact: a19bb49140 user: songliu | |
| 01:17 | • Reply: docsrc patch for pages/testing.in artifact: 7276fc9a7d user: larrybr | |
| 01:16 | • Reply: docsrc patch for pages/testing.in artifact: 416f028db4 user: stephan | |
| 01:04 | • Post: docsrc patch for pages/testing.in artifact: a5dbe3a2bf user: brickviking | |
| 00:57 | • Reply: Different behavior between insert and prepare commands artifact: 08e7f34823 user: larrybr | |
| 00:56 | • Reply: Different behavior between insert and prepare commands artifact: f04d75ce2a user: stephan | |
| 00:51 | • Edit: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 9aae136689 user: drh | |
| 00:46 | • Post: Different behavior between insert and prepare commands artifact: 9cc7f2efbe user: anonymous | |
| 00:11 | • Edit reply: CTRL-C behavior in shell artifact: 8282d2345c user: larrybr | |
2 Years Ago (more context)
|
2022-04-19
| ||
| 21:21 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: f981a83d54 user: kmedcalf | |
| 21:05 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: e4e6559950 user: RandomCoder | |
| 21:04 | • Edit reply: CLI - edit last executed (multi-line) SQL statement? artifact: 636b46ddc5 user: AAsk1902 | |
| 21:03 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 6587ea7435 user: hanche | |
| 20:59 | • Edit reply: CLI - edit last executed (multi-line) SQL statement? artifact: cf07bb8749 user: AAsk1902 | |
| 20:36 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 7e6144f754 user: AAsk1902 | |
| 19:59 | • Reply: Integer division artifact: 2375919e06 user: larrybr | |
| 19:14 | • Reply: Integer division artifact: 1a59bcabf9 user: hanche | |
| 18:34 | • Edit reply: Integer division artifact: 50efe879ef user: larrybr | |
| 18:17 | • Reply: Integer division artifact: cd5aeb1662 user: larrybr | |
| 15:56 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: a4473c4d5e user: midijohnny | |
| 15:18 | • Reply: Integer division artifact: c4724dad0e user: hanche | |
| 14:59 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 367acc5915 user: drh | |
| 14:12 | • Reply: How do I remove column wraps? artifact: a7efd03377 user: billwade | |
| 14:05 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: d863d59711 user: jicman | |
| 13:00 | • Reply: Possible typo and dead link in doc artifact: 016b45d534 user: larrybr | |
| 12:49 | • Post: Possible typo and dead link in doc artifact: aad4f1a298 user: anonymous | |
| 11:55 | • Reply: Safeguard against table scans? artifact: 25011661a0 user: vegard | |
| 11:13 | • Reply: WAL with Read Only Access artifact: 8ff20f4255 user: anonymous | |
| 10:12 | • Reply: Integer division artifact: ee7db0564e user: cuz | |
| 09:57 | • Reply: Safeguard against table scans? artifact: 9f15d43377 user: cuz | |
| 09:24 | • Post: Safeguard against table scans? artifact: 226dc47a92 user: vegard | |
| 09:01 | • Reply: Sqllogictest question artifact: d57b3c5d86 user: drh | |
| 08:57 | • Edit reply: Integer division artifact: 7bc43424b1 user: drh | |
| 08:56 | • Reply: Integer division artifact: fc54e760f0 user: drh | |
| 04:52 | • Reply: Integer division artifact: 8b44a9b372 user: cuz | |
| 03:45 | • Post: Sqllogictest question artifact: 9d7ad2048e user: bucweat | |
3 Years Ago (more context)
|
2021-04-19
| ||
| 23:54 | • Reply: simple insert issue with 3.35.5 - .sqliterc issue? artifact: da3c47397b user: anonymous | |
| 23:47 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: daed9e4df5 user: howardk | |
| 23:08 | • Post: Clarification re parameters needed. artifact: 1acdeae96c user: anonymous | |
| 22:52 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: c97b1d3336 user: RichardDamon | |
| 21:30 | • Reply: simple insert issue with 3.35.5 - .sqliterc issue? artifact: 1c18d39d3a user: kmedcalf | |
| 21:15 | • Reply: Administrator SQLite artifact: b5f3b3d3f4 user: kmedcalf | |
| 20:42 | • Reply: Administrator SQLite artifact: 12ccb88bac user: anonymous | |
| 20:24 | • Post: Bug report: inconsistent error message across different CONSTRAINT types artifact: b17fdd0d59 user: kevinlang | |
| 20:22 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 70a135b29f user: RichardDamon | |
| 20:21 | • Post: simple insert issue with 3.35.5 - .sqliterc issue? artifact: d3f408df38 user: anonymous | |
| 20:12 | • Reply: Universal binary build for Apple Silicon artifact: b4404ff091 user: slavin | |
| 19:59 | • Reply: Access strategy for a one-thread per connection http server artifact: 1bc7813cdb user: anonymous | |
| 19:40 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 1e06ce5ee7 user: howardk | |
| 19:32 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: b10111d5f9 user: howardk | |
| 19:30 | • Reply: Administrator SQLite artifact: e63f84449a user: kmedcalf | |
| 19:30 | • Reply: Administrator SQLite artifact: 4c24c5139f user: dfgriggs | |
| 19:26 | • Edit reply: Administrator SQLite artifact: 47cea6dbb3 user: kmedcalf | |
| 19:24 | • Reply: Administrator SQLite artifact: aa76c758f1 user: kmedcalf | |
| 19:20 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 8dc774f745 user: RichardDamon | |
| 19:02 | • Reply: Access strategy for a one-thread per connection http server artifact: 2cb8a16a50 user: kmedcalf | |
| 18:55 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: b145a44fbd user: howardk | |
| 18:51 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: f36af5376a user: howardk | |
| 18:45 | • Reply: AVG with GROUP BY returns 0 artifact: 99cde188bc user: kmedcalf | |
| 18:42 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: f83a4a3cef user: howardk | |
| 17:59 | • Reply: Administrator SQLite artifact: e9ab63c697 user: anonymous | |
| 16:37 | • Reply: Aliased function result with the same name issue artifact: 36c281c5cc user: Maxulite | |
| 16:26 | • Edit reply: Administrator SQLite artifact: a91a16fc3c user: dfgriggs | |
| 16:22 | • Reply: Administrator SQLite artifact: 330a421b8c user: dfgriggs | |
| 15:24 | • Reply: Aliased function result with the same name issue artifact: e606e64e34 user: larrybr | |
| 15:11 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 3ad68c3b96 user: RichardDamon | |
| 15:10 | • Post: Administrator SQLite artifact: 8f3fd098b9 user: anonymous | |
| 14:25 | • Reply: How to Record all Transactions artifact: ce91c3a51c user: MichaelS | |
| 14:24 | • Reply: How to Record all Transactions artifact: 7eeccac644 user: MichaelS | |
| 14:22 | • Reply: How to Record all Transactions artifact: 5ff9d5ce84 user: ddevienne | |
| 14:17 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 77f12f0a1f user: ddevienne | |
| 14:14 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: ff2610b7d0 user: dvdraymond | |
| 13:48 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 80eacfe984 user: RichardDamon | |
| 13:44 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 08fa31f099 user: curmudgeon | |
| 13:38 | • Reply: How to Record all Transactions artifact: e21eefdc60 user: stephan | |
| 13:34 | • Post: How to Record all Transactions artifact: d444043cad user: anonymous | |
| 13:32 | • Reply: Access strategy for a one-thread per connection http server artifact: 2d2a88dde6 user: wyoung | |
| 13:20 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: b4d48a923f user: drh | |
| 13:11 | • Reply: Access strategy for a one-thread per connection http server artifact: 47e9770883 user: anonymous | |
| 12:53 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 4fee04fb03 user: ddevienne | |
| 11:51 | • Reply: SQLite doesn't use indexes for bitwise clauses? artifact: e27ae565f5 user: drh | |
| 11:35 | • Reply: AVG with GROUP BY returns 0 artifact: 26ab5515ca user: antlor | |
| 10:59 | • Reply: AVG with GROUP BY returns 0 artifact: 4a469411eb user: wyoung | |
| 09:18 | • Reply: usage of SHA-1 artifact: 6690fa3571 user: odubaj | |
| 09:17 | • Post: Aliased function result with the same name issue artifact: f2aa1d0cbf user: Maxulite | |
| 08:59 | • Reply: usage of SHA-1 artifact: 0dd4b73ef9 user: ddevienne | |
| 08:45 | • Reply: AVG with GROUP BY returns 0 artifact: 95c3b35c4b user: anonymous | |
| 08:43 | • Reply: AVG with GROUP BY returns 0 artifact: d87ea04e54 user: anonymous | |
| 08:39 | • Reply: AVG with GROUP BY returns 0 artifact: 761f8c7920 user: kmedcalf | |
| 08:35 | • Reply: AVG with GROUP BY returns 0 artifact: b81b42686d user: kmedcalf | |
| 08:30 | • Post: Universal binary build for Apple Silicon artifact: 02d9066ccb user: naeco2005 | |
| 08:28 | • Reply: Access strategy for a one-thread per connection http server artifact: 41683e615a user: kmedcalf | |
| 08:15 | • Reply: usage of SHA-1 artifact: 0fd0958b45 user: odubaj | |
| 07:45 | • Post: AVG with GROUP BY returns 0 artifact: 422cbf1f60 user: anonymous | |
| 07:40 | • Reply: Access strategy for a one-thread per connection http server artifact: 52bf9b7e0e user: wyoung | |
| 06:56 | • Reply: Access strategy for a one-thread per connection http server artifact: b7c5b251aa user: anonymous | |
| 06:55 | • Reply: Cant write from root user into sqlite when sticky bit is set artifact: b043d6f197 user: 777777 | |
| 02:59 | • Reply: Access strategy for a one-thread per connection http server artifact: 04cb589c4a user: kmedcalf | |
| 02:21 | • Reply: SQL query help for between times and grouping times artifact: 51cd5b87d0 user: cuz | |
| 02:05 | • Post: Access strategy for a one-thread per connection http server artifact: 4306d5fb45 user: anonymous | |
| 02:01 | • Reply: SQL query help for between times and grouping times artifact: 7dea5c2608 user: cuz | |
4 Years Ago (more context)
|
2020-04-19
| ||
| 23:26 | • Post: Is there a non-trigger way to format data on INSERT/UPDATE? artifact: 477e8950e7 user: anonymous | |
| 22:02 | • Reply: how to refuse write empty value artifact: 978c236b3a user: itandetnik | |
| 21:37 | • Edit reply: Setting Database file directory on linux artifact: a752aacf72 user: LarryBrasfield | |
| 21:36 | • Edit reply: Setting Database file directory on linux artifact: fd6824000f user: LarryBrasfield | |
| 21:32 | • Reply: Setting Database file directory on linux artifact: 451dea8c8c user: LarryBrasfield | |
| 20:49 | • Reply: how to refuse write empty value artifact: 7a9e5a2ca5 user: plazna | |
| 20:42 | • Reply: how to refuse write empty value artifact: 45ae24010f user: plazna | |
| 20:41 | • Reply: how to refuse write empty value artifact: 589d11c510 user: plazna | |
| 20:28 | • Post: Setting Database file directory on linux artifact: c1e36ada0e user: zensky | |
| 19:17 | • Edit reply: string literals, is there more than one escape? artifact: b6a949f397 user: LarryBrasfield | |
| 19:05 | • Reply: string literals, is there more than one escape? artifact: ddcea2c485 user: LarryBrasfield | |
| 18:42 | • Reply: how to refuse write empty value artifact: 7afa94b845 user: LarryBrasfield | |
| 17:48 | • Reply: how to refuse write empty value artifact: c217703e1d user: kmedcalf | |
| 17:42 | • Reply: Malwarebytes slows SQLite artifact: 4056f32683 user: kmedcalf | |
| 17:39 | • Reply: Select is S*L*O*W but not in Development artifact: 0c00e540cc user: kmedcalf | |
| 17:13 | • Reply: string literals, is there more than one escape? artifact: f4f564e7ee user: kmedcalf | |
| 17:01 | • Edit reply: Subqueries and "no such column" error on references to other tables artifact: 7f81c61eac user: groue | |
| 16:55 | • Reply: Subqueries and "no such column" error on references to other tables artifact: 7fb402fdb5 user: groue | |
| 16:33 | • Reply: Subqueries and "no such column" error on references to other tables artifact: 4021c79c78 user: groue | |
| 16:04 | • Reply: Subqueries and "no such column" error on references to other tables artifact: fe1e144b1d user: cuz | |
| 14:54 | • Reply: how to refuse write empty value artifact: d6fa763c2d user: LarryBrasfield | |
| 14:25 | • Reply: Subqueries and "no such column" error on references to other tables artifact: 635cb9fb60 user: _Neal_ | |
| 13:27 | • Reply: Can SQLite query go in hung/stuck state? artifact: 18525122b7 user: slavin | |
| 13:02 | • Post: how to refuse write empty value artifact: fbeefe3d91 user: plazna | |
| 12:57 | • Reply: Crash in sqlite3_open_v2 with SQLITE_HAS_CODEC artifact: d80b3f77d2 user: anonymous | |
| 12:41 | • Post: Subqueries and "no such column" error on references to other tables artifact: bae3d3ba2e user: groue | |
| 09:11 | • Reply: Malwarebytes slows SQLite artifact: a95515f234 user: luuk | |
| 08:24 | • Post: Malwarebytes slows SQLite artifact: 3fc74eda11 user: slavin | |
| 08:15 | • Reply: Select is S*L*O*W but not in Development artifact: 8bb034ab81 user: slavin | |
| 07:06 | • Reply: Can SQLite query go in hung/stuck state? artifact: dc6b5789ef user: surabhi.nitsurat | |
| 02:24 | • Reply: Select is S*L*O*W but not in Development artifact: 1c8b6c7562 user: eKundl | |
| 02:19 | • Reply: Select is S*L*O*W but not in Development artifact: c0c0f15f8e user: eKundl | |
| 01:44 | • Edit reply: Select is S*L*O*W but not in Development artifact: 1f50b24c87 user: slavin | |
| 01:44 | • Edit reply: Select is S*L*O*W but not in Development artifact: 7466341063 user: slavin | |
| 01:43 | • Reply: Select is S*L*O*W but not in Development artifact: c0fbd43c46 user: slavin | |
| 01:37 | • Reply: Can SQLite query go in hung/stuck state? artifact: 577d8f129c user: slavin | |
| 01:11 | • Post: Select is S*L*O*W but not in Development artifact: de075ba31f user: eKundl | |
| 00:23 | • Reply: string literals, is there more than one escape? artifact: f2063b42c4 user: jake | |