Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user TripeHound
2024-02-11
| ||
16:28 | • Reply: Disk image malformed after executing a transaction (works on a small sample but not the full database) (artifact: 5c2e863ca4 user: TripeHound) | |
2024-02-06
| ||
17:26 | • Reply: Help with my `journal_mode=WAL;` mental model (artifact: 4f7b435ba2 user: TripeHound) | |
2024-01-12
| ||
23:44 | • Reply: Window functions documentation (artifact: 8c8fb5a295 user: TripeHound) | |
2023-12-29
| ||
12:01 | • Reply: Some Queries are 40 times slower after v3.39.1 (artifact: 856c4f5e44 user: TripeHound) | |
2023-10-29
| ||
15:16 | • Reply: Code properties violations during software vulnerabilities investigation - Bug report 2 (artifact: 8beaa3bfdf user: TripeHound) | |
06:34 | • Reply: What could cause 12 reserved bytes per page? (And how to undo it?) (artifact: 7887ae2959 user: TripeHound) | |
2023-10-25
| ||
19:06 | • Reply: Foreign key constraint ignored on inserts (FK enabled) (artifact: e3028f77cf user: TripeHound) | |
2023-10-24
| ||
21:30 | • Reply: SQLite version 3.44.0 now in beta (artifact: a53125f9fe user: TripeHound) | |
2023-10-20
| ||
22:23 | • Reply: Getting Column does not belong to table exception (artifact: 107e6a0bb4 user: TripeHound) | |
2023-10-02
| ||
12:57 | • Reply: Unexpected result in Handling of NULL Values (artifact: 445e365bfb user: TripeHound) | |
2023-09-05
| ||
11:16 | • Reply: Bug: sqlite3_clear_bindings misbehaves (artifact: e4a78c43f4 user: TripeHound) | |
2023-06-12
| ||
18:40 | • Edit reply: regexp bug? or brain flatulence? (artifact: bf7f3bee02 user: TripeHound) | |
18:39 | • Reply: regexp bug? or brain flatulence? (artifact: b72572d31a user: TripeHound) | |
2023-04-13
| ||
17:07 | • Reply: C-APP ERROR: SQLITE_SCHEMA no such table (artifact: c7b79477e3 user: TripeHound) | |
2023-02-25
| ||
11:17 | • Reply: Read connection DATA LOSS under WAL mode (artifact: 47b3715cf0 user: TripeHound) | |
2023-01-15
| ||
08:58 | • Reply: Bug? "SQL Logic Error" when compiled with Visual Studio (artifact: 57b84cb663 user: TripeHound) | |
2023-01-10
| ||
14:28 | • Reply: Find an issue sqlite cannot open on some release version of Linux (artifact: 0acbf931cc user: TripeHound) | |
2022-11-27
| ||
07:48 | • Reply: Does an unchanged DB retain its timestamp? (artifact: 4e4ff16bc3 user: TripeHound) | |
2022-11-26
| ||
18:22 | • Edit reply: Documentation Query (artifact: 8248d7eb07 user: TripeHound) | |
18:16 | • Reply: Documentation Query (artifact: 809d73e93c user: TripeHound) | |
2022-10-22
| ||
16:54 | • Reply: "No such table" error when accessing attached file database in multithread (artifact: 93bbaaf7c0 user: TripeHound) | |
2022-10-19
| ||
08:42 | • Reply: Documentation (artifact: 1a795ca4fd user: TripeHound) | |
2022-05-02
| ||
13:51 | • Reply: Possible Wrong Results of the Group By Clause (artifact: 425168181b user: TripeHound) | |
2022-04-14
| ||
16:40 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 6c58ebdd63 user: TripeHound) | |
2022-03-20
| ||
08:12 | • Reply: Unable to update table data using ODBC (artifact: 4f16fe90de user: TripeHound) | |
2022-03-06
| ||
09:04 | • Reply: CASE TYPEOF(field) WHEN 'text' THEN .... doesn't seem to work (artifact: 8a48f0d13a user: TripeHound) | |
2022-02-20
| ||
22:43 | • Reply: why is an empty field evaluate to greater than an integer? (artifact: 166ce62cd1 user: TripeHound) | |
2022-02-10
| ||
23:07 | • Reply: while updating sqlite jdbc 3.34.0 to sqlite-jdbc-3.36.0.3 its showing error org.sqlite.SQLiteException: SQLITE_CORRUPT (artifact: be615b8a0b user: TripeHound) | |
2022-01-24
| ||
13:08 | • Reply: binding by reference instead of value (artifact: c77c5b69a6 user: TripeHound) | |
2022-01-18
| ||
22:46 | • Reply: Help me understand the path syntax used by json_extract() (artifact: 62c35df322 user: TripeHound) | |
2022-01-10
| ||
07:44 | • Reply: Using SQLITE_OMIT_xxx in SQLite 3.36 (artifact: eea74051eb user: TripeHound) | |
2022-01-01
| ||
08:52 | • Reply: My code's ATTACH will not create a new db but sqlite3's shell will? (artifact: b8850ce467 user: TripeHound) | |
2021-12-29
| ||
00:28 | • Reply: Serious error emptied my complete database! (artifact: 052af783af user: TripeHound) | |
2021-12-15
| ||
15:33 | • Reply: Error: stepping, unable to open database file (14) (artifact: ecfccced59 user: TripeHound) | |
2021-08-08
| ||
20:38 | • Reply: Getting a date range using "like" (artifact: 9a3c8bba44 user: TripeHound) | |
15:30 | • Reply: Getting a date range using "like" (artifact: e41b95c26e user: TripeHound) | |
2021-07-22
| ||
22:06 | • Edit reply: Compile error when symbols SQLITE_OMIT_SHARED_CACHE and SQLITE_USER_AUTHENTICATION=1 are both defined (artifact: 091bb655e4 user: TripeHound) | |
22:02 | • Reply: Compile error when symbols SQLITE_OMIT_SHARED_CACHE and SQLITE_USER_AUTHENTICATION=1 are both defined (artifact: 4389d16629 user: TripeHound) | |
2021-07-13
| ||
09:06 | • Reply: "=" character not mentioned in expr syntax definition (artifact: 657dd8b19d user: TripeHound) | |
2021-07-07
| ||
13:42 | • Reply: Shortcut to change a non changing update or upsert in a noop (artifact: c44fc8a646 user: TripeHound) | |
2021-07-02
| ||
06:09 | • Reply: Incorrect Result From SQLite Query (artifact: f467ecf01e user: TripeHound) | |
2021-05-13
| ||
09:12 | • Reply: How to convert am/pm time to 24hrs time format (artifact: b4ce3bfcec user: TripeHound) | |
2021-05-05
| ||
08:53 | • Reply: Why do I have a `SQLITE_AUTOINDEX` index for my primary key? Is the table itself not an index on the PK? (artifact: 56aa9f593f user: TripeHound) | |
2021-04-10
| ||
14:11 | • Reply: useless constant term lead to incorrect output (artifact: 173c42f489 user: TripeHound) | |
2021-03-30
| ||
19:41 | • Reply: Atomically initialize database (artifact: 9b1f89b3fd user: TripeHound) | |
2021-03-29
| ||
09:20 | • Reply: Query Contraint with an if clause? (artifact: 6b3616c189 user: TripeHound) | |
2021-03-27
| ||
14:49 | • Reply: Novice question about running UTF-8 on CLI from file. (artifact: ad6d5f92c7 user: TripeHound) | |
2021-03-25
| ||
22:36 | • Edit reply: json_tree documentation improvement: change type "string" to "text" (artifact: e56a7597e7 user: TripeHound) | |
22:35 | • Reply: json_tree documentation improvement: change type "string" to "text" (artifact: 3e86be3c6d user: TripeHound) | |
2021-03-23
| ||
11:07 | • Reply: Strange CLI .exit issue (artifact: f1ecabfa8a user: TripeHound) | |