This Day In History For 2023-07-30
1 Year Ago (more context)
2022-07-30
| ||
23:02 | • Post: Connect with using Multi-threaded Mode in dotnet artifact: 79869adf5b user: anonymous | |
22:02 | • Reply: sqlite3.h artifact: 538235a60a user: stephan | |
21:52 | • Reply: sqlite3.h artifact: 4e4c03b73f user: Chrismoore | |
21:12 | • Reply: Aggregate Query Problem artifact: e948a68aa6 user: balaji | |
20:37 | • Reply: Aggregate Query Problem artifact: 6a7bf6993b user: kmedcalf | |
20:30 | • Reply: Aggregate Query Problem artifact: 6299f599b7 user: balaji | |
20:29 | • Edit reply: Aggregate Query Problem artifact: a6b47edc34 user: kmedcalf | |
20:28 | • Reply: Aggregate Query Problem artifact: 6335f7de04 user: kmedcalf | |
20:20 | • Reply: Aggregate Query Problem artifact: e887f5998f user: kmedcalf | |
19:53 | • Reply: Aggregate Query Problem artifact: 42cda75ac9 user: balaji | |
19:44 | • Reply: Aggregate Query Problem artifact: 8cb8b380df user: balaji | |
19:32 | • Reply: Aggregate Query Problem artifact: 9ad24729fa user: balaji | |
19:29 | • Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 9862a2b63f user: anonymous | |
19:26 | • Reply: Aggregate Query Problem artifact: 12345f27a1 user: balaji | |
19:19 | • Reply: Aggregate Query Problem artifact: 2c42e5cd12 user: kmedcalf | |
19:18 | • Edit reply: Extension to read a text file as if it's a database artifact: fc53aed82b user: simonw | |
19:18 | • Reply: Extension to read a text file as if it's a database artifact: d456eee0ee user: simonw | |
18:49 | • Reply: Extension to read a text file as if it's a database artifact: 0d0a9c8f50 user: alexgarciaxyz | |
18:40 | • Reply: Aggregate Query Problem artifact: 156f9c44d4 user: kmedcalf | |
18:30 | • Reply: Aggregate Query Problem artifact: 58f9c4c682 user: cuz | |
18:15 | • Reply: Aggregate Query Problem artifact: 005a9f87ee user: kmedcalf | |
18:08 | • Reply: Aggregate Query Problem artifact: b8ae31a3e0 user: cleverly | |
17:47 | • Reply: SELECT * FROM my_table not showing the headers artifact: bce564900b user: cleverly | |
17:19 | • Reply: sqlite3.h artifact: 5c47f3dada user: kmedcalf | |
17:19 | • Edit: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: 24141445a5 user: 961679 | |
17:18 | • Post: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: e8af246f10 user: 961679 | |
17:13 | • Post: Extension to read a text file as if it's a database artifact: ed36b1eb6e user: slavin | |
17:08 | • Post: Aggregate Query Problem artifact: d4aec36498 user: balaji | |
16:45 | • Reply: Import CSV into an existing table artifact: 54a75ea64f user: little-brother | |
16:34 | • Reply: Import CSV into an existing table artifact: decedc0f88 user: anonymous | |
16:15 | • Edit reply: Import CSV into an existing table artifact: 8fda4d7d66 user: hanche | |
16:13 | • Reply: Import CSV into an existing table artifact: 400044cd7c user: hanche | |
15:42 | • Post: Import CSV into an existing table artifact: 3bc6b91e58 user: anonymous | |
15:26 | • Reply: strftime accepts wrong date artifact: 1716cce007 user: hanche | |
14:04 | • Reply: Dump and restore virtual tables (for in-memory databases) artifact: c45d449e0e user: inukshuk | |
13:39 | • Reply: Dump and restore virtual tables (for in-memory databases) artifact: b68bc59ddd user: anonymous | |
12:21 | • Post: Dump and restore virtual tables (for in-memory databases) artifact: c42294b96c user: inukshuk | |
12:10 | • Reply: strftime accepts wrong date artifact: 9b409bd978 user: holgerj | |
10:22 | • Reply: strftime accepts wrong date artifact: 329fe3abd5 user: hanche | |
01:38 | • Reply: sqlite3.h artifact: cec8f95e14 user: Chrismoore | |
00:11 | • Reply: SELECT * FROM my_table not showing the headers artifact: 20256dfe32 user: stephan | |
2 Years Ago (more context)
2021-07-30
| ||
23:20 | • Reply: Mention if printf() should have been called sprintf() artifact: c177310e84 user: larrybr | |
22:21 | • Reply: Mention packages might be available, no need to compile your own artifact: 1238d04fd1 user: larrybr | |
22:00 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: e52d40b4ac user: kmedcalf | |
21:17 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: 8872bab984 user: cuz | |
21:04 | • Reply: Round function returning -0.0 artifact: 4ecb18062a user: cuz | |
21:02 | • Reply: Mention if printf() should have been called sprintf() artifact: cafc54c318 user: wyoung | |
20:57 | • Reply: Abbreviation artifact: 9f3c5703a6 user: cuz | |
20:30 | • Post: Mention packages might be available, no need to compile your own artifact: 6d67c9d870 user: jidanni | |
20:26 | • Post: Mention column widths assume raw bytes artifact: c23162cf2a user: jidanni | |
20:15 | • Post: Mention if printf() should have been called sprintf() artifact: fcf3b21c58 user: jidanni | |
20:11 | • Reply: Bug: `GENERATED ALWAYS` constraint ends up in column type artifact: 82e5f7eb2e user: drh | |
19:49 | • Reply: AUTOINCREMENT by value artifact: 4bc3c1241c user: gunter_hick | |
19:41 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: 7ae29588f1 user: gunter_hick | |
19:28 | • Reply: AUTOINCREMENT by value artifact: 5f4b0bc34d user: kmedcalf | |
19:22 | • Reply: Round function returning -0.0 artifact: 60a8418801 user: kmedcalf | |
19:21 | • Edit: (Deleted) artifact: b98e8b8d9b user: kmedcalf | |
19:20 | • Post: (Deleted) artifact: b4c1d18d6f user: kmedcalf | |
19:05 | • Edit reply: Round function returning -0.0 artifact: 57c8074d3b user: rmariani | |
19:04 | • Reply: Round function returning -0.0 artifact: 27e398c97b user: rmariani | |
18:36 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: f5c0464ab1 user: anonymous | |
18:13 | • Reply: LEFT JOIN Misunderstanding artifact: 8e5c185381 user: rmariani | |
17:57 | • Post: Abbreviation artifact: 83063fd4b5 user: anonymous | |
17:50 | • Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: a5be7fc80c user: anonymous | |
17:42 | • Reply: Odd CL behaviour artifact: a04abcb7c5 user: larrybr | |
17:35 | • Reply: Odd CL behaviour artifact: 7c6ca8d1ff user: anonymous | |
17:33 | • Post: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: bc1d13cddc user: anonymous | |
17:23 | • Edit reply: LEFT JOIN Misunderstanding artifact: 61147883cb user: rmariani | |
17:22 | • Reply: LEFT JOIN Misunderstanding artifact: b7cc2750f9 user: rmariani | |
17:13 | • Reply: Round function returning -0.0 artifact: 5d5853b19f user: rmariani | |
16:13 | • Reply: LEFT JOIN Misunderstanding artifact: 8ae4d29967 user: jicman | |
16:07 | • Post: Odd CL behaviour artifact: b6698dcae7 user: Trudge | |
15:10 | • Reply: Round function returning -0.0 artifact: 91dc2197b9 user: lexfiend | |
15:06 | • Reply: Round function returning -0.0 artifact: 3579a9fe38 user: zoistas | |
13:59 | • Reply: Help calculating data when answers in previous row artifact: a0b07082d3 user: rmariani | |
13:42 | • Reply: LEFT JOIN Misunderstanding artifact: 73a99b46ed user: jicman | |
13:40 | • Reply: AUTOINCREMENT by value artifact: b16e26a6b7 user: anonymous | |
13:39 | • Reply: Round function returning -0.0 artifact: 58a7226aa3 user: RandomCoder | |
13:35 | • Reply: LEFT JOIN Misunderstanding artifact: 29a0dc20f8 user: jicman | |
13:33 | • Reply: LEFT JOIN Misunderstanding artifact: e5680a6502 user: jicman | |
13:27 | • Reply: LEFT JOIN Misunderstanding artifact: 134b052945 user: ddevienne | |
12:57 | • Reply: LEFT JOIN Misunderstanding artifact: 721178fa73 user: rmariani | |
12:53 | • Edit reply: LEFT JOIN Misunderstanding artifact: c69e16d62a user: rmariani | |
12:51 | • Reply: LEFT JOIN Misunderstanding artifact: b0954fcf31 user: rmariani | |
12:39 | • Delete reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: 8de2d93344 user: slavin | |
12:39 | • Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: fb1ef9c78c user: slavin | |
12:28 | • Reply: LEFT JOIN Misunderstanding artifact: bd05c5ea6e user: anonymous | |
12:04 | • Reply: LEFT JOIN Misunderstanding artifact: fc2d3e8487 user: jicman | |
10:03 | • Post: AUTOINCREMENT by value artifact: 985263fc5c user: dido__ | |
08:58 | • Reply: Round function returning -0.0 artifact: f19825c660 user: jdennis | |
08:14 | • Reply: Round function returning -0.0 artifact: bed12d794f user: rmariani | |
08:09 | • Edit reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: a056cb8ed6 user: chromesearcher | |
08:07 | • Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: 18140540cc user: chromesearcher | |
07:58 | • Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: ff2dffec98 user: chromesearcher | |
07:17 | • Post: sqlite3_errcode(db_instance) incorrectly returns SQLITE_OK(0) when last error code was SQLITE_READONLY(8) artifact: 3836350f74 user: anonymous | |
07:15 | • Reply: Round function returning -0.0 artifact: 4899757b88 user: anonymous | |
07:14 | • Post: sqlite3_errcode(db_instance) incorrectly returns SQLITE_OK(0) when last error code was SQLITE_READONLY(8) artifact: 379ddb8296 user: anonymous | |
07:07 | • Reply: Round function returning -0.0 artifact: fc46f950a0 user: jdennis | |
06:58 | • Edit reply: Round function returning -0.0 artifact: ccc11a1952 user: rmariani | |
06:47 | • Reply: Round function returning -0.0 artifact: 095a674179 user: rmariani | |
06:46 | • Reply: Round function returning -0.0 artifact: ee1a09234e user: rmariani | |
06:11 | • Reply: Which version of SQLite supports VxWorks DKM mode ? artifact: 3e5df61bae user: anonymous | |
05:34 | • Reply: Round function returning -0.0 artifact: 2fa5fa85c0 user: lexfiend | |
05:31 | • Reply: Can SQLITE_INTERNAL be a transient error ? artifact: 224c846428 user: lexfiend | |
05:24 | • Reply: Round function returning -0.0 artifact: 65b49f98cd user: rmariani | |
05:14 | • Reply: documenting SQLite's "IS" behavior artifact: 30e2463ba7 user: rmariani | |
05:12 | • Edit reply: LEFT JOIN Misunderstanding artifact: 03bf9fe632 user: rmariani | |
05:11 | • Reply: LEFT JOIN Misunderstanding artifact: a5f3e5ed8d user: rmariani | |
04:06 | • Post: Round function returning -0.0 artifact: cc8d7dd31b user: anonymous | |
02:35 | • Post: LEFT JOIN Misunderstanding artifact: 3b587713f8 user: jicman | |
3 Years Ago (more context)
2020-07-30
| ||
23:46 | • Reply: sqlite-src-3320300 fails test shell1-1.7.1 on Solaris 10 sparcv9 artifact: d6c9d58151 user: blastwave | |
22:39 | • Reply: sqlite-src-3320300 fails test shell1-1.7.1 on Solaris 10 sparcv9 artifact: d58b6d2486 user: drh | |
22:18 | • Post: sqlite-src-3320300 fails test shell1-1.7.1 on Solaris 10 sparcv9 artifact: 88853df939 user: blastwave | |
22:17 | • Reply: Database Growing by itself to huge sizes artifact: dc1f60c130 user: cuz | |
22:08 | • Reply: Usage of suboptimum index artifact: 3fb9b483fa user: drh | |
21:53 | • Reply: Usage of suboptimum index artifact: c5b068215a user: Hardy | |
21:37 | • Reply: Database Growing by itself to huge sizes artifact: 083ec0849b user: DasGoravani | |
20:51 | • Reply: Suggestion: Use strong hashes on the download page artifact: 684bd1ede2 user: anonymous | |
20:45 | • Reply: Please fix CVE-2020-15358 artifact: 0a1b9b6031 user: stephan | |
20:42 | • Reply: Please fix CVE-2020-15358 artifact: 7eb5ce1d72 user: pkolbus | |
20:41 | • Reply: Please fix CVE-2020-15358 artifact: c21a9a8239 user: drh | |
20:28 | • Reply: Please fix CVE-2020-15358 artifact: aead0b8d0a user: stephan | |
20:04 | • Post: Please fix CVE-2020-15358 artifact: 5230bca319 user: AceHack | |
17:10 | • Reply: Typos in SQLite source code artifact: 24585a9601 user: jsoref | |
16:21 | • Reply: Multiple process connections for in-memory DB artifact: a1262d62d2 user: dan | |
16:01 | • Reply: Usage of suboptimum index artifact: 7aad873403 user: dan | |
15:06 | • Post: Usage of suboptimum index artifact: 2a992f739b user: Hardy | |
13:54 | • Edit reply: SQLITE python 3 issue, please help artifact: 40dc233bf9 user: Clothears | |
13:50 | • Reply: SQLITE python 3 issue, please help artifact: 0b927a6d6d user: Clothears | |
13:37 | • Reply: SQLITE python 3 issue, please help artifact: 64f212f7b7 user: kmedcalf | |
13:28 | • Edit reply: SQLITE python 3 issue, please help artifact: 578ee0812e user: Clothears | |
13:28 | • Reply: SQLITE python 3 issue, please help artifact: 5f654ccc70 user: Clothears | |
12:59 | • Reply: SQLITE python 3 issue, please help artifact: 5596076393 user: dvdraymond | |
11:14 | • Post: Multiple process connections for in-memory DB artifact: 760f6e655e user: Ivan.R | |
10:53 | • Reply: Odd, query taking too long artifact: 95caaf8713 user: bobby31 | |
10:47 | • Reply: Odd, query taking too long artifact: 565f1b2111 user: bobby31 | |
10:17 | • Reply: Database Growing by itself to huge sizes artifact: d378c7c184 user: anonymous | |
09:48 | • Reply: Database Growing by itself to huge sizes artifact: 49dada7744 user: TripeHound | |
04:14 | • Post: SQLITE python 3 issue, please help artifact: d4d98c14d6 user: anonymous | |
01:40 | • Reply: Database Growing by itself to huge sizes artifact: e19c51460c user: kmedcalf | |
01:21 | • Reply: Database Growing by itself to huge sizes artifact: 4afb46704c user: LarryBrasfield | |
00:45 | • Reply: Database Growing by itself to huge sizes artifact: 8a7112b98c user: DasGoravani | |
00:39 | • Reply: Typos in SQLite source code artifact: d78fab278d user: jsoref | |
00:12 | • Reply: Order by after a union fails when a function is used in the order by artifact: f149ab2706 user: drh | |