SQLite Forum

Timeline
Login

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

50 events by user kmedcalf occurring around 2021-07-26 00:14:58.

2021-08-06
23:19 Reply: Select and count from 2 tables artifact: 7e6344d582 user: kmedcalf
23:12 Reply: Select and count from 2 tables artifact: 458e37f91b user: kmedcalf
22:48 Reply: Select and count from 2 tables artifact: 4a1b694688 user: kmedcalf
21:09 Reply: SQLite with NFS + cachefilesd artifact: f2d4ee372e user: kmedcalf
21:08 Reply: SQLite with NFS + cachefilesd artifact: 2e8394d4c1 user: kmedcalf
20:57 Reply: SQLite3.exe - How to use arguments AND remain in interactive mode? artifact: bef8832218 user: kmedcalf
2021-08-05
20:49 Reply: LEFT JOIN Misunderstanding artifact: ae7d11c955 user: kmedcalf
00:56 Reply: LEFT JOIN Misunderstanding artifact: 844d91cdd8 user: kmedcalf
2021-08-04
23:02 Reply: Calculating Trip Duration in Minutes? artifact: d2171f7efc user: kmedcalf
22:47 Reply: LEFT JOIN Misunderstanding artifact: dc4bbc4390 user: kmedcalf
22:28 Reply: Calculating Trip Duration in Minutes? artifact: 58e34c0ed0 user: kmedcalf
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