HI, Is it likely the maximum BLOB size will be increased in a not too distant future version of SQLite?
In a world of machines where 1TB memory is not unusual the current upper limit of ~2GB is proving to be restrictive for my use. One might suggest that storing binary data of that size using SQLite is abusing SQLite and an alternative, such as HDF , should be used. To a certain extent that is true, but having to manage multiple files with some data in SQLite and other data in HDF files brings along another set of complications. And SQLite reads/writes BLOBs at disk access speeds so SQLite does not suffer from efficiency issues. Plus SQLite supports partial BLOB read/write. Andrew _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users