SQLite Forum

Timeline
Login

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

93 events for the month beginning 2021-05-01 by user kmedcalf

Following month ↑
2021-05-31
14:59 Reply: Nothing for several days from the forum artifact: b742bf9891 user: kmedcalf
2021-05-29
02:18 Reply: foreign key issue on deleate artifact: 9b2de402ff user: kmedcalf
2021-05-28
23:42 Edit reply: Bug of json_each if object has value field. artifact: 902b7b09df user: kmedcalf
23:41 Reply: Bug of json_each if object has value field. artifact: c88dadca20 user: kmedcalf
05:09 Reply: foreign key issue on deleate artifact: 3591a0cac2 user: kmedcalf
03:25 Reply: nested case statement not working artifact: 5560dd3768 user: kmedcalf
2021-05-27
23:36 Reply: nested case statement not working artifact: 7a49b2631e user: kmedcalf
17:55 Reply: Is there a way to optimize this UPDATE command to run faster? artifact: 72a1d04ea7 user: kmedcalf
10:28 Reply: Inconsistent output possibly due to affinity issue artifact: 8ae88cd0bc user: kmedcalf
01:33 Reply: index to help with selection and ordering artifact: 2981ef024d user: kmedcalf
2021-05-25
23:17 Edit reply: Inconsistent output possibly due to affinity issue artifact: 882a631175 user: kmedcalf
23:15 Reply: Inconsistent output possibly due to affinity issue artifact: 6d4606c7e4 user: kmedcalf
20:46 Reply: Inconsistent output possibly due to affinity issue artifact: ffa015ac07 user: kmedcalf
2021-05-24
05:30 Reply: short circuiting subqueries with `IN`? artifact: b606b3736a user: kmedcalf
00:30 Reply: Independent in-memory database per thread? artifact: 6aa65fb4c2 user: kmedcalf
2021-05-23
20:33 Edit reply: nested case statement not working artifact: 58d4ae77d2 user: kmedcalf
20:33 Reply: nested case statement not working artifact: b94071851a user: kmedcalf
20:23 Reply: short circuiting subqueries with `IN`? artifact: ba228d0af2 user: kmedcalf
20:13 Reply: short circuiting subqueries with `IN`? artifact: ed2d66f197 user: kmedcalf
20:00 Edit reply: short circuiting subqueries with `IN`? artifact: 8b093b0dcd user: kmedcalf
19:59 Edit reply: short circuiting subqueries with `IN`? artifact: 3f2f3c4298 user: kmedcalf
19:51 Edit reply: short circuiting subqueries with `IN`? artifact: 7e47eb65f9 user: kmedcalf
19:43 Reply: short circuiting subqueries with `IN`? artifact: a2fbda8fd2 user: kmedcalf
19:29 Reply: short circuiting subqueries with `IN`? artifact: 9581ff7a5a user: kmedcalf
17:16 Reply: sql parser error artifact: 006a53dbf1 user: kmedcalf
2021-05-22
17:01 Reply: Can I read(select) parallelly on the same connection in multi-threads? artifact: d6e6fac7a1 user: kmedcalf
16:28 Reply: How often sqlite flush to disk under NORMAL mode? artifact: 3c185ba715 user: kmedcalf
2021-05-21
08:22 Reply: How often sqlite flush to disk under NORMAL mode? artifact: 8445738c33 user: kmedcalf
2021-05-20
05:20 Reply: How to check if HAVE_USLEEP is activated? artifact: 6fcbc1c18d user: kmedcalf
2021-05-19
15:49 Edit reply: Feature request: expose additional state to identify left-open statements artifact: 3a2637cccc user: kmedcalf
15:47 Reply: Feature request: expose additional state to identify left-open statements artifact: 8f10be4b47 user: kmedcalf
2021-05-17
22:55 Reply: Window RAM Disk no better than local SSD? artifact: 25b09883f0 user: kmedcalf
19:57 Reply: Nearest-match join artifact: e90722f177 user: kmedcalf
19:13 Edit reply: Nearest-match join artifact: b6ed194641 user: kmedcalf
19:08 Edit reply: Nearest-match join artifact: c1255b2c54 user: kmedcalf
19:04 Edit reply: Nearest-match join artifact: 80f40393fa user: kmedcalf
18:51 Edit reply: Nearest-match join artifact: 7a40a1d69e user: kmedcalf
18:39 Edit reply: Nearest-match join artifact: d3e0628ac3 user: kmedcalf
18:34 Reply: Nearest-match join artifact: 53c0b254f1 user: kmedcalf
18:01 Edit reply: Nearest-match join artifact: 61008f60b6 user: kmedcalf
06:43 Reply: memory vs mmap artifact: e296da94ba user: kmedcalf
02:53 Reply: memory vs mmap artifact: 9eb30885eb user: kmedcalf
01:12 Reply: memory vs mmap artifact: 7eee1ce2e4 user: kmedcalf
2021-05-16
21:34 Reply: How to reset auto increment on DB browser artifact: b024cf15db user: kmedcalf
18:52 Reply: Feedback on writing a SQLite VFS for a distributed object store artifact: fe688bde49 user: kmedcalf
18:16 Edit reply: Nearest-match join artifact: a56291ed45 user: kmedcalf
18:05 Reply: Global PRAGMA data_version artifact: 51912e77b7 user: kmedcalf
17:52 Reply: Nearest-match join artifact: 7f37b22b52 user: kmedcalf
17:26 Reply: Nearest-match join artifact: 65a778b940 user: kmedcalf
03:20 Reply: Global PRAGMA data_version artifact: 8e90cb3c80 user: kmedcalf
01:43 Edit reply: Global PRAGMA data_version artifact: 76f1eb7475 user: kmedcalf
01:41 Edit reply: Global PRAGMA data_version artifact: f81cda753c user: kmedcalf
01:40 Reply: Global PRAGMA data_version artifact: ff1ea94534 user: kmedcalf
2021-05-13
19:42 Reply: Nothing for several days from the forum artifact: efc5830784 user: kmedcalf
13:35 Reply: Fast way to insert rows in SQLite artifact: d32ab102c4 user: kmedcalf
13:17 Reply: What is the recommended way to update multiple columns from a single select? artifact: 7533a14610 user: kmedcalf
2021-05-12
00:29 Reply: Cleaning up after SQLite artifact: 78d03db70e user: kmedcalf
2021-05-11
06:41 Edit reply: Add into date in sqlite artifact: 8be44e9bce user: kmedcalf
06:40 Reply: Add into date in sqlite artifact: 1c90efc2c4 user: kmedcalf
2021-05-09
19:15 Reply: Statement that fires trigger is not executed when the trigger causes an error artifact: a5cfd84dd7 user: kmedcalf
2021-05-07
04:56 Reply: Recursive query to find the shortest path artifact: 50dfc41ac8 user: kmedcalf
2021-05-06
23:45 Reply: Foreign key that is never enforced? artifact: a4909c0b63 user: kmedcalf
23:21 Reply: Foreign key that is never enforced? artifact: 1b5b112f13 user: kmedcalf
07:19 Edit reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 5e8ba03d0e user: kmedcalf
06:56 Reply: Including decimal.c in compiled binary and enabling by default artifact: 4738436891 user: kmedcalf
06:34 Reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 6c704bdb4d user: kmedcalf
2021-05-05
05:50 Reply: Columns metadata is invalit for RETURNING clause artifact: 47b5abadc1 user: kmedcalf
03:31 Edit reply: Including decimal.c in compiled binary and enabling by default artifact: 1e87626b93 user: kmedcalf
03:29 Reply: Including decimal.c in compiled binary and enabling by default artifact: 80156d1e04 user: kmedcalf
03:26 Reply: User Defined Functions artifact: 400562ef40 user: kmedcalf
03:24 Reply: User Defined Functions artifact: 28c335ff41 user: kmedcalf
2021-05-04
17:47 Reply: User Defined Functions artifact: a50b7c8474 user: kmedcalf
17:39 Reply: User Defined Functions artifact: 7fd14b907d user: kmedcalf
06:47 Reply: cli: .mode insert - use current table name artifact: 680dae1d1a user: kmedcalf
05:24 Reply: Including decimal.c in compiled binary and enabling by default artifact: 49333ac211 user: kmedcalf
2021-05-03
19:39 Reply: cli: .mode insert - use current table name artifact: 66231ac0e2 user: kmedcalf
19:23 Reply: New type of transaction (or a new behavior for DEFERRED transactions) artifact: d16bff50ff user: kmedcalf
19:13 Reply: New type of transaction (or a new behavior for DEFERRED transactions) artifact: 434435c1cc user: kmedcalf
17:44 Reply: Setting temp_store_directory on Windows in future proof way artifact: cd6b69fd36 user: kmedcalf
17:17 Edit reply: Database is locked when "upgrading" from read to write artifact: ceb2ebdd13 user: kmedcalf
17:17 Reply: Database is locked when "upgrading" from read to write artifact: 1db18a0bed user: kmedcalf
17:03 Reply: Database is locked when "upgrading" from read to write artifact: 02440085bd user: kmedcalf
02:30 Reply: Recursive query to find the shortest path artifact: 845ed93705 user: kmedcalf
02:15 Reply: Database is locked when "upgrading" from read to write artifact: 4253fbbecd user: kmedcalf
02:10 Reply: Database is locked when "upgrading" from read to write artifact: 082ef04876 user: kmedcalf
2021-05-02
19:36 Reply: Setting temp_store_directory on Windows in future proof way artifact: f96ab2dab2 user: kmedcalf
07:54 Reply: Setting temp_store_directory on Windows in future proof way artifact: 2cdd0c12bb user: kmedcalf
04:37 Reply: "Office Space"... I'm losing all those pennies artifact: d8c5916ad5 user: kmedcalf
02:27 Reply: "Office Space"... I'm losing all those pennies artifact: 0e203a8c04 user: kmedcalf
02:19 Reply: "Office Space"... I'm losing all those pennies artifact: a1a054be3a user: kmedcalf
2021-05-01
23:34 Reply: Recursive query to find the shortest path artifact: 2e18f2b1cc user: kmedcalf
23:17 Reply: how to collate in a union and noaccent artifact: 214e1a95c1 user: kmedcalf
01:25 Reply: SQLite database in space? artifact: 7728edc880 user: kmedcalf
Previous month ↓