How do you think, if I save PDF file to Blob field in MySql?

[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.

[cnavarro]

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

[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

[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.

[cnavarro]

Dutch, some options:

1) For only preview first page of pdf document

viewtopic.php?f=6&t=32550&p=191290&hilit=Reader+Acrobat#p191378

2) With an external application

viewtopic.php?f=6&t=32550&p=191295&hilit=sumatra#p191296

3) 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#p157419

3) Other solution ( please read all topic )

viewtopic.php?f=6&t=33439#p197146

[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.

Dutch, some options:

1) For only preview first page of pdf document

viewtopic.php?f=6&t=32550&p=191290&hilit=Reader+Acrobat#p191378

2) With an external application

viewtopic.php?f=6&t=32550&p=191295&hilit=sumatra#p191296

3) 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#p157419

3) Other solution ( please read all topic )

viewtopic.php?f=6&t=33439#p197146