Re: Object/relational mappers for PHP?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Mitch Pirtle wrote:
Hi gang,

We finally have the underpinnings for database drivers in Joomla 1.5,
and now are tackling the thorny issue of all those MySQL-specific SQL
statements littering the core.

This might help:


http://wiki.cc/php/Object_Relational_Mapping


Joshua D. Drake


One solution of course is to use Christopher Kings-Lynne's(sp?) MySQL
compatibility goodies, but we are also looking to solve this riddle at
the application layer so we can support more databases in the future.

We have implemented some basic SQL generating methods in our database
class (to manage LIMIT and LEFT JOIN differences, for example) but are
primarily relying on ANSI SQL to get around most issues.

I'd like to know if anyone here is already working on a class to
generate SQL at the object level, as opposed to (re)inventing your own
API to generate queries for each database engine.

Anybody else working on something?

--
Mitch Pirtle
Joomla! Core Developer
Open Source Matters

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend



--

           === The PostgreSQL Company: Command Prompt, Inc. ===
     Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
     Providing the most comprehensive  PostgreSQL solutions since 1997
                    http://www.commandprompt.com/




[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux