[eluser]PhireGuys[/eluser]
[quote author="jpi" date="1278783363"]@Phire_SK
I find this extension useful for 3 things :
* Easily create complex SQL queries. I have never fully understood all the possibles JOIN operations in MySQL. DMZ simplify this.
* DMZ handles very well relationships between tables (one to many, many to many etc..). Foreign keys are handle at the application level, so it's not dependent on your storage engine or RDBS.
* It's a very good extension for RAD. All these get* (see documentation) methods are very powerful. It's almost magic
There are two small drawbacks (IMHO) :
* If you master SQL, then at the beginning you will probably loose time in reading the (very good, very complete) documentation of DMZ. The extension is quite intuitive but still there are "a lot" of things to read and understand at the beginning. Specially for newbies (but, seen you number of posts in the forum, you are not).
* There are some overhead. I dont know how much, but ORM in general are not, i think, compatible with absolute performance. But don't forget you are not Facebook + any small server is quite powerful these days.
Anyway, I warmly recommend you give it a try.[/quote]
Thanks for the detailed explanation. I'll most likely try this out on my next CI build, since that one I think will have a lot of complicated MySQL calls. I've gotten used to figuring it out myself through trial and error, but this might save me a lot of time.
