Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
133 events for the month beginning 2021-04-01 by user kmedcalf
Following month ↑|
2021-04-30
| ||
| 05:27 | • Reply: Where is the temporary database file stored? artifact: 61124efd0c user: kmedcalf | |
| 05:15 | • Edit reply: Where is the temporary database file stored? artifact: 2e93357a27 user: kmedcalf | |
| 05:09 | • Reply: Where is the temporary database file stored? artifact: 15cf96fdec user: kmedcalf | |
|
2021-04-29
| ||
| 17:44 | • Reply: WAL files deleted artifact: acb9609c43 user: kmedcalf | |
| 04:12 | • Reply: Help, reading sqlite3_blob_open() artifact: 19653eea3e user: kmedcalf | |
|
2021-04-28
| ||
| 12:40 | • Edit reply: Database is locked when "upgrading" from read to write artifact: dca7f2f1fc user: kmedcalf | |
| 12:32 | • Reply: Database is locked when "upgrading" from read to write artifact: 6e85b59f15 user: kmedcalf | |
| 12:30 | • Edit reply: Database is locked when "upgrading" from read to write artifact: b9ff09b2d4 user: kmedcalf | |
| 12:25 | • Reply: Database is locked when "upgrading" from read to write artifact: c3cb9524be user: kmedcalf | |
| 12:15 | • Reply: Database is locked when "upgrading" from read to write artifact: e51c0e031c user: kmedcalf | |
|
2021-04-27
| ||
| 22:40 | • Reply: Database is locked when "upgrading" from read to write artifact: bde839c27d user: kmedcalf | |
|
2021-04-25
| ||
| 20:22 | • Reply: How to convert to CTE artifact: be4e00339e user: kmedcalf | |
| 19:35 | • Reply: How to convert to CTE artifact: 8a3238875e user: kmedcalf | |
| 17:45 | • Reply: bug report : adding constant to GROUP BY leads to different output artifact: 9fd8fe958d user: kmedcalf | |
| 17:37 | • Reply: Backup via file system backup software artifact: 65c94f0cec user: kmedcalf | |
| 17:22 | • Reply: How to convert to CTE artifact: 5f2210c2d8 user: kmedcalf | |
| 07:15 | • Edit reply: How to convert to CTE artifact: 5bc8ed823f user: kmedcalf | |
| 07:10 | • Edit reply: How to convert to CTE artifact: 6d727c5e38 user: kmedcalf | |
| 07:09 | • Edit reply: How to convert to CTE artifact: eac7dae83f user: kmedcalf | |
| 04:46 | • Edit reply: How to convert to CTE artifact: 6147f5adc8 user: kmedcalf | |
| 04:39 | • Edit reply: How to convert to CTE artifact: 427b179b5d user: kmedcalf | |
| 04:28 | • Reply: How to convert to CTE artifact: 11d6641deb user: kmedcalf | |
| 01:42 | • Reply: Backup via file system backup software artifact: 35eefef49b user: kmedcalf | |
| 01:36 | • Reply: Backup via file system backup software artifact: 72e792cdac user: kmedcalf | |
|
2021-04-24
| ||
| 22:09 | • Reply: Sending output to a pipe artifact: 801ee0be99 user: kmedcalf | |
| 21:59 | • Reply: PROBLEM WITH TRANSACTION artifact: 87e58b3e1f user: kmedcalf | |
| 21:55 | • Reply: Different results in SELECT DISTINCT artifact: 6d8903632c user: kmedcalf | |
| 06:41 | • Reply: How to convert to CTE artifact: 5dc12daa39 user: kmedcalf | |
|
2021-04-23
| ||
| 23:52 | • Edit reply: How to convert to CTE artifact: c35ccbe517 user: kmedcalf | |
| 23:49 | • Reply: How to convert to CTE artifact: 9024d83761 user: kmedcalf | |
| 05:11 | • Reply: How to convert to CTE artifact: c8f9a59f56 user: kmedcalf | |
|
2021-04-22
| ||
| 23:13 | • Edit reply: How to convert to CTE artifact: ac7b767772 user: kmedcalf | |
| 22:54 | • Edit reply: How to convert to CTE artifact: 8f9aa20c01 user: kmedcalf | |
| 22:49 | • Reply: How to convert to CTE artifact: 8316acd06d user: kmedcalf | |
| 21:50 | • Reply: How to convert to CTE artifact: 18dcf85aed user: kmedcalf | |
| 21:34 | • Reply: How to convert to CTE artifact: a4510ab6e2 user: kmedcalf | |
| 21:10 | • Reply: How to convert to CTE artifact: 6794586fbd user: kmedcalf | |
| 20:30 | • Reply: How to convert to CTE artifact: a085d59c5b user: kmedcalf | |
| 18:32 | • Reply: Execute changes in Photoshop Elements artifact: 3983e96915 user: kmedcalf | |
|
2021-04-21
| ||
| 02:37 | • Edit reply: The NUMERIC data type? artifact: 6c939f8f70 user: kmedcalf | |
| 02:29 | • Edit reply: The NUMERIC data type? artifact: 44aca9a5a8 user: kmedcalf | |
| 02:29 | • Reply: The NUMERIC data type? artifact: 0e6ea27a93 user: kmedcalf | |
|
2021-04-20
| ||
| 18:48 | • Edit reply: Administrator SQLite artifact: 38714de5cc user: kmedcalf | |
| 18:46 | • Reply: Administrator SQLite artifact: a98b4918d5 user: kmedcalf | |
| 00:08 | • Edit reply: Clarification re parameters needed. artifact: 6a5b141ff6 user: kmedcalf | |
| 00:06 | • Reply: Clarification re parameters needed. artifact: 56503253f9 user: kmedcalf | |
|
2021-04-19
| ||
| 21:30 | • Reply: simple insert issue with 3.35.5 - .sqliterc issue? artifact: 1c18d39d3a user: kmedcalf | |
| 21:15 | • Reply: Administrator SQLite artifact: b5f3b3d3f4 user: kmedcalf | |
| 19:30 | • Reply: Administrator SQLite artifact: e63f84449a user: kmedcalf | |
| 19:26 | • Edit reply: Administrator SQLite artifact: 47cea6dbb3 user: kmedcalf | |
| 19:24 | • Reply: Administrator SQLite artifact: aa76c758f1 user: kmedcalf | |
| 19:02 | • Reply: Access strategy for a one-thread per connection http server artifact: 2cb8a16a50 user: kmedcalf | |
| 18:45 | • Reply: AVG with GROUP BY returns 0 artifact: 99cde188bc user: kmedcalf | |
| 08:39 | • Reply: AVG with GROUP BY returns 0 artifact: 761f8c7920 user: kmedcalf | |
| 08:35 | • Reply: AVG with GROUP BY returns 0 artifact: b81b42686d user: kmedcalf | |
| 08:28 | • Reply: Access strategy for a one-thread per connection http server artifact: 41683e615a user: kmedcalf | |
| 02:59 | • Reply: Access strategy for a one-thread per connection http server artifact: 04cb589c4a user: kmedcalf | |
|
2021-04-18
| ||
| 19:08 | • Reply: SQL query help for between times and grouping times artifact: 43aa3e377c user: kmedcalf | |
| 07:22 | • Reply: SQL query help for between times and grouping times artifact: 730292fd92 user: kmedcalf | |
|
2021-04-17
| ||
| 23:43 | • Reply: SQL query help for between times and grouping times artifact: 0723a15de3 user: kmedcalf | |
| 09:41 | • Reply: SQL query help for between times and grouping times artifact: e59ed71814 user: kmedcalf | |
| 08:23 | • Reply: SQL query help for between times and grouping times artifact: 3c2a7a3cee user: kmedcalf | |
| 03:17 | • Edit reply: SQL query help for between times and grouping times artifact: e6cd2814c4 user: kmedcalf | |
| 03:13 | • Edit reply: SQL query help for between times and grouping times artifact: 4c97cfd819 user: kmedcalf | |
| 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 | |
| 00:22 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 9a9647c2a8 user: kmedcalf | |
|
2021-04-06
| ||
| 03:53 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 8701859636 user: kmedcalf | |
|
2021-04-05
| ||
| 22:38 | • Reply: open db in read only; explicitly store diff as WAL ? artifact: 9a1fefe424 user: kmedcalf | |
| 18:22 | • Reply: SQLite3 command using select to CSV or terminal does not return all rows artifact: cf530c7880 user: kmedcalf | |
| 18:18 | • Reply: What indexes help Window Functions artifact: dc84d47231 user: kmedcalf | |
| 17:43 | • Reply: What indexes help Window Functions artifact: 50128245d9 user: kmedcalf | |
| 17:39 | • Reply: What indexes help Window Functions artifact: 4b4638544f user: kmedcalf | |
| 17:22 | • Reply: Command Line Shell set parameter as date artifact: 1464987882 user: kmedcalf | |
| 06:23 | • Edit reply: What indexes help Window Functions artifact: b167699823 user: kmedcalf | |
| 06:22 | • Reply: What indexes help Window Functions artifact: 2ccbf24ab4 user: kmedcalf | |
| 06:16 | • Reply: COUNT statement returns inconsistent values when used with UNION ALL artifact: eb2d5f8d55 user: kmedcalf | |
|
2021-04-03
| ||
| 23:27 | • Reply: Command Line Shell set parameter as date artifact: 7dc925fc87 user: kmedcalf | |
| 18:12 | • Reply: How to dump a table to a TSV file but escape characters properly artifact: 6c74cf7d40 user: kmedcalf | |
| 14:35 | • Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 72040cc6ec user: kmedcalf | |
| 14:25 | • Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 0045cf952d user: kmedcalf | |
| 14:19 | • Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: ac041041cf user: kmedcalf | |
| 13:48 | • Reply: Problem with single quotes Swift/MacOS artifact: ff3283bb27 user: kmedcalf | |
|
2021-04-01
| ||
| 19:59 | • Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: ce746bbb70 user: kmedcalf | |
| 00:49 | • Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: ae388a58be user: kmedcalf | |