NYCPHP Meetup

[nycphp-talk] ORM that uses more advanced MySQL features

y2rob at aol.com y2rob at aol.com
Tue Apr 28 13:42:34 EDT 2009


 i've heard about doctrine and i am not working with it, and i love and hate it.  i think once you spend the time to set it up (minus certain quirks with doctrine migrations),  it will do a pretty decent job, but if you have a large (and i mean large) database, you'll can spend a good amount of time creating your models before you start doing actual php coding.

the point being, is if i were to start a project and if i deemed it worthy to use doctrine as the model in an mvc style project, then it's great (esp for migrations), but if i had an existing huge database and you wanted to refactor the project and wanted minimal development time with great results, i would lean more towards using a framework like codeigniter.  minimal model defining and rapid development with fairly great retrieval of data, and method chaining.

it all depends on the situation

~rob


 ps - sorry for going on the tangent


 

-----Original Message-----
From: Guilherme Blanco <guilhermeblanco at gmail.com>
To: NYPHP Talk <talk at lists.nyphp.org>
Sent: Tue, 28 Apr 2009 12:46 pm
Subject: Re: [nycphp-talk] ORM that uses more advanced MySQL features










Doctrine_View is able to handle views in any DBMS.

Also, you can manually map the view if you want to work on updatable
views, just like Oracle supports.

Stored procedures works on the fly, just like a common function call.
Doctrine does something like that:
In case DQL can interpret it, apply the custom workarounds, otherwise,
just 
bypass it to DBMS driver.

If not enough, you can use Doctrine_RawSql to create your custom DBMS
specific call, when DQL is not smart enough to handle the query
(something like UNIONS or SELECT of a selected query table: SELECT *
FROM (SELECT ...))

If you need more guidance on it, feel free to subscribe to
doctrine-user or doctrine-dev mailing lists.
We also have IRC channel at freenode #doctrine and a forum in the website.

Finally... manual have been updated a lot recently. We're releasing a
printed version in the next couple of weeks.


Cheers,

On Tue, Apr 28, 2009 at 1:37 PM, Marcelo Araujo
<marcelosaraujo at gmail.com> wrote:
> Since when, Guilherme?
>
> On Tue, Apr 28, 2009 at 1:31 PM, Guilherme Blanco
> <guilhermeblanco at gmail.com> wrote:
>> www.doctrine-project.org
>>
>> =)
>>
>> On Tue, Apr 28, 2009 at 1:08 PM, Ajai Khattri <ajai at bitblit.net> wrote:
>>>
>>> Does anyone know of an ORM that can use views and stored procedures in
>>> MySQL?
>> --
>> Guilherme Blanco - Web Developer
>> CBC - Certified Bindows Consultant
>> Cell Phone: +55 (16) 9215-8480
>> MSN: guilhermeblanco at hotmail.com
>> URL: http://blog.bisna.com
>> São Paulo - SP/Brazil
>> _______________________________________________
>> New York PHP User Group Community Talk Mailing List
>> http://lists.nyphp.org/mailman/listinfo/talk
>>
>> http://www.nyphp.org/show_participation.php
>
>
>
> --
> Marcelo Araujo
> Zend Certified Engineer
> http://www.crosi.com.br
> +55 34 9144 1472
> _______________________________________________
> New York PHP User Group Community
 Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/show_participation.php
>



-- 
Guilherme Blanco - Web Developer
CBC - Certified Bindows Consultant
Cell Phone: +55 (16) 9215-8480
MSN: guilhermeblanco at hotmail.com
URL: http://blog.bisna.com
São Paulo - SP/Brazil
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/show_participation.php



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20090428/6d16b73f/attachment.html>


More information about the talk mailing list