On 2/1/2012 3:47 PM, Simon Slavin wrote:
5 or 10 tables is not a problem. If you were talking about 50 to 100 tables,
that might start to be a problem. But yes, you can store any number of files
in the following way:
CREATE TABLE resources (
pathAndName TEXT PRIMARY KEY,
content BLOB)
Compressing the resulting SQLite database often results in very small files.
...and if it's going to be a read-only dataset and there's a budget that
allows a one-time charge of US$2500 to be incurred, I would highly
recommend HWACI's CEROD extension that encrypts and compresses the data
store so that to the world outside, it appears to be a "proprietary"
format while your code sees it as a simple SQLite3 database..
Best Regards,
Mohit.
2/1/2012 | 9:22 PM.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
