This Day In History For 2024-04-18
1 Year Ago (more context)
2023-04-18
| ||
23:45 | • Reply: CTRL-C behavior in shell artifact: 1fb3fa505a user: larrybr | |
23:40 | • Reply: where clause in on conflict upsert statement is ignored artifact: 50c3988a3d user: delfigamer | |
23:32 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: a713782762 user: alexgarciaxyz | |
23:21 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 01c8b4059e user: alexgarciaxyz | |
23:16 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 3560fa9f4c user: larrybr | |
21:24 | • Post: sqlite-gui on hackernews artifact: 00c6e69fda user: ThanksRyan | |
20:35 | • Post: Hi, I don't know SQL but I need to contact an admin on this site artifact: 595672e926 user: throwaway4182023 | |
18:51 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: f7225794ba user: alexgarciaxyz | |
17:38 | • Reply: Bug in 3.41.2: Index on expression causes query to return wrong result artifact: 5a8edf599c user: lexi_lambda | |
17:25 | • Reply: Assertion failure in sqlite3_test_control function artifact: df25a64d45 user: songliu | |
17:02 | • Reply: Assertion failure in sqlite3_test_control function artifact: 274262a016 user: drh | |
16:33 | • Reply: Import TXT file into SQLite - End of Line character artifact: 2c35e5e4c9 user: larrybr | |
16:21 | • Reply: Import TXT file into SQLite - End of Line character artifact: 8e82b077b9 user: chrisjlocke1 | |
15:31 | • Reply: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: 3072517dbb user: larrybr | |
15:26 | • Post: Assertion failure in sqlite3_test_control function artifact: 2c1a9cb14e user: songliu | |
14:38 | • Reply: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: 09503b4d33 user: larrybr | |
14:26 | • Reply: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: fa9c632261 user: jicman | |
14:18 | • Reply: Bug in 3.41.2: Index on expression causes query to return wrong result artifact: 7b05031344 user: drh | |
13:36 | • Reply: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: fdfc419b1f user: anonymous | |
13:30 | • Reply: Import TXT file into SQLite - End of Line character artifact: b3e1850d54 user: punkish | |
13:09 | • Edit reply: Import TXT file into SQLite - End of Line character artifact: edcbba6dee user: chrisjlocke1 | |
13:08 | • Reply: Import TXT file into SQLite - End of Line character artifact: 901339b423 user: chrisjlocke1 | |
12:53 | • Reply: Import TXT file into SQLite - End of Line character artifact: acc83ef723 user: TimKendal | |
12:39 | • Reply: Import TXT file into SQLite - End of Line character artifact: 80ad502032 user: TimKendal | |
12:35 | • Reply: where clause in on conflict upsert statement is ignored artifact: 1195dfcd19 user: drh | |
10:16 | • Reply: where clause in on conflict upsert statement is ignored artifact: b3f137a11f user: anonymous | |
10:15 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 3106885320 user: florian.balmer | |
08:01 | • Reply: case-sensitivity of INDEX artifact: 0b800d94a6 user: punkish | |
08:00 | • Post: Bug in 3.41.2: Index on expression causes query to return wrong result artifact: f34e32d120 user: lexi_lambda | |
01:44 | • Reply: case-sensitivity of INDEX artifact: 5203d8f4ee user: slavin | |
01:07 | • Reply: A new option, possibly, for CLI: -utf8 artifact: f59108f106 user: kmedcalf | |
00:03 | • Edit reply: A new option, possibly, for CLI: -utf8 artifact: 0649712398 user: larrybr | |
2 Years Ago (more context)
2022-04-18
| ||
22:06 | • Reply: Integer division artifact: c793b9bea8 user: larrybr | |
21:29 | • Reply: Integer division artifact: ae820b0821 user: hanche | |
21:19 | • Reply: Integer division artifact: 03d25c5d96 user: larrybr | |
20:53 | • Edit reply: Integer division artifact: ce07c12b00 user: hanche | |
20:49 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 9542cc0175 user: midijohnny | |
20:48 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 1ca910c3bb user: midijohnny | |
20:42 | • Reply: Integer division artifact: 4351d21810 user: billwade | |
20:42 | • Reply: Integer division artifact: e0bd128dbd user: larrybr | |
20:38 | • Edit reply: CLI - edit last executed (multi-line) SQL statement? artifact: ef5b2a9678 user: vman59 | |
20:35 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: ac36fc2f9a user: hanche | |
20:35 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 8de4412c0d user: vman59 | |
20:30 | • Reply: Delete statement freezes my program artifact: f830ef08bc user: RandomCoder | |
20:29 | • Edit reply: Integer division artifact: 813e80a41c user: hanche | |
20:26 | • Reply: Integer division artifact: 16dc828174 user: hanche | |
20:26 | • Reply: Delete statement freezes my program artifact: 1545586660 user: cuz | |
20:07 | • Reply: Virtual Table Joins with Repeated calls to xFilter artifact: 000aebb814 user: agrothberg | |
20:06 | • Reply: Delete statement freezes my program artifact: b33ddc12ff user: larrybr | |
20:04 | • Reply: Integer division artifact: 768e8e7ed1 user: cuz | |
19:59 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: f290157a6f user: midijohnny | |
19:56 | • Reply: Delete statement freezes my program artifact: e318fc552c user: anonymous | |
19:55 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: d122810227 user: larrybr | |
19:53 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: bc68861b01 user: hanche | |
19:53 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 02d63c1ccf user: midijohnny | |
19:51 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: c152944e06 user: midijohnny | |
19:50 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 5a847a83e5 user: hanche | |
19:28 | • Reply: Delete statement freezes my program artifact: 569d620bd5 user: larrybr | |
19:18 | • Reply: Delete statement freezes my program artifact: 9cfce3f867 user: anonymous | |
19:13 | • Reply: Integer division artifact: 3e8b1139aa user: larrybr | |
19:01 | • Reply: Integer division artifact: b515869d66 user: kmedcalf | |
18:56 | • Post: Integer division artifact: ea04405b27 user: billwade | |
18:55 | • Edit reply: CLI - edit last executed (multi-line) SQL statement? artifact: 06be2f8dc1 user: kmedcalf | |
18:54 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 82803c8a27 user: kmedcalf | |
18:51 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 60ccb7d37a user: larrybr | |
18:45 | • Reply: CLI - edit last executed (multi-line) SQL statement? artifact: 218f2b0c99 user: midijohnny | |
18:40 | • Post: CLI - edit last executed (multi-line) SQL statement? artifact: c58da95ff2 user: midijohnny | |
15:24 | • Reply: SQLite column metadata interface returns wrong result artifact: 096149bcc0 user: riyaz-ali | |
14:40 | • Reply: Result: near "(": syntax error artifact: 43c1daf3c3 user: LurkingKiwi | |
11:29 | • Reply: SQLite column metadata interface returns wrong result artifact: 1f95225d29 user: dkfellows | |
11:24 | • Reply: Foreign keys TO a virtual table artifact: cefd5a9044 user: anonymous | |
10:48 | • Post: SQLite column metadata interface returns wrong result artifact: 9f52150e86 user: riyaz-ali | |
10:32 | • Reply: Foreign keys TO a virtual table artifact: 9aefce2236 user: drh | |
10:22 | • Reply: Delete statement freezes my program artifact: 8617b0d32b user: larrybr | |
10:10 | • Reply: Need Explanation ! artifact: 12274b7dab user: larrybr | |
09:55 | • Post: Foreign keys TO a virtual table artifact: 15954e2f58 user: anonymous | |
07:17 | • Edit reply: Need Explanation ! artifact: d4f9bf26c8 user: AAsk1902 | |
07:00 | • Reply: Need Explanation ! artifact: 54e1d4a9e0 user: AAsk1902 | |
05:56 | • Post: Need Explanation ! artifact: e8f1d21da5 user: biplob9842 | |
05:22 | • Post: Faster, more compact sqlar archives artifact: 926566d116 user: Yairlenga | |
3 Years Ago (more context)
2021-04-18
| ||
22:07 | • Reply: SQL query help for between times and grouping times artifact: e352fde8ab user: larrybr | |
21:53 | • Post: System.Data.SQLite cross-compile SQLite.Interop.dll artifact: 67cf1da1af user: kroggen | |
21:35 | • Reply: SQL query help for between times and grouping times artifact: c397056b70 user: ThanksRyan | |
21:25 | • Reply: SQL query help for between times and grouping times artifact: cfdc547999 user: ThanksRyan | |
19:08 | • Reply: SQL query help for between times and grouping times artifact: 43aa3e377c user: kmedcalf | |
16:25 | • Reply: Pragma compile_options does not show some options artifact: 8402de4d3f user: larrybr | |
14:17 | • Edit reply: Pragma compile_options does not show some options artifact: 21b430687e user: larrybr | |
13:26 | • Reply: Cant write from root user into sqlite when sticky bit is set artifact: 39d5037058 user: slavin | |
09:10 | • Reply: VACUUM fails on a database with enabled user authentication extension artifact: 1176d6862d user: aloys | |
08:23 | • Reply: Reporting vulnerabilities artifact: 8ac39a2db2 user: anonymous | |
08:13 | • Reply: SQL query help for between times and grouping times artifact: b9ee85aa7f user: Clothears | |
08:08 | • Reply: Week numbers in queries artifact: 3c41319790 user: anonymous | |
07:33 | • Reply: Cant write from root user into sqlite when sticky bit is set artifact: d7133301cc user: 777777 | |
07:22 | • Reply: SQL query help for between times and grouping times artifact: 730292fd92 user: kmedcalf | |
02:15 | • Reply: ALTER TABLE DROP COLUMN corrupts data artifact: 7c4de0452c user: cuz | |
01:53 | • Reply: SQL query help for between times and grouping times artifact: c849d67d1f user: cuz | |
01:47 | • Reply: ALTER TABLE DROP COLUMN corrupts data artifact: 96896f825d user: larrybr | |
01:35 | • Post: SQLite doesn't use indexes for bitwise clauses? artifact: 6a9e5b1b09 user: howardk | |
01:23 | • Reply: SQL query help for between times and grouping times artifact: a5b73181b0 user: cuz | |
00:15 | • Post: ALTER TABLE DROP COLUMN corrupts data artifact: cc5592c740 user: CyberShadow | |
4 Years Ago (more context)
2020-04-18
| ||
22:58 | • Post: string literals, is there more than one escape? artifact: 8b354dd50f user: LarryBrasfield | |
22:21 | • Reply: sqlite3.exe export with bom artifact: 88b3e6f0e8 user: neubauer | |
22:16 | • Reply: Can SQLite query go in hung/stuck state? artifact: ad9b56d09d user: surabhi.nitsurat | |
21:18 | • Reply: SQL LITE Update artifact: 0aa2261044 user: LarryBrasfield | |
21:14 | • Reply: SQL LITE Update artifact: a143057271 user: slavin | |
20:46 | • Post: SQL LITE Update artifact: d3935c7a69 user: anonymous | |
20:07 | • Reply: geopoly_within doc bug artifact: 5c852a139b user: drh | |
19:59 | • Reply: SQL compliance on Wikipedia artifact: 026b23f302 user: jking | |
19:40 | • Post: geopoly_within doc bug artifact: 29dd10943e user: boris.gontar | |
18:55 | • Reply: SQL-Query is always empty artifact: 5e27646890 user: anonymous | |
17:30 | • Reply: SQL compliance on Wikipedia artifact: eb65be0274 user: Clothears | |
16:48 | • Reply: SQL compliance on Wikipedia artifact: d69a00eafb user: anonymous | |
15:54 | • Reply: Stopping a long running operation artifact: acf0f510e3 user: slavin | |
15:44 | • Reply: SQL compliance on Wikipedia artifact: bd512355a9 user: slavin | |
15:09 | • Delete reply: sqlite3.exe export with bom artifact: 2f1fa3cfb4 user: slavin | |
14:13 | • Reply: sqlite3.exe export with bom artifact: 562fc40335 user: drh | |
13:34 | • Reply: Can SQLite query go in hung/stuck state? artifact: 0d1faa3380 user: drh | |
13:30 | • Reply: sqlite3.exe export with bom artifact: c03a57fbde user: slavin | |
12:34 | • Post: SQL compliance on Wikipedia artifact: 2ae92e0224 user: anonymous | |