SQLite User Forum

Today In History
Login

This Day In History For 2024-03-15

1 Year Ago (more context)

2023-03-15
21:00 Reply: Help with query plan artifact: 00ed71196a user: jkreibich
20:51 Reply: Help with query plan artifact: 8cc97c2ffc user: jkreibich
20:01 Post: Incorrect update caused by subquery in where clause artifact: 0007d1fdb1 user: zuming_jiang
19:47 Reply: Incorrect deletion caused by subquery in where clause artifact: 207c5978c0 user: zuming_jiang
18:42 Reply: OR-by-UNION vs INDEXED BY artifact: 980074a36b user: fernandocc
18:32 Reply: Windows 11 fails in Winforms app artifact: 1080beffd3 user: kmedcalf
18:31 Reply: Incorrect deletion caused by subquery in where clause artifact: f07fb593f9 user: drh
18:23 Reply: Windows 11 fails in Winforms app artifact: 2c10f85c56 user: AAsk1902
18:23 Reply: OR-by-UNION vs INDEXED BY artifact: 50b75b52e9 user: drh
18:18 Reply: Windows 11 fails in Winforms app artifact: 148f5d4c3d user: kmedcalf
18:13 Reply: SQLite WASM benchmarks artifact: bd925c0816 user: stephan
18:02 Post: OR-by-UNION vs INDEXED BY artifact: 4fc5e5c256 user: fernandocc
17:54 Edit reply: Database tables got deleted automatically artifact: 77ee37b5b5 user: AAsk1902
17:51 Edit reply: Windows 11 fails in Winforms app artifact: f83497b860 user: AAsk1902
17:51 Reply: Windows 11 fails in Winforms app artifact: 4325a15d5d user: AAsk1902
17:33 Reply: SQLite in serverless cloud container artifact: 64a84f3f2d user: anonymous
17:29 Reply: Windows 11 fails in Winforms app artifact: c9c0174e9f user: kmedcalf
17:24 Reply: Database tables got deleted automatically artifact: d2eb456ecd user: AAsk1902
17:21 Reply: Database tables got deleted automatically artifact: 9598e6fcdb user: kmedcalf
17:21 Edit reply: Windows 11 fails in Winforms app artifact: da6fa11519 user: AAsk1902
17:20 Reply: Database tables got deleted automatically artifact: 25d928796e user: larrybr
17:20 Reply: Windows 11 fails in Winforms app artifact: 4473e4dd17 user: AAsk1902
17:17 Post: Database tables got deleted automatically artifact: 4872a81a33 user: Trushanti
17:17 Reply: Program with SQLite database running too slow artifact: 846932c524 user: lea12345
17:07 Reply: RFE: add pragma_schema_version.schema column artifact: dc23400161 user: kmedcalf
17:04 Edit reply: SQLite WASM benchmarks artifact: a5caec1199 user: tantaman
17:03 Reply: RFE: add pragma_schema_version.schema column artifact: 3580e0d23d user: larrybr
17:00 Reply: SQLite WASM benchmarks artifact: 4462e4c72c user: tantaman
16:53 Reply: Incorrect deletion caused by subquery in where clause artifact: 9e3594e8b0 user: drh
16:53 Reply: Windows 11 fails in Winforms app artifact: 82048f610e user: BudsyBaby
16:49 Reply: Bug: schema hidden column of pragma tables always null artifact: 552180960f user: kmedcalf
16:49 Reply: Windows 11 fails in Winforms app artifact: 0cee4c55c4 user: BudsyBaby
16:44 Reply: Program with SQLite database running too slow artifact: e8fddf4d1c user: larrybr
16:40 Reply: Program with SQLite database running too slow artifact: e197065110 user: kmedcalf
16:29 Reply: Incorrect deletion caused by subquery in where clause artifact: d7404dc0d6 user: kmedcalf
16:12 Edit reply: Bug: schema hidden column of pragma tables always null artifact: 321ea8d79a user: kmedcalf
15:59 Reply: Bug: schema hidden column of pragma tables always null artifact: ebfe9f6c84 user: kmedcalf
15:32 Reply: RFE: add pragma_schema_version.schema column artifact: 71ff1e7689 user: kmedcalf
15:16 Reply: Program with SQLite database running too slow artifact: 16524e50f9 user: lea12345
15:16 Reply: Program with SQLite database running too slow artifact: cab77aed40 user: lea12345
14:54 Reply: Building SQLite fails during make artifact: ad4b078dbe user: anonymous
14:42 Post: Incorrect deletion caused by subquery in where clause artifact: e61252062c user: zuming_jiang
14:29 Reply: Building SQLite fails during make artifact: 5376ef7c29 user: stephan
14:16 Reply: Building SQLite fails during make artifact: 4deaa609a1 user: anonymous
14:06 Reply: Subtract in select artifact: 8be28ef034 user: Meks22
14:03 Reply: Building SQLite fails during make artifact: 01df1c8632 user: stephan
13:49 Reply: Building SQLite fails during make artifact: 2acb982566 user: anonymous
13:48 Reply: Subtract in select artifact: 8e635cd157 user: knu
13:30 Reply: Subtract in select artifact: 421423978b user: jicman
13:28 Reply: Building SQLite fails during make artifact: 7b768243e4 user: stephan
13:19 Reply: Bug: schema hidden column of pragma tables always null artifact: 6600f46e5d user: anonymous
13:15 Reply: Building SQLite fails during make artifact: 854be7e859 user: anonymous
13:15 Reply: "LEFT JOIN .. ON false" optimization artifact: 40be95b764 user: mabrand
13:03 Edit: Subtract in select artifact: ff79ec8fae user: stephan
12:59 Post: Subtract in select artifact: a8053a71ab user: Meks22
12:25 Reply: SQLite WASM Apache configuration fragment artifact: 6fe92507f9 user: stephan
12:16 Post: SQLite WASM Apache configuration fragment artifact: 69dc1f537f user: mmomtchev
12:11 Reply: RFE: add pragma_schema_version.schema column artifact: d4fd06d48b user: larrybr
11:18 Reply: RFE: add pragma_schema_version.schema column artifact: 2198fe0bdc user: ddevienne
10:18 Reply: Building SQLite fails during make artifact: a8d0dfceb2 user: stephan
10:01 Post: Building SQLite fails during make artifact: 706f7c10f8 user: anonymous
09:47 Post: SQLite in serverless cloud container artifact: f4ac0f8eff user: anonymous
05:52 Reply: RFE: add pragma_schema_version.schema column artifact: 21d7436c06 user: larrybr
05:14 Reply: Bug: schema hidden column of pragma tables always null artifact: 313b87243d user: larrybr
04:53 Reply: Bug: schema hidden column of pragma tables always null artifact: f7827d4dfa user: bjoern
04:50 Reply: RFE: add pragma_schema_version.schema column artifact: 23ae9ada55 user: bjoern
03:25 Reply: Incorrect query result artifact: a01352b885 user: John-Jove
03:15 Edit reply: Incorrect query result artifact: 193bff2343 user: larrybr
03:09 Reply: Incorrect query result artifact: 3f81e93ac0 user: larrybr
03:02 Reply: Incorrect query result artifact: 0bc37146ea user: John-Jove
02:04 Reply: ANALYZE causes incorrect query results. artifact: 4890d72fac user: drh
02:02 Reply: Incorrect query result artifact: eecefe6fcc user: drh
01:57 Reply: ANALYZE causes incorrect query results. artifact: 6e39fca50e user: John-Jove
01:46 Reply: Incorrect query result artifact: 90df450115 user: John-Jove
00:02 Reply: Request for ENH for consideration. (parse_url, parse_str etc). artifact: b96d9a529b user: midijohnny

