SQLite User Forum

Today In History
Login

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