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.

SQLite 3.39.2

82 pointsby marcobambinialmost 3 years ago

5 comments

btreecatalmost 3 years ago
I once experimented with using SQLite as a file store for small images (10s of Kb). We had so many images on disk, that a recursive ls command wouldn&#x27;t complete in a single day.<p>At one point we even hit inode limits.<p>I tested out storing the images in sqlite files across a few directories. I also testing using tar and zip storage with the same schema. Turns out the blog post they wrote was right, and SQLite was indeed faster than our normal IO.<p><a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;fasterthanfs.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;fasterthanfs.html</a>
评论 #32184879 未加载
评论 #32184856 未加载
评论 #32184943 未加载
dmitrygralmost 3 years ago
Anytime you think you need to invent a file format for your application, please save yourself the trouble and use sqlite. It&#x27;ll handle consistency, searching, updating, OS-specific quirks, everything.
评论 #32185343 未加载
orangepurplealmost 3 years ago
Why do so many websites urge readers to avoid using sqlite as a production database? From what it looks like sqlite can handle a million daily users
评论 #32185158 未加载
评论 #32186137 未加载
评论 #32185009 未加载
评论 #32185358 未加载
评论 #32185096 未加载
coreyp_1almost 3 years ago
&gt; 1. Add (long overdue) support for RIGHT and FULL OUTER JOIN.<p>Yay!
评论 #32184763 未加载
quaffapintalmost 3 years ago
For something used in so many places for so many reasons it&#x27;s interesting to read everything they test for their releases... <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;testing.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;testing.html</a>
评论 #32185297 未加载