> I'm all for building apps as infrastructure neutral as > possible, I'm sorry, this is pretty stupid. If you're > going to pick the lowest common denominator from ALL > DB platforms (or even all common ones), you're going > to be hurting. Unless you're building an app for > distribution that has to run on a bunch of platforms > (or building a DB abstraction framework > <cough> Isaac <cough>)
Subtle. :) I guess I do tend actually to advocate some form of db abstraction layer if not necessarily mine (although I've been told that it's unusual in the CF world). But even without an abstraction layer, I would still encourage the use of methods that are cross-platform with regard to the database... not at the expense of being able to meet deadlines of course, but if there's a db-independent solution that can be implemented reasonably easily, I consider that a win because that reduces the amount of work involved in changing the database later if necessary... see below... > leverage the database wherever possible. Structure > your code so that you can replace the DB with another > with a minimum of fuss should you need to, but use your > database. See. :) > Note that I'm not advocating not using caching, but > rather relying on caching just to avoid database > dependance. Caching is very valuable, and can give > HUGE performance increases. Well if you've got a situation where you can both improve performance and eliminate db platform dependancy in an application (as was -- I thought the scenario I was talking about), that would be a win-win situation I would think. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217272 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
