SQLite Forum

Timeline
Login

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

50 most recent forum posts by user 1codedebugger

2023-10-07
20:42 Reply: Does substr have to read the full blob into memory to determine the desired segment? (artifact: 50950ff7e9 user: 1codedebugger)
19:32 Post: Does substr have to read the full blob into memory to determine the desired segment? (artifact: 8651f982ff user: 1codedebugger)
2023-10-06
18:54 Edit: (Deleted) (artifact: 35107c003b user: 1codedebugger)
18:22 Post: (Deleted) (artifact: 7abdd7de53 user: 1codedebugger)
04:31 Edit: (Deleted) (artifact: 2f3d17f762 user: 1codedebugger)
04:13 Edit: (Deleted) (artifact: d9205ee05a user: 1codedebugger)
04:00 Post: (Deleted) (artifact: e99a06ca6c user: 1codedebugger)
2023-09-06
18:21 Post: Understanding query plan: are these rows in recursive query accumulated or tested and discarded? (artifact: 1cebba6cf5 user: 1codedebugger)
2023-08-31
07:31 Reply: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: 2f095802d6 user: 1codedebugger)
07:26 Reply: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: a0e7cb7502 user: 1codedebugger)
07:15 Reply: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: 0ad89f5487 user: 1codedebugger)
07:07 Reply: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: d07fc6e7b0 user: 1codedebugger)
05:44 Reply: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: 84ac9b9616 user: 1codedebugger)
01:09 Post: Novice question about the "lifetime" of the -deterministic flag caching in user-defined functions? (artifact: 4a04e35868 user: 1codedebugger)
2023-08-30
18:17 Reply: SQLite and SQL Guru Keith (artifact: e94a0f459f user: 1codedebugger)
2023-08-28
00:47 Post: json_array_length after json_remove appears wrong in Fiddle? (artifact: 0560d5e482 user: 1codedebugger)
2023-08-27
06:25 Delete reply: (Deleted) (artifact: 7df7a8815d user: 1codedebugger)
06:25 Edit: (Deleted) (artifact: 762a4903e4 user: 1codedebugger)
04:35 Reply: (Deleted) (artifact: 975e5c5084 user: 1codedebugger)
04:09 Edit: (Deleted) (artifact: 1bcc99a06c user: 1codedebugger)
04:08 Delete reply: (Deleted) (artifact: ce9c0cb9df user: 1codedebugger)
2023-08-26
07:11 Reply: (Deleted) (artifact: 5023f5e21e user: 1codedebugger)
06:29 Post: (Deleted) (artifact: 9ff2c510fc user: 1codedebugger)
01:29 Post: (Deleted) (artifact: 7acaa8533d user: 1codedebugger)
2023-08-24
03:00 Reply: How to efficiently track an order of rows? (artifact: fdfb0d701c user: 1codedebugger)
02:45 Reply: How to efficiently track an order of rows? (artifact: 6f4d3b782d user: 1codedebugger)
00:52 Reply: How to efficiently track an order of rows? (artifact: df3a5025c9 user: 1codedebugger)
2023-08-23
21:02 Post: How to efficiently track an order of rows? (artifact: 113f72517c user: 1codedebugger)
17:18 Reply: Novice question about difference in which tables are materialized in similar queries. (artifact: d166f8c106 user: 1codedebugger)
17:03 Reply: Novice question about difference in which tables are materialized in similar queries. (artifact: 18627ca773 user: 1codedebugger)
05:43 Post: Novice question about difference in which tables are materialized in similar queries. (artifact: 74529ea731 user: 1codedebugger)
2023-08-15
22:30 Post: String/integer in ':'-type parameter substituton in Tcl? (artifact: 3743665397 user: 1codedebugger)
2023-08-14
15:52 Reply: Trying to understand how/when a recursive query breaks out of a loop? (artifact: b1be471a0a user: 1codedebugger)
2023-08-12
23:10 Edit: Trying to understand how/when a recursive query breaks out of a loop? (artifact: de554ac0cc user: 1codedebugger)
22:53 Post: Trying to understand how/when a recursive query breaks out of a loop? (artifact: 259f39e95e user: 1codedebugger)
20:17 Edit: (Deleted) (artifact: 7195097478 user: 1codedebugger)
07:11 Post: (Deleted) (artifact: cd9edd9b8b user: 1codedebugger)
2023-08-06
02:57 Reply: Why big-endian? (artifact: f40fbe3baa user: 1codedebugger)
2023-05-18
23:28 Reply: How to combine indiviual queries (artifact: b9d7776815 user: 1codedebugger)
2023-05-09
16:26 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: 6530b1849c user: 1codedebugger)
07:04 Edit reply: Validate SQL query (artifact: 9a27dd26dd user: 1codedebugger)
07:02 Reply: Validate SQL query (artifact: 8f440f398a user: 1codedebugger)
05:43 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: 4eaada5dc9 user: 1codedebugger)
00:35 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: d93c282a3c user: 1codedebugger)
00:17 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: d7fae097e6 user: 1codedebugger)
00:10 Reply: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: a0e221d117 user: 1codedebugger)
2023-05-08
22:42 Post: Using "incrblob" of the Tcl interface and the -command option of chan copy (artifact: 02c1916507 user: 1codedebugger)
2023-05-01
02:25 Post: Is it valid to transform row result values within an aggregate function when grouping? (artifact: 319f3302bb user: 1codedebugger)
2023-04-30
05:07 Delete reply: How to apply a left join to each data grouping? (artifact: cb51959c0a user: 1codedebugger)
2023-04-29
05:59 Reply: ORDER BY on a PARTITION changes the paritition size (artifact: 06fc1a895a user: 1codedebugger)