Is there a limit on a datastore? Is there a limit on a table?
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Friday, 9 August 2013 9:17 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLITe space issue On 8 Aug 2013, at 11:52pm, Inna Belakhova <inna.belakh...@melbourne.vic.gov.au> wrote: > We have a database that is 8GB and most of the data is in a RESOURCE > table that contains BLOB type. > > > > Is there a limit on how much data can be inserted into the table? Limits for things in SQLite databases can be found here: <http://www.sqlite.org/limits.html> Item 1 answers your question: by default 1,000,000,000 bytes, with special compilation 2,147,483,647 bytes > Is it possible to convert SQLITe to SQL database and transferring the > BLOB data as well? You can extract the contents of a BLOB field and dump many ways; write it to a file if you want. You might like a command-line shell tool for SQLite: <http://www.sqlite.org/sqlite.html> you can download from the site pre-compiled for various OSes. It will dump the data in SQLite databases as SQL commands. It will dump BLOB fields as hexadecimal octets. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email is intended solely for the named addressee. If you are not the addressee indicated please delete it immediately. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
