Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user jake
2024-02-19
| ||
03:24 | • Reply: Feature Request: Dynamic SQL without requiring an external file (artifact: ea88ccb36c user: jake) | |
2023-06-04
| ||
11:24 | • Reply: .param lquoted iterals (artifact: d4b25877ff user: jake) | |
2023-03-02
| ||
06:18 | • Reply: Building custom extensions into a WASM Distribution of SQLite (artifact: 575d843234 user: jake) | |
01:59 | • Reply: Building custom extensions into a WASM Distribution of SQLite (artifact: 53511f0c92 user: jake) | |
2023-01-31
| ||
21:39 | • Reply: Splitting up conflated names (artifact: 7fc6d2b58b user: jake) | |
03:57 | • Edit reply: Splitting up conflated names (artifact: 9874f154ad user: jake) | |
02:33 | • Reply: Splitting up conflated names (artifact: d08197ceaa user: jake) | |
2022-11-29
| ||
01:05 | • Reply: PIVOT / UNPIVOT / TRANSPOSE / CROSSTAB (artifact: b037fae026 user: jake) | |
2022-11-23
| ||
22:29 | • Reply: Simple sqlite wasm import via browser (artifact: 2119230da8 user: jake) | |
2022-08-18
| ||
01:14 | • Reply: Query to create a table with blank row inserted between missing RowID's? (artifact: a604c4da21 user: jake) | |
2022-06-24
| ||
04:39 | • Reply: .read - use variables? (artifact: 785597e342 user: jake) | |
02:42 | • Reply: .read - use variables? (artifact: 770ac3d497 user: jake) | |
01:39 | • Reply: .read - use variables? (artifact: fa101965f7 user: jake) | |
2022-05-04
| ||
12:59 | • Post: Unexpected parse error accessing special rowid column (artifact: bc19c2500c user: jake) | |
2022-01-27
| ||
22:41 | • Reply: Include extensions at compile time (artifact: 8162973f1d user: jake) | |
2022-01-11
| ||
00:33 | • Reply: SQLite3 shell doing math operation on parameter substitution (artifact: 4b5278f459 user: jake) | |
2021-12-13
| ||
12:41 | • Reply: Importing XML (artifact: c3d8f60d4a user: jake) | |
2021-10-01
| ||
03:22 | • Reply: Query group missing from the output (artifact: 3fc316bab5 user: jake) | |
2021-08-31
| ||
15:27 | • Reply: Possible bug: Unexpected result using correlated aggregate subquery (artifact: 9310273f00 user: jake) | |
08:12 | • Post: Possible bug: Unexpected result using correlated aggregate subquery (artifact: 9f2b929904 user: jake) | |
2021-07-12
| ||
14:22 | • Edit reply: Unstack one column to multiple (artifact: 96701f9f63 user: jake) | |
14:16 | • Reply: Unstack one column to multiple (artifact: ecf6e748a1 user: jake) | |
2021-04-20
| ||
13:05 | • Reply: Aliased function result with the same name issue (artifact: 7174a250f3 user: jake) | |
11:06 | • Reply: Aliased function result with the same name issue (artifact: 08480e31c5 user: jake) | |
2021-02-25
| ||
00:18 | • Reply: Tiny doc bug: sqlite_source_id() has outdated SHA1 reference (artifact: 7b60ca0b85 user: jake) | |
2021-02-10
| ||
02:49 | • Reply: Split an Extract column (artifact: 96b5db0dbf user: jake) | |
2021-02-02
| ||
12:28 | • Reply: string concatenation issue in prepared statement (artifact: 04b59d5e34 user: jake) | |
2021-01-27
| ||
04:21 | • Reply: Help with a search command (artifact: 36ec978ca0 user: jake) | |
01:11 | • Reply: Help with a search command (artifact: fcc42fdee6 user: jake) | |
2020-12-26
| ||
02:54 | • Reply: Novice question about employing more complex SQL versus procedural code (artifact: 38231853d0 user: jake) | |
01:50 | • Reply: sqlite3_expanded_sql for carray with single bound parameter (artifact: 563e854657 user: jake) | |
2020-12-22
| ||
09:42 | • Reply: Is it possible to bind a single ? in a parameterized query to a listing of values for an in clause? (artifact: 0eecae1b74 user: jake) | |
03:44 | • Reply: Novice question about employing more complex SQL versus procedural code (artifact: f260acc733 user: jake) | |
2020-12-01
| ||
05:36 | • Reply: Freeing sqlite3_module after registering (artifact: e3b8122f82 user: jake) | |
04:26 | • Reply: Freeing sqlite3_module after registering (artifact: ed0e9f6830 user: jake) | |
2020-11-17
| ||
23:20 | • Reply: Start rowid from 0 (artifact: edb232493c user: jake) | |
2020-11-06
| ||
08:15 | • Reply: no such table: generate_series (artifact: 0177297eb7 user: jake) | |
02:09 | • Reply: Recursive Update on Date field (artifact: 00e06083f9 user: jake) | |
00:01 | • Reply: Use Recursive Date to test Holiday and Weekend and Update Record (artifact: c925c2793f user: jake) | |
2020-11-03
| ||
10:29 | • Reply: .param converts text to number - How to avoid this (artifact: 1bf202b391 user: jake) | |
2020-11-02
| ||
10:03 | • Reply: Alternative for nesting REPLACE()? (artifact: ac5cd57abc user: jake) | |
2020-10-13
| ||
04:57 | • Reply: Check Contraints (artifact: 9de75df61d user: jake) | |
2020-08-05
| ||
08:42 | • Post: CLI fails to bind parameters in tabular output modes (3.33.0 pre-release) (artifact: 17ba6aac24 user: jake) | |
2020-07-13
| ||
13:27 | • Reply: Charts (artifact: 1cd7b34b46 user: jake) | |
12:11 | • Reply: Charts (artifact: eabd38e503 user: jake) | |
00:54 | • Reply: Charts (artifact: 756b01fb0d user: jake) | |
2020-06-03
| ||
03:37 | • Reply: json_append array with multiple values (artifact: c0f2429efb user: jake) | |
2020-05-13
| ||
03:33 | • Reply: Can this simple query be optimized? (artifact: 56d977b08f user: jake) | |
00:17 | • Reply: Can this simple query be optimized? (artifact: f1fabba9fb user: jake) | |
2020-04-19
| ||
00:23 | • Reply: string literals, is there more than one escape? (artifact: f2063b42c4 user: jake) | |