Subject Re: [firebird-support] Advice on storing large numbers of documents in a Firebird database
Author Steve Wiser
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


On Thu, Nov 14, 2013 at 12:31 PM, <miker169@...> 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.