<i>> Enhance the JSON SQL functions to support JSON5 extensions</i><p>Wait, what's JSON5??<p><i>> Object keys may be unquoted identifiers.</i><p><i>> Objects may have a single trailing comma.</i><p><i>> Arrays may have a single trailing comma.</i><p><i>> Strings may be single quoted.</i><p><i>> Strings may span multiple lines by escaping new line characters.</i><p><i>> Strings may include new character escapes.</i><p><i>> Numbers may be hexadecimal.</i><p><i>> Numbers may have a leading or trailing decimal point.</i><p><i>> Numbers may be "Infinity", "-Infinity", and "NaN".</i><p><i>> Numbers may begin with an explicit plus sign.</i><p><i>> Single (//...) and multi-line (/</i>...<i>/) comments are allowed.</i><p><i>> Additional white space characters are allowed.</i><p>Oh crap, the levees have broken!
Is there an unavoidable reason why SQLite won't allow foreign keys to be added with ALTER TABLE, only at table creation? The whole "select * into temporary table and create new table with FK constraint" seems so verbose / convoluted, my layman's mind can't comprehend why one can't simply<p><pre><code> ALTER TABLE "foo" ADD FOREIGN KEY...</code></pre>
How are people using sqlite within a multi-threaded, asynchronous runtime: are you using a synchronization lock? SQLite seems to "kinda, sorta" support multi-threading, requiring special configuration and caveats. Is there a good reference?