Re: AW: AW: [PEAR-DEV] DB_NestedSet_MDB useless

From: Date: Tue, 01 Jul 2003 14:53:16 +0000
Subject: Re: AW: AW: [PEAR-DEV] DB_NestedSet_MDB useless
References: 1  Groups: php.pear.dev 
Request: Send a blank email to pear-dev+get-17901@lists.php.net to get a copy of this message
Hi everybody, I'm currently using the NestedSet package for one of my project. I would say the major inconvenient I went into with NestedSet is that even if it supports DB and MDB drivers, its SQL code is MySQL specific for a few requests. That includes the value2query method too, because for INSERT queries, it generated MySQL compliant SQL code only ! Thus, we have modified a bit the code so that it uses standard SQL and works fine with almost any database DB or MDB has a driver for. We have successfully tested it with MySQL (of course!), PostgreSQL, SQLServer and Oracle 8i & 9i. If you are interested, I can post the modified version or send it. IMHO, it could be a good idea to integrate database compatibility before rewriting some parts of it. Feel free to send me an email, or reply here if any of you feels interested. Cheers, Antoine. -- Antoine ANGENIEUX http://www.clever-age.com Clever Age - conseil en architecture technique GSM: +33 6 63 58 36 95 Tél: +33 1 49 01 28 63

« previous php.pear.dev (#17901) next »