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
