BLOB column in the db - upload and retrieval/display

(2 posts) (2 voices)
  1. eugfri, Member

    hi,
    I see some old thread on the forum regarding usage of blob columns:

    https://mydbr.com/forums/topic.php?id=1109#post-3347

    I don't find anything in the docs, but maybe you have created something since the time of the thread above. Is it possible to:
    1) have binary file (pdf, image etc - i.e. not structured delimited data) uploaded and stored in the db BLOB column?
    2) have BLOB column in result set displayed on the report as clickable link (in order to show the actual content of the BLOB)?

    Of course all of this is doable directly in PHP but how can such functionality can be integrated within mydbr application?

    Thank you

  2. myDBR Team, Key Master

    Hi,
    no change there yet. Blobs can be used to display images. Uploading blobs is not yet supported.

    There is little benefit of storing files into the database. In most cases you store the file separately into a filesystem and just store the link to the file into the database.
    --
    myDBR Team


Reply

You must log in to post.