Re: Large objects

Started by Igor Roboulover 25 years ago5 messagesgeneral
Jump to latest
#1Igor Roboul
igor@raduga.dyndns.org

On Thu, Nov 02, 2000 at 10:22:00AM +0000, Evelio Mart?nez wrote:

I want to make a image catalogue. I will use postgresql, perl and php.

What are the advantages of having the images in the database instead of
having them out in a directory?

After all, to show the images I need them on a directory?

Really, you can show images from database, BUT
there are no much reasons put in database something, for which you can't
say WHERE field=some_thing
Better place images into filesystem.

--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

#2Denis Perchine
dyp@perchine.com
In reply to: Igor Roboul (#1)

I want to make a image catalogue. I will use postgresql, perl and php.

What are the advantages of having the images in the database instead of
having them out in a directory?

After all, to show the images I need them on a directory?

Really, you can show images from database, BUT
there are no much reasons put in database something, for which you can't
say WHERE field=some_thing
Better place images into filesystem.

Except on case... When you would like to be sure in transaction safety...

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

#3Igor Roboul
igor@raduga.dyndns.org
In reply to: Denis Perchine (#2)

On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:

Except on case... When you would like to be sure in transaction safety...

Ok, but not for image galery.

--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

#4Igor Roboul
igor@raduga.dyndns.org
In reply to: Igor Roboul (#3)

On Thu, Nov 02, 2000 at 02:39:54PM +0300, Igor Roboul wrote:

On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:

Except on case... When you would like to be sure in transaction safety...

Ok, but not for image galery.

I have answered on argument about transactions

--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744

#5Denis Perchine
dyp@perchine.com
In reply to: Igor Roboul (#3)

On Thu, Nov 02, 2000 at 05:35:04PM +0600, Denis Perchine wrote:

Except on case... When you would like to be sure in transaction safety...

Ok, but not for image galery.

Again... If you can accept that you will have half of image, it's OK.
If not...

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------