Hello,
Do you have some example code for storing images in the database. I'm doing
something similar but storing binary files on the filesystem, but storing
paths in the database. I'm doing this because I don't want searching to
slow down when the image is in the same table being searched. But then I
thought I could just create a relational link to the image/binary table
without needing to search that table.
I'm afraid of a database getting out of synch. like you mentioned. My other
concern is that if I store in the DB, I may reach a filesize limit as the
image/binary database could be as much as 20GB or more. That is the main
reason I store only paths.
----- Original Message -----
From: Dylan Neild <dneild@stripped>
To: James Lyon <james.lyon@stripped>; MySQL List <mysql@stripped>
Sent: Wednesday, December 22, 1999 6:45 AM
Subject: Re: Storing images in tables for web pages?
Well,
For me, it was pretty simple either way, so I wouldn't say you should get
discouraged from going the "image in DB" route.
I personally prefer storing images in the Database, because it means that
getting rid of those images once I'm done with them become very easy, and I
don't have to worry about the database ever going out of sync with the disk,
which was REALLY happening badly when I was doing it the other way (just
storing the paths).
Regards,
Dylan
> From: James Lyon <james.lyon@stripped>
> Organization: Aztec Business Solutions
> Date: Wed, 22 Dec 1999 02:17:36 +0000
> To: MySQL List <mysql@stripped>
> Subject: Re: Storing images in tables for web pages?
>
>> PHP3 is the way to go for this. I'm serving up 1800+ images from a MySQL
>> database with no noticeable performance loss over serving them straight
off
>> the hard disk (MySQL 3.23.7 / PHP 3.0.12 / FreeBSD 3.4-STABLE).
>
> I'm curious -- it actually seems easier to me to store the piccies in a
> directory
> and store the filename since the HTML creation then gets real simple. Er
...
> then
> again, I'm only just about to do this so maybe I'll find out something I
> haven't
> realised!
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread21894@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread21926@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
