In reference to your needs one more suggestion :
>> If you put the blobs outside of a sqlite database and store your
householding, indexing data inside your sqlite data i would suggest to
use journal mode = on because your journal file and database file
without the blobs has a small amount and if you loose your database due
to a crash inside your application you would possibly loose the
housekeeping data for your raw data in files and that would make the
whole really big amount of storage useless.
>> Keep your indexes and housekeeping data secure (my advice) if you
don't want to gamble !
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users