Thread: Large objects
Hi! Just a question concerning large objects. 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? Thanks Evelio
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
> > 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 ----------------------------------
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
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
> 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 ----------------------------------