SQLite Forum

Timeline
Login

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

50 forum posts by user kmedcalf occurring on or before 2022-01-11 00:53:45.

2022-01-11
00:53 Reply: RETURNING clause on prepared statement not behaving like un-prepared (artifact: 213fdeb83e user: kmedcalf)
00:41 Reply: RETURNING clause on prepared statement not behaving like un-prepared (artifact: e89b2d1c6f user: kmedcalf)
2022-01-10
22:13 Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 (artifact: c838b45f40 user: kmedcalf)
20:01 Edit reply: RETURNING clause on prepared statement not behaving like un-prepared (artifact: d16bbc5079 user: kmedcalf)
20:00 Edit reply: RETURNING clause on prepared statement not behaving like un-prepared (artifact: 8a244bb39a user: kmedcalf)
19:50 Reply: RETURNING clause on prepared statement not behaving like un-prepared (artifact: c9b7625483 user: kmedcalf)
2022-01-09
23:37 Edit reply: Is it possible to make -shm/-wal files permanent? (artifact: 57a6f67f56 user: kmedcalf)
23:36 Edit reply: Is it possible to make -shm/-wal files permanent? (artifact: 6282e0bcb8 user: kmedcalf)
21:15 Reply: Is it possible to make -shm/-wal files permanent? (artifact: 02e1cc7011 user: kmedcalf)
21:13 Reply: Is it possible to make -shm/-wal files permanent? (artifact: 0b15ce482e user: kmedcalf)
21:05 Reply: Is it possible to make -shm/-wal files permanent? (artifact: 66124eafc4 user: kmedcalf)
2022-01-08
22:22 Reply: recommendation for reclaiming the db when disk is full (artifact: 7a5a3f59db user: kmedcalf)
22:12 Reply: recommendation for reclaiming the db when disk is full (artifact: 1ce49485e4 user: kmedcalf)
21:34 Edit reply: recommendation for reclaiming the db when disk is full (artifact: 6710ba197c user: kmedcalf)
21:30 Reply: recommendation for reclaiming the db when disk is full (artifact: 2d5f34fc94 user: kmedcalf)
18:14 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS (artifact: b33241e94f user: kmedcalf)
00:59 Reply: Can a SQLite DB be accessed by another Computer? (artifact: a0a775c72e user: kmedcalf)
00:33 Reply: How do you determine if a row/column is holding a DATETIME value (artifact: bd235c0220 user: kmedcalf)
00:14 Reply: How do you determine if a row/column is holding a DATETIME value (artifact: d9d5940cae user: kmedcalf)
2022-01-07
20:27 Edit reply: Windows nanosecond file times to accurate presentable format and back (artifact: 1e65c9e061 user: kmedcalf)
19:59 Edit reply: Windows nanosecond file times to accurate presentable format and back (artifact: adee5af294 user: kmedcalf)
19:57 Reply: Windows nanosecond file times to accurate presentable format and back (artifact: 332cee8cf4 user: kmedcalf)
19:13 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS (artifact: 160fbfcb56 user: kmedcalf)
19:10 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS (artifact: 92800a5779 user: kmedcalf)
03:15 Reply: autovacuum in sqlite VS autovacuum in PG (artifact: 958079e14f user: kmedcalf)
2021-12-31
21:21 Reply: select valid lat/lng from columns typed as text (artifact: 992182edbe user: kmedcalf)
21:11 Reply: select valid lat/lng from columns typed as text (artifact: 3fe7a9097f user: kmedcalf)
21:06 Reply: select valid lat/lng from columns typed as text (artifact: 52405d1b7d user: kmedcalf)
21:06 Reply: select valid lat/lng from columns typed as text (artifact: 1e91dd4aed user: kmedcalf)
19:06 Reply: select valid lat/lng from columns typed as text (artifact: ef548c12cd user: kmedcalf)
2021-12-29
22:28 Reply: Left outter join on pragma tables acts as inner join (artifact: 8f94a3d12e user: kmedcalf)
2021-12-28
04:58 Reply: select distinct in table and modify column (artifact: 4803093e7f user: kmedcalf)
2021-12-27
18:10 Reply: Foreign key joins (artifact: 49e01c333a user: kmedcalf)
01:15 Reply: table locked when dropping a temp table (artifact: 68a4eb17ba user: kmedcalf)
00:03 Reply: table locked when dropping a temp table (artifact: 4c17151116 user: kmedcalf)
2021-12-26
19:46 Reply: Foreign key joins (artifact: 806d243779 user: kmedcalf)
2021-12-24
00:25 Reply: sqlite3 error (artifact: bc2e327186 user: kmedcalf)
2021-12-20
00:31 Reply: HEX - What is the reverse function? (artifact: b210e2c234 user: kmedcalf)
2021-12-19
21:50 Reply: HEX - What is the reverse function? (artifact: 9520fa78ea user: kmedcalf)
2021-12-12
03:32 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 73125e3e63 user: kmedcalf)
00:36 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 9ed7985630 user: kmedcalf)
00:10 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: ca57132e2f user: kmedcalf)
2021-12-11
22:39 Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 43e016e488 user: kmedcalf)
14:33 Reply: MAX performance (artifact: 6adf81aeae user: kmedcalf)
14:24 Reply: MAX performance (artifact: 3f730f3feb user: kmedcalf)
13:57 Reply: Close/Dispose does not release lock (artifact: 502f172369 user: kmedcalf)
13:50 Reply: MAX performance (artifact: 2a8fb12cd0 user: kmedcalf)
12:39 Reply: MAX performance (artifact: fa6e4e3ce5 user: kmedcalf)
2021-12-08
05:56 Reply: how to do "Explain Query Plan" using code (c++ or rust)? (artifact: e01882ab44 user: kmedcalf)
05:30 Reply: how to do "Explain Query Plan" using code (c++ or rust)? (artifact: 59f56e8e4c user: kmedcalf)