Semantics and methodology of use aside, SQLite is the same as MySQL, MSSQL, Access, etc, in that it is a tool to store and retrieve bytes in a retrievable way via some kind of structured language. None of mentioned tools actually do any sort of presentation of said data. "From the factory", SQLite at best contains a command line tool to pull text out of the database using a query language. MySQL is pretty much the same as well. MS being MS, its administration tools work via a GUI in which what is read from the database presents the data in whatever format it thinks it should be done, however, the back end engine stores the data.
There are, of course, 3rd party tools across the board that willl do the image processing for you, so long you give whatever is presenting the information the proper information. With MySQLAdmin, for instance, you can store information that a particular field should be treated as an image, WAV, etc. I use SQLite Expert which optionally figures out what kind of blob data it is on its own and presents it within the UI. As for storing blob information that should be placed in a certain location, IMO, store all blobs in a table with a 1:1 PK:FK relationship outside of what data you want. So for instance, something of the sort tImageList ImageID:integer as PK ImagePath:char ImageDetails:char tImageBlob ImageID:integer as FK to tImageList.ImageID ImageData:Blob On Thu, Apr 28, 2016 at 2:27 PM, deltagamma1 at gmx.net <deltagamma1 at gmx.net> wrote: > What is a convenient way to store the path from a external blob (jpg, > pdf) ? > How can I retrieve this blob ? > Is there a Frontend which opens the jpg directly from the listed > table-content ? > > 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 just discovered recently sqlitespeed, but do not know how > to handle the problems described above. > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
