We store images as blobs in Firebird without any real problems. The only issue is that once the DB gets to a certain size it can be a pain to do a full backup/restore
-steve On Thu, Nov 14, 2013 at 12:31 PM, <[email protected]> wrote: > > > This is somewhat related to the "Restore Data" topic being discussed today. > > I would like to use Firebird as an archive for a large number of documents > (probably about 10,000) totaling around 100Gb. Each file would be stored as > a BLOB. > > The documents are a generally variety of Open/LibreOffice (SXW, ODT etc), > Word (DOC, DOCX), Excel (XLS, XLSX), PDF and various image formats. > > The reason for using Firebird is to associate a small amount of meta data > with each file. > > Generally the database would reside on a dedicated Linux server, but might > also be copied to a Windows 8 desktop or laptop. > > At the moment my concern is more about data integrity rather than security > (the information isn't very sensitive and both the server and desktop are > behind a reasonably strong firewall) but any thoughts on external access > are also welcome (SSH tunneling?) > > Thanks for comments! > > > This message and any files transmitted with it may contain information > that is privileged, confidential, and exempt from disclosure under > applicable law. They are intended solely for the use of the intended > recipient. If you are not the intended recipient, distributing, copying, > disclosing, or reliance on the contents of this communication is strictly > prohibited. If this has reached you in error, kindly destroy this message > and notify the sender immediately. Thank you for your assistance. > > We attempt to sweep harmful content (e.g. viruses) from e-mail and > attachments, however we cannot guarantee their safety and can accept no > liability for any resulting damage. The recipient is responsible to verify > the safety of this message and any attachments before accepting them. >
