Re: storing images

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]




>I am searching for tutorials to store and properly display images using
>php-postgresql!
>
>What data type must be the image collumn on my database?
>how can i display the images ?
>how can i control the size of the stored image?

To include large objects (like images) in the database you need to use
BLOBs, I think the type for postgresql is "bytea". Check the docs. I seem to
remember that you inserted them by means of "lo_import" and extracted them
via "lo_export".

I am designing an application that needs images (who doesn't?) but I have
decided to store the images separately as usual images (gif, jpg) and store
in the database the link to those images, so I read the link from the
database and the php script loads the image from the link. I don't have any
special requirement for the security of the images, that is, if you knew the
link yourself you could load it in the browser but that is not important.

Adrian Tineo



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux