SQLite Forum

Timeline
Login

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

87 most recent events by user kmedcalf occurring on or after 2021-07-07 17:13:24.

2021-08-04
20:12 Reply: Calculating Trip Duration in Minutes? (artifact: 9257ea9118 user: kmedcalf)
19:59 Reply: C api sqlite3_db_readonly returns -1 (artifact: 95cef488df user: kmedcalf)
19:51 Reply: LEFT JOIN Misunderstanding (artifact: 4b1f391de2 user: kmedcalf)
2021-08-03
22:05 Post: Rename Column structure elements bug (artifact: 3aebfc2599 user: kmedcalf)
2021-08-02
21:09 Reply: null character sorts greater than 0x7f and less than 0x80 (artifact: fc0cd3784f user: kmedcalf)
20:16 Reply: null character sorts greater than 0x7f and less than 0x80 (artifact: 7fb3603f8b user: kmedcalf)
2021-07-31
19:41 Reply: Round function returning -0.0 (artifact: b1e28fe7e9 user: kmedcalf)
2021-07-30
22:00 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. (artifact: e52d40b4ac user: kmedcalf)
19:28 Reply: AUTOINCREMENT by value (artifact: 5f4b0bc34d user: kmedcalf)
19:22 Reply: Round function returning -0.0 (artifact: 60a8418801 user: kmedcalf)
19:21 Edit: (Deleted) (artifact: b98e8b8d9b user: kmedcalf)
19:20 Post: (Deleted) (artifact: b4c1d18d6f user: kmedcalf)
2021-07-26
01:06 Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause (artifact: 286f1523f5 user: kmedcalf)
00:14 Reply: sqlite3_carray_bind and constness (artifact: 6385fc7d53 user: kmedcalf)
2021-07-25
04:00 Reply: Can SQLite be used with AWS Elastic File System (EFS)? (artifact: a1de1eadc4 user: kmedcalf)
03:51 Reply: Random crash doing SELECT (artifact: f7bd30fd82 user: kmedcalf)
2021-07-23
17:13 Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause (artifact: 93a759ecd6 user: kmedcalf)
2021-07-22
20:35 Reply: operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors (artifact: 5f7ca077a7 user: kmedcalf)
18:50 Reply: operators IS TRUE and IS FALSE missing from diagrams and table plus possible evaluation errors (artifact: 41b8296fbb user: kmedcalf)
2021-07-20
22:34 Reply: Calculating duration in ISO8601 timestamp (artifact: ec40738a07 user: kmedcalf)
22:27 Reply: Calculating duration in ISO8601 timestamp (artifact: 16077b26ad user: kmedcalf)
21:55 Reply: Calculating duration in ISO8601 timestamp (artifact: 2774fbe354 user: kmedcalf)
19:57 Reply: Clear shared memory DB and backup problem (artifact: 2e0a80011e user: kmedcalf)
2021-07-19
22:00 Reply: Different comparison results in WHERE and SELECT clauses (artifact: 1b050e6251 user: kmedcalf)
20:05 Reply: Unexpected return from the NULL column (artifact: 7823fbd6e6 user: kmedcalf)
18:58 Edit reply: Unexpected return from the NULL column (artifact: a46c91af8c user: kmedcalf)
18:56 Reply: Unexpected return from the NULL column (artifact: 48cc1c7c6b user: kmedcalf)
18:19 Reply: LIKE optimization - limitation to string literals (artifact: 5eed38ae42 user: kmedcalf)
2021-07-18
23:11 Reply: LIKE optimization - limitation to string literals (artifact: 5e068b8c49 user: kmedcalf)
22:56 Reply: LIKE optimization - limitation to string literals (artifact: 8986c8ea97 user: kmedcalf)
20:49 Reply: Inserting One Billion Rows in SQLite Under A Minute (artifact: b31eff149e user: kmedcalf)
20:38 Reply: Does the column order in an insert statement impact the insert speed? (artifact: 28c2401f3c user: kmedcalf)
20:21 Reply: Tips for getting SQLite under Python to perform better with more RAM? (artifact: 94128a21c8 user: kmedcalf)
20:08 Reply: Tips for getting SQLite under Python to perform better with more RAM? (artifact: 02f7bda329 user: kmedcalf)
00:41 Edit reply: Tips for getting SQLite under Python to perform better with more RAM? (artifact: 550045447f user: kmedcalf)
00:23 Reply: Tips for getting SQLite under Python to perform better with more RAM? (artifact: 44e29996b7 user: kmedcalf)
2021-07-17
23:41 Edit reply: ORDER BY not ordering with the correct result (artifact: aa0ebe26ed user: kmedcalf)
23:39 Reply: ORDER BY not ordering with the correct result (artifact: 5c3f79cffa user: kmedcalf)
23:25 Reply: (Deleted) (artifact: 9d6c41b5fa user: kmedcalf)
23:09 Reply: (Deleted) (artifact: 78d0c6a2a3 user: kmedcalf)
22:52 Reply: ORDER BY not ordering with the correct result (artifact: 113c5d7b16 user: kmedcalf)
22:29 Reply: (Deleted) (artifact: c08eb1e306 user: kmedcalf)
22:25 Reply: (Deleted) (artifact: a956b84d82 user: kmedcalf)
22:20 Reply: Tips for getting SQLite under Python to perform better with more RAM? (artifact: 219a431b5d user: kmedcalf)
21:44 Reply: (Deleted) (artifact: 23fc511d83 user: kmedcalf)
21:38 Reply: ORDER BY not ordering with the correct result (artifact: b02e7f161a user: kmedcalf)
2021-07-13
00:38 Reply: CHECK and ON CONFLICT (artifact: ec02265fb3 user: kmedcalf)
00:27 Reply: What join is needed for non-similar data? (artifact: 7459a2b393 user: kmedcalf)
2021-07-12
23:41 Edit reply: How much would you trust a page-level checksum ? (artifact: fc577eb803 user: kmedcalf)
23:36 Reply: How much would you trust a page-level checksum ? (artifact: 1468cbc367 user: kmedcalf)
22:14 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 4ba5fe1656 user: kmedcalf)
21:55 Edit reply: How much would you trust a page-level checksum ? (artifact: be9a5dad32 user: kmedcalf)
21:53 Reply: How much would you trust a page-level checksum ? (artifact: ec10000b20 user: kmedcalf)
2021-07-11
22:25 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 499f52aa70 user: kmedcalf)
22:22 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 8f99ed3223 user: kmedcalf)
22:05 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 764065ab63 user: kmedcalf)
22:01 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 53216b2928 user: kmedcalf)
20:53 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 50fc0d0a3d user: kmedcalf)
20:40 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 1c2fbbfae9 user: kmedcalf)
20:38 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: c2bae8c59b user: kmedcalf)
20:36 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: f24446aa83 user: kmedcalf)
20:24 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: 63ac2b56d2 user: kmedcalf)
19:50 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: c9da49bb23 user: kmedcalf)
19:38 Edit reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: b23c3d34a0 user: kmedcalf)
19:36 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: bcfaddd2d3 user: kmedcalf)
18:43 Reply: is it possible to update bunch of records in reverse order to avoid unique constrain violation (artifact: d53b0b1412 user: kmedcalf)
2021-07-10
18:05 Reply: Can this SQL be simplified? (artifact: 3faafc8a11 user: kmedcalf)
18:04 Reply: Can this SQL be simplified? (artifact: bf0829e919 user: kmedcalf)
16:55 Delete reply: Why can you write triggers using functions from extensions? How does that work? (artifact: 5ec4cab66a user: kmedcalf)
16:52 Reply: Why can you write triggers using functions from extensions? How does that work? (artifact: 8f2b52a006 user: kmedcalf)
2021-07-09
22:05 Reply: How to handle collation version changes (artifact: 5317344555 user: kmedcalf)
21:24 Reply: Linkage #defines are unused (artifact: 7bc94de9ec user: kmedcalf)
09:09 Reply: Deleted rows not in FreeList (artifact: 208177b00a user: kmedcalf)
07:28 Reply: Gimme my options! a feature to be (artifact: bd318ecf72 user: kmedcalf)
2021-07-08
18:17 Reply: How to detect invalid trigger w/o actually running it? (artifact: 8fca601281 user: kmedcalf)
17:51 Reply: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' (artifact: 8982cb386b user: kmedcalf)
05:11 Reply: Linkage #defines are unused (artifact: 67b56fb72d user: kmedcalf)
05:00 Edit reply: Linkage #defines are unused (artifact: 7ac9885b2b user: kmedcalf)
04:59 Reply: Linkage #defines are unused (artifact: e4eac3c051 user: kmedcalf)
04:46 Edit reply: Help needed to return the right math results in sql query (artifact: f75c564d2d user: kmedcalf)
04:46 Reply: Help needed to return the right math results in sql query (artifact: dbde2432c0 user: kmedcalf)
04:37 Reply: How to handle collation version changes (artifact: 0db41d1f45 user: kmedcalf)
00:02 Reply: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' (artifact: 21e07c3172 user: kmedcalf)
2021-07-07
23:02 Reply: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' (artifact: 85e0bc470e user: kmedcalf)
19:36 Reply: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' (artifact: 1f6bcaaeb5 user: kmedcalf)
19:21 Post: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' (artifact: cef65da4ad user: kmedcalf)
17:13 Reply: How ddo I specify options with MSVC (artifact: 13e3b04e02 user: kmedcalf)