How do you think, if I save PDF file to Blob field in MySql?
Posted:
Tue Aug 22, 2017 9:10 amby dutch
Dear All,
I have step to save receipt in PDF file format. If I save to Mediumblob field in MySql.
1. Is it stable to extract and re-use PDF file?
2. Does it make load time longer, when we fetch data of this table?
Thanks for any idea and suggestion.
Re: How do you think, if I save PDF file to Blob field in MySql?
Posted:
Tue Aug 22, 2017 9:51 amby cnavarro
dutch wrote:Dear All,
I have step to save receipt in PDF file format. If I save to Mediumblob field in MySql.
1. Is it stable to extract and re-use PDF file?
2. Does it make load time longer, when we fetch data of this table?
Thanks for any idea and suggestion.
If you have doubts, use to save another table related to the same key field as the main table
Re: How do you think, if I save PDF file to Blob field in MySql?
Posted:
Tue Aug 22, 2017 2:17 pmby Armando
Dutch:
Cristobal's advice is a great option, my experience
1.- Is it stable ?, Yes, of course it is very stable.
2.- Yes, it takes more time to load the records
an other options are
Tinyblob
Blob
MeniumBlob
LongBlob
Best regards
Re: How do you think, if I save PDF file to Blob field in MySql?
Posted:
Wed Aug 23, 2017 12:33 amby dutch
Thanks Narvarro and Armando,
I have another question, how to preview PDF in Mediumblob field in MySql?
Does the XIMAGE support PDF preview?
I read many post in forum, but it is no success case to preview PDF object?
Thanks in advance for any idea or suggestion.
Re: How do you think, if I save PDF file to Blob field in MySql?
Posted:
Wed Aug 23, 2017 1:11 amby cnavarro
Dutch, some options:
1) For only preview first page of pdf document
viewtopic.php?f=6&t=32550&p=191290&hilit=Reader+Acrobat#p1913782) With an external application
viewtopic.php?f=6&t=32550&p=191295&hilit=sumatra#p1912963) With ActiveX ( search "AcroPDF.PDF.1" )
- Code: Select all Expand view
REDEFINE ACTIVEX oActiveX ID 800 OF oDlg PROGID "AcroPDF.PDF.1"
// Or DEFINE ACTIVEX ...
viewtopic.php?f=6&t=28148&hilit=Reader+Acrobat#p1574193) Other solution ( please read all topic )
viewtopic.php?f=6&t=33439#p197146
Re: How do you think, if I save PDF file to Blob field in MySql?
Posted:
Wed Aug 23, 2017 2:21 amby dutch
Dear Navarro,
Thank you so much for your suggestion.
RICHTEDIT5 and ACTIVEX is working well for a PDF FILE. How to preview PDF data from a field (blob, MySql)?
Thanks in advance.