Re: Best way to store and retrieve photo from PostGreSQL

Поиск
Список
Период
Сортировка
От Brent Wood
Тема Re: Best way to store and retrieve photo from PostGreSQL
Дата
Msg-id 45E2100B.2060706@niwa.co.nz
обсуждение исходный текст
Ответ на Re: Best way to store and retrieve photo from PostGreSQL  (Kenneth Downs <ken@secdat.com>)
Список pgsql-general
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 image selection tool - www.atlasmd.com)

Atlas originally used Firebird RDBMS for image data, but was migrated to
PostGIS to fully support OGC compliant spatial functionality.

The additional step we have implemented to ensure a two way link between
the images & the data is to write the db primary key to an EXIF field in
each image as it is uploaded. This means that given an image, we can
access it's data from the DB, (by looking up the key which is embedded
in the image) instead of the usual approach which only permits a link
the other way.

Cheers,

  Brent Wood

В списке pgsql-general по дате отправления:

Предыдущее
От: "Robert Haas"
Дата:
Сообщение: Re: complex referential integrity constraints
Следующее
От: Filipe Fernandes
Дата:
Сообщение: Re: General Ledger db design