huge ? text ?? you don't supply numbers so a fully qualified answer may be hard
1) subject to this
Implementation Limits For SQLite[
^] ie 'limits', you may be able to 'zip' compress your file then insert it into a blob
- I'd suggest you write two functions or methods, storeFileAsZip retrieveFileAsZip that wrap the required functions, and maybe give you a stream back in the retrieve case
2) If your compressed (zipped) files are larger than 'blob' max size, you could use a different storage for the files and store the path / access method in the database
You may be able to glean more info/use
Namespace Poco::Data[
^] to help you.
Btw ..if you're going to store a file in a blob, I'd also include a 'checksum' of the original file, so you can verify integrity etc