Should I dynamically recreate a PDF, rather than s

Question

I need customers to be able to download PDFs of letters that have been sent to them.

I have read the threads about database versus filesystem storage of documents or images, and it does sound like the consensus is that, for anything more than just a few images, filesystem is the way to go.

What I want to know:

• would a reasonable alternative be to just store the letter details in the database, and recreate the PDF 'on the fly' when it is requested?
• Is that approach superior or inferior to fetching the PDF from the filesystem?

Answer 1

As long as the PDF document is of permanent nature (not just a work doc, but something official signed and sent somewhere else in the company or outside the company), you should have a copy of this PDF file on your network, and a link to this file in your database.

You cannot rely on the available data to reproduce the very same document at a different time mainly because:

1. Data can be changed (yes! suppose that the letter is settled to be signed by Head Of Department, and staff has changed?)
2. Your report format will change (header, footer, logo, etc)
3. The document you produced is kept by somebody else who will make use of the data available in the document.

Answer 2

The question of whether to generate the pdfs dynamically or store them statically sounds more like a question of law than a question of programming.

If you don't have access to legal counsel that can provide guidance on this then it is going to be far safer to err on the side of caution and store them statically.

Answer 3

If it is for archival purposes, I would definitely store the PDF because in future, your PDF generation script may change and then the letter will not be exactly the same as what was originally sent. The customer will be expecting it to be exactly the same.

It doesn't matter what approach is superior, sometimes it is better to go for what approach is safer.

Answer 4

Is there a forensics reason why you have to maintain records of letters sent to customers? If you are going to regenerate on the fly, how do you know that future code changes won't rewrite the letter (or, at least, the customer can make that argument in court if the information is used in a lawsuit)...

Answer 5

Few things to consider, is the PDF generate based on data as it existed at some point in time. E.G. a Bill based on data from the prior month?

If so, Would you use the same template each month to generate this letter? What happens if/when the letter format changes, if you regenerate on the fly it is no longer the same that was sent to them. Is storing the PDF stream into the database a possibility?

I guess what I am getting at, do you need an exact representation of what was sent to the user, or is that flexible?

Answer 6

I'm inclined to say "it depends".

When one document is requested many times, it may be a saving if you compose it on the first request, and retrieve it subsequentially.

OTOH if most requests for a document are of the just-once type, and the creation process doesn't eat up most of your server capacity, on-the-fly will have clear advantage.