TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

SQLite 3.42.0

250 点作者 nikbackm大约 2 年前

6 条评论

gred大约 2 年前
<i>&gt; Enhance the JSON SQL functions to support JSON5 extensions</i><p>Wait, what&#x27;s JSON5??<p><i>&gt; Object keys may be unquoted identifiers.</i><p><i>&gt; Objects may have a single trailing comma.</i><p><i>&gt; Arrays may have a single trailing comma.</i><p><i>&gt; Strings may be single quoted.</i><p><i>&gt; Strings may span multiple lines by escaping new line characters.</i><p><i>&gt; Strings may include new character escapes.</i><p><i>&gt; Numbers may be hexadecimal.</i><p><i>&gt; Numbers may have a leading or trailing decimal point.</i><p><i>&gt; Numbers may be &quot;Infinity&quot;, &quot;-Infinity&quot;, and &quot;NaN&quot;.</i><p><i>&gt; Numbers may begin with an explicit plus sign.</i><p><i>&gt; Single (&#x2F;&#x2F;...) and multi-line (&#x2F;</i>...<i>&#x2F;) comments are allowed.</i><p><i>&gt; Additional white space characters are allowed.</i><p>Oh crap, the levees have broken!
评论 #35963351 未加载
评论 #35963053 未加载
评论 #35962871 未加载
评论 #35963114 未加载
评论 #35963069 未加载
评论 #35962641 未加载
评论 #35962684 未加载
评论 #35975911 未加载
评论 #35962893 未加载
评论 #35962972 未加载
评论 #35984924 未加载
评论 #35963783 未加载
airstrike大约 2 年前
Is there an unavoidable reason why SQLite won&#x27;t allow foreign keys to be added with ALTER TABLE, only at table creation? The whole &quot;select * into temporary table and create new table with FK constraint&quot; seems so verbose &#x2F; convoluted, my layman&#x27;s mind can&#x27;t comprehend why one can&#x27;t simply<p><pre><code> ALTER TABLE &quot;foo&quot; ADD FOREIGN KEY...</code></pre>
评论 #35963753 未加载
jksmith大约 2 年前
Maybe this comment is worthless and has no information content, but SQLite is in the pantheon of open source projects, along with linux itself.
say_it_as_it_is大约 2 年前
How are people using sqlite within a multi-threaded, asynchronous runtime: are you using a synchronization lock? SQLite seems to &quot;kinda, sorta&quot; support multi-threading, requiring special configuration and caveats. Is there a good reference?
评论 #35964033 未加载
评论 #35964096 未加载
评论 #35964955 未加载
评论 #35963716 未加载
pyrolistical大约 2 年前
Wat &gt; Note that SQLite interprets NaN, QNaN, and SNaN as just an alternative spellings for &quot;null&quot;
maxpert大约 2 年前
Wait! Can I store unicode escaped binary strings in JSON now?