HNGlance

Top Best New Show

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

https://news.ycombinator.com/item?id=41263208

by iio7 • 2 years ago

4 2 2 years ago

NE

news.ycombinator.com

Related Stories

Loading related stories...

Comments

2

tazu• 2 years ago

Personally, 10GB. It's a database of all "person pages" on English Wikipedia with some extracted text (infobox and sections) compressed using sqlite-zstd[1]. About 350k rows.

(I know this is "small" compared to what SQLite can handle, but it's the biggest I've worked with. Most of my SQLite databases are under 500MB).

[1] https://github.com/phiresky/sqlite-zstd

jtarchie• 2 years ago

Currently 55GB, for read-only work at the moment. Using full text search, rtree, JSON, and indexes.

Source preview

news.ycombinator.com

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms