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
>

Reply via email to