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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

SQLite 3.38 Released

65 点作者 crawshaw大约 3 年前

6 条评论

solarmist大约 3 年前
Nice to see JSON support no longer needs compile time enabling.
bob1029大约 3 年前
&gt; Added the sqlite3_error_offset() interface, which can sometimes help to localize an SQL error to a specific character in the input SQL text, so that applications can provide better error messages.<p>So, once I get my Sqlite provider updated to 3.38, I will have the ablity to highlight the naughty token directly in the user&#x27;s sql entry box?<p>This could be revolutionary for our internal admin tool UX. If I can flip everything following the offset to some error style class, the user will be able to instantly zoom to what the database is complaining about. In larger queries, this would be even more valuable as locating an offending magic string can take a lot longer.
tiffanyh大约 3 年前
&gt; Enhancements to date and time functions…<p>What’s the rationale for SQLite not having a date&#x2F;time data type?
评论 #30435137 未加载
评论 #30435133 未加载
评论 #30435150 未加载
Loranubi大约 3 年前
Great! Hopefully when Python updates its sqlite library in a few years, it will finally have JSON support. So far it was commonly built without it.
评论 #30438110 未加载
评论 #30439767 未加载
simonw大约 3 年前
&gt; Use a Bloom filter to speed up large analytic queries.<p>I&#x27;d love to know more about this one! Examples of queries it can speed up would be fascinating.
评论 #30440160 未加载
eatonphil大约 3 年前
Just opened a PR against mattn&#x2F;go-sqlite3 to support it and tested the new JSON syntax support in DataStation. This is fantastic!<p><a href="https:&#x2F;&#x2F;github.com&#x2F;mattn&#x2F;go-sqlite3&#x2F;pull&#x2F;1019" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;mattn&#x2F;go-sqlite3&#x2F;pull&#x2F;1019</a>