SQLite User Forum

Forum
Login

Most recent threads

3.2 hours ago Test for the existence of a property/path in a JSON string?no replies
12.0 hours ago sqlite3 CLI change complaint4 posts spanning 2.3 days
15.5 hours ago SQLite Editor for PHP now availableno replies
16.2 hours ago Document what happens when json_group_{array,object}() operate on empty result set4 posts spanning 2.9 days
17.1 hours ago xUpdate help for virtual table11 posts spanning 2.1 days
1.9 days ago SQLite SEE License Terms and Future Updates2 posts spanning 4.1 minutes
2.5 days ago How to know which Lemon version?no replies
2.8 days ago Broken link in documentation2 posts spanning 4.2 hours
2.9 days ago Double quotes in the constraint name when dropping6 posts spanning 66.0 days
3.4 days ago zipvfs and cerod in one build?7 posts spanning 288.7 days
4.5 days ago Why does SQLITE_FCNTL_PDB exist?no replies
4.7 days ago What happens on UPDATE OR FAIL?6 posts spanning 17.7 hours
6.2 days ago Documentation typo in sqlite.org/c3ref/step.html2 posts spanning 43.4 minutes
6.5 days ago SQLite Tcl Interface: "00000" converted to "0" but only for one variable?5 posts spanning 8.5 days
7.3 days ago SIGBUS in walIndexAppend (truncated SHM index?)2 posts spanning 14.1 hours
7.4 days ago Useful .prompt settings?27 posts spanning 84.4 days
10.3 days ago An rtree REAL `-0.0` comes back as `+0.0` after a temp-table round trip3 posts spanning 3.8 days
12.9 days ago Out-of-bounds read in deltaGetInt() when input contains no in-buffer terminator (ext/misc/fossildelta.c)2 posts spanning 24.0 minutes
13.6 days ago Pterocos: online editor with SQLite support (plus Python, Lua, DuckDB, HTML/CSS/JS)no replies
13.6 days ago A three-column `NOT BETWEEN` returns `1` for every copied row where the original comparison is `0`2 posts spanning 11.6 hours
13.6 days ago `json_quote(0) IN (SELECT rt2_c1 ...)` rejects the only copied rtree_i32 value and turns `AVG(...)` into `NULL`3 posts spanning 11.4 hours
13.6 days ago Request: Support "ON CONFLICT DO SELECT" to match Postgres 19no replies
13.6 days ago `((CASE ... END) IS rt1_c0) IS FALSE` flips from `0` to `1` on copied operands2 posts spanning 11.2 hours
13.7 days ago Does PRAGMA defer_foreign_keys defer RESTRICT actions?4 posts spanning 4.5 hours
13.8 days ago COALESCE with 0 or 1 argumentsno replies
↓ Older...