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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Making a change to SQLite source code

117 点作者 jerryjerryjerry超过 2 年前

6 条评论

under-Peter超过 2 年前
What a nice blogpost! I really enjoyed how Bruno leads us through the whole process including his thoughts and strategies to find the code that needs to be modified and how to do it. Luckily the problem - how to get the bytes of a sqlite record - is small enough in scope to solve in a readable blogpost. That’s a „genre“ i really enjoy.<p>Interesting that he could also do purely by reading the code, or at least presents it that way. I might have started by hooking a debugger to the application and seeing where an insert takes me. Guess many roads lead to rome.
throwaway81523超过 2 年前
Not mentioned is that the full test sqlite test suite is proprietary and you need a super expensive sqlite foundation membership to get access to it. That means (unless you get that membership), your patched&#x2F;forked version will be less extensively tested than the official version. So sqlite is in reality very difficult to fork. Sqlite is very solid, but bugs do sometimes show up in it despite all that testing, and more relevantly, some bugs in development are presumably caught by the testing, which outsiders don&#x27;t have access to.<p>I&#x27;m somewhat leery of hacking on sqlite for this reason. It seems to me like a good candidate for RiiR.
评论 #33347008 未加载
TrustPatches超过 2 年前
Really liked this post. One of the hardest things for me as a junior engineer is navigating complicated codebases and understanding them enough to make the change I want. This gives useful insight on how one might approach a similar problem.
评论 #33342148 未加载
gwd超过 2 年前
The next blog post can be about how to submit the change to libSQL [1], so other people can take advantage of it.<p>[1] <a href="https:&#x2F;&#x2F;github.com&#x2F;libsql&#x2F;libsql" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;libsql&#x2F;libsql</a>
pokstad超过 2 年前
This reminds me: I’m really looking forward to SQLite blob I&#x2F;O being added to the Golang library. There is an open PR to add it. It will enable a lot of interesting use cases revolving around streaming of blobs rather than storing them in memory.
idealmedtech超过 2 年前
Would be great to see how this change affects SQLite’s absolutely gargantuan test suite!