SQLite Forum

Timeline
Login

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

50 most recent forum posts by user dan

2024-03-18
21:17 Edit reply: RIGHT PART OF ORDER BY query plan output is unclear and optimization opportunities (artifact: ce33ae884f user: dan)
21:11 Reply: SQLITE_DIRECT_OVERFLOW_READ and cksumvfs bug (artifact: 75c57d7e71 user: dan)
17:52 Reply: RIGHT PART OF ORDER BY query plan output is unclear and optimization opportunities (artifact: c15935ceca user: dan)
13:37 Reply: API to invoke busy handler (artifact: 96a6d7f344 user: dan)
12:06 Reply: API to invoke busy handler (artifact: 3ce79c9630 user: dan)
2024-03-15
07:37 Reply: Inconsistent query result may caused by view (artifact: 416bc76425 user: dan)
2024-03-14
10:30 Reply: FTS5 and >= (artifact: 4a75acbdf1 user: dan)
2024-03-12
17:41 Reply: Behavior of Common table expression (artifact: bbd0dfbc59 user: dan)
2024-03-11
16:20 Reply: How sqlite updates row? (artifact: 9d4488e73f user: dan)
2024-03-08
14:37 Reply: Inconsistent query result after adding where condition. (artifact: fb7d04791e user: dan)
2024-03-06
17:43 Reply: SQLite Encryption Extension in Xcode for iOS/iPadOS/MacOS (artifact: 56d0e32787 user: dan)
2024-02-28
15:08 Edit reply: Two texts not equal but unclear how (artifact: 1b9d8e3547 user: dan)
15:07 Reply: Two texts not equal but unclear how (artifact: eaad377b30 user: dan)
15:02 Edit reply: Two texts not equal but unclear how (artifact: 5e4e7124ad user: dan)
14:50 Reply: Two texts not equal but unclear how (artifact: 65547cda34 user: dan)
2024-02-22
08:44 Reply: Journal file won't go away? (artifact: 251bc342d6 user: dan)
2024-02-20
21:00 Reply: FTS5 search (artifact: a9315750f3 user: dan)
20:54 Edit: FTS5 search (artifact: b1fbc0581c user: dan)
2024-02-13
11:07 Reply: BEGIN IMMEDIATE VFS call ordering (artifact: f871c7c18b user: dan)
2024-02-12
11:00 Reply: BEGIN IMMEDIATE VFS call ordering (artifact: 2464eeb7f6 user: dan)
2024-02-09
15:17 Reply: Supported file systesm for SQLITE_ENABLE_BATCH_ATOMIC_WRITE (artifact: c8b236a0df user: dan)
15:10 Reply: Massive insert optimisation (artifact: e512be6eeb user: dan)
10:44 Reply: "PRAGMA foreign_keys = OFF" and "ON DELETE CASCADE" (artifact: 1f00f75895 user: dan)
2024-02-08
11:10 Edit reply: "PRAGMA foreign_keys = OFF" and "ON DELETE CASCADE" (artifact: 336ff34b9f user: dan)
11:10 Reply: "PRAGMA foreign_keys = OFF" and "ON DELETE CASCADE" (artifact: 70494aa203 user: dan)
10:58 Reply: How exactly does corruption happen during WAL checkpoint? (artifact: 67d30ae46d user: dan)
2024-02-07
14:56 Reply: Failed temptable3.test (artifact: 7cc3d27866 user: dan)
10:58 Reply: "PRAGMA foreign_keys = OFF" and "ON DELETE CASCADE" (artifact: bb5eff5afc user: dan)
2024-02-03
20:16 Reply: How exactly does corruption happen during WAL checkpoint? (artifact: 5eb54ccb0c user: dan)
2024-02-02
16:48 Reply: How exactly does corruption happen during WAL checkpoint? (artifact: 83bbdd7c07 user: dan)
14:29 Reply: Bug report: Address Sanitizer reporting memory overrun errors (artifact: aba0712603 user: dan)
14:21 Reply: Why does type matter in WHERE clause? (artifact: 2057babb9f user: dan)
13:58 Reply: How exactly does corruption happen during WAL checkpoint? (artifact: 92eb4004a8 user: dan)
10:54 Reply: How exactly does corruption happen during WAL checkpoint? (artifact: 39139916c8 user: dan)
2024-02-01
16:47 Reply: When do readers actually stop using the WAL? Is there a contradiction? (artifact: 0a4979f0c2 user: dan)
2024-01-31
11:12 Delete reply: Use after free in jsonParseAddNodeArray, sqlite3.c:202989 (artifact: 18ac08a6ad user: dan)
11:04 Reply: Use after free in jsonParseAddNodeArray, sqlite3.c:202989 (artifact: d07c435cbe user: dan)
2024-01-29
14:09 Reply: How can I implement a mechanism similar to MySQL's binlog in SQLite (artifact: d53014f652 user: dan)
2024-01-26
20:31 Reply: Possible bad index in exprAnalyze (artifact: f313d53d77 user: dan)
2024-01-22
11:39 Edit reply: vacuum into results in Error: in prepare, no such column (artifact: a1884abcca user: dan)
11:38 Reply: vacuum into results in Error: in prepare, no such column (artifact: a58c941d49 user: dan)
2024-01-18
17:41 Edit reply: Malformed Database upon Index Creation (artifact: 7e67401535 user: dan)
11:21 Edit reply: Bug converting date to ISO date (artifact: 218342d9c8 user: dan)
11:20 Reply: Bug converting date to ISO date (artifact: 9f212177df user: dan)
10:54 Edit reply: Malformed Database upon Index Creation (artifact: af7806802b user: dan)
2024-01-17
16:22 Reply: FTS5 speed "ver1" vs. "ver1.1" (artifact: a65e6973c7 user: dan)
2024-01-16
21:01 Reply: FTS5 speed "ver1" vs. "ver1.1" (artifact: 9491da26da user: dan)
11:49 Reply: FTS5 speed "ver1" vs. "ver1.1" (artifact: cbb67c18aa user: dan)
2024-01-14
11:16 Reply: why is the "real" time so much higher than the "user + sys" times? (artifact: e3068b8f25 user: dan)
2024-01-12
13:54 Reply: sqlite .dump with CHECKS breaking (artifact: e6c0f45a86 user: dan)