SQLite Forum

Timeline
Login

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

50 events by user kmedcalf occurring around 2022-01-26 21:43:53.

2022-02-01
20:58 Reply: 4-byte float possible in SQLite? artifact: 4e2251f9f6 user: kmedcalf
2022-01-31
00:51 Reply: Is there a way to aggregate values in a column in sqlite in one-to-many relationship into array? artifact: 86331a6221 user: kmedcalf
2022-01-30
21:08 Reply: Multi-connection access to database on USB drive artifact: 0ae805b9f5 user: kmedcalf
07:49 Reply: "printf" with "as" and "order by" artifact: e832efa8c7 user: kmedcalf
02:45 Reply: Multi-connection access to database on USB drive artifact: 5c77fed94f user: kmedcalf
02:07 Reply: Multi-connection access to database on USB drive artifact: 96b0a65935 user: kmedcalf
2022-01-29
23:52 Reply: "printf" with "as" and "order by" artifact: 265f455a11 user: kmedcalf
21:28 Reply: UPDATE FROM syntax error artifact: 46937e3f71 user: kmedcalf
00:05 Edit reply: Primary Key or Unique Index artifact: 9c3bb4f07c user: kmedcalf
00:04 Edit reply: Primary Key or Unique Index artifact: 4c84c266cf user: kmedcalf
2022-01-28
23:58 Reply: Primary Key or Unique Index artifact: 3959ee1f45 user: kmedcalf
23:48 Edit reply: How to keep collation after substr()? artifact: 230ecbe6bf user: kmedcalf
23:47 Reply: How to keep collation after substr()? artifact: 4dd021194c user: kmedcalf
23:00 Reply: Syntax error at UPDATE - works in SQLiteStudio, not in my code artifact: b244c94962 user: kmedcalf
20:30 Reply: below function will free the heap memory for running application or not artifact: 8e2f016a0f user: kmedcalf
18:25 Reply: Primary Key or Unique Index artifact: 0aba1e7baf user: kmedcalf
05:52 Reply: Docs: julianday() returns a real number, not a string artifact: 986c46aefc user: kmedcalf
2022-01-27
20:47 Reply: Docs: julianday() returns a real number, not a string artifact: 9a39328a66 user: kmedcalf
04:12 Reply: Multi-connection access to database on USB drive artifact: b3552111d7 user: kmedcalf
2022-01-26
23:19 Edit reply: Docs: julianday() returns a real number, not a string artifact: be59bc0b83 user: kmedcalf
23:13 Reply: Docs: julianday() returns a real number, not a string artifact: a2f3e0b139 user: kmedcalf
21:52 Edit reply: Docs: julianday() returns a real number, not a string artifact: 49c8da2be8 user: kmedcalf
21:50 Edit reply: Docs: julianday() returns a real number, not a string artifact: 8d8ad3c805 user: kmedcalf
21:47 Edit reply: Docs: julianday() returns a real number, not a string artifact: 2f31fee9f6 user: kmedcalf
21:43 Reply: Docs: julianday() returns a real number, not a string artifact: 2f07d4ae35 user: kmedcalf
2022-01-25
20:36 Edit reply: Select first row in a group artifact: 98ffc23ffd user: kmedcalf
20:33 Reply: Select first row in a group artifact: 71642989ed user: kmedcalf
2022-01-24
20:12 Reply: Case when artifact: 3aed8dd803 user: kmedcalf
19:52 Reply: Session Extension: Changeset for Query/View artifact: 1add172b16 user: kmedcalf
17:01 Reply: How to check if sqlite3_stmt is done? artifact: c087c4e1c0 user: kmedcalf
16:51 Reply: ghost file "file" when using URI for memory database with SQLITE_USE_URI=0 artifact: e2814e56dd user: kmedcalf
16:45 Reply: How to check if sqlite3_stmt is done? artifact: 2d3b7b3a3b user: kmedcalf
16:37 Reply: column constraint ascending primary key with text type artifact: 89d44bc413 user: kmedcalf
16:29 Reply: column constraint ascending primary key with text type artifact: 76d140578a user: kmedcalf
03:12 Reply: Reuse HAVING clause computation in the existing table artifact: 4a2eec8534 user: kmedcalf
03:04 Reply: Reuse HAVING clause computation in the existing table artifact: 48889e284d user: kmedcalf
03:03 Reply: Reuse HAVING clause computation in the existing table artifact: 5f5173e2af user: kmedcalf
2022-01-23
21:40 Reply: binding by reference instead of value artifact: 5f81fa824f user: kmedcalf
2022-01-22
21:18 Reply: INSERT INTO SELECT upgrade to IMMEDIATE/EXCLUSIVE artifact: f154424527 user: kmedcalf
01:11 Reply: Why is this query so slow, but only in SQLite? artifact: f3707b7d5e user: kmedcalf
00:57 Reply: Why is this query so slow, but only in SQLite? artifact: 676c42b47b user: kmedcalf
2022-01-21
23:57 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: ee528de010 user: kmedcalf
23:52 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: 53f07e1bbb user: kmedcalf
2022-01-20
23:30 Reply: How to check if sqlite3_stmt is done? artifact: ca36f03689 user: kmedcalf
23:16 Reply: Regarding memory mapped i/o artifact: 0d2d1c1e3b user: kmedcalf
03:30 Reply: Distinguishing CREATE TABLE failure (already exists) from othe failures artifact: c49c46c596 user: kmedcalf
2022-01-19
23:21 Reply: SQLITE3.EXE V3.37.2 artifact: fc17677edb user: kmedcalf
22:58 Reply: SQLITE3.EXE V3.37.2 artifact: e6e7345461 user: kmedcalf
02:03 Reply: .param set accepts "illegal" names artifact: 23e2ca3f76 user: kmedcalf
01:22 Edit reply: pragma table_info confusion by multiple attache databases artifact: 27f85a4634 user: kmedcalf