On Thursday 17 Jul 2003 09:38 am, Taco Fleur wrote: > *** Database > > We have generally always used MySQL as the database for sites we develop > but considering the possible "enterprise" scale nature of this > application we're starting to look elsewhere. In my opinion MySQL isn't > quite there in that respect -- lack of stored procs, relationships etc.
I think the new versions has most of those it. > I have just started looking at PostgreSQL which appears to be a GPL'd > version of Oracle. Has anyone got any thoughts on this? We used to use it, it scaled well to start with, but by the end we were having to rebuild our indexes almost weekly, by hand. > There may also be the need to enable access to the application via > webservices (again, CFCs come in useful) but of course these must be > properly authentised -- only "proper" calls with the appropriate > authentication tokens should be processed. Anyone got ideas on how this > could/should be handled? You may want to post this section on the CFCDev mailing list. There are a range of ways of doing it, from passing username/password as arguemnts when invoking the CFC upwards to building a session/key exchange framework. -- Thomas C Advanced ColdFusion Programmer HANDLE WITH EXTREME CARE: This Email Contains Minute Electrically Charged Particles Moving at Velocities in Excess of Five Hundred Million Miles Per Hour. PLEASE ALSO NOTE: I don't speak for the company that sent this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
