Ran across this this morning ... removed in 3.0 (10) Are there any known size limits to SQLite databases?
As of version 2.7.4, SQLite can handle databases up to 241 bytes (2 terabytes) in size on both Windows and Unix. Older version of SQLite were limited to databases of 231 bytes (2 gigabytes). SQLite version 2.8 limits the amount of data in one row to 1 megabyte. SQLite version 3.0 has no limit on the amount of data that can be stored in a single row. The names of tables, indices, view, triggers, and columns can be as long as desired. However, the names of SQL functions (as created by the sqlite_create_function() API) may not exceed 255 characters in length. http://www.sqlite.org/faq.html#q10 ----- Original Message ----- From: "Kervin L. Pierre" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, May 05, 2005 9:45 AM Subject: Re: [sqlite] BLOB read/write in chunks? D. Richard Hipp wrote: > On Wed, 2005-05-04 at 23:31 -0400, Henrik Bruun wrote: > >>Does Sqlite support reading/writing BLOB data in chunks? I'm >>considering storing very large items (200MB+) in BLOB fields. >> > > > With SQLite, the entire BLOB must be read or written all > at once. There is no limit on the size of BLOBs. (The I was under the impression that there was a row size limit of 1 MB. Saw this in documentation somewhere. Was that limit removed? Regards, Kervin
