Re: Queries - Mailing list pgsql-advocacy

From Christian Voelker
Subject Re: Queries
Date
Msg-id 5B88F6A6-3084-4410-9962-542605DC4BAE@gmx.net
Whole thread Raw
In response to Queries  ("Anindya Bhattacharyya" <anindya.bhattacharyya@cmcltd.com>)
List pgsql-advocacy
Am 21.01.2008 um 08:47 schrieb Anindya Bhattacharyya:

> Kindly let me know whether post GresSql

PostgreSQL or Postgres as an acceptable shorthand
(sorry for being picky with this, but there is a
lengthy discussion going on how to ensure that
related information is found)

> is capable of storing images

Yes. You might want to have a look at

<http://www.postgresql.org/docs/8.2/interactive/largeobjects.html>

> and what is the maximum size of such images that the database can
> handle.

I dont know of a limit.

Storing BLOBs is a special topic. There are people
on this list who told they use it in production,
but I personally believe that you have to have a
very good reason to do so. Portability is not neces-
sarily one of them. There are abstraction layers
for using a separate bitstore within a filesystem
like Storage Resource Broker SRB so that you have
to store only the path in the db. DSpace is an
implementation example in Java for this approach.

> Also whether it is capable of biometric identifications

I cant imagine which datatype this should be exactly.
Maybe you define your own type? Look here:

<http://www.postgresql.org/docs/8.2/interactive/datatype.html>
<http://www.postgresql.org/docs/8.2/interactive/sql-createtype.html>

Bye, Christian


pgsql-advocacy by date:

Previous
From: Enrico
Date:
Subject: Pgtheme: PostgreSQL theme for drupal 5.x and 6.x
Next
From: Richard Broersma Jr
Date:
Subject: Re: Sun and SAP invest in Greenplum