Re: [sqlite] How to insert a binary file into the database of sqlite in C++?

[Dennis Cote]

我本楚狂人 wrote:

I have search with Google , and find these information as below
sqlite3_prepare(..., "insert into foo values(?);", -1, &stmt, ...);
sqlite3_bind_blob(stmt, 1, "bar", 3, SQLITE_TRANSIENT);
sqlite3_step(stmt);

But if there is a file in this path "C:\a.mp3",
I use 
"ifstream mp3("C:\\a.mp3")
open this file .

Then I don't know how can I insert it  to the database with the
pointer "sqlite3 *db; "
(the database has two column,
the first's type is text(to write the name of file)
;
the second's type is blob(to write the binary file ) )

Would you please give me some code about this problem?Thank you.

And another question,
What's the lastest parameter's mean of sqlite3_prepare?
I have read the help of this problem , but I can't understand.
 

This (or something like it) should do what you want, but I'm not sure if 
putting large objects like MP3 files into the database is really a good 
idea. Others have said they had better performance using the file system 
to store large files and simply saving the file names in the database.

ifstream mp3("C:\\a.mp3");
mp3.seekg(0, ios::end);
long sz = mp3.tellg();
mp3.seekg(0, ios::beg);
stringstream sbuf;
sbuf << mp3.rdbuf();
char* buf = sbuf.str();

sqlite3_prepare(..., "insert into foo values(?);", -1, &stmt, ...);
sqlite3_bind_blob(stmt, 1, buf, sz, SQLITE_TRANSIENT);
sqlite3_step(stmt);

HTH
Dennis Cote