Re: [PHP] postgreSQl and images

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

Relevant Pages

  • Re: Simple DBMS in VB
    ... Because you want to store variable length data, ... but complicates updating when changes in the data necessitate ... seem the Genre table and the Album's song lists would not need updating ... is to keep the images in their ...
    (microsoft.public.vb.general.discussion)
  • Re: Simple DBMS in VB
    ... Because you want to store variable length data, ... but complicates updating when changes in the data necessitate ... seem the Genre table and the Album's song lists would not need updating ... is to keep the images in their ...
    (microsoft.public.vb.general.discussion)
  • Re: storing path only to database
    ... Do not store the images in the file, rather store them on the hard drive and ... store the path to them in the Access database. ... Alternatively, you can store images in multiple tables, each one of which is ... Dim MyFolder As String ...
    (microsoft.public.access.formscoding)
  • Create Hyperlinked Images within a Auto Cascading Table PHP
    ... written in PHP within these tables they show images i need these images ... other HTML pages... ... Note these tables are written within the <?PHP> area of the full Script ... Easy - A - Store image in Mysql ...
    (comp.lang.php)
  • Re: Architecture question
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... The fax machine would store incoming images in a windows folder. ...
    (microsoft.public.sqlserver.fulltext)