SQLite Forum

Timeline
Login

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

50 most recent events by user dan occurring on or after 2021-09-02 06:32:44.

2022-05-03
10:51 Reply: (SOLVED) any idea what went wrong on this 4TB db to cause "database or disk is full" ? artifact: 5c2bae99a7 user: dan
2022-04-28
18:28 Reply: Why SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTERTABLE artifact: f85f84cbc1 user: dan
2022-04-25
11:02 Reply: Two crashes found through fuzzing artifact: 0f0091d6b2 user: dan
10:44 Reply: Possible bug with INNER JOIN in 3.38.2 artifact: a27911b63f user: dan
2022-04-20
16:44 Reply: Surprising behavior of aggregate JSON functions? artifact: f630ffc4db user: dan
2022-04-16
15:22 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: bf55b5a789 user: dan
2022-04-14
18:34 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 880f31fa3c user: dan
17:33 Edit reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 542982906b user: dan
17:33 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 5cde70092c user: dan
2022-04-07
13:47 Reply: sqlite3 fts5 contentless or content=external table, how store and read a non-FTS column value artifact: 804cc92a00 user: dan
2022-03-23
11:35 Reply: Corrupt FTS5 table after declaring triggers a certain way artifact: 93be31a44a user: dan
2022-03-19
14:15 Reply: Unexpected result from query with window function artifact: c1226f163d user: dan
2022-03-18
06:51 Reply: Performance Analysis artifact: 4b6ee2a416 user: dan
2022-02-25
20:15 Reply: Addressing multiple WITH definitions artifact: 464835f569 user: dan
2022-02-23
11:16 Reply: Conditional Trigger using WHEN clause NOT Working. artifact: 2a2e3020ac user: dan
11:04 Edit: The SQLite SET-AND Gotcha artifact: 731f159fc9 user: dan
11:03 Reply: Set F_FULLSYNC on macOS? artifact: 14469d5fc3 user: dan
2022-02-20
08:22 Edit reply: Slow aggregate query artifact: 6f141af7b9 user: dan
08:17 Reply: Slow aggregate query artifact: d2e506b20b user: dan
2022-02-14
14:28 Reply: increasing page_size not working for >10GB DB? artifact: 3862820843 user: dan
2022-02-04
21:29 Reply: FTS5 error: database disk image is malformed artifact: 5acb884b07 user: dan
2022-01-10
11:42 Reply: pragma table_info Bug artifact: 452941eaa1 user: dan
2022-01-03
11:21 Reply: Reading SQLite database by using C Language artifact: 051f0e1b6e user: dan
11:20 Delete reply: Reading SQLite database by using C Language artifact: 189390a38d user: dan
11:19 Reply: Reading SQLite database by using C Language artifact: 2dcdc3b4c4 user: dan
2021-12-29
21:03 Reply: Typo in the FTS3 documentation artifact: 869703247f user: dan
2021-12-20
11:17 Reply: Building FTS3 as loadable extension artifact: ddb65b06c3 user: dan
2021-12-10
07:05 Reply: Window Function caching? artifact: ea32b8a335 user: dan
2021-12-06
10:55 Reply: Error: stepping, unable to open database file (14) artifact: 95bc75eec3 user: dan
10:51 Reply: Additional .001 .002 .. huge files get created sporadically artifact: 295005c217 user: dan
2021-12-03
14:57 Reply: Journal mode for "" (temp) db cannot be set to WAL? artifact: 4496b903e5 user: dan
2021-12-01
10:55 Reply: Will the database file be corrupted if using MEMORY journal mode ? artifact: 04d41d4b06 user: dan
2021-11-30
14:15 Reply: SQLIte 3.37.0 breaks SQLITE_OPEN_NOMUTEX - TSAN failure artifact: cc6668e7b3 user: dan
10:58 Edit reply: unixFcntlExternalReader not found if using SQLITE_OMIT_WAL artifact: 6b5933cd04 user: dan
10:58 Reply: unixFcntlExternalReader not found if using SQLITE_OMIT_WAL artifact: b5acf19435 user: dan
10:42 Reply: Error while executing query, no column with such name exists artifact: 21e6024666 user: dan
07:14 Reply: compiler warning on Version 3.37.0 (2021-11-27). artifact: fccec89e7d user: dan
2021-10-19
10:59 Reply: SQLite Page Cache Subsystem as Library artifact: 540c87005c user: dan
2021-10-13
15:26 Reply: Different time spent in Windows and Linux artifact: d8db57418b user: dan
2021-09-28
11:24 Reply: Unable to search an FTS5 trigram table when using external content artifact: 413819ed72 user: dan
2021-09-27
15:25 Reply: PRAGMA wal_checkpoint(RESTART) unexpectedly returning SQLITE_BUSY immediately artifact: 32bac245c0 user: dan
2021-09-18
18:13 Reply: sqlite-android-3360000.aar / SQLiteOpenHelper / getWritableDatabase() / unknown error (code 14): Could not open database artifact: 00d636e060 user: dan
2021-09-17
11:25 Reply: Memory-mapped IO used for temp files even though memory-mapped I/O is not used artifact: 04b2595910 user: dan
11:18 Reply: FTS5: use = or MATCH to compare IDs? artifact: 1782f9097f user: dan
2021-09-16
19:43 Edit reply: Javascript enforcement artifact: cbfeca1fc7 user: dan
2021-09-14
14:03 Reply: DB with Fts4 passes integrity check, but throws SQLITE_CORRUPT_VTAB (database disk malformed) whenever column is queried artifact: c8a686f349 user: dan
2021-09-10
11:14 Edit reply: solved disk I/O error on F2FS artifact: 6b076fdf63 user: dan
11:13 Reply: solved disk I/O error on F2FS artifact: edf23e3c3e user: dan
2021-09-03
11:32 Reply: Virtual table ORDER BY and GT/LT (GE/LE) constraints expected behavior - full table scan when not needed? artifact: 5efafa1334 user: dan
2021-09-02
06:32 Reply: SEGV in online backup API artifact: 0707e14052 user: dan