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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

Appropriate Uses for SQLite

84 点作者 vince_refiti大约 10 年前

9 条评论

pstadler大约 10 年前
<p><pre><code> &quot;The SQLite website (https:&#x2F;&#x2F;www.sqlite.org&#x2F;) uses SQLite itself, of course, and as of this writing (2015) it handles about 400K to 500K HTTP requests per day, about 15-20% of which are dynamic pages touching the database. Each dynamic page does roughly 200 SQL statements. [...]&quot; </code></pre> Wait... What? They&#x27;re saying that their dynamic pages are executing 200 SQL statements per request?<p>Off-topic: I enjoyed reading this article which was posted here a while ago <a href="http:&#x2F;&#x2F;www.sqlite.org&#x2F;testing.html" rel="nofollow">http:&#x2F;&#x2F;www.sqlite.org&#x2F;testing.html</a>
评论 #9356195 未加载
127001brewer大约 10 年前
<i>SQLite works great as the database engine for most low to medium traffic websites (which is to say, most websites). The amount of web traffic that SQLite can handle depends on how heavily the website uses its database.</i><p>I am curious to know how many people here solely use SQLite to power the back-end of their web application(s), especially when the page states, &quot;<i>SQLite does not compete with client&#x2F;server databases.</i>&quot;<p>(Or is the page referring to content-management-system-type websites?)
评论 #9354979 未加载
评论 #9355298 未加载
评论 #9354969 未加载
评论 #9357302 未加载
评论 #9354736 未加载
heyalexej大约 10 年前
I was fooled by the name for a long time. &quot;SQLite? That&#x27;s what you use to store 160 phone book entries or something.&quot; How wrong I was.
评论 #9354552 未加载
评论 #9353833 未加载
AdrianRossouw大约 10 年前
There&#x27;s also mbtiles, which is a standard way of storing map tiles in an sqlite database in blob fields.<p><a href="https:&#x2F;&#x2F;www.mapbox.com&#x2F;guides&#x2F;an-open-platform&#x2F;#storing-tiles" rel="nofollow">https:&#x2F;&#x2F;www.mapbox.com&#x2F;guides&#x2F;an-open-platform&#x2F;#storing-tile...</a><p>you can have sqlite databases that are gigs in size and perform great.
baconner大约 10 年前
Can anybody speak to their experience using sqlite for data analysis purposes?<p>Am I wrong in thinking it&#x27;s just plain old row oriented storage and not something more aggregate oriented?
评论 #9355740 未加载
评论 #9355638 未加载
zachrose大约 10 年前
Neat. I&#x27;ve also used an in-memory SQLite db for testing ActiveRecord models.<p>Also, the same list if uses can be applied to nedb as a lightweight alternative to MongoDB.
mike_r_parsons大约 10 年前
Don&#x27;t get mislead by the &quot;lite&quot; in sqlite. I can do about 200k sql requests per second with a sqlite inmemory db and node.js
tootie大约 10 年前
How does SQLite handle replication? Can I have 10 app server nodes reading from one SQLite DB? NFS?
评论 #9354716 未加载
评论 #9355586 未加载
评论 #9355566 未加载
评论 #9354839 未加载
micro-ram大约 10 年前
sqlite.org SSL Cert just expired