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 <d...@sqlite.org> wrote: > On Thu, Oct 18, 2012 at 9:03 AM, Mike King <making1...@gmail.com> 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 October 2012 13:17, Joe Mistachkin <sql...@mistachkin.com> 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 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 they >> > are really large, any efficiency gains from using incremental BLOB I/O >> > would probably be minimal. >> > >> > Anyhow, I've created a ticket to track this feature request, here: >> > >> > http://system.data.sqlite.org/index.html/info/32d482b38b >> > >> > Now, it's on the roadmap; however, I'm not sure about the timeline of >> > getting this implemented. >> > >> > -- >> > Joe Mistachkin >> > >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users