Re: postgreSQl and images

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

 



On Saturday 04 November 2006 18:26, Alain Roger wrote:
> 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.

No you don't.

>
> 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 ?

depends.

> what is the purpose in this case to store image a bytea / large object ?

Keeping track af thousands of small images... in my case anyway.
makes it very easy to keep track of what you got'n not.

> moreover, how my php code will load image from DB and stored there as OID ?

the usual way?

> isn't it too much complex in comparison with just storing path and name of
> image ?

depends again. You wouldn't be in my shoes storing all those small images on 
the fs and then keep track of them. 

either you end up with a had as method of grouping them together, 
moreover you can have thousands of small files inside one dir with an id name 
to it, and yes the last one, thousands of directories with one file inside...

no, no and nono

>
> thanks a lot
>
> Al.

-- 
---
Børge
Kennel Arivene 
http://www.arivene.net
---

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux