SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent forum posts by user Clothears

2024-03-06
15:49 Reply: Non-breaking space character breaks regexp (artifact: 26792f179d user: Clothears)
2024-03-04
14:23 Reply: Dates in the past (artifact: 6b0c1ebaea user: Clothears)
2024-03-02
22:30 Reply: Dates in the past (artifact: 886e25f0f0 user: Clothears)
14:21 Reply: Dates in the past (artifact: dbdf180018 user: Clothears)
2024-02-29
21:25 Reply: Novice question about using timestamps as long-term unique ids? (artifact: 91013a5df8 user: Clothears)
2024-02-20
22:33 Reply: sqlite update routine for App (artifact: 0de59ee042 user: Clothears)
21:46 Reply: sqlite update routine for App (artifact: 20af5963f7 user: Clothears)
2024-02-19
09:29 Delete reply: For crypto prices, I'm going to use floating points + rounding . I considered the alternatives. Please tell me why I'm wrong. (artifact: efbf708572 user: Clothears)
09:27 Reply: For crypto prices, I'm going to use floating points + rounding . I considered the alternatives. Please tell me why I'm wrong. (artifact: 3141d703c5 user: Clothears)
2024-02-17
12:44 Reply: Viewing the exact values of Floating Points in the db (artifact: 3054fbb7c3 user: Clothears)
2024-01-29
13:05 Reply: Feature Request : Get table name alias from prepared statement (artifact: 2f569e2326 user: Clothears)
2024-01-22
11:48 Reply: vacuum into results in Error: in prepare, no such column (artifact: 2a1f2dd9da user: Clothears)
2024-01-21
22:02 Reply: SQLite sharding/partitioning performance (artifact: eeb992c683 user: Clothears)
2024-01-15
21:45 Reply: Query sum or different if in ather field ther is 1 or 2 (artifact: c7d55bfb83 user: Clothears)
21:40 Reply: wish Please throw informative "attempt to write a readonly database" exception (artifact: d63114d8f1 user: Clothears)
2024-01-04
16:49 Reply: Unclear documentation - some suggestions (artifact: 6abc09ebfd user: Clothears)
2023-12-14
22:52 Reply: Inserting/deleting versus Creating table as/dropping for in-memory database? (artifact: b8293aefed user: Clothears)
2023-12-05
15:52 Reply: preserve sign of REAL even if it is 0.0 ? (artifact: 48c22eaa35 user: Clothears)
2023-12-04
21:52 Reply: preserve sign of REAL even if it is 0.0 ? (artifact: 5931560948 user: Clothears)
2023-11-11
10:53 Reply: Randomly write NULL value into Database (artifact: f55f3c419f user: Clothears)
2023-11-04
21:28 Post: Minor typos in https://sqlite.org/flextypegood.html (artifact: 664cce061f user: Clothears)
2023-10-28
21:43 Reply: sqlite-wasm: does OPFS have an automatic data clearing mechanism or bug? (artifact: 102f014b32 user: Clothears)
2023-10-19
14:37 Reply: Getting Column does not belong to table exception (artifact: a348809bab user: Clothears)
2023-10-17
17:07 Reply: Fix FAQ Entry for #5 (artifact: 87f14dd4b7 user: Clothears)
2023-10-16
14:32 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? (artifact: 9a68878148 user: Clothears)
13:51 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? (artifact: f80f261a47 user: Clothears)
11:40 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? (artifact: 17af9851db user: Clothears)
2023-10-14
20:55 Reply: RFC: is there a semantic difference between NULL and a 0-length blob? (artifact: 0dff924953 user: Clothears)
2023-09-27
17:03 Reply: In-memory databases do not have sqlite_schema (artifact: c9c8469411 user: Clothears)
2023-07-14
18:41 Reply: System.Data.SQLite - ?Int64 (artifact: f46e4070d3 user: Clothears)
2023-07-13
16:19 Reply: System.Data.SQLite - ?Int64 (artifact: 88745d8425 user: Clothears)
2023-06-29
13:46 Reply: Conversion msaccess mdb to SQLite (artifact: e58c208944 user: Clothears)
2023-06-23
09:24 Reply: Cheap way of doing this (artifact: 96d068a95c user: Clothears)
2023-06-22
14:35 Reply: Cheap way of doing this (artifact: 5cf6f3938b user: Clothears)
12:50 Post: Cheap way of doing this (artifact: a669cc4924 user: Clothears)
2023-05-31
18:13 Reply: Column Default value (artifact: 8def9f3423 user: Clothears)
2023-05-28
15:05 Reply: Missing metadata (artifact: a9be0ccaf2 user: Clothears)
14:02 Reply: Missing metadata (artifact: 5475be0672 user: Clothears)
11:34 Reply: Missing metadata (artifact: f413803959 user: Clothears)
2023-05-27
10:28 Edit reply: Column Default value (artifact: 5d6e442feb user: Clothears)
10:26 Edit reply: Column Default value (artifact: 2301788d04 user: Clothears)
10:25 Reply: Column Default value (artifact: f378ed1cec user: Clothears)
2023-05-14
14:11 Reply: Secure delete/overwrite data (artifact: a6648b63d5 user: Clothears)
2023-05-08
16:25 Reply: System.Data.SQLite Help File Unreadable (artifact: 8a2ca88e47 user: Clothears)
2023-05-01
14:20 Reply: Suggestions of tools to handle database migrations (using raw SQL)? (artifact: 14b220f0bc user: Clothears)
2023-04-30
22:25 Reply: Suggestions of tools to handle database migrations (using raw SQL)? (artifact: 00c87ea834 user: Clothears)
2023-04-28
21:12 Reply: Update "The Advantages Of Flexible Typing " web page? (artifact: 298f1611a4 user: Clothears)
2023-04-22
16:45 Reply: comparing (dis)advantages of ATTACHED vs all-in-one db (artifact: 682f1dbe07 user: Clothears)
2023-04-21
18:45 Reply: comparing (dis)advantages of ATTACHED vs all-in-one db (artifact: d0443f5a6a user: Clothears)
2023-04-19
19:02 Reply: SQLite on a Server (artifact: efd2b90812 user: Clothears)