SQLite Forum

Timeline
Login

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

50 most recent events by user kmedcalf occurring on or after 2021-08-06 22:48:12.

2021-09-04
17:14 Reply: The characters to be escaped in Sqlite3 to prevent Sql Injection artifact: b41758f3b4 user: kmedcalf
2021-09-02
20:30 Reply: What happens if I define LONGDOUBLE_TYPE as double? artifact: f8d5005aea user: kmedcalf
18:19 Reply: What happens if I define LONGDOUBLE_TYPE as double? artifact: da7cbb5453 user: kmedcalf
2021-09-01
18:09 Reply: Lua db:close deletes WAL file artifact: 8e121a3145 user: kmedcalf
18:02 Reply: Why WAL file (-wal) may disappear? artifact: 868b497a4f user: kmedcalf
17:59 Reply: Finding overlap of boxed coordinates artifact: 6534fd3497 user: kmedcalf
2021-08-30
18:44 Reply: A thought on LIKE/GLOB optimization artifact: 48076b81fa user: kmedcalf
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