News for hackers. Stuff that matters.
Re:Ask HN: How much data can a 5MB database store? by shawndumas on Tuesday August 17, 2010 @09:40PM (#1613002)
The Bible, in two different translations, as an MySQL file (though I don't know how optimized it is), with Fulltext Indexes, is 10 mb[1].

 

So one Bible is ~5.

    

Does that help?

 

-------------

[1] http://www.biblesql.net/download

Re:Ask HN: How much data can a 5MB database store? by cperciva on Tuesday August 17, 2010 @07:55PM (#1612818)
Umm... 5MB minus database overhead?
Re:Ask HN: How much data can a 5MB database store? by WCC on Tuesday August 17, 2010 @08:04PM (#1612839)
That was going to my answer, too, so I'll elaborate a bit.

It depends on the format of the database and the contents as well. If all you store is a single 4.9MB image, then there's not much overhead. If you store thousands of short text records, then each one can only have a little data, and will have a lot of overhead.

Re:Ask HN: How much data can a 5MB database store? by wrath on Tuesday August 17, 2010 @08:07PM (#1612843)
5mb compressed minus database overhead?
Re:Ask HN: How much data can a 5MB database store? by andrewstuart on Tuesday August 17, 2010 @11:20PM (#1613139)
About 5MB