SQLite User Forum

Today In History
Login

This Day In History For 2024-03-29

1 Year Ago (more context)

2023-03-29
23:53 Reply: before insert trigger artifact: 5bbb0fe6c0 user: larrybr
22:44 Reply: before insert trigger artifact: 9ce5fd6c62 user: DiamondJohn
22:35 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 2669911f24 user: knu
22:34 Edit reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 2fc5398cf7 user: dempson
22:32 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 331c528efa user: dempson
20:28 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: c19f3921b6 user: anonymous
20:14 Post: before insert trigger artifact: f039821f33 user: justme
19:47 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: e9f6b843ad user: bjoern
19:42 Reply: python sqlite3 db mysteriously ending up as a 0 byte file artifact: 850f9aeebb user: john_relegardin
19:31 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 6fc85119d3 user: stephan
19:25 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: afb3bf833f user: anonymous
18:59 Edit reply: Dot Commands artifact: ab6bd8adf4 user: AAsk1902
18:59 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: e29b2f50fe user: anonymous
18:55 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: b70ee95718 user: dan
18:53 Reply: Dot Commands artifact: d0e6ed98dc user: AAsk1902
18:49 Edit reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 09f220cd16 user: AAsk1902
18:48 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: b08faa45ec user: AAsk1902
18:37 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 7d52ca565b user: drh
18:35 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: 25b6588b11 user: bjoern
18:06 Post: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: cbca7db7d0 user: anonymous
17:01 Reply: Dot Commands artifact: 6a79f5cfcf user: mgrmgr
16:55 Reply: Executing dot command from C interface artifact: 39271c7e45 user: larrybr
16:47 Reply: CROSS JOIN doc bug? artifact: a5016f6fb5 user: kmedcalf
16:35 Reply: CROSS JOIN doc bug? artifact: f1addf591c user: kmedcalf
16:18 Reply: Executing dot command from C interface artifact: c33c57e733 user: ddevienne
15:53 Reply: CROSS JOIN doc bug? artifact: b2052c0510 user: kmedcalf
15:31 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: c30e99a9d2 user: dan
14:49 Edit reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: acb1d37375 user: bjoern
14:43 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: ce7e50e242 user: bjoern
14:42 Reply: Dot Commands artifact: cd4dc0b61f user: knu
14:32 Reply: Executing dot command from C interface artifact: 5b4013b6fe user: larrybr
14:31 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: cfca52e26b user: bjoern
14:10 Reply: Linux process cannot write to sqlite database artifact: a4a15296c8 user: wyoung
14:09 Reply: Very slow query needs help to be faster artifact: 36fa731d18 user: jicman
14:05 Reply: Linux process cannot write to sqlite database artifact: af50c36777 user: wyoung
14:05 Reply: Very slow query needs help to be faster artifact: 860f77ed4c user: jicman
13:46 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: 6c869e2799 user: dan
13:36 Edit reply: CROSS JOIN doc bug? artifact: 7b45ea1ae8 user: holgerj
13:35 Reply: CROSS JOIN doc bug? artifact: 33a0931610 user: holgerj
13:32 Reply: Dot Commands artifact: 08702ff397 user: AAsk1902
12:28 Edit: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: a6ffe28e5f user: bjoern
12:28 Edit: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: abff40ba62 user: bjoern
12:19 Post: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: e21eb92eaa user: bjoern
12:06 Reply: Linux process cannot write to sqlite database artifact: 6423b047ae user: CompuRoot
11:46 Reply: Dot Commands artifact: eaccb5547c user: mgrmgr
11:29 Reply: Does SQLite WASM include the zipfile support? artifact: cdaa8dfac4 user: mandolyte
10:39 Reply: SQLITE_LOCKED from WAL_CHECKPOINT artifact: 9fba47556b user: dan
09:56 Reply: Very slow query needs help to be faster artifact: c4a09fe68f user: ddevienne
08:26 Reply: Dot Commands artifact: 0c31d82884 user: anonymous
08:11 Post: Dot Commands artifact: 8a37a3d993 user: AAsk1902
07:26 Reply: Linux process cannot write to sqlite database artifact: 335357a234 user: stephan
07:18 Reply: Linux process cannot write to sqlite database artifact: be980ac508 user: nuclight
07:07 Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 9363fc61b4 user: nuclight
07:00 Reply: Executing dot command from C interface artifact: e5b6f5286e user: ddevienne
05:56 Reply: Column aliases inside FROM artifact: caabdcc705 user: anonymous
04:29 Reply: Very slow query needs help to be faster artifact: 70899dbd3e user: anonymous
03:22 Reply: Executing dot command from C interface artifact: 05245779d7 user: larrybr
03:15 Post: Executing dot command from C interface artifact: f98f63d042 user: oneeyeman
02:29 Post: ORDER BY in lag() window function compared to that of the containing statement? artifact: 7a239fddd8 user: anonymous

2 Years Ago (more context)

2022-03-29
10:51 Reply: How to trim suffix from a text column? artifact: 0d717dc81d user: gunter_hick
09:59 Post: SEE License Implementation won't work in .Net API artifact: b7375fbd63 user: kelvin.muyambo
08:58 Reply: How to trim suffix from a text column? artifact: 459bb6b868 user: anonymous
07:09 Reply: Incorrect 3.38.2 win64 download artifact: 9688701c30 user: anonymous
05:31 Reply: SQLite creating automatic index where a schema-defined index already exists artifact: 2bd11b8f19 user: anonymous
03:14 Edit reply: How to trim suffix from a text column? artifact: 6c1a3e357d user: kmedcalf
03:13 Reply: How to trim suffix from a text column? artifact: 2c8bc8c831 user: kmedcalf
03:04 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: 892d894cd8 user: xuannamtoba
02:59 Edit reply: How to trim suffix from a text column? artifact: 6a934252d8 user: kmedcalf
02:54 Reply: How to trim suffix from a text column? artifact: 195be56d2c user: kmedcalf
01:44 Post: How to trim suffix from a text column? artifact: e4bf65bbef user: 6kEs4Majrd
01:27 Reply: SQLite creating automatic index where a schema-defined index already exists artifact: 697c6c7425 user: msa
00:52 Reply: Excel formulas in SQLITE artifact: fb7ab51d87 user: anonymous

3 Years Ago (more context)

2021-03-29
23:38 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 1f5ddb95b2 user: larrybr
23:35 Edit reply: SQLite Heap overflow artifact: 845854dae9 user: larrybr
23:34 Edit reply: SQLite Heap overflow artifact: 187919c75d user: larrybr
23:21 Reply: SQLite Heap overflow artifact: 2a973c8c5b user: larrybr
23:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 8b49459ada user: kmedcalf
22:57 Reply: SQLite Heap overflow artifact: 13b194bac6 user: kmedcalf
22:48 Reply: SQLite Heap overflow artifact: 7e20800161 user: larrybr
22:05 Edit reply: SQLite Heap overflow artifact: c9faf097fc user: kmedcalf
22:02 Reply: SQLite Heap overflow artifact: aec45a16c1 user: kmedcalf
21:41 Post: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: cdc28fec1a user: sbinder
20:34 Reply: SQLite Heap overflow artifact: 62d0daf49a user: larrybr
20:19 Post: SQLite Heap overflow artifact: 5d150e3186 user: anonymous
19:00 Post: (Deleted) artifact: 7a2a50db41 user: 1codedebugger
18:42 Reply: Missing Exports artifact: 1435cfea38 user: larrybr
18:03 Reply: Missing Exports artifact: 9c983d4506 user: anonymous
17:09 Reply: Missing Exports artifact: e5970965f1 user: larrybr
16:09 Reply: VPN log in problem artifact: 780efab355 user: Trudge
16:02 Reply: Missing Exports artifact: 59432b10c9 user: anonymous
15:24 Post: VPN log in problem artifact: 312f1df1c8 user: anonymous
15:21 Reply: Novice question about running UTF-8 on CLI from file. artifact: 869af44e54 user: anonymous
14:38 Reply: Missing Exports artifact: 1f615ae603 user: larrybr
13:09 Reply: Novice question about running UTF-8 on CLI from file. artifact: 8f5d5298e6 user: jicman
13:05 Reply: Missing Exports artifact: 0df0c1db20 user: anonymous
12:52 Reply: Missing Exports artifact: bd79ad2c38 user: anonymous
12:39 Reply: Missing Exports artifact: 52a41706d0 user: anonymous
12:22 Reply: Missing Exports artifact: dc845fc715 user: larrybr
09:55 Reply: Query Contraint with an if clause? artifact: ffe32a3922 user: kmedcalf
09:20 Reply: Query Contraint with an if clause? artifact: 6b3616c189 user: TripeHound
08:13 Post: Missing Exports artifact: d8d49f2c54 user: raasaywarden
07:27 Reply: Query Contraint with an if clause? artifact: 0762700ddb user: samrusso4
05:16 Reply: "ERROR ON LOAD EXTENSION" artifact: 356122403d user: BenediktRothe

4 Years Ago (more context)

2020-03-29
21:45 Reply: Natural sort order artifact: 29041e2cf4 user: mark
21:39 Reply: feature request dump multiple tables at once artifact: 1ec3d18075 user: mark
21:30 Reply: Quoting is hard artifact: 2769abd21f user: anonymous
21:26 Reply: progress handler from user functions artifact: 39f4d44e2a user: anonymous
21:10 Reply: 3.31.1: docs as PDF? artifact: e3aa45c5d6 user: richs
20:44 Reply: Natural sort order artifact: 6c32cec36f user: drh
19:57 Post: Sqlite in PHP import data from a file artifact: d7ecfde163 user: pizzipie
19:56 Reply: 3.31.1: docs as PDF? artifact: c5242bdf9c user: gisbert
19:51 Reply: 3.31.1: docs as PDF? artifact: 734ff8a796 user: gisbert
19:36 Reply: vtable constructor failed fails in one machine artifact: 9292f41b2d user: davidgf
17:52 Post: vtable constructor failed fails in one machine artifact: f1a41e4dc8 user: davidgf
17:35 Post: Seach engine crawling of new forum posts artifact: 5fd0acff89 user: Maxulite
17:08 Post: progress handler from user functions artifact: 03c94975a1 user: Maxulite
14:16 Reply: Beginners learning SQLite -- where to start? artifact: 6ce0edb06b user: rtan2010
14:14 Post: How to run SQLite under VSCode artifact: 69150f7b25 user: rtan2010
11:56 Reply: Colons in column names? artifact: c79d3587da user: kmedcalf
10:04 Reply: Colons in column names? artifact: 1495c3b9d5 user: msa
09:35 Reply: Natural sort order artifact: b5cf53b0c5 user: anonymous
09:23 Edit reply: Beginners learning SQLite -- where to start? artifact: eec76f3bf0 user: KlaasZ4usVanBv
09:16 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 4143dc712c user: kmedcalf
08:27 Reply: Colons in column names? artifact: cb610cf4af user: cladisch
08:10 Reply: Beginners learning SQLite -- where to start? artifact: b3eca25cf5 user: KlaasZ4usVanBv
08:00 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: c29e3074b7 user: kmedcalf
07:53 Reply: Natural sort order artifact: cbad577d80 user: cladisch
07:47 Reply: Colons in column names? artifact: 69aaa3a686 user: stephan
07:41 Edit reply: Colons in column names? artifact: 62525ab9d6 user: d3x0r
07:40 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 833117c051 user: luuk
07:39 Reply: Colons in column names? artifact: 4303456ce9 user: d3x0r
07:34 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 8f5150ca32 user: kmedcalf
07:17 Reply: Colons in column names? artifact: 21897d24af user: kmedcalf
06:55 Edit: (Deleted) artifact: be11bf60bb user: rtan2010
06:33 Edit reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 2fefa20faf user: PongoZ
06:12 Post: Beginners learning SQLite -- where to start? artifact: 5ab563bca1 user: rtan2010
06:09 Reply: (Deleted) artifact: b2c81ac0f2 user: rtan2010
06:06 Reply: (Deleted) artifact: ab2345baa8 user: stephan
05:58 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: f4bdc29b41 user: PongoZ
05:57 Reply: Retrieving FIRST occurrence of a string in a column (SQLITE PHP) artifact: 80b6873bd1 user: PongoZ
05:55 Post: (Deleted) artifact: e89ab190ea user: rtan2010
05:07 Reply: Colons in column names? artifact: 04712e5b7a user: stephan
04:08 Post: Colons in column names? artifact: bc85f1e1d4 user: msa
01:03 Reply: Natural sort order artifact: 4b01876e72 user: drh
00:55 Reply: Natural sort order artifact: 35fb771227 user: drh
00:00 Reply: feature request: Add option to UNIQUE constrain to treat NULLs as distinct artifact: 533bf11625 user: drh