Thanks Srikanth, I had already found that thread before posting. I just wanted to clarify because there is a lot of conflicting information out there stating SQLite's database size limit. In that thread it states 2 GB. However, reading the limits document ( http://www.sqlite.org/limits.html ) does not seem to reveal a statement about the actual size limit of a database. The maximum string, BLOB, and row is defined as 2 GB. Does this also mean that the size of the database is limited to that value? The only thing that I can find that might be indicative of a maximum database size is the SQLITE_MAX_PAGE_COUNT (1,073,741,823) multiplied by SQLITE_MAX_PAGE_SIZE (32,768), which is 35,184,372,056,064 - only a tab bit more than 2 GB ;-)
Maybe I'm completely wrong here? On Thu, Feb 26, 2009 at 4:23 AM, Srikanth <[email protected]> wrote: > > Refer similar discussion below: > > > http://groups.google.com/group/gears-users/browse_thread/thread/5138ac3bee9f4d1a/bd51a51e7e5d5a1d?lnk=gst&q=database+size#bd51a51e7e5d5a1d > > Srikanth > > On Feb 26, 5:58 am, Michael Wynne <[email protected]> wrote: > > Are there any built-in limits that Gears imposes on the SQLite > > database files? For example, is there anything stopping someone from > > looping infinitely and inserting garbage into a database until the > > disk fills up? > > > > Thanks! > > > > --Michael > -- Michael Wynne
