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
