SQLite Forum

Timeline
Login

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

50 most recent forum posts by user deonb

2024-01-10
23:30 Reply: Suggestion: octal literals (artifact: d58b3d71b7 user: deonb)
2024-01-09
21:11 Post: Can a bad sqlite expression index extension cause corruption that looks like this? (artifact: f1165db36f user: deonb)
2023-12-06
19:07 Reply: JSONB has landed (artifact: 37333e40e9 user: deonb)
2023-12-05
21:15 Reply: JSONB has landed (artifact: f6af0c1a06 user: deonb)
2023-11-14
11:04 Reply: SQLite doesn't use indexes for bitwise clauses? (artifact: 239bcabbd1 user: deonb)
10:55 Reply: SQLite doesn't use indexes for bitwise clauses? (artifact: a681871cef user: deonb)
2023-09-21
21:13 Reply: xBestIndex malfunction on JOIN but works with IN (artifact: bdff25f964 user: deonb)
16:11 Post: xBestIndex malfunction on JOIN but works with IN (artifact: 5b87790f30 user: deonb)
2023-06-30
16:04 Reply: Column/Cell level storage report (artifact: ad473526b0 user: deonb)
15:35 Post: Column/Cell level storage report (artifact: 74b10d4f83 user: deonb)
2023-06-20
01:22 Reply: Can I tell the difference between and int and an int64? (artifact: 7b844c4339 user: deonb)
2023-06-19
21:24 Reply: How can I make SQLITE run slower? (artifact: 953e8fa445 user: deonb)
18:45 Post: Can I tell the difference between and int and an int64? (artifact: 7c450a50ca user: deonb)
18:30 Reply: How can I make SQLITE run slower? (artifact: 854fcd8e5c user: deonb)
2023-06-18
01:50 Reply: How can I make SQLITE run slower? (artifact: ad2cfd4b55 user: deonb)
2023-06-16
16:13 Reply: How can I make SQLITE run slower? (artifact: 22476af960 user: deonb)
03:56 Post: How can I make SQLITE run slower? (artifact: 67a1ae98f1 user: deonb)
2023-06-08
16:54 Reply: Option to make SQLite stricter with non-aggregate columns (artifact: c562f4bc4b user: deonb)
2023-06-07
04:55 Post: Is there a way to tell SQLITE that x > 1 implies x > 0? (artifact: 95ba87d3a2 user: deonb)
2023-06-02
18:58 Reply: How is a count(*) index decided? (artifact: 92782b1e29 user: deonb)
2023-06-01
21:48 Post: How is a count(*) index decided? (artifact: dc65a80d50 user: deonb)
2023-03-24
20:57 Reply: Schema-less SQLite (artifact: 2733b2dfa7 user: deonb)
2022-12-22
23:44 Reply: single thread mode slower than multi thread mode? (artifact: 332194b3be user: deonb)
2022-11-02
10:57 Post: sqlite3_analyzer --pageinfo returning ERROR: database or disk is full (artifact: 57fb17c556 user: deonb)
2022-09-08
05:43 Reply: SQLite Tools for windows 64bit (artifact: 213c169f4a user: deonb)
2022-03-22
03:17 Reply: Just curious: Bytecode generation - non SQL input? (artifact: cfdd7ea16d user: deonb)
2022-01-30
02:04 Reply: Multi-connection access to database on USB drive (artifact: aa44df5ec5 user: deonb)
01:47 Reply: Multi-connection access to database on USB drive (artifact: a76eff77c1 user: deonb)
01:13 Reply: Multi-connection access to database on USB drive (artifact: 78c1105e33 user: deonb)
2022-01-27
08:09 Reply: Multi-connection access to database on USB drive (artifact: 9e95582214 user: deonb)
01:14 Post: Multi-connection access to database on USB drive (artifact: e6abcca34d user: deonb)
2021-10-01
22:45 Post: Is the lifetime of argv in sqlite3_module::xConnect greater than sqlite3_module::xFilter? (artifact: a92b7f0d66 user: deonb)
2021-08-04
23:27 Reply: LEFT JOIN Misunderstanding (artifact: 9c3b2fa6c2 user: deonb)
23:18 Reply: LEFT JOIN Misunderstanding (artifact: 15f4ba2557 user: deonb)
23:11 Reply: LEFT JOIN Misunderstanding (artifact: cb45380a75 user: deonb)
20:40 Edit reply: LEFT JOIN Misunderstanding (artifact: ef96895763 user: deonb)
20:38 Reply: LEFT JOIN Misunderstanding (artifact: 21b726780d user: deonb)
16:36 Reply: LEFT JOIN Misunderstanding (artifact: e3b76869b2 user: deonb)
2021-06-08
21:45 Reply: Requesting optimization for index expression case (artifact: ec2dac5ff7 user: deonb)
20:14 Reply: Requesting optimization for index expression case (artifact: 763512b641 user: deonb)
19:01 Post: Requesting optimization for index expression case (artifact: c63c0442c8 user: deonb)
2021-05-07
04:30 Reply: Is there a way to mark an index 'explicit' only? (artifact: f47da6b2c1 user: deonb)
2021-05-03
06:05 Reply: Is there a way to mark an index 'explicit' only? (artifact: aadbbeabba user: deonb)
05:56 Post: Is there a way to mark an index 'explicit' only? (artifact: 3a9b77465a user: deonb)
2021-03-01
17:01 Edit reply: Tracing why SQLITE is making an index decision (artifact: d586737c58 user: deonb)
16:59 Reply: Tracing why SQLITE is making an index decision (artifact: a803755950 user: deonb)
06:32 Reply: Tracing why SQLITE is making an index decision (artifact: b84ae1d5b5 user: deonb)
2021-02-26
21:53 Edit reply: Tracing why SQLITE is making an index decision (artifact: 750de7a7d2 user: deonb)
21:52 Reply: Tracing why SQLITE is making an index decision (artifact: f9f15274b8 user: deonb)
03:15 Post: Tracing why SQLITE is making an index decision (artifact: e5930ce14f user: deonb)