Announcement

Collapse
No announcement yet.

saving binary files to a database

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Eric Pearson
    replied
    Shawn --

    Have you checked out the sample programs called SaveLongData.BAS and ReadLongData.BAS, which are included with SQL Tools?

    The only pitfalls that I know about are ODBC driver quirks, such as the one that Bob M. ran into.

    -- Eric Pearson, Perfect Sync, Inc.

    Leave a comment:


  • Michael Mattias
    replied
    >Tags, anyone?

    Someone did put tags on that post, but I'm not even sure "blob" "sql tools" and "pdf" would have helped a whole lot. If you're not using the third-party product Sql Tools, and don't know that 'blob' is an acronym (Binary Long Object), often but not necessarily associated with 'Database,' you're left with "PDF" and who knows how many posts there are here with "PDF" as a subject/tag.

    There's so much stuff on this board now you could almost play "The Google Game" where the winner is whomever can come up with a search term returning EXACTLY ONE 'hit.'

    MCM

    Leave a comment:


  • Gösta H. Lovgren-2
    replied
    Originally posted by Michael Mattias View Post
    The 'subject' of that post sure didn't help your search, either. "Sql Tools and blob fields" is not where I would have started had I been looking for "PDF files to database"
    Tags, anyone?

    ==============================================
    "When you do the common things in life
    in an uncommon way,
    you will command the attention of the world."
    George Washington Carver (1864-1943)
    ==============================================

    Leave a comment:


  • Michael Mattias
    replied
    The 'subject' of that post sure didn't help your search, either. "Sql Tools and blob fields" is not where I would have started had I been looking for "PDF files to database"

    Leave a comment:


  • Shawn Anderson
    replied
    right you are

    http://www.powerbasic.com/support/pb...ad.php?t=41021

    I searched before but this time just searched for posts by Bob.

    Thanks!

    Leave a comment:


  • Michael Mattias
    replied
    Someone here (Bob Melcher?) just posted a question and engendered a lot of responses re options and techniques on this very subject.... Within the last two weeks I'm pretty sure.

    Leave a comment:


  • Shawn Anderson
    started a topic saving binary files to a database

    saving binary files to a database

    When saving database information with attachments like JPG's or PDF files, I've always saved the binary file in it's own directory and simply made a link pointing to it in the database. I have to believe that it is common practice to embed the file in the database.

    To accomplish this, I'm guessing you have some sort of dynamically sized binary field in a table that relates to your main data and that you simply read the file and save it, and reverse the process to write it.

    The main reason I'm doing this is the security issue of leaving say, a sensitive PDF file floating out on a web server or something.

    Any advice or pitfalls I should watch for?

    I'm using SqlTools Pro and a MySql server.

    Thanks!
Working...
X