Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

I'd missed that - The devil is always in the detail (cue Homer Simpson "DOH!") Thanks again and sorry to be a nuisance On 18 October 2012 14:35, Richard Hipp wrote: > On Thu, Oct 18, 2012 at 9:03 AM, Mike King wrote: > >> At the moment it's difficult to

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

On Thu, Oct 18, 2012 at 9:03 AM, Mike King wrote: > At the moment it's difficult to tell but I envisage 3-4gb being the > maximum. > The maximum BLOB size in SQLite is 1GB. So you would do well to store your images in separate files. > > Cheers, > > Mike > > On 18

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

At the moment it's difficult to tell but I envisage 3-4gb being the maximum. Cheers, Mike On 18 October 2012 13:17, Joe Mistachkin wrote: > > Mike King wrote: >> >> Thanks - sorry to be a pain but is this on the roadmap for the future? >> (For the thing I'm playing with

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Mike King wrote: > > Thanks - sorry to be a pain but is this on the roadmap for the future? > (For the thing I'm playing with this is the difference between storing > images in the database or storing them in the filesystem). > Out of curiosity, what size images are you dealing with? Unless

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Thanks - sorry to be a pain but is this on the roadmap for the future? (For the thing I'm playing with this is the difference between storing images in the database or storing them in the filesystem). Cheers, On 18 October 2012 11:23, Joe Mistachkin wrote: > > Mike King

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

Mike King wrote: > > That's great to know but is this supported in system.data.sqlite > or is there any plans to do so? > It's not being planned yet. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

That's great to know but is this supported in system.data.sqlite or is there any plans to do so? Cheers On Thursday, 18 October 2012, Simon Slavin wrote: > > On 17 Oct 2012, at 11:59pm, Mike King > > wrote: > > > I'm using the latest System.Data.Sqlite with

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

On 17 Oct 2012, at 11:59pm, Mike King wrote: > I'm using the latest System.Data.Sqlite with c# and .Net 4. > > Is there any method of writing to a BLOB in byte array chunks rather > than in one big lump? (I can see how using SQLiteDataReader GetBytes I > can read a blob

[sqlite] System.Data.Sqlite writing chunks to a BLOB

Hi All, I'm using the latest System.Data.Sqlite with c# and .Net 4. Is there any method of writing to a BLOB in byte array chunks rather than in one big lump? (I can see how using SQLiteDataReader GetBytes I can read a blob back in chunks). Best Regards,