Re: Queries

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