SQLite Forum

Timeline
Login

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

50 events by user kmedcalf occurring on or before 2021-08-30 00:00:46.

2021-08-30
00:00 Edit reply: A thought on LIKE/GLOB optimization (artifact: e893ded226 user: kmedcalf)
2021-08-29
23:53 Reply: A thought on LIKE/GLOB optimization (artifact: 4bff081882 user: kmedcalf)
2021-08-26
20:31 Reply: Recursively Import 10 GB sized csv file to sqlite fast without blocking reads (artifact: a48a944442 user: kmedcalf)
2021-08-24
22:04 Reply: SQLite.Interop.dll is not loading due to its dependency binaries are missing in windows server core OS (artifact: d9c9e88dec user: kmedcalf)
22:01 Reply: When is "IS" used in SQLite? (artifact: ab51b4d4bb user: kmedcalf)
2021-08-23
07:35 Reply: Random crash doing SELECT (artifact: 7d76de2dd9 user: kmedcalf)
00:21 Reply: Coverting 305GB CSV to sqlite database (artifact: 28b351f272 user: kmedcalf)
2021-08-22
02:06 Reply: about "strict" mode (artifact: 5741068d63 user: kmedcalf)
2021-08-20
03:25 Reply: How to estimate a database disk file size or in-memory db memory usage ? ? (artifact: f4c37307a8 user: kmedcalf)
2021-08-19
22:31 Edit reply: "database or disk is full" with in-memory database. Suggested next steps? (artifact: befa34108e user: kmedcalf)
22:28 Reply: "database or disk is full" with in-memory database. Suggested next steps? (artifact: 7cedf2c0cb user: kmedcalf)
22:14 Reply: "database or disk is full" with in-memory database. Suggested next steps? (artifact: 6b1fca229b user: kmedcalf)
21:42 Reply: Trying to "Open Database" Safari History.db file and get Error: "could not open safari database file reason: unable to open.. (artifact: 4e4ed3bd3d user: kmedcalf)
21:37 Reply: "database or disk is full" with in-memory database. Suggested next steps? (artifact: c41d8ea9ca user: kmedcalf)
19:39 Reply: Random crash doing SELECT (artifact: 076ac2c329 user: kmedcalf)
18:18 Reply: Random crash doing SELECT (artifact: 8c02593343 user: kmedcalf)
2021-08-17
03:47 Reply: Avoiding recursive CTE materialisation (artifact: 722accdc1f user: kmedcalf)
2021-08-15
18:04 Reply: wal checkpointing very slow (artifact: 2d1d0c35ef user: kmedcalf)
17:30 Edit reply: Avoiding recursive CTE materialisation (artifact: 08c696f77a user: kmedcalf)
17:28 Reply: Avoiding recursive CTE materialisation (artifact: 1752b282b5 user: kmedcalf)
17:08 Reply: Numeric vs integer (artifact: 522abeeead user: kmedcalf)
2021-08-14
18:33 Reply: AVG funcion problem (artifact: 62b3b8dcc1 user: kmedcalf)
18:29 Reply: AVG funcion problem (artifact: 8a27c0eb9e user: kmedcalf)
08:58 Reply: AVG funcion problem (artifact: 1c9b4816f8 user: kmedcalf)
08:44 Reply: AVG funcion problem (artifact: 935265d964 user: kmedcalf)
2021-08-13
20:19 Reply: Calculating Trip Duration in Minutes? (artifact: 4b7464319b user: kmedcalf)
19:50 Reply: Sqlite connections isolated even after COMMIT (artifact: 33b580b46c user: kmedcalf)
19:49 Reply: .expert Error: ON clause references tables to its right (artifact: 393054a774 user: kmedcalf)
2021-08-12
22:25 Reply: .expert Error: ON clause references tables to its right (artifact: f77dec7ac1 user: kmedcalf)
22:08 Reply: help! decimal field multiplication error? (artifact: 297c25ff66 user: kmedcalf)
2021-08-10
20:48 Reply: LEFT JOIN Misunderstanding (artifact: 8f6fbbdf4c user: kmedcalf)
2021-08-09
23:04 Reply: Not understanding a subquery - Some guidance? (artifact: 8e3f6e86de user: kmedcalf)
22:57 Reply: Not understanding a subquery - Some guidance? (artifact: 1f785737b7 user: kmedcalf)
22:36 Reply: Getting a date range using "like" (artifact: 4c96c6f2b7 user: kmedcalf)
2021-08-08
11:36 Reply: Not understanding a subquery - Some guidance? (artifact: 7ef1beb221 user: kmedcalf)
07:15 Reply: Not understanding a subquery - Some guidance? (artifact: adaa20b743 user: kmedcalf)
07:05 Reply: Not understanding a subquery - Some guidance? (artifact: 0b5e684a67 user: kmedcalf)
2021-08-07
20:50 Reply: Not understanding a subquery - Some guidance? (artifact: ed05ff807b user: kmedcalf)
20:45 Reply: SQLite3.exe - How to use arguments AND remain in interactive mode? (artifact: 14ad5f0434 user: kmedcalf)
20:34 Reply: SQLite3.exe - How to use arguments AND remain in interactive mode? (artifact: 644934993f user: kmedcalf)
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)