2 Years Ago (more context)

2022-03-15
23:36 Reply: Is there a curated list of extensions for SQLite? artifact: 295c8fc789 user: anonymous
18:47 Reply: Placeholder as ORDER BY expression artifact: 6f8b24704b user: kmedcalf
18:27 Reply: Placeholder as ORDER BY expression artifact: 044c8a96f2 user: kmedcalf
18:13 Reply: Placeholder as ORDER BY expression artifact: 034f9be728 user: vman59
18:10 Reply: Is this silent failure expected behavior? artifact: 3c8e1a3010 user: larrybr
17:51 Post: Performance drop on any netcore build. artifact: b73c930cfb user: marco_6
17:37 Reply: Placeholder as ORDER BY expression artifact: 8386a2dbfc user: larrybr
17:21 Edit: Placeholder as ORDER BY expression artifact: a0a3b585af user: triendl.kj
16:44 Reply: Prevent Automatic Rounding? artifact: 1f56c9b40e user: anonymous
16:21 Post: Placeholder as ORDER BY expression artifact: 1634572524 user: triendl.kj
15:45 Reply: Prevent Automatic Rounding? artifact: 9339ebed92 user: jhersey29
15:41 Reply: Prevent Automatic Rounding? artifact: cc9437844a user: jhersey29
15:28 Reply: Prevent Automatic Rounding? artifact: ffdc0909fb user: jhersey29
15:22 Reply: Prevent Automatic Rounding? artifact: 89ef3f70b9 user: jhersey29
15:02 Reply: Prevent Automatic Rounding? artifact: 023fc9c839 user: anonymous
14:55 Reply: Prevent Automatic Rounding? artifact: 4167a04a27 user: RandomCoder
14:34 Delete reply: Prevent Automatic Rounding? artifact: 525ba285ba user: jhersey29
14:34 Reply: Prevent Automatic Rounding? artifact: 7e4d278d4e user: jhersey29
14:33 Edit reply: Prevent Automatic Rounding? artifact: 40864f1bf9 user: jhersey29
14:13 Reply: Prevent Automatic Rounding? artifact: 3a8f412de9 user: jhersey29
14:10 Reply: Is this silent failure expected behavior? artifact: 0f5b4e7b2f user: jfriedl
13:02 Reply: sqlite3_value_dup and stale pointers artifact: 9be2d22ee7 user: anonymous
12:36 Reply: JSON_Object() Argument Limit artifact: 43e4e5d8d6 user: midijohnny
11:57 Reply: Is there a curated list of extensions for SQLite? artifact: 1d536770ee user: midijohnny
10:20 Reply: Prevent Automatic Rounding? artifact: a9a031d8c4 user: larrybr
10:10 Reply: Prevent Automatic Rounding? artifact: e4bbd625e8 user: wyoung
09:55 Reply: Is this silent failure expected behavior? artifact: bf8b1d9e57 user: larrybr
09:32 Post: Is this silent failure expected behavior? artifact: 718f489a43 user: jfriedl
08:38 Reply: Fast way to insert rows in SQLite artifact: 49dca7491f user: ddevienne
07:18 Reply: Prevent Automatic Rounding? artifact: 35d7ff2dbb user: larrybr
07:16 Reply: Prevent Automatic Rounding? artifact: c1e11afd74 user: larrybr
07:07 Edit reply: Prevent Automatic Rounding? artifact: b84040f7b9 user: hanche
07:04 Reply: How to unpivot a cross-table with “changing“ numbers of columns and column names? artifact: 18a645d9ad user: anonymous
06:04 Reply: Prevent Automatic Rounding? artifact: 93f711f4e4 user: hanche
03:28 Reply: JSON_Object() Argument Limit artifact: c062718809 user: alexgarciaxyz
01:59 Reply: Annual Maintenance Subscription and High-priority Technical Support artifact: 94199d1e18 user: anonymous
01:43 Reply: Is there a curated list of extensions for SQLite? artifact: 369865453d user: anonymous

3 Years Ago (more context)

2021-03-15
23:49 Reply: TEXT values can contain arbitrary binary data artifact: c32228e0a3 user: roywellington
23:36 Reply: TEXT values can contain arbitrary binary data artifact: e6b43bcb79 user: roywellington
22:59 Reply: Serious problems with STORED columns artifact: c6040bf211 user: kmedcalf
22:56 Edit reply: Serious problems with STORED columns artifact: 02313c094f user: kmedcalf
22:52 Reply: V3.35.0 Math Functions with Pre-Compiled Binaries artifact: 90a54a26db user: anonymous
22:50 Reply: Serious problems with STORED columns artifact: cf7d0d3566 user: kmedcalf
22:35 Reply: Serious problems with STORED columns artifact: d0c3b6bfe3 user: kmedcalf
22:14 Reply: Error "database disk image is malformed" when loading an appendvfs db artifact: af47fff554 user: larrybr
22:04 Reply: Error "database disk image is malformed" when loading an appendvfs db artifact: 3a637c9302 user: anonymous
21:53 Reply: V3.35.0 Math Functions with Pre-Compiled Binaries artifact: eb9fd723bb user: larrybr
21:51 Reply: V3.35.0 Math Functions with Pre-Compiled Binaries artifact: f6ea7c1f22 user: anonymous
21:35 Reply: Serious problems with STORED columns artifact: 6f17606b06 user: wyoung
21:30 Post: Serious problems with STORED columns artifact: 28ab8d7150 user: anonymous
21:11 Reply: V3.35.0 Math Functions with Pre-Compiled Binaries artifact: e3bcaa16bc user: anonymous
20:46 Reply: Error "database disk image is malformed" when loading an appendvfs db artifact: 703942b078 user: anonymous
19:38 Reply: Runtime of and opcode counts of ANALYZE artifact: 2a948e5000 user: larrybr
19:21 Edit reply: Error "database disk image is malformed" when loading an appendvfs db artifact: 8d650bd1f2 user: larrybr
19:09 Reply: Error "database disk image is malformed" when loading an appendvfs db artifact: 4123d5aba1 user: larrybr
18:34 Reply: Runtime of and opcode counts of ANALYZE artifact: 741ebf0b16 user: macsql20
18:32 Reply: Runtime of and opcode counts of ANALYZE artifact: a22acd815d user: macsql20
18:31 Reply: Runtime of and opcode counts of ANALYZE artifact: 9b37d6dd5f user: macsql20
18:28 Post: Error "database disk image is malformed" when loading an appendvfs db artifact: b20b40ce56 user: anonymous
17:52 Reply: Runtime of and opcode counts of ANALYZE artifact: 5933ce0452 user: macsql20
17:51 Reply: Runtime of and opcode counts of ANALYZE artifact: 1a634c8225 user: macsql20
16:22 Reply: Are MATERIALIZED and RETURNING keywords? artifact: 91764a7de6 user: little-brother
15:12 Reply: Unable to load dll 'SQLite.interop.dll' after installing my app. The dll is present in the application folder artifact: 93375045c2 user: larrybr
15:12 Reply: Can you see what I do wrong? artifact: 05c04c3891 user: kmedcalf
14:58 Reply: Can you see what I do wrong? artifact: 24b3275a28 user: gunter_hick
14:53 Reply: Unable to load dll 'SQLite.interop.dll' after installing my app. The dll is present in the application folder artifact: 4c65792b64 user: anonymous
14:43 Reply: Can you see what I do wrong? artifact: ac64f36921 user: anonymous
14:28 Reply: Can you see what I do wrong? artifact: 6e0f371ca3 user: anonymous
13:58 Reply: TEXT values can contain arbitrary binary data artifact: b737c3f38d user: kmedcalf
12:28 Reply: SELECT and RETURNING in one statement artifact: 337b010983 user: larrybr
12:20 Reply: heap over flow artifact: 507c756600 user: larrybr
12:14 Post: heap over flow artifact: 97dab4add5 user: 3ntr0py1337
12:09 Reply: Are MATERIALIZED and RETURNING keywords? artifact: c15a5f06f3 user: larrybr
12:05 Reply: Runtime of and opcode counts of ANALYZE artifact: 6bd9280999 user: drh
11:28 Post: SELECT and RETURNING in one statement artifact: 5e1ef49f35 user: marcob
09:44 Post: Are MATERIALIZED and RETURNING keywords? artifact: 35ce7e4c63 user: little-brother
09:44 Reply: TEXT values can contain arbitrary binary data artifact: 5ac8052f87 user: cuz
08:09 Reply: Documentation should be improved for the CLI command .dump artifact: 46bcb9aafc user: anonymous
07:44 Reply: Documentation should be improved for the CLI command .dump artifact: 76a8011656 user: larrybr
07:01 Reply: TEXT values can contain arbitrary binary data artifact: dae1f9d17c user: jking
07:00 Reply: TEXT values can contain arbitrary binary data artifact: 8d87ec0dfe user: gunter_hick
06:43 Post: Documentation should be improved for the CLI command .dump artifact: efd663a507 user: anonymous
05:38 Reply: Runtime of and opcode counts of ANALYZE artifact: 74f94985b2 user: sqweek
03:43 Post: TEXT values can contain arbitrary binary data artifact: 572882973f user: roywellington
01:09 Edit reply: Can you see what I do wrong? artifact: e209c65189 user: kmedcalf
01:07 Reply: Can you see what I do wrong? artifact: 5629f5813c user: kmedcalf
00:46 Post: Can you see what I do wrong? artifact: 0275c79728 user: anonymous
00:05 Reply: "SQL Features That SQLite Does Not Implement" needs updating artifact: a4fd07393a user: larrybr

4 Years Ago (more context)

2020-03-15
19:43 Post: Improved virtual tables artifact: 524ccce544 user: anonymous
18:36 Reply: Help needed! Database corruption on embedded system artifact: 66cbc50f2a user: vasile.rares93
16:01 Edit reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: db1c22c57f user: stephan
15:57 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 95461ccee6 user: stephan
15:53 Reply: 400 Bad Request .... artifact: 4bde68bd68 user: drh
15:34 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 133f4168d2 user: mark
15:25 Post: 400 Bad Request .... artifact: 642c5479be user: mark
15:01 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 36aeeedde1 user: punkish
14:20 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 2fa19af6d0 user: stephan
14:12 Reply: How to edit posts waiting in the moderator approval queue? artifact: 72646a117d user: stephan
13:56 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 79dfc4478f user: mark
13:52 Reply: email gateway Confusing authorship on edited posts artifact: 0bbb38ab42 user: punkish
13:33 Reply: How to edit posts waiting in the moderator approval queue? artifact: 6f2d6beb24 user: mark
13:06 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: a05f706d7f user: punkish
12:53 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 3bad3235e4 user: crustyoz
12:35 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 17056976e9 user: stephan
12:29 Post: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read artifact: 5de21a55dc user: mark
12:27 Reply: How to edit posts waiting in the moderator approval queue? artifact: 74bf9cf4e5 user: stephan
12:25 Post: (email) Feature request: meta info in signature instead of body artifact: e17cb0a95c user: mark
12:20 Post: How to edit posts waiting in the moderator approval queue? artifact: d2644e930a user: mark
12:17 Post: (email) Use of square brackets in subject causes WikiLinks? artifact: 3051f5f727 user: mark
12:10 Post: email gateway Confusing authorship on edited posts artifact: f6da165d1c user: mark
04:23 Post: reset password? artifact: 64220dc464 user: jimdod
02:36 Reply: Cannot change my email settings artifact: 84736a5c99 user: stephan
02:04 Reply: Cannot change my email settings artifact: 525594854d user: nh2
01:56 Post: Extended result codes and extensions artifact: 036849d4ba user: nh2
01:20 Edit reply: sqlite write performance is slower than the filesystem artifact: a7678f6f3d user: bioinfornatics
01:19 Reply: sqlite write performance is slower than the filesystem artifact: cc5fbae781 user: bioinfornatics
00:33 Reply: sqlite write performance is slower than the filesystem artifact: 1805d184dd user: slavin