> All I can say is... My condolensces. > Making an application database independent is an > extremely daunting and time-consuming task. > There is no easy way to do it.
You haven't seen the onTap framework I take it. :P I'll admit, it's not been easy to get all the pieces to fit -- some were easy, some were rather challenging... but that's why I've made it open-source, so everyone can benefit. > Since each database engine has many different > rules, procedures and operations, you basically > end up having to write all of the SQL again for > each DB you want to support. Yes and no ... When I build my applications, I generally don't write SQL -- instead I have a series of custom tags and functions which write the SQL for me. The db's don't have to be consistent because my API is consistent. > The only way around this is to write your original SQL > to adhere to the most basic ANSI standard - which is > also hard to do because you then lose the support for > the some of the functionality in the DB you originally > wrote it for. Also not entirely true... I even managed to maintain concatenation, although I haven't used it myself lately. :) > Have a long and serious discussion with the powers that > be at your place if the massive amount of time and effort > (a.k.a. money) needed to make your CMS db independent > will ever be realized in profits from sales. I think he'd be talking to himself... though I could be wrong. :) If we're talking about a large application, yes, there would be some leg-work involved in converting it, but if there's a decent API in place, it can be realized without breaking the bank. 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://macromedia.breezecentral.com/p49777853/ http://www.sys-con.com/author/?id=4806 http://www.fusiontap.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:202285 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
