TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

The SQLite Database File Format

144 pointsby s16hover 10 years ago

6 comments

jevinskieover 10 years ago
<a href="http://permalink.gmane.org/gmane.comp.db.sqlite.general/90549" rel="nofollow">http:&#x2F;&#x2F;permalink.gmane.org&#x2F;gmane.comp.db.sqlite.general&#x2F;9054...</a><p>Apparently the latest and greatest SQLite is sometimes 50% faster than 3.7.17 released in July of last year. Impressive!<p>I also love using SQLite for testing compiler optimization passes. Their TCL test suite coverage is quite good. Unfortunately, I think you have to splurge tens of thousands of dollars to get the C-based test suite. I believe you can only test full branch coverage with the C test suite.
whittenover 10 years ago
Is SQLite used as the internal database for some popular systems?
评论 #8386456 未加载
评论 #8386812 未加载
评论 #8386576 未加载
评论 #8387173 未加载
评论 #8386828 未加载
评论 #8386886 未加载
评论 #8387363 未加载
评论 #8387789 未加载
评论 #8389062 未加载
评论 #8388512 未加载
评论 #8388853 未加载
sauereover 10 years ago
<a href="http://howfuckedismydatabase.com/sqlite/" rel="nofollow">http:&#x2F;&#x2F;howfuckedismydatabase.com&#x2F;sqlite&#x2F;</a>
评论 #8389049 未加载
rckclmbrover 10 years ago
This is an odd, random thing to be on the front page. Did any event in particular happen to make this come up?
评论 #8386750 未加载
评论 #8385699 未加载
评论 #8385615 未加载
评论 #8385693 未加载
tschernoover 10 years ago
Also very interesting: <a href="http://www.sqlite.org/testing.html" rel="nofollow">http:&#x2F;&#x2F;www.sqlite.org&#x2F;testing.html</a>
jpswadeover 10 years ago
The problem with SQLite is that there&#x27;s no official RFC, it&#x27;s a pseudo database.<p>When you&#x27;re weighing up what to implement, it certainly helps when there is an agreed upon technical specification.
评论 #8387584 未加载
评论 #8387297 未加载
评论 #8387404 未加载