SQLite User Forum

Forum
Login

Most recent threads

10.0 minutes ago opfs-sahpool never rolls back a hot journal, so an interrupted transaction stays half-applied8 posts spanning 16.5 hours
37.8 minutes ago Storing files in the database10 posts spanning 1.9 days
2.2 hours ago ASC & DESC integer primary keys11 posts spanning 19.0 hours
10.1 hours 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?2 posts spanning 4.2 hours
14.2 hours ago Windows: opt-in FILE_SHARE_DELETE so a read-only database can be replaced by rename while readers have it openno replies
16.5 hours ago opfs-sahpool: report SQLITE_FULL when the browser says storage is fullno replies
22.1 hours ago opfs-sahpool: failed installOpfsSAHPoolVfs() can delete all existing databases in the pool6 posts spanning 3.1 days
28.1 hours 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
1.8 days ago Warning with GCC-15 and link time optimization (lto) on sqlite3ColumnSetColl3 posts spanning 4.8 hours
3.5 days ago lemon default YYREALLOC/YYFREE breakageno replies
3.6 days ago Suboptimal query plan when testing NOT NULL against a VIEW containing a LEFT JOINno replies
3.9 days ago SQLite WASM site does not use SVG logo yet2 posts spanning 50.0 minutes
5.1 days ago First stable version of SQLite Edit for PHP is now availableno replies
5.1 days ago (Deleted)no replies
5.9 days ago Is `sqlite3_set_last_insert_rowid()` intended to be restricted to virtual table implementations?4 posts spanning 7.5 hours
7.7 days ago Is it possible to build the whole source tree without amalgamation?9 posts spanning 22.4 hours
7.8 days ago x86 bug: SQLITE_CALLBACK not specified8 posts spanning 151.7 days
8.4 days ago Performance Regression with Semantically Equivalent Predicates9 posts spanning 18.5 hours
8.9 days ago SQLite 3.50: Is there no way to disable rpath?11 posts spanning 1.25 years
9.0 days ago SQLite 3.53.1: incorrect total() result after sliding-window frame transition2 posts spanning 23.7 hours
9.7 days ago Getting Different Results from a view than the select query that makes it.3 posts spanning 59.5 minutes
11.7 days ago [SELECT] Keep most recent record?4 posts spanning 17.4 hours
11.9 days ago CREATE TALE like sqlite_master10 posts spanning 30.5 hours
12.5 days ago FTS5 contentless_delete tables do not seem to maintain the row count4 posts spanning 2.9 days
12.5 days ago HCTree : concurrent inserts against rowid tables conflict2 posts spanning 31.4 hours
↓ Older...