SQLite Forum

Timeline
Login

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

50 events by user kmedcalf occurring around 2021-04-11 20:01:54.

2021-04-17
03:10 Reply: SQL query help for between times and grouping times artifact: 65c40f606e user: kmedcalf
03:05 Reply: SQL query help for between times and grouping times artifact: a525888ce2 user: kmedcalf
01:55 Reply: SQL query help for between times and grouping times artifact: 7084c702cf user: kmedcalf
2021-04-16
19:14 Edit reply: Reporting vulnerabilities artifact: 6bdea5075e user: kmedcalf
19:12 Reply: Reporting vulnerabilities artifact: 1fe1a2b1c1 user: kmedcalf
2021-04-15
08:54 Reply: sql error:INSERT INTO tbl_des SELECT v1,v2.. FROM tbl_src on conflict(vehicle_id,begin_time) do nothing artifact: e92d9c7b66 user: kmedcalf
02:17 Reply: bug:update from virtual table (geopoly),and no return received artifact: a1788f41e1 user: kmedcalf
01:39 Reply: Pragma compile_options does not show some options artifact: 188cfec077 user: kmedcalf
2021-04-14
18:03 Reply: Pragma compile_options does not show some options artifact: 2b1cf8d7bd user: kmedcalf
17:43 Reply: bug:update from virtual table (geopoly),and no return received artifact: 2652003d2a user: kmedcalf
17:25 Edit reply: Select of text that matches scientific notation format automatically converted to number artifact: 5140b9b103 user: kmedcalf
17:21 Reply: Select of text that matches scientific notation format automatically converted to number artifact: e8d951003b user: kmedcalf
17:07 Reply: suggest:for geopoly,advice to add primary key like rtree artifact: a2f9cfdebf user: kmedcalf
2021-04-13
20:53 Reply: Select of text that matches scientific notation format automatically converted to number artifact: a3f116d2d8 user: kmedcalf
19:09 Reply: how DISTINCT remove the duplicate rows? artifact: 128bf07196 user: kmedcalf
18:58 Reply: Pragma compile_options does not show some options artifact: f587a007f3 user: kmedcalf
18:41 Reply: Select of text that matches scientific notation format automatically converted to number artifact: 2be0240464 user: kmedcalf
18:29 Reply: how DISTINCT remove the duplicate rows? artifact: 15523825c1 user: kmedcalf
18:27 Reply: how DISTINCT remove the duplicate rows? artifact: 1a0a47cb17 user: kmedcalf
18:08 Edit reply: Select of text that matches scientific notation format automatically converted to number artifact: c0241f21ed user: kmedcalf
18:06 Reply: Select of text that matches scientific notation format automatically converted to number artifact: 064fc53aeb user: kmedcalf
06:49 Reply: how to do arithmetic calculations on real/decimal/double in sqlite artifact: c97029eadf user: kmedcalf
2021-04-11
22:37 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 79c46c7271 user: kmedcalf
22:16 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: cd00613c26 user: kmedcalf
20:01 Edit reply: How to get the last row_id in a table without inserting anything artifact: 37b33c0d4e user: kmedcalf
20:00 Reply: How to get the last row_id in a table without inserting anything artifact: 9e764cef2a user: kmedcalf
19:54 Reply: How to get the last row_id in a table without inserting anything artifact: 7199bb666c user: kmedcalf
2021-04-10
20:25 Reply: meaning of "GROUP BY CONSTANT" artifact: 90a5774115 user: kmedcalf
05:42 Reply: meaning of "GROUP BY CONSTANT" artifact: 1979a3cfb1 user: kmedcalf
01:30 Reply: group_concat with distinct and custom seperator artifact: 221c2926f5 user: kmedcalf
01:16 Reply: meaning of "GROUP BY CONSTANT" artifact: f8460474c4 user: kmedcalf
2021-04-09
19:16 Reply: impact of cache_size artifact: d7b2a32bfd user: kmedcalf
18:03 Reply: meaning of "GROUP BY CONSTANT" artifact: 189a62e695 user: kmedcalf
2021-04-08
20:02 Reply: impact of cache_size artifact: 8c519c5a89 user: kmedcalf
18:29 Reply: misuse not detected artifact: e65a82f871 user: kmedcalf
18:23 Edit reply: misuse not detected artifact: 3cff7a2806 user: kmedcalf
18:11 Reply: misuse not detected artifact: e18f1eff37 user: kmedcalf
2021-04-07
23:29 Reply: impact of cache_size artifact: ea98e4cb08 user: kmedcalf
05:18 Reply: Please avoid all use of the "LL" suffix for long-long integer literals artifact: 9ba1033f71 user: kmedcalf
04:57 Reply: open db in read only; explicitly store diff as WAL ? artifact: 0e6f5b81f1 user: kmedcalf
04:51 Reply: open db in read only; explicitly store diff as WAL ? artifact: 3cff1d4422 user: kmedcalf
03:58 Edit reply: Error with upsert and trigger WHEN clause? artifact: 1fbd7715ba user: kmedcalf
03:57 Reply: Error with upsert and trigger WHEN clause? artifact: 66d8f21fd1 user: kmedcalf
03:52 Reply: Error with upsert and trigger WHEN clause? artifact: c3ff89d18b user: kmedcalf
03:43 Reply: Error with upsert and trigger WHEN clause? artifact: 32b714eeec user: kmedcalf
01:34 Edit reply: Growing WAL-File artifact: 72703ef8bd user: kmedcalf
01:30 Edit reply: Growing WAL-File artifact: 7ffd82d23d user: kmedcalf
01:25 Reply: Growing WAL-File artifact: 406988435d user: kmedcalf
00:30 Edit reply: open db in read only; explicitly store diff as WAL ? artifact: 38caef7f9c user: kmedcalf
00:29 Reply: open db in read only; explicitly store diff as WAL ? artifact: 46bb5762da user: kmedcalf