Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
Thanks all,
Ed wrote:
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
Ed wrote:
I guess a pdf file is a binnary file and it will contain characters that
will mess things up, so my question is:
Hi, sorry for the late answer. The reason, until I come up with a better one,
is that I'm doing my own basic
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
Is there a specific reason you want to store this in a database? Why
not use the local (or networked) file system and simply store the
metadata about the PDF in the database?
Cheers,
Jay
Hi Jay,
Could you explain what you mean by metadata
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common binary
format is generally not a good idea.
Alec
Ed
i think he means you store only the name of the document
and the directory location of where it is located.
-Original Message-
From: Ed [EMAIL PROTECTED]
Sent: Mar 7, 2007 3:15 PM
To: mysql@lists.mysql.com
Subject: Re: binary into blob
On Wednesday 07 March 2007 19:28, Jay Pipes wrote
Ed wrote:
On Wednesday 07 March 2007 19:28, Jay Pipes wrote:
Is there a specific reason you want to store this in a database? Why
not use the local (or networked) file system and simply store the
metadata about the PDF in the database?
Cheers,
Jay
Hi Jay,
Could you explain what you
On Wednesday 07 March 2007 21:26, Alexander Lind wrote:
I would put the pdf as a regular file on the hd, and store the path to
it in the db.
Meta data could be things like the size of the pdf, author, owner,
number of pages etc.
Storing binary data from pdf:s or images or any other common
Here's a great article on how to store pdf/whatever binary as blob chunks:
http://www.dreamwerx.net/phpforum/?id=1
On Wed, 7 Mar 2007, Jay Pipes wrote:
Ed wrote:
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file
I have to disagree with most, I would store the entire file in the
database, metadata and all. Better security, if you have a backend
database, it's much harder to get the data than pdf's sitting in a
directory on the webserver. Plus if you ever want to scale to a
multi-webserver environment,
imagine a large system where pdf-files are accessed by clients a lot.
say 1 pdf file is access per second on average.
also say that your database is on a machine separate from the
webserver(s) (as is common).
do you really think its a good idea to pump the pdf data from the db
each time it
I've built systems than stream tons of data via this method, at times
into some impressive requests per second. Also I've exposed files stored
in this manner via a ftp interface with servers able to deliver near wire
speed data in and out of the db storage.
When your into a load balanced
On 07 Mar 2007 at 3:57p -0500, Alexander Lind wrote:
imagine a large system where pdf-files are accessed by clients a lot.
say 1 pdf file is access per second on average.
also say that your database is on a machine separate from the
webserver(s) (as is common).
do you really think its a good
Kevin Hunter wrote:
Grrr. All you lazy top-posters! ;) It seems to me that a case can
be legitimately made for both methods of handling BLOBs. On the one
hand, where speed and/or efficiency (on many different levels) are the
top priorities, it'd be good to keep the DB as trim as possible.
hehe, well said and sorry for the top-posting.
I can only agree, both methods have their merits! :)
Alec
Seems I started quite a debate ;)
I wanted to thank you all again for your opinion and for planting a new seed
of doubt on which direction I'll go ;)
I setup the db as proposed earlier
15 matches
Mail list logo
