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.

Ask HN: What is the biggest size of a SQLite database you have worked with?

4 pointsby iio79 months ago

2 comments

tazu9 months ago
Personally, 10GB. It&#x27;s a database of all &quot;person pages&quot; on English Wikipedia with some extracted text (infobox and sections) compressed using sqlite-zstd[1]. About 350k rows.<p>(I know this is &quot;small&quot; compared to what SQLite can handle, but it&#x27;s the biggest I&#x27;ve worked with. Most of my SQLite databases are under 500MB).<p>[1]: <a href="https:&#x2F;&#x2F;github.com&#x2F;phiresky&#x2F;sqlite-zstd">https:&#x2F;&#x2F;github.com&#x2F;phiresky&#x2F;sqlite-zstd</a>
jtarchie9 months ago
Currently 55GB, for read-only work at the moment. Using full text search, rtree, JSON, and indexes.