Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user jkreibich
2024-04-16
| ||
14:10 | • Reply: Query with CASE, WHEN IN and THEN (artifact: a8856671ad user: jkreibich) | |
2024-03-29
| ||
20:25 | • Reply: Why are there no sqlite3_attach & sqlite3_detach API calls (artifact: fef7c185f6 user: jkreibich) | |
20:06 | • Reply: Does "CREATE Database" exist? (artifact: 40b46b2fa8 user: jkreibich) | |
2024-03-23
| ||
18:46 | • Reply: In-place VACUUM 20x slower than VACUUM INTO (artifact: 589357320e user: jkreibich) | |
2024-03-22
| ||
16:32 | • Reply: In-place VACUUM 20x slower than VACUUM INTO (artifact: 5afc766b55 user: jkreibich) | |
2024-02-19
| ||
16:48 | • Reply: For crypto prices, I'm going to use floating points + rounding . I considered the alternatives. Please tell me why I'm wrong. (artifact: e15f526770 user: jkreibich) | |
2023-09-25
| ||
18:31 | • Reply: Incorrect result with TOTAL Function on rtree table (artifact: 0f09d11337 user: jkreibich) | |
2023-09-20
| ||
12:46 | • Reply: Difference between attaching memory database and temporary tables (artifact: b6ab7fdb85 user: jkreibich) | |
2023-08-16
| ||
19:56 | • Reply: proposal: static user extensions via compile options (artifact: 79c76c9026 user: jkreibich) | |
19:20 | • Post: proposal: static user extensions via compile options (artifact: 00829394c7 user: jkreibich) | |
2023-08-07
| ||
04:37 | • Reply: Why big-endian? (artifact: ba10bc2d47 user: jkreibich) | |
2023-07-31
| ||
00:48 | • Reply: Virtual table for Apache Arrow (artifact: 90accc7554 user: jkreibich) | |
2023-07-28
| ||
22:44 | • Post: Virtual table for Apache Arrow (artifact: c43413b4bf user: jkreibich) | |
2023-06-08
| ||
17:53 | • Reply: Option to make SQLite stricter with non-aggregate columns (artifact: 7ed06b3839 user: jkreibich) | |
2023-03-20
| ||
20:46 | • Reply: PRAGMA reverse_unordered_selects cause different results (artifact: b49034dbec user: jkreibich) | |
08:48 | • Reply: PRAGMA reverse_unordered_selects cause different results (artifact: ef6f593b8b user: jkreibich) | |
2023-03-18
| ||
15:16 | • Reply: Close all open connections (artifact: 476e0eb473 user: jkreibich) | |
2023-03-16
| ||
01:36 | • Reply: Subtract in select (artifact: bf4815ca7a user: jkreibich) | |
2023-03-15
| ||
21:00 | • Reply: Help with query plan (artifact: 00ed71196a user: jkreibich) | |
20:51 | • Reply: Help with query plan (artifact: 8cc97c2ffc user: jkreibich) | |
2023-03-13
| ||
22:42 | • Reply: Help with query plan (artifact: 044b458cb9 user: jkreibich) | |
2023-03-09
| ||
22:56 | • Post: Help with query plan (artifact: 869b3915a2 user: jkreibich) | |
2023-01-19
| ||
01:20 | • Reply: SQLLite Querying Question (artifact: 816306b23c user: jkreibich) | |
2023-01-12
| ||
17:01 | • Reply: Best way to XOR two tables? (artifact: f65af232ab user: jkreibich) | |
2023-01-07
| ||
02:27 | • Reply: Accessing SQLite DB file remotely over network (artifact: 8da63937dd user: jkreibich) | |
2023-01-03
| ||
19:03 | • Reply: Complete documentation (artifact: 62c85dec45 user: jkreibich) | |
2022-08-18
| ||
01:28 | • Reply: Query to create a table with blank row inserted between missing RowID's? (artifact: 1f90d683d1 user: jkreibich) | |
2022-07-26
| ||
14:47 | • Reply: Deterministic and consistent .schema of the CLI (artifact: 9bcdd545e8 user: jkreibich) | |
14:46 | • Reply: Deterministic and consistent .schema of the CLI (artifact: 8a444dfda7 user: jkreibich) | |
2022-04-28
| ||
05:31 | • Reply: Questions about running SQL queries in parallel for performance (artifact: 1523641760 user: jkreibich) | |
2022-04-27
| ||
02:44 | • Reply: sqlite db design question (artifact: 8809489a30 user: jkreibich) | |
2022-04-26
| ||
14:37 | • Reply: sqlite db design question (artifact: 80e6782e47 user: jkreibich) | |
2022-04-05
| ||
02:44 | • Reply: Creating an empty table with no columns (artifact: bfea485472 user: jkreibich) | |
2022-04-02
| ||
01:27 | • Reply: Creating an empty table with no columns (artifact: 80069a0c0e user: jkreibich) | |
01:03 | • Reply: Creating an empty table with no columns (artifact: 28b3738015 user: jkreibich) | |
2022-03-04
| ||
17:54 | • Reply: Book,Author,Book_Author (artifact: dee97f9699 user: jkreibich) | |
2022-03-03
| ||
17:49 | • Reply: Book,Author,Book_Author (artifact: 740f1047ad user: jkreibich) | |
2022-03-01
| ||
21:38 | • Reply: IEEE 754 canonicalization in SQLite (artifact: 1a6c61e053 user: jkreibich) | |
01:06 | • Reply: IEEE 754 canonicalization in SQLite (artifact: a2a728cfee user: jkreibich) | |
2022-02-02
| ||
20:58 | • Reply: 4-byte float possible in SQLite? (artifact: 5f961ed5e0 user: jkreibich) | |
2021-12-12
| ||
00:12 | • Reply: SQLite3 select (with table scan) not saturating NVMe throughput (artifact: 9600804ee8 user: jkreibich) | |
2021-12-10
| ||
20:39 | • Reply: Sqlite3 can happend deadlock? (artifact: 7151da7546 user: jkreibich) | |
17:55 | • Reply: Sqlite3 can happend deadlock? (artifact: 5c1129d50a user: jkreibich) | |
2021-04-13
| ||
07:06 | • Reply: Saving Wikipedia to SQLite (artifact: 005b81734e user: jkreibich) | |
2021-04-11
| ||
00:40 | • Reply: books / papers on "one sqlite per user" design ? (artifact: e606ad4f14 user: jkreibich) | |
2021-04-07
| ||
20:46 | • Reply: Saving Wikipedia to SQLite (artifact: 69afac78aa user: jkreibich) | |
2021-02-26
| ||
17:44 | • Reply: Ability to: SELECT * EXCEPT(some,columns) (artifact: 3616d9a25f user: jkreibich) | |
2021-02-19
| ||
17:10 | • Reply: Table and index in separate files (artifact: 17337e5553 user: jkreibich) | |
2021-01-19
| ||
23:41 | • Reply: Need If column exist option in SQLite (artifact: 41ee91d72e user: jkreibich) | |
2021-01-01
| ||
19:16 | • Reply: SQLite3 for Teensy 4.1 - dirent.h (artifact: b88988e317 user: jkreibich) | |