We are storing images as files with names/paths, metadata, etc. in
PostGIS (as our images are often associated with a location, being
things like field specimen images, or seabed pictures we use PostGIS to
store & query the location info, and UMN Mapserver as the engine driving
a map based i
> Hi,
>
> I would like to store picture in my DB and after to display them on my PHP
> pages.
>
> What is the best solution for that ?
>
> thanks a lot
>
> --
> Alain
>
> Windows XP SP2
> PostgreSQL 8.1.4
> Apache 2.0.58
> PHP 5
>
>
I do with ByteA datatype
On Feb 25, 2007, at 9:26 AM, Tomas Vondra wrote:
Store the pictures in the filesystem and only the path,
description and
other metadata in the database. My suggestion ;-)
Andreas
Don't do that - the filesystems are not transactional (at least not
the usual ones), so you'll lose the abi
Tomas Vondra wrote:
Store the pictures in the filesystem and only the path, description and
other metadata in the database. My suggestion ;-)
Andreas
Don't do that - the filesystems are not transactional (at least not
the usual ones), so you'll lose the ability to use transactions.
Imagi
Hello Tomas,
Tomas Vondra wrote:
Store the pictures in the filesystem and only the path, description and
other metadata in the database. My suggestion ;-)
Andreas
Anyway, I do recommend storing images in the database, using a 'bytea'
column for the binary data (and load them only if reall
This is what i did (to stored pictures in DB)...
but i use the following process :
1.store picture on my localhost db
2. export as SQL statement all pictures from my table :-( ===> it was 7.4Mb
3. import to the remote db hosted by a company.
is there an easy way to store image into a hosted DB
Tomas Vondra <[EMAIL PROTECTED]> schrieb:
>
> >Store the pictures in the filesystem and only the path, description and
> >other metadata in the database. My suggestion ;-)
> >Andreas
> >
> Don't do that - the filesystems are not transactional (at least not the
> usual ones), so you'll lose the
On 2/26/07, Joris Dobbelsteen <[EMAIL PROTECTED]> wrote:
See the discussion "[GENERAL] Database versus filesystem for
storing images" earlier on the List.
And man, do I wish people used threading-capable mailers
and didn't do tofu-posts. :/
- Joris
Cheers,
Andrej
---
Store the pictures in the filesystem and only the path, description and
other metadata in the database. My suggestion ;-)
Andreas
Don't do that - the filesystems are not transactional (at least not the
usual ones), so you'll lose the ability to use transactions. Imagine
what happens when
Andreas Kretschmer wrote:
Alain Roger <[EMAIL PROTECTED]> schrieb:
Hi,
I would like to store picture in my DB and after to display them on my PHP
pages.
What is the best solution for that ?
Store the pictures in the filesystem and only the path, description and
other metadata in the
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alain Roger
Sent: zondag 25 februari 2007 16:57
To: pgsql-general@postgresql.org
Subject: [GENERAL] Best way to store and retrieve photo from
PostGreSQL
Hi,
I would like to store pic
Alain Roger <[EMAIL PROTECTED]> schrieb:
> Hi,
>
> I would like to store picture in my DB and after to display them on my PHP
> pages.
>
> What is the best solution for that ?
Store the pictures in the filesystem and only the path, description and
other metadata in the database. My suggestion ;
Hi,
I would like to store picture in my DB and after to display them on my PHP
pages.
What is the best solution for that ?
thanks a lot
--
Alain
Windows XP SP2
PostgreSQL 8.1.4
Apache 2.0.58
PHP 5
13 matches
Mail list logo