Reconsider storing PDF files as BLOBs. Just store them as regular files and store the path to the file in the DB.

With lots of large BLOBs, the database gets bloated, the DB dumps become huge, and it can create problems on platforms with a 2GB file limit, like some versions of Linux.

When you stream a BLOB to a client, you must hold open a DB handle the entire time, and if you try to read the whole BLOB into a Perl variable, you will get a large perl process. Your operating system is designed to store files and you will have a much easier time doing so.

At first glance, SPOPS doesn't seem suited to this task at all. It is a framework for saving Perl objects (complex data structures) to a database. Files are not good things to store in databases.

In reply to Re: Anyone using SPOPS to store BLOBs? by bunnyman
in thread Anyone using SPOPS to store BLOBs? by talexb

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.