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
See the discussion "[GENERAL] Database versus filesystem for storing
images" earlier on the List.
It started at 31 december 2006 and ended 9 januari 2007.
It goes trough all/most pro/con arguments for different options.
- Joris
From: [EMAIL PROTECTED]
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 ;
12 matches
Mail list logo
