This Day In History For 2023-07-31
1 Year Ago (more context)
|
2022-07-31
| ||
| 23:08 | • Post: New tutorial: Cleaning data with sqlite-utils and Datasette artifact: af260ae0d0 user: simonw | |
| 22:55 | • Reply: Foreign keys artifact: 8bf80f8292 user: kmedcalf | |
| 22:07 | • Reply: Foreign keys artifact: 12f149e255 user: cuz | |
| 21:31 | • Reply: UPSERT ON CONFLICT enhancement artifact: 0d26bb071e user: kmedcalf | |
| 21:20 | • Reply: Foreign keys artifact: 762958b22c user: kmedcalf | |
| 20:13 | • Edit: UPSERT ON CONFLICT enhancement artifact: b9ac2692cb user: rgumpertz | |
| 20:09 | • Post: UPSERT ON CONFLICT enhancement artifact: 571bda1999 user: rgumpertz | |
| 20:07 | • Reply: Foreign keys artifact: 0e87506741 user: dfgriggs | |
| 19:36 | • Reply: Foreign keys artifact: b99c1c11ee user: kmedcalf | |
| 18:26 | • Reply: Foreign keys artifact: ed4d9d06b9 user: anonymous | |
| 18:19 | • Reply: Foreign keys artifact: 727ebca7f4 user: anonymous | |
| 18:17 | • Reply: Foreign keys artifact: f5666ff61c user: anonymous | |
| 17:17 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: f74ce40141 user: 961679 | |
| 17:05 | • Reply: Foreign keys artifact: d04fbd1567 user: cuz | |
| 17:01 | • Edit reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: ed8a9bb735 user: 961679 | |
| 16:50 | • Reply: Foreign keys artifact: 3d0b8c6791 user: kmedcalf | |
| 16:49 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 2c8cf874ad user: 961679 | |
| 16:43 | • Edit reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 353a6bc16a user: kmedcalf | |
| 16:40 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 2a882046c6 user: kmedcalf | |
| 16:33 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: fbf89d4499 user: kmedcalf | |
| 16:22 | • Reply: Connect with using Multi-threaded Mode in dotnet artifact: 0b8d4e6fda user: kmedcalf | |
| 16:10 | • Post: Set the application name for readline? artifact: 3dc99c40c1 user: hanche | |
| 14:58 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 147e7d7a2b user: slavin | |
| 14:35 | • Reply: Foreign keys artifact: f87494dd85 user: anonymous | |
| 13:27 | • Reply: Potential typo in equation in window function documentation artifact: 086fbc7e87 user: anonymous | |
| 12:55 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 5b6a3d668e user: 961679 | |
| 12:54 | • Reply: Connect with using Multi-threaded Mode in dotnet artifact: 20d44cbe0a user: jicman | |
| 11:54 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 74330a7f09 user: anonymous | |
| 11:12 | • Post: Foreign keys artifact: fa017673e3 user: anonymous | |
| 10:59 | • Post: Generated columns vs. STRICT tables artifact: feb7ba3527 user: MarkusWinand | |
| 09:07 | • Reply: Displaying last shell command to edit and execute artifact: c5e8e65219 user: hanche | |
| 08:32 | • Reply: Why repeated expressions in query are not optimized out? artifact: df1f1e965f user: daniele | |
| 08:11 | • Reply: Displaying last shell command to edit and execute artifact: 99d7d7260f user: UserMBL | |
| 08:00 | • Reply: Select by column id artifact: 281701833a user: chrisjlocke1 | |
| 05:42 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 093a7f4d84 user: 961679 | |
| 04:46 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: d1e5b17ec1 user: 961679 | |
| 04:25 | • Reply: Select by column id artifact: cd52909570 user: anonymous | |
| 00:52 | • Reply: Reporting SQLite3 script errors to PowerShell artifact: 5677245d9a user: larrybr | |
| 00:44 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: c8e6455684 user: slavin | |
| 00:24 | • Reply: Displaying last shell command to edit and execute artifact: 9a84adda6d user: Trudge | |
| 00:02 | • Post: Reporting SQLite3 script errors to PowerShell artifact: ba4a872647 user: TomEggers | |
2 Years Ago (more context)
|
2021-07-31
| ||
| 22:50 | • Reply: Round function returning -0.0 artifact: d582ee88bf user: rmariani | |
| 20:28 | • Reply: Round function returning -0.0 artifact: f07de6f87d user: larrybr | |
| 19:57 | • Reply: Round function returning -0.0 artifact: 5194a96d9d user: rmariani | |
| 19:41 | • Reply: Round function returning -0.0 artifact: b1e28fe7e9 user: kmedcalf | |
| 16:43 | • Edit reply: Round function returning -0.0 artifact: a23fbb0488 user: rmariani | |
| 16:42 | • Reply: Round function returning -0.0 artifact: 72ee60d8fc user: rmariani | |
| 16:37 | • Reply: Round function returning -0.0 artifact: 40d106fae4 user: anonymous | |
| 15:06 | • Reply: Odd CL behaviour artifact: ede3f5ccfc user: Trudge | |
| 15:02 | • Reply: Odd CL behaviour artifact: 117955119d user: Trudge | |
| 11:48 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: e9ddd6fbba user: anonymous | |
| 11:14 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: 5844099d7b user: anonymous | |
| 07:07 | • Post: HN article: Static.wiki – read-only Wikipedia using a 43GB SQLite file artifact: 8537d5c3c1 user: andreas-kupries | |
| 06:22 | • Reply: Odd CL behaviour artifact: 692b6786fe user: wyoung | |
| 02:10 | • Reply: Round function returning -0.0 artifact: 21d92f32ba user: lexfiend | |
| 02:08 | • Reply: Round function returning -0.0 artifact: 5bcd98f4d7 user: lexfiend | |
| 01:59 | • Reply: Round function returning -0.0 artifact: b1d6b7b179 user: lexfiend | |
3 Years Ago (more context)
|
2020-07-31
| ||
| 23:18 | • Reply: Usage of suboptimum index artifact: a6293a6f99 user: drh | |
| 23:16 | • Reply: Usage of suboptimum index artifact: b2ca8c710c user: drh | |
| 23:05 | • Reply: Usage of suboptimum index artifact: 0781f2dd60 user: drh | |
| 22:25 | • Edit reply: Usage of suboptimum index artifact: 76a2ecaa0b user: Hardy | |
| 22:08 | • Reply: Usage of suboptimum index artifact: f5351d8402 user: Hardy | |
| 22:03 | • Reply: Usage of suboptimum index artifact: 86c668f120 user: Hardy | |
| 18:12 | • Reply: Usage of suboptimum index artifact: 2a5fb15a1d user: dan | |
| 17:28 | • Edit reply: Usage of suboptimum index artifact: 629841ebde user: kmedcalf | |
| 17:28 | • Reply: Usage of suboptimum index artifact: d4d077e113 user: kmedcalf | |
| 16:37 | • Reply: Need help building a custom amalgamation artifact: 7f8cc07e5f user: wyoung | |
| 16:27 | • Edit reply: Need help building a custom amalgamation artifact: b0d81d25ad user: LarryBrasfield | |
| 16:19 | • Reply: Need help building a custom amalgamation artifact: 0606ac3b0e user: LarryBrasfield | |
| 15:31 | • Reply: Need help building a custom amalgamation artifact: b97b2d8ff0 user: anonymous | |
| 15:27 | • Reply: Need help building a custom amalgamation artifact: b3dc220335 user: drh | |
| 15:21 | • Reply: Need help building a custom amalgamation artifact: 1b207144a6 user: stephan | |
| 15:07 | • Reply: Need help building a custom amalgamation artifact: 2b49c2c3b9 user: anonymous | |
| 14:58 | • Reply: Need help building a custom amalgamation artifact: cb4bc14c51 user: drh | |
| 14:46 | • Reply: Need help building a custom amalgamation artifact: 743841e0cf user: anonymous | |
| 13:56 | • Reply: Need help building a custom amalgamation artifact: 9cc9bd5f77 user: wyoung | |
| 12:42 | • Post: Need help building a custom amalgamation artifact: efb2952e5a user: anonymous | |
| 11:19 | • Reply: Usage of suboptimum index artifact: af6fcf93f7 user: dan | |
| 00:52 | • Reply: sqlite-src-3320300 fails test shell1-1.7.1 on Solaris 10 sparcv9 artifact: 35cb1f4e5e user: blastwave | |
| 00:11 | • Reply: sqlite-src-3320300 fails test shell1-1.7.1 on Solaris 10 sparcv9 artifact: f02dd6d2a0 user: drh | |