from Hacker News

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

by iio7 on 8/16/24, 4:37 AM with 2 comments

  • by tazu on 8/16/24, 8:39 PM

    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

  • by jtarchie on 8/19/24, 8:44 PM

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