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
On 5/5/2005 at 07:58 Henrik Bruun wrote:
>Thanks. If I try to break these 200MB files into smaller chunks
myself
>and insert the pieces into individual rows are there any
recommendations
>as to a row size (10K, 64K, 1MB...)? and do I need to make any *.h
>constant file changes to indicate t
On Thu, 2005-05-05 at 09:45 -0400, Kervin L. Pierre wrote:
> I was under the impression that there was a row size
> limit of 1 MB. Saw this in documentation somewhere.
>
> Was that limit removed?
>
Row size limits were removed in version 3.0.0.
--
D. Richard Hipp <[EMAIL PROTECTED]>
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:
Sent: Thursday, May 05, 2005 9:45 AM
Subject: Re: [sqlite] BLOB read/writ
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 s
Thanks. If I try to break these 200MB files into smaller chunks myself
and insert the pieces into individual rows are there any recommendations
as to a row size (10K, 64K, 1MB...)? and do I need to make any *.h
constant file changes to indicate that I want to work with larger row
sizes (or wa
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. (T
On May 4, 2005 09:31 pm, Henrik Bruun wrote:
> Does Sqlite support reading/writing BLOB data in chunks? I'm
> considering storing very large items (200MB+) in BLOB fields. Many
> other DB libraries have ways to access these large binary items in
> blocks and I was hoping Sqlite had such a facilit
Does Sqlite support reading/writing BLOB data in chunks? I'm
considering storing very large items (200MB+) in BLOB fields. Many
other DB libraries have ways to access these large binary items in
blocks and I was hoping Sqlite had such a facility too. Any
recommendations on realistic row size
9 matches
Mail list logo
