postgreSQl and images

Hi,

I create a table with some large object (ref: OID) to store some images.
When my PHP will display some data, it will also display the images stored
as OID.

However, i've read that before i must restore the image by exporting them to
local (on server) file.

isn't it easier in this case, to simply store the path and file name of file
to DB and just read the data to display image on PHP pages ?
what is the purpose in this case to store image a bytea / large object ?

moreover, how my php code will load image from DB and stored there as OID ?
isn't it too much complex in comparison with just storing path and name of
image ?

thanks a lot,

Al.

Relevant Pages

  • Re: [PHP] postgreSQl and images
    ... When my PHP will display some data, it will also display the images ... as OID. ... what is the purpose in this case to store image a bytea / large object ...
    (php.general)
  • Re: [PHP] postgreSQl and images
    ... I create a table with some large object (ref: OID) to store some images. ... When my PHP will display some data, it will also display the images stored ...
    (php.general)
  • Re: Object Oriented Content System - the idea
    ... >I expected php to be smarter then that. ... >form like bytecode in memory for the next request. ... each action added some stuff to a "response" XML document. ... that map/object/data and formats it for HTML display using an includeed PHP ...
    (comp.lang.php)
  • Re: session trouble
    ... Note that you're building your display block AFTER your loop. ... <?php session_start; ... The problem here is going to be since you have multiple school clubs, it's going to be hard to relate a particular club to the entry in your database if it going to be changed. ... Another way is to add a suffix to each field, often times the primary key for the table. ...
    (comp.lang.php)
  • Re: PictureBox max width
    ... many seconds of recording and the rate. ... and that's the length of display problem. ... what I don't understand is why you need to store all this ... no need whatsoever to store the actual bitmap that the data produces. ...
    (microsoft.public.vb.general.discussion)