All of these are reasons we use the DB for all dynamically managed content, including binary files. Oracle is absolutely fantastic at this these days. For example, Oracle Text is far superior to the Verity implementation in CF, since the full text query can be included in the SQL statement used to retrieve doc info (including version info and many other things that are more difficult to manage with content written to a filesystem). It also means that if multiple CF servers are used or a DR server is brought online, we don't have to worry about where Verity files were written (the index is all in the DB, with the content, where it belongs). A few years ago BLOBS were bad but things have come a long way.
>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]
![]()
