space to run with BLOBs then go for it...I personally and have always been
warned off using them from various sources...they are not user friendly true
that may be changing but in essence there really should be a need for them
..if you can use a pointer to a physical object).
There is a saber to everones foil on this issue....like someone mentioned
and maybe I was a tad strong and single minded but I do think BLOB's are a
just not good for such things as Web Apps...and using with CF
_____
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: 21 September 2004 17:01
To: CF-Talk
Subject: Re: BLOB
> Well yes and no, it's not just my opinion its also good SQL practice,
> Storing data in BLOB's and CLOB's is not good full stop. It leads to
says who?
> If you can give me a valid business case of storing data in this matter
> which overrides the fact its bad practice then I am all ears.
multiuser, continuous data, data integrity, transactions, business rule
implementation, centralized storage and management, not having to manage
millions of files, etc. pretty much every reason why you'd use a db in the
first place. the whole GIS industry is running its enterprise databases on
modern BLOB (spatial) technology. ibm, oracle, ms, esri, mapinfo, etc. have
all spent a bundle on this technology. even freebies like postgres (postGIS
is actually pretty slick) & mySQL are on the bandwagon.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
