SQLite Forum

Timeline
Login

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)