Should I Store My Data in a Database Or Should I Just Store the PDF?

Upload and start working with your PDF documents.
No downloads required

How To Create PDF Online?

Upload & Edit Your PDF Document
Save, Download, Print, and Share
Sign & Make It Legally Binding

Easy-to-use PDF software

review-platform review-platform review-platform review-platform review-platform

Should I store my data in a database or should I just store the PDF documents, that I will eventually create, on the server?

Depends, you can either store the path to the file and the filename as strings in the database and then store the file in the correct place, or you can store the file itself as a BLOB. advantages of using a BLOB is you can index the contents of PDF’s (and office documents) in MSSQL Server, this can be very nice for a library application as you can use TSQL statements to search through document contents. How to search pdf contents in SQL Server you can do similar in other databases by storing paths and filenames in the database, then ocr’ing the file and storing the results of the OCR as another database field, obviously this can take up a lot of space. Edit. don't know why I put ocr there… this wouldn't actually be very effective, I meant use ghostscript to parse the pdf

PDF documents can be cumbersome to edit, especially when you need to change the text or sign a form. However, working with PDFs is made beyond-easy and highly productive with the right tool.

How to Create PDF with minimal effort on your side:

  1. Add the document you want to edit — choose any convenient way to do so.
  2. Type, replace, or delete text anywhere in your PDF.
  3. Improve your text’s clarity by annotating it: add sticky notes, comments, or text blogs; black out or highlight the text.
  4. Add fillable fields (name, date, signature, formulas, etc.) to collect information or signatures from the receiving parties quickly.
  5. Assign each field to a specific recipient and set the filling order as you Create PDF.
  6. Prevent third parties from claiming credit for your document by adding a watermark.
  7. Password-protect your PDF with sensitive information.
  8. Notarize documents online or submit your reports.
  9. Save the completed document in any format you need.

The solution offers a vast space for experiments. Give it a try now and see for yourself. Create PDF with ease and take advantage of the whole suite of editing features.

Customers love our service for intuitive functionality

4.5

satisfied

46 votes

Create PDF: All You Need to Know

This would make for a much better Search feature, not sure how useful this would be except perhaps if you wanted to store files in an external disk or another source. To make this work, you would have to install a PDF OCR module like this, which has been built for use in MySQL. (There are some prebuilt ones that you can install too.) Then you would have to configure the mysql.pdf module to use the PDF OCR module. This means you would have to create a function call to the PDF OCR module to perform the OCR of the PDF, then call this function, for example, mysql.pdf.ODR(“C:\path\to\file.pdf”, function(SQL, result) {var results = result.data; // Add custom metadata about the PDF to the PDF itself, and then display a custom meta-table}) To store text files, you'd need to have the functions from 'File' as well. (Some database engine support.