Hello John,
You do not have to load the entire file into memory. The best way is to
memory map it and use the returned pointer to copy it into the RDBMS.
You can retrieve it to a file in a similar way. It helps if you store
the file size in the DB so that you can create a file the correct size
to act as a destination for your memcopy.
It is only a few lines of code to wrap such logic along with the current
Sqlite API.
That's just a great idea. Is there an API in SQLite or should I wrap the
native OS APIs?
THANKS!!!
dimitris