SQLite Forum

Timeline
Login

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)