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!
