[wp-hackers] Making WordPress database independent
matthew at mcgarity.me
Mon Feb 7 18:14:52 UTC 2011
The issue of too many platforms to test is mitigated if all of the SQL calls
are encapsulated in wpdb -- right now, that's not the case. If you get to
that point, I still think that you only develop WordPress to function on
MySQL, then leave it up to the third-party people to do the swap-out and
testing for their specific platforms.
On Mon, Feb 7, 2011 at 11:23 AM, Piyush Mishra <me at piyushmishra.com> wrote:
> May be using DAOs will help. we can push all functionality to the DAO of
> respective db layer and simple inbuilt functions from the specific vendor
> can be used where needed and in other databases, the same features can be
> implemented at the code level??
> Just an idea yet. but it seems good to me.
> 1 factory, 1 PDO or similar base class and few interfaces and their mysql
> implementation will get us to where we currently stand with MySQL, we might
> not actually need whole ORMs etc
> On Mon, Feb 7, 2011 at 10:33 PM, Brian Layman <wp-hackers at thecodecave.com
> > On 2/7/2011 11:49 AM, Piyush Mishra wrote:
> >> With NoSQL picking up craze, postgre gaining popularity and WordPress
> >> moving
> >> towards being a complete CMS, its a move that we should make.
> >> Propel might be a good option, may be DAOs.
> >> But this option is good for progress of the CMS as a whole.
> >> I bet people will start discovering new areas for improvement within the
> >> core as they implement database abstraction.
> > Will they? Admittedly anything that causes people to look at code again
> > can do that, but would it introduce any major improvements? Remember -
> > feature that isn't supported in MySQL and all our "supported" database
> > engines would be excluded from use.. Heck, we can't even generically use
> > features that require MySQL 5.0 yet (assuming 3.1 hasn't dropped before I
> > hit send).
> > I'm really curious to see how having access to stored procedures,
> > views will affect the WordPress Core. I wonder where that rabbit trail
> > lead us.
> > --
> > Brian Layman
> > http://eHermitsInc.com
> > Managed WordPress Hosting
> > _______________________________________________
> > wp-hackers mailing list
> > wp-hackers at lists.automattic.com
> > http://lists.automattic.com/mailman/listinfo/wp-hackers
> Piyush Mishra
> Life's Short, Live it to the maximum
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers