SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent forum posts by user gunter_hick

2024-04-19
06:07 Reply: Why is Database Locked? (artifact: 22409b704c user: gunter_hick)
2024-04-17
14:45 Reply: Results of queries containing null bytes may be incorrect (artifact: cf3a76740d user: gunter_hick)
2024-04-15
14:05 Reply: Results of queries containing null bytes may be incorrect (artifact: 600b223b2e user: gunter_hick)
10:35 Reply: Difference in query plan when using 1 instead of true keyword (artifact: 02dab84f16 user: gunter_hick)
09:56 Reply: (Deleted) (artifact: c393c07369 user: gunter_hick)
09:54 Reply: Difference in query plan when using 1 instead of true keyword (artifact: 2fbbe39a0b user: gunter_hick)
2024-04-11
13:12 Edit reply: sqlite3_bind_blob unable to bind empty byte array (artifact: 8b000023b3 user: gunter_hick)
13:10 Reply: sqlite3_bind_blob unable to bind empty byte array (artifact: 115bd133de user: gunter_hick)
06:48 Reply: Using GUID as primary key (artifact: f5e671605f user: gunter_hick)
2024-04-08
08:11 Reply: Slow query not using primary key for group by min/max (artifact: f64e179d7c user: gunter_hick)
2024-04-04
05:38 Reply: attaching database while restoring from hot journal yields SQLITE_BUSY (artifact: 3684272450 user: gunter_hick)
2024-04-03
14:14 Reply: attaching database while restoring from hot journal yields SQLITE_BUSY (artifact: f5736c3ca4 user: gunter_hick)
2024-04-02
13:28 Reply: SAVEPOINT ... CONSTRAINT (table1, table2, ...) (artifact: 37d71f5170 user: gunter_hick)
13:25 Reply: CHECK - keyword (artifact: 9a68a29cbe user: gunter_hick)
11:27 Reply: Dumping Data (.dump) (artifact: e44661c1ee user: gunter_hick)
09:54 Reply: SAVEPOINT ... CONSTRAINT (table1, table2, ...) (artifact: 970216d609 user: gunter_hick)
05:30 Reply: Create Table Foreign Key Clause Syntax Diagram Issue? (artifact: 129738028f user: gunter_hick)
2024-03-26
07:02 Reply: How can the data in the sqlite3_update_hook orsqlite3_traces callbacks be associated with transactions? (artifact: 2b391db449 user: gunter_hick)
06:26 Reply: How can the data in the sqlite3_update_hook orsqlite3_traces callbacks be associated with transactions? (artifact: 17decd4a9c user: gunter_hick)
2024-03-21
11:56 Reply: Convert DB file to PST file (artifact: c6fe102cb7 user: gunter_hick)
11:50 Reply: Transaction fails immediately in Android before busy_timeout expires (artifact: e813ea6e1d user: gunter_hick)
2024-03-20
05:51 Reply: DB Locking Issue with single threaded writes (artifact: 0554debf3e user: gunter_hick)
2024-03-18
12:16 Reply: RIGHT PART OF ORDER BY query plan output is unclear and optimization opportunities (artifact: 0e8b993e71 user: gunter_hick)
12:03 Reply: Create Table Foreign Key Clause Syntax Diagram Issue? (artifact: d2572bf238 user: gunter_hick)
11:57 Reply: API to invoke busy handler (artifact: b35b49dbab user: gunter_hick)
2024-03-06
15:13 Reply: Non-breaking space character breaks regexp (artifact: 9ff62ab87e user: gunter_hick)
14:07 Reply: Index doesn't have expected performance benefit (artifact: be784ac975 user: gunter_hick)
2024-03-05
06:48 Edit reply: Index doesn't have expected performance benefit (artifact: 273194d140 user: gunter_hick)
06:46 Reply: Index doesn't have expected performance benefit (artifact: 1b30bc27c4 user: gunter_hick)
2024-02-29
06:45 Reply: Virtual Table Joins with Repeated calls to xFilter (artifact: 19ffdc86ae user: gunter_hick)
2024-02-28
06:37 Reply: Virtual Table Joins with Repeated calls to xFilter (artifact: a53516f408 user: gunter_hick)
2024-02-27
06:31 Reply: Virtual Table Joins with Repeated calls to xFilter (artifact: 8f5d1d4030 user: gunter_hick)
2024-02-26
06:42 Reply: Why is IN Faster than NOT IN ? (artifact: 0a27c17c8e user: gunter_hick)
2024-02-23
08:12 Reply: Why is IN Faster than NOT IN ? (artifact: 81a3c308be user: gunter_hick)
06:19 Reply: Virtual Table Joins with Repeated calls to xFilter (artifact: 68d97f6ae9 user: gunter_hick)
2024-02-20
14:08 Reply: Using a derived value in a SQL statement (artifact: ccf26d1d7b user: gunter_hick)
11:32 Reply: Using a derived value in a SQL statement (artifact: db91bfc7cd user: gunter_hick)
07:58 Reply: Seeking clarification regarding the use of CREATE TRIGGER and the WITH clause (artifact: ff149f96d0 user: gunter_hick)
06:40 Reply: Seeking clarification regarding the use of CREATE TRIGGER and the WITH clause (artifact: c75314e1b5 user: gunter_hick)
2024-02-16
07:45 Reply: DEFAULT hex literal exceeding 64 bit (artifact: aa1ff37a38 user: gunter_hick)
07:25 Reply: How to handle fork()s? (artifact: 29df77ea3c user: gunter_hick)
07:14 Reply: How to handle fork()s? (artifact: 5fa57d53dc user: gunter_hick)
06:48 Reply: Option to specify primary key on .import? (artifact: 3b6f7d19f6 user: gunter_hick)
2024-02-15
15:08 Reply: Foreign key mismatch issues (artifact: e0db14a497 user: gunter_hick)
15:00 Reply: How to handle fork()s? (artifact: 97d8588e63 user: gunter_hick)
2024-02-12
07:09 Reply: Temp index or In memory index (artifact: 6bcbf52c6b user: gunter_hick)
2024-02-09
11:15 Reply: sqlite3_step return codes (artifact: d819c2c01d user: gunter_hick)
09:05 Reply: Error inserting BIGINT value (insert 2147499852) in sqlite3 wal mode (artifact: e7f41f2f8c user: gunter_hick)
07:31 Reply: sqlite3_step return codes (artifact: 2273b6ef2e user: gunter_hick)
2024-02-08
14:57 Reply: Matching partial name data between two SQLite3 tables (artifact: d199ee64a8 user: gunter_hick)