SQLite User Forum

Forum
Login

Most recent threads

2.7 days ago diskused extension outputno replies
3.0 days ago Broken link in the TH3 documentation2 posts spanning 59.1 minutes
3.6 days ago LibreDB Studio: a self-hosted web SQL IDE for server-side SQLite filesno replies
3.6 days ago Planner prefers Playlist=? index over a matching partial index when the constant is a heavily skewed value (after ANALYZE)no replies
3.7 days ago sqlite3_incomplete and comments5 posts spanning 3.2 days
3.7 days ago Windows: WAL open fails with SQLITE_IOERR_TRUNCATE since 3.50.0 when another process still maps the -shm2 posts spanning 3.1 hours
3.8 days ago Lemon: ResortStates cannot be skipped2 posts spanning 14.9 minutes
3.9 days ago opfs-sahpool: report SQLITE_FULL when the browser says storage is full3 posts spanning 5.8 days
4.4 days ago Missing functionalityno replies
4.6 days ago Fixing cross compilation to Windows with Tcl support13 posts spanning 50.1 days
5.7 days ago Question about the spam protection7 posts spanning 9.5 hours
5.9 days ago Recover from sqlite3_reset() error2 posts spanning 6.3 hours
6.8 days ago lemon default YYREALLOC/YYFREE breakage8 posts spanning 5.7 days
7.3 days ago Android bindings: patch adding SQLiteDatabase.loadExtension()4 posts spanning 11.3 hours
7.9 days ago Should SQLite truncate a db file outside a transaction?3 posts spanning 14.0 hours
8.6 days ago Windows: opt-in FILE_SHARE_DELETE so a read-only database can be replaced by rename while readers have it open4 posts spanning 24.3 hours
8.6 days ago Without sqlite_stat1, a short IN list on a joined UNIQUE column wins over x IN (SELECT ...) on a far more selective index. Is this expected?3 posts spanning 24.3 hours
8.8 days ago opfs-sahpool never rolls back a hot journal, so an interrupted transaction stays half-applied13 posts spanning 21.4 hours
8.9 days ago Storing files in the database11 posts spanning 2.0 days
9.1 days ago ASC & DESC integer primary keys11 posts spanning 19.0 hours
9.9 days ago opfs-sahpool: failed installOpfsSAHPoolVfs() can delete all existing databases in the pool6 posts spanning 3.1 days
10.2 days ago Adding a group by to aggregate query of 70 groups out of 1295 rows won't complete; what am I doing wrong?4 posts spanning 7.6 hours
10.8 days ago Warning with GCC-15 and link time optimization (lto) on sqlite3ColumnSetColl3 posts spanning 4.8 hours
12.6 days ago Suboptimal query plan when testing NOT NULL against a VIEW containing a LEFT JOINno replies
12.9 days ago SQLite WASM site does not use SVG logo yet2 posts spanning 50.0 minutes
↓ Older...