Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
188 events by user kmedcalf occurring around 2020-05-03 19:48:26.
2020-06-05
| ||
07:22 | • Reply: index question artifact: c960b43378 user: kmedcalf | |
06:58 | • Edit reply: How to not to overwrite a row if the key exists? artifact: 3d316d12af user: kmedcalf | |
06:53 | • Reply: How to not to overwrite a row if the key exists? artifact: bea0ac6bbf user: kmedcalf | |
06:26 | • Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 869e4689ba user: kmedcalf | |
03:38 | • Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 59c616d545 user: kmedcalf | |
03:36 | • Reply: How to not to overwrite a row if the key exists? artifact: 200b5af38f user: kmedcalf | |
2020-06-04
| ||
23:38 | • Reply: Non primary key alias to rowid artifact: f6c90dc3f4 user: kmedcalf | |
23:32 | • Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 3beed2e7a2 user: kmedcalf | |
23:26 | • Reply: select in order artifact: a426b97b30 user: kmedcalf | |
15:32 | • Edit reply: Non primary key alias to rowid artifact: 2e3666f630 user: kmedcalf | |
15:23 | • Reply: Non primary key alias to rowid artifact: 79428a8551 user: kmedcalf | |
14:34 | • Edit reply: Non primary key alias to rowid artifact: 9ba9ab9c7d user: kmedcalf | |
14:28 | • Reply: Non primary key alias to rowid artifact: 05de6b422d user: kmedcalf | |
14:13 | • Reply: Problems related to writing following queries can someone write all these queries? artifact: f497bd1a01 user: kmedcalf | |
14:09 | • Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: a5746fb174 user: kmedcalf | |
2020-06-02
| ||
23:54 | • Reply: Feature Request: pragma to curb bad column expectations artifact: 00075f7eb9 user: kmedcalf | |
03:24 | • Reply: Question about aliases on SELECT artifact: 26a82df9bc user: kmedcalf | |
2020-06-01
| ||
18:45 | • Reply: Are Views just stored SQL Strings or something more? artifact: f4e1c09069 user: kmedcalf | |
17:58 | • Reply: Are Views just stored SQL Strings or something more? artifact: d101ea0db1 user: kmedcalf | |
2020-05-31
| ||
05:31 | • Edit reply: Database Schema Changed Error artifact: e2b56e0eee user: kmedcalf | |
05:26 | • Reply: Database Schema Changed Error artifact: 6af0d63be1 user: kmedcalf | |
05:15 | • Reply: warning: function may return address of local variable -Wreturn-local-addr artifact: e44657f546 user: kmedcalf | |
2020-05-30
| ||
10:36 | • Edit reply: Confused about blobs artifact: 698b00b35c user: kmedcalf | |
10:34 | • Edit reply: Confused about blobs artifact: cfbfcf47f5 user: kmedcalf | |
10:33 | • Reply: Confused about blobs artifact: 6970443096 user: kmedcalf | |
10:16 | • Reply: Confused about blobs artifact: 41e3a253be user: kmedcalf | |
2020-05-29
| ||
17:59 | • Reply: SQLite turns 20 artifact: f0553ac256 user: kmedcalf | |
2020-05-27
| ||
10:27 | • Reply: deterministic functions behave differently in version 3.32.1 with python3 artifact: 52d80bf6da user: kmedcalf | |
2020-05-26
| ||
22:41 | • Reply: Best way to observe database operations artifact: 2d085b1de5 user: kmedcalf | |
11:06 | • Reply: How to set the column separator for the CSV extension in the CLI? artifact: 403a79bc57 user: kmedcalf | |
2020-05-25
| ||
22:39 | • Reply: Date/time formatting artifact: 038712da79 user: kmedcalf | |
22:02 | • Edit reply: Date/time formatting artifact: c282dd7e50 user: kmedcalf | |
21:59 | • Edit reply: Date/time formatting artifact: 0630198f4e user: kmedcalf | |
21:58 | • Reply: Date/time formatting artifact: 59f7b0210a user: kmedcalf | |
12:05 | • Edit reply: Bug when converting string to boolean? artifact: fe6c972903 user: kmedcalf | |
12:00 | • Edit reply: Bug when converting string to boolean? artifact: c03d6db525 user: kmedcalf | |
11:55 | • Reply: Bug when converting string to boolean? artifact: 8db8abf456 user: kmedcalf | |
2020-05-24
| ||
22:12 | • Reply: Bug when converting string to boolean? artifact: 48acc813b1 user: kmedcalf | |
10:14 | • Reply: How to set the column separator for the CSV extension in the CLI? artifact: 08a728ff22 user: kmedcalf | |
00:52 | • Edit reply: ORDER BY not working for a specific DB/table artifact: 9d7faf3590 user: kmedcalf | |
00:51 | • Reply: ORDER BY not working for a specific DB/table artifact: fd3f62f3ac user: kmedcalf | |
2020-05-23
| ||
12:44 | • Reply: ORDER BY not working for a specific DB/table artifact: 5e3775020a user: kmedcalf | |
2020-05-22
| ||
23:38 | • Reply: ORDER BY not working for a specific DB/table artifact: cc1cfd0e53 user: kmedcalf | |
21:33 | • Reply: ORDER BY not working for a specific DB/table artifact: a374c60f4a user: kmedcalf | |
20:30 | • Reply: ORDER BY not working for a specific DB/table artifact: 1197d2a524 user: kmedcalf | |
09:40 | • Reply: ORDER BY not working for a specific DB/table artifact: 219c470be5 user: kmedcalf | |
05:14 | • Reply: Temporary data when running out of memory artifact: e32a6dfba4 user: kmedcalf | |
04:51 | • Reply: ORDER BY not working for a specific DB/table artifact: b9f335807c user: kmedcalf | |
04:32 | • Reply: ORDER BY not working for a specific DB/table artifact: e023e710be user: kmedcalf | |
2020-05-21
| ||
21:02 | • Reply: ORDER BY not working for a specific DB/table artifact: d16c5fa6cb user: kmedcalf | |
05:13 | • Reply: ORDER BY not working for a specific DB/table artifact: 59c19f0b4b user: kmedcalf | |
2020-05-17
| ||
18:26 | • Reply: Jumbled image tiles? artifact: 88722e14d7 user: kmedcalf | |
2020-05-16
| ||
09:32 | • Reply: change in round() function artifact: 6de13bd987 user: kmedcalf | |
00:07 | • Edit reply: change in round() function artifact: 80fb6f9785 user: kmedcalf | |
00:06 | • Reply: change in round() function artifact: 1efbeb20ca user: kmedcalf | |
2020-05-15
| ||
18:04 | • Reply: Why is utf8 IN char* but utf8 OUT is unsigned char* artifact: 65bc906727 user: kmedcalf | |
17:52 | • Reply: change in round() function artifact: 736195c9fc user: kmedcalf | |
2020-05-14
| ||
18:23 | • Reply: Can this simple query be optimized? artifact: 3cbb049eb3 user: kmedcalf | |
18:09 | • Reply: output in column mode is truncated artifact: f9bb0d5d24 user: kmedcalf | |
2020-05-13
| ||
23:34 | • Reply: Compiling Zipfile.c artifact: b6135f7f96 user: kmedcalf | |
23:06 | • Reply: Can this simple query be optimized? artifact: 6e6d9fcfc7 user: kmedcalf | |
18:36 | • Reply: Mono.Data.Sqlite In-Memory Shared Database artifact: 22523f09e5 user: kmedcalf | |
01:32 | • Reply: Can this simple query be optimized? artifact: d1748ffe25 user: kmedcalf | |
01:27 | • Reply: Can this simple query be optimized? artifact: 642d489968 user: kmedcalf | |
2020-05-12
| ||
22:19 | • Reply: Can this simple query be optimized? artifact: 5879df2de9 user: kmedcalf | |
18:35 | • Reply: Thoughts on why this is not working? artifact: 22f9fed604 user: kmedcalf | |
18:12 | • Reply: Using sqlite3_load_extension on windows artifact: fdc8f657b3 user: kmedcalf | |
17:37 | • Edit reply: Using sqlite3_load_extension on windows artifact: cc9eba82f1 user: kmedcalf | |
17:35 | • Edit reply: Using sqlite3_load_extension on windows artifact: 81fb0fb951 user: kmedcalf | |
17:35 | • Reply: Using sqlite3_load_extension on windows artifact: 06cf40156b user: kmedcalf | |
2020-05-08
| ||
19:36 | • Reply: Help: Setting a column after finding first desired entry artifact: 4ef76046a3 user: kmedcalf | |
12:31 | • Reply: Using sqlite3_load_extension on windows artifact: 6eb7482a25 user: kmedcalf | |
2020-05-07
| ||
19:58 | • Reply: Using sqlite3_load_extension on windows artifact: f43f43fde6 user: kmedcalf | |
19:19 | • Reply: Create a trigger without a name, BUG? artifact: b89681a4d4 user: kmedcalf | |
18:23 | • Reply: Using sqlite3_load_extension on windows artifact: 5e6843dd51 user: kmedcalf | |
2020-05-06
| ||
22:11 | • Reply: Best way to handle unique column needs artifact: 57c04743e1 user: kmedcalf | |
22:07 | • Reply: Best way to handle unique column needs artifact: f1a32097f1 user: kmedcalf | |
17:12 | • Reply: Best way to handle unique column needs artifact: f03d82edcc user: kmedcalf | |
17:07 | • Reply: Best way to handle unique column needs artifact: 593af7061a user: kmedcalf | |
14:49 | • Reply: Best way to handle unique column needs artifact: 35f6675b3e user: kmedcalf | |
14:43 | • Reply: select between two dates artifact: 2cdde5bd06 user: kmedcalf | |
2020-05-05
| ||
20:12 | • Edit reply: Is write permission required for read-only connections on a WAL database? artifact: d906af6d7a user: kmedcalf | |
19:57 | • Reply: Is write permission required for read-only connections on a WAL database? artifact: 28cf852219 user: kmedcalf | |
18:26 | • Reply: Is write permission required for read-only connections on a WAL database? artifact: 3ea7b7a417 user: kmedcalf | |
18:00 | • Reply: Is write permission required for read-only connections on a WAL database? artifact: 030179b7ca user: kmedcalf | |
17:56 | • Reply: Is write permission required for read-only connections on a WAL database? artifact: e05ffc39db user: kmedcalf | |
2020-05-04
| ||
21:39 | • Edit reply: DB read fails while doing parallel bulk DB updates artifact: ac418b38b2 user: kmedcalf | |
21:39 | • Reply: DB read fails while doing parallel bulk DB updates artifact: b93fcd7170 user: kmedcalf | |
17:09 | • Reply: Week numbers in queries artifact: 66a9d50397 user: kmedcalf | |
16:45 | • Reply: Feature request: Dynamically execute SQL from shell artifact: 211575fc46 user: kmedcalf | |
16:30 | • Reply: Feature request: Dynamically execute SQL from shell artifact: 4647e9dba7 user: kmedcalf | |
16:16 | • Reply: Week numbers in queries artifact: f393976a00 user: kmedcalf | |
15:45 | • Reply: PRAGMA temp_store_directory artifact: 18d6feedb8 user: kmedcalf | |
2020-05-03
| ||
19:48 | • Reply: DB read fails while doing parallel bulk DB updates artifact: 516de21570 user: kmedcalf | |
19:43 | • Reply: Feature request: Dynamically execute SQL from shell artifact: a76824c56d user: kmedcalf | |
19:38 | • Reply: PRAGMA INTEGRITY_CHECK takes very long artifact: 476ccb359a user: kmedcalf | |
19:31 | • Reply: PRAGMA temp_store_directory artifact: 1360782dad user: kmedcalf | |
19:08 | • Edit reply: DB read fails while doing parallel bulk DB updates artifact: fb5b96f377 user: kmedcalf | |
19:07 | • Reply: DB read fails while doing parallel bulk DB updates artifact: ee71ce1977 user: kmedcalf | |
18:35 | • Reply: PRAGMA temp_store_directory artifact: ecacee0ad7 user: kmedcalf | |
15:32 | • Edit reply: PRAGMA temp_store_directory artifact: fcf33a0e70 user: kmedcalf | |
15:18 | • Reply: PRAGMA temp_store_directory artifact: 384310fb72 user: kmedcalf | |
15:08 | • Edit reply: Week numbers in queries artifact: f92c559ce4 user: kmedcalf | |
15:04 | • Reply: Week numbers in queries artifact: 711fc665c1 user: kmedcalf | |
14:52 | • Reply: PRAGMA temp_store_directory artifact: 5e7502d39f user: kmedcalf | |
2020-05-02
| ||
13:38 | • Reply: Restart a counter in a table based on a another field in the same table artifact: 7f172d5c8e user: kmedcalf | |
13:22 | • Reply: Restart a counter in a table based on a another field in the same table artifact: 8c37b1b62a user: kmedcalf | |
13:10 | • Reply: Ambiguous 'ambiguous error', is it normal or bug? artifact: f96b597c9d user: kmedcalf | |
2020-05-01
| ||
09:33 | • Reply: Ambiguous 'ambiguous error', is it normal or bug? artifact: 54e5fb3874 user: kmedcalf | |
09:11 | • Reply: how to force python to use recent sqlite3 version artifact: 4691e7792b user: kmedcalf | |
2020-04-29
| ||
15:41 | • Reply: how to backup a locked DB artifact: 89e92a3822 user: kmedcalf | |
15:16 | • Reply: Problem with CTE followed by a delete artifact: 2b628873a8 user: kmedcalf | |
2020-04-28
| ||
18:56 | • Reply: WAL mode speed vs normal comparison artifact: c294a22f06 user: kmedcalf | |
16:12 | • Reply: Feature Request: support bulk value fetches artifact: 9f3664f854 user: kmedcalf | |
12:50 | • Reply: Problem with CTE followed by a delete artifact: c36ea840df user: kmedcalf | |
2020-04-26
| ||
12:08 | • Reply: Recursive TRIGGER stopping on reference to same table artifact: 78994cb84c user: kmedcalf | |
03:04 | • Edit reply: Integer becomes blob artifact: e42a30cf56 user: kmedcalf | |
03:02 | • Reply: Integer becomes blob artifact: d0e8abc723 user: kmedcalf | |
2020-04-24
| ||
22:14 | • Edit reply: Sqlite3 is multi-core multi-OS system artifact: be527149a3 user: kmedcalf | |
22:12 | • Reply: Sqlite3 is multi-core multi-OS system artifact: 2a0ec086e8 user: kmedcalf | |
22:02 | • Reply: Integer becomes blob artifact: 70861c223e user: kmedcalf | |
21:54 | • Reply: SQLite search with text vs numeric field artifact: c48ce2ef22 user: kmedcalf | |
21:40 | • Reply: infinite loop in the generated opcode caused by the inappropriate handling of crafted statement artifact: 8d45eb7bcb user: kmedcalf | |
2020-04-23
| ||
12:04 | • Edit reply: Feature request: extensions to UPDATE artifact: e181725165 user: kmedcalf | |
12:01 | • Edit reply: Feature request: extensions to UPDATE artifact: 46972c27af user: kmedcalf | |
11:47 | • Reply: Feature request: extensions to UPDATE artifact: 4d8b145c81 user: kmedcalf | |
11:30 | • Reply: create trigger artifact: 568369b11b user: kmedcalf | |
11:13 | • Reply: create trigger artifact: 65231ad838 user: kmedcalf | |
2020-04-22
| ||
21:24 | • Reply: Feature request: extensions to UPDATE artifact: 5175db4ef5 user: kmedcalf | |
21:04 | • Reply: create trigger artifact: 814e1284b5 user: kmedcalf | |
07:43 | • Reply: RENAME COLUMN incomplete documentation artifact: 55fe1821c1 user: kmedcalf | |
2020-04-21
| ||
16:14 | • Reply: Country-coding from Lat/Long, using GeoPoly and/or R-Tree artifact: a5d8b7b733 user: kmedcalf | |
15:04 | • Reply: Country-coding from Lat/Long, using GeoPoly and/or R-Tree artifact: cef68d511e user: kmedcalf | |
2020-04-20
| ||
15:19 | • Edit reply: CASE WHEN False THEN MyFunction() END calls MyFunction artifact: 5871d97ba7 user: kmedcalf | |
15:17 | • Reply: CASE WHEN False THEN MyFunction() END calls MyFunction artifact: e9ab341879 user: kmedcalf | |
02:24 | • Reply: Subqueries and "no such column" error on references to other tables artifact: 33cf3d7277 user: kmedcalf | |
01:32 | • Reply: Is there a non-trigger way to format data on INSERT/UPDATE? artifact: d32de43a40 user: kmedcalf | |
01:26 | • Reply: how to refuse write empty value artifact: 66056dda3b user: kmedcalf | |
01:22 | • Reply: how to refuse write empty value artifact: 14d17ac1ad user: kmedcalf | |
2020-04-19
| ||
17:48 | • Reply: how to refuse write empty value artifact: c217703e1d user: kmedcalf | |
17:42 | • Reply: Malwarebytes slows SQLite artifact: 4056f32683 user: kmedcalf | |
17:39 | • Reply: Select is S*L*O*W but not in Development artifact: 0c00e540cc user: kmedcalf | |
17:13 | • Reply: string literals, is there more than one escape? artifact: f4f564e7ee user: kmedcalf | |
2020-04-17
| ||
06:26 | • Reply: select in order artifact: d90c8c2fe1 user: kmedcalf | |
06:15 | • Reply: select in order artifact: 1e0e4b2f5d user: kmedcalf | |
2020-04-16
| ||
20:16 | • Reply: Help speeding up a query artifact: 985e37eee5 user: kmedcalf | |
19:46 | • Reply: SQL-Query is always empty artifact: 719102d523 user: kmedcalf | |
19:18 | • Reply: Help speeding up a query artifact: ceb50e6465 user: kmedcalf | |
17:25 | • Reply: SQL-Query is always empty artifact: e25a7955af user: kmedcalf | |
17:21 | • Reply: select in order artifact: 5f5858fa95 user: kmedcalf | |
15:57 | • Reply: select in order artifact: 7e917f04cd user: kmedcalf | |
14:03 | • Reply: Slow updates, many with exactly 1000ms? artifact: b83886491c user: kmedcalf | |
13:52 | • Reply: SQL-Query is always empty artifact: f7350db5ef user: kmedcalf | |
2020-04-15
| ||
12:21 | • Edit reply: length function for BLOB out of sync with documentation artifact: 6aa929f2f7 user: kmedcalf | |
12:20 | • Reply: length function for BLOB out of sync with documentation artifact: c676b9a79a user: kmedcalf | |
01:42 | • Edit reply: Method to delete all unreferenced rows from a parent table? artifact: 8e6e405e18 user: kmedcalf | |
01:38 | • Reply: Method to delete all unreferenced rows from a parent table? artifact: 8f3d459e33 user: kmedcalf | |
2020-04-14
| ||
21:18 | • Reply: Why is foreign key support based on the connection? artifact: f99d13712f user: kmedcalf | |
19:21 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: d4e9cf6b7c user: kmedcalf | |
19:17 | • Reply: Memory leak when calling sqlite3_exec() artifact: 7105d87f73 user: kmedcalf | |
05:30 | • Reply: Memory leak when calling sqlite3_exec() artifact: c0d8e04a98 user: kmedcalf | |
2020-04-13
| ||
11:31 | • Edit reply: How to use BLOB in C program artifact: 6d030d0f61 user: kmedcalf | |
11:30 | • Reply: How to use BLOB in C program artifact: 7d02bb3804 user: kmedcalf | |
2020-04-12
| ||
18:10 | • Edit reply: How can I compile the newest percentile.c? artifact: 5ed16629f5 user: kmedcalf | |
18:07 | • Edit reply: How can I compile the newest percentile.c? artifact: 24b1e148a8 user: kmedcalf | |
18:06 | • Reply: How can I compile the newest percentile.c? artifact: adf0616699 user: kmedcalf | |
18:03 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: 2d1169e04f user: kmedcalf | |
2020-04-11
| ||
17:24 | • Edit reply: length function for BLOB out of sync with documentation artifact: 4255ad6f19 user: kmedcalf | |
17:22 | • Reply: length function for BLOB out of sync with documentation artifact: 81268b3063 user: kmedcalf | |
15:40 | • Edit reply: length function for BLOB out of sync with documentation artifact: 454c5052bc user: kmedcalf | |
15:39 | • Edit reply: length function for BLOB out of sync with documentation artifact: a4bec63783 user: kmedcalf | |
15:38 | • Edit reply: length function for BLOB out of sync with documentation artifact: bc5a7275a9 user: kmedcalf | |
15:24 | • Reply: length function for BLOB out of sync with documentation artifact: e4cfa46a59 user: kmedcalf | |
08:18 | • Edit reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 6410d416a0 user: kmedcalf | |
08:14 | • Edit reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 09f8f525a9 user: kmedcalf | |
08:08 | • Reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 4d66f9c278 user: kmedcalf | |
07:47 | • Reply: Disk I/O error on cifs volume artifact: 2e04a610ca user: kmedcalf | |
2020-04-10
| ||
21:24 | • Reply: Disk I/O error on cifs volume artifact: 2cb9bebf7f user: kmedcalf | |
19:22 | • Reply: Disk I/O error on cifs volume artifact: ff7ad9abfb user: kmedcalf | |
18:49 | • Reply: Return boolean if item EXISTS in database artifact: ea2faf7b47 user: kmedcalf | |
2020-04-08
| ||
10:35 | • Reply: Please explain the error on insert artifact: 43812b8a92 user: kmedcalf | |
05:06 | • Reply: How to upgrade sqlite3 version artifact: 85710bca75 user: kmedcalf | |
05:01 | • Reply: Please explain the error on insert artifact: 4f9ba989f1 user: kmedcalf | |
2020-04-07
| ||
02:13 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: 9a049682f1 user: kmedcalf | |
2020-04-06
| ||
21:56 | • Reply: JOIN query behaves differently with/without trailing ON? artifact: c8f99ee0ba user: kmedcalf | |
19:26 | • Reply: shell's .load is pathSep picky artifact: aa60b7f05d user: kmedcalf | |
14:16 | • Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: d34937f246 user: kmedcalf | |
2020-04-05
| ||
17:17 | • Reply: 'no query solution' error artifact: e141d3b03f user: kmedcalf | |