SQLite Forum

Timeline
Login

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

50 most recent forum posts by user lexfiend

2024-04-17
05:00 Edit reply: How should I pause a trigger and start it again later? (artifact: bd2caa30a2 user: lexfiend)
04:58 Reply: How should I pause a trigger and start it again later? (artifact: afbc36a508 user: lexfiend)
2024-04-14
11:50 Reply: SQLite archive function (artifact: 121cb8854f user: lexfiend)
2024-04-04
15:47 Reply: Analyze and the TEMP schema (artifact: 52de622df1 user: lexfiend)
2024-03-26
03:04 Reply: Any SQLite Software that implements simple HTTP client? (artifact: a4d037801d user: lexfiend)
2024-03-22
04:05 Reply: Any SQLite Software that implements simple HTTP client? (artifact: b1f2cfc9d2 user: lexfiend)
2024-03-16
13:01 Reply: calculate the hamming distance between a table column signed integer and a provided signed integer (artifact: 4b89d3c0d9 user: lexfiend)
2024-03-14
04:19 Reply: Using IIF as a subquery possible ? (artifact: 3dd5483afb user: lexfiend)
2024-03-07
15:43 Reply: Using reserved keyword (artifact: 5199e4a24a user: lexfiend)
13:56 Edit reply: Using reserved keyword (artifact: 2afac5e820 user: lexfiend)
13:56 Reply: Using reserved keyword (artifact: c286185755 user: lexfiend)
2024-02-29
06:24 Reply: Novice question about using timestamps as long-term unique ids? (artifact: 8c1f2a0c9f user: lexfiend)
2024-02-15
11:37 Reply: Option to specify primary key on .import? (artifact: e39c6b208e user: lexfiend)
05:17 Reply: Option to specify primary key on .import? (artifact: 53cf68cc6a user: lexfiend)
2024-01-27
14:47 Edit reply: calculating cumulative count (artifact: f6cba42e1e user: lexfiend)
14:42 Reply: calculating cumulative count (artifact: 9b9da66c91 user: lexfiend)
14:22 Reply: problem implementing multi-statement transactions (artifact: fe54b1e8b1 user: lexfiend)
14:01 Reply: problem implementing multi-statement transactions (artifact: 2c41fcc502 user: lexfiend)
13:51 Reply: calculating Count per "time period" (artifact: dff52b9c19 user: lexfiend)
12:40 Reply: problem implementing multi-statement transactions (artifact: 57804c2eda user: lexfiend)
2023-09-27
16:44 Edit reply: In-memory databases do not have sqlite_schema (artifact: 429a209653 user: lexfiend)
16:29 Edit reply: In-memory databases do not have sqlite_schema (artifact: 8bea5217d3 user: lexfiend)
16:22 Reply: In-memory databases do not have sqlite_schema (artifact: aa29404485 user: lexfiend)
16:07 Edit reply: In-memory databases do not have sqlite_schema (artifact: 489c245666 user: lexfiend)
16:07 Reply: In-memory databases do not have sqlite_schema (artifact: 745d2f9781 user: lexfiend)
2023-08-08
11:45 Edit reply: decimal precision (artifact: e2a1b94e5c user: lexfiend)
11:27 Reply: decimal precision (artifact: 85d4c9074f user: lexfiend)
2023-07-31
12:10 Edit reply: ALTER VIEW command (artifact: 1f25de4365 user: lexfiend)
11:44 Reply: ALTER VIEW command (artifact: 6b5a7843f2 user: lexfiend)
2023-07-26
14:20 Reply: Unexpected match with FTS5 query (artifact: 445c15d4da user: lexfiend)
07:52 Reply: Unexpected match with FTS5 query (artifact: 7780944861 user: lexfiend)
03:17 Reply: Unexpected match with FTS5 query (artifact: 11e204b610 user: lexfiend)
2023-07-25
14:10 Reply: Unexpected match with FTS5 query (artifact: 37e01d2ff5 user: lexfiend)
10:47 Reply: Unexpected match with FTS5 query (artifact: 6923a47dce user: lexfiend)
2023-07-20
11:52 Reply: Question about behaviour in WAL mode (artifact: 958883e75d user: lexfiend)
2023-06-05
07:06 Reply: .param lquoted iterals (artifact: c47d6b5fdb user: lexfiend)
03:37 Reply: .param lquoted iterals (artifact: e16c0be6c4 user: lexfiend)
2023-05-30
08:13 Reply: Insert a BLOB value (artifact: 469b4b1f03 user: lexfiend)
08:11 Delete reply: Insert a BLOB value (artifact: 881e435c6c user: lexfiend)
08:11 Reply: Insert a BLOB value (artifact: 37e4f09d1a user: lexfiend)
07:49 Reply: Insert a BLOB value (artifact: 6a1d1e0c4f user: lexfiend)
2023-05-26
15:23 Reply: Parse error when a RETURNING clause refers to the alias of the inserted table (artifact: 4cc2d487da user: lexfiend)
2023-05-24
16:17 Reply: Allow sqlar to work from a view? (artifact: a1c7f559a0 user: lexfiend)
15:32 Edit reply: Allow sqlar to work from a view? (artifact: 1afce3f7b7 user: lexfiend)
15:26 Reply: Allow sqlar to work from a view? (artifact: 7cc8cbfbd9 user: lexfiend)
2023-05-15
09:27 Edit reply: How does one effectively ask for help in this forum (or anywhere)? (artifact: 1c129e8ad9 user: lexfiend)
09:25 Reply: How does one effectively ask for help in this forum (or anywhere)? (artifact: 4804d1b333 user: lexfiend)
03:21 Reply: How does one effectively ask for help in this forum (or anywhere)? (artifact: d83820c975 user: lexfiend)
2023-05-14
01:51 Reply: How to store a list of values? (artifact: aaab4035b0 user: lexfiend)
2023-05-04
12:56 Reply: DB file is dropped/re-created on next app run (artifact: 777a058ff1 user: lexfiend)