On Thu, 28 Apr 2016 20:27:17 +0200 "deltagamma1 at gmx.net" <deltagamma1 at gmx.net> wrote:
> If I store the blob directly in the sqlite, is there a way to open the > blob directly with the respective programm (e.g. irfanview or a pdf > with acroread) ? I have heard of a FUSE filesystem implemented with SQLite. I don't know if it exposes tables as files, or anything like that. If you're going to use an external program like acroread to view the blob, you're pretty much forced to provide it with a filename, hence you'll have to write your blob to a file, and give the application that filename. A few such programs might be willing to read from standard input, in which case you could provide a pipe. Or you might be able to use a named pipe (mkfifo) instead of a temporary file. I don't know a way to write binary data to a file using the command-line tool. Maybe there's one out there someone else knows of. --jkl
