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..
> Rep
ke a charm ;-)
Regards, Jigal.
- 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 doe
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 fil
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 st
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 lo
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 databa
>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: http://
>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
>heade
Subject: Re: Saving file into database
Date: Wed, 10 Mar 2004 14:25:33 +0100
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
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).
Hop
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 su
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 databas
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 us
13 matches
Mail list logo
