Large Objects

From: Adam Sherman <adam(at)tritus(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Large Objects
Date: 2001-08-11 06:31:37
Message-ID: 20010811023136.F5526@tritus.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm in the middle of designing a file management app in PHP4 using
PostgreSQL, and have a design question:

Should I use large objects?

I'm thinking that since not all databases support BLOBs, maybe I
should avoid them? Can I use a TEXT column with much the same effect?

The 1GB field size limit would be fine.

Note that the app is being prototyped in PHP4, but will eventually (I
hope!) be ported to Java.

Thanks for your help,

A.

--
Adam Sherman
President & Technology Architect
Tritus Consultant Group Inc.
+1.613.255.5164
http://www.tritus.ca

Browse pgsql-general by date

  From Date Subject
Next Message Laurent HERVE 2001-08-11 08:32:32 Showing locks
Previous Message Joe Conway 2001-08-11 02:53:47 Re: Constraint, Rule, or Trigger?