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.
Daniel Önnerby wrote:
The questions about saving files in a database is a reoccurring subject
of this mailing list.
How about adding a feature request for something like a
sqlite3_bind_file() to load a file into a statement and maybe a
sqlite3_column_savefile(). I guess this could solve some things like not
loading the whole file into memory and instead stream the file on commit.
Oracle has something similar like this in the PHP-implementation (
http://se2.php.net/manual/en/function.oci-lob-import.php )
Personally I think that files should be save like files on the filesystem.
Best regards
Daniel
Eduardo Morras wrote:
At 19:00 18/03/2007, you wrote:
Hello John,
thanks for the valuable piece of advice. The idea is that either
1) I store data in tabular form and work with them
2) I create a table of blobs and each blob is the binary content of a
file
(2) is my method in question, for (1) we all know it works. So I
turned to
SQLite just because it seems that it is a lighweight single file
database.
So, even if i don't like (2), I can setup an implementation where I
have a
file system inside a fully portable file.
BR
dimitris
You can use zlib to dwhat you want. It has functions for add and
delete files, it's flat file and provides medium/good compression. You
can store your file metadata on SQLite as zip filename, name of the
binary file, an abstract or even a password for zip file.
HTH
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
