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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

SQLite 3.36.0 Changelog

40 点作者 patrickdevivo将近 4 年前

2 条评论

hardwaresofton将近 4 年前
&gt; The &quot;memdb&quot; VFS now allows the same in-memory database to be shared among multiple database connections in the same process as long as the database name begins with &quot;&#x2F;&quot;.<p>Ohh this is interesting -- now SQLite can function as an in-memory shared DB, as long as you have lots of readers and only one writer? IIRC WAL mode doesn&#x27;t apply to in-memory DBs but the locking concurrency docs[0] seem to suggest that most of the time the one writer would hold the RESERVED+ locks and readers would hold the SHARED locks.<p>[0]: <a href="https:&#x2F;&#x2F;sqlite.org&#x2F;lockingv3.html" rel="nofollow">https:&#x2F;&#x2F;sqlite.org&#x2F;lockingv3.html</a>
alecst将近 4 年前
And just yesterday I realized that SQLite didn&#x27;t come with the REGEXP extension by default. How cool.