> From: [email protected] [mailto:[email protected]] On Behalf Of John > Slee > > On 23 March 2013 20:36, Edward Ned Harvey (lopser) > <[email protected]> wrote: > > If you build an application that depends on specifics of the DB, then > > you're making yourself inflexible to switch to a different DB. It is > > advisable in most cases, to build a layer of abstraction in your data > > model, away from the DB. So you could easily switch the underlying > > DB if you wanted to. But that's not always possible, and I don't > > have any simple way of telling you how to do that. > > Totally disagree here. > > By doing this you reduce the usable database feature set to the lowest > common denominator > > How anyone can get away with buying [often very expensive] database > licenses and then deliberately not using most of the features they've > paid for on nothing more than a _fantasy_ that they might later switch > databases, is beyond me.
I agree with you, and I agree with what I said, that you disagreed with. ;-) We just have apparently a different perspective on what you're likely to do in the future Here's what it boils down to: If your product is a product, that you license and distribute to your customers, then you'll likely have an advantage being compatible with multiple DB's, unless you can make an assumption about their environment that makes it safe for you to narrow the DB compatibility list. If your product is a service such that you have unilateral and proprietary selection of the DB and architecture, or if you deploy your product to customers and can safely make assumptions about their environment, or there's a clear and specialized advantage to running your specific work load on a specific DB (which is a rare situation), then it likely benefits you to develop your app specialized to that particular DB features. _______________________________________________ Discuss mailing list [email protected] https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss This list provided by the League of Professional System Administrators http://lopsa.org/
