We built Zurmo, a Yii based CRM application, and chose RedBeanPHP because we felt it was a better solution for our ORM needs. It has 2 modes, frozen and unfrozen which allow easy development without having to worry about the schema. Also, we have added an auto-build functionality for the database schema so that you don’t have to worry about how the schema is constructed. We also like how it keeps the beans decoupled from the models in the application.
We don’t use Yii active record at all. We developed our own base model that is extended by all models that we are using in the system, and that model is RedBeanModel(located in app/protected/extensions/zurmoinc/framework/models). With this setup, we don’t need to write any sql queries (actually almost any because some some queries are database specific - check DatabaseCompatibilityUtil), RedBeanPHP cares about all actions on database (creating tables, updating them and so on). Maybe you want to download Zurmo to see how we have done this?
Thanks for the reply. I didn’t realise what you did do with and how. I’m still to php but with your explanation I should be able to figure out some more things. For now I also have it working with loading and unloading as described in my link above.