.
- Original Message -
From: [EMAIL PROTECTED]
To: Eve Atley [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 5:42 PM
Subject: RE: Saving file into database
It does make the database larger.. as far as overhead... As you
can't just store the file
On Fri, 12 Mar 2004, Jigal van Hemert wrote:
I've been reading this thread, but I can't see the advantages of storing
files in a database.
I've always had the impression that a *file* system was the appropriate
place to store files.
Scalability, searching, security.. just a few..
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP
headers, we're able to let user download the PDFs without having to
store a
local copy on disk, directly from the database (content-disposition
header).
Hi
Is there an advantage to storing the PDFs directly into the database?
I'm also curious how large this would make a database. Is there any space
saved through this method, or would they still be the same size as the
original PDF?
- Eve
--
MySQL General Mailing List
For list archives:
Erich Beyrent wrote:
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP
headers, we're able to let user download the PDFs without having to
store a
local copy on disk, directly from the
Eve Atley wrote:
Is there an advantage to storing the PDFs directly into the database?
I'm also curious how large this would make a database. Is there any space
saved through this method, or would they still be the same size as the
original PDF?
- Eve
There's a percentage of disk space
I store any kind of files, PDF/word/etc.. I just like not having
lots of directories with 1000's of files each in them... Seems
more organized to me..
On Thu, 11 Mar 2004, Erich Beyrent wrote:
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF
It does make the database larger.. as far as overhead... As you
can't just store the file as a blob.. You'll need some referencing data in order to
find it, and restore it back out of the database..
I just checked out my database (100's of files) which has:
Total file size: 1765.34MB
Mysql
Are you running a web server (or ftp server) as well? Because if you are,
then you can upload the files to a separate directory using perl and just
store the links to that file into a table in your database...
If you're not running a webserver (or ftp)... then lemme konw if you get a
viable
Use the BLOB, Luke!
See your local MySQL manual for details.
We're using BLOBs to store PDF in our database, and through the use of
HTTP headers, we're able to let user download the PDFs without having to
store a local copy on disk, directly from the database
(content-disposition header).
Thanks for all the answers!!!
I have been trying the longblob's and it seems to work!
Now all I have to is to figure out how to read it out.. but how hard can it
be ;)
thanks again for all good suggestions!
/isa
From: Kurt Haegeman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Saving
Yes, it's possible. Just make sure you quote it (see the Perl DBI docs for
the quote method) before you insert it.
j- k-
On Tuesday 09 March 2004 12:49 am, Isa Wolt wrote:
Hi,
I would like to save a binary file into a mysql database, for later being
able to use the file. I am using
Check this article:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Port code/design to perl or whatever client language you want.. mysql
could care less once it's got the data (correctly)
On Tue, 9 Mar 2004, Isa Wolt wrote:
Hi,
I would like to save a binary file into a mysql database,
13 matches
Mail list logo
