This is also my experience. I spent many hours hacking SO to do what I want, even when it was a simple many-to-one (as apposed to one-to-many) relationship. SA solved this easily with the 'backref' option. (just one example)
I don't think there is any extra typing, because you need all 3 objects to be separate for separate things. It makes it easier to handle MVC separately in my opinion, because the class you map to is totally separate from the way it maps to the database, so you could easily use that class somewhere else, hooking in your own Database/Data management system. The support offered by Mike Bayer is particularly stellar, especially considering he almost single-handedly created and manages SQLAlchemy on his own time. He has personally responded to simple problems I have on more than one occasion. For me SA solved so many problems and made my life as a programmer better. Although there was a bit of a learning curve getting my SO transfered over to SA, it has payed back 10-fold. Activemapper for me caused nothing but problems. The way it uses meta data is crappy, and it does not give you much flexibility with your relationships. I doubt any mapper will preserve all the power that SA contains. As for fighting, if you are fighting with it, usually it just means that you need to read a bit more into the documentation. -percious On Jan 25, 9:14 am, "Lee McFadden" <[EMAIL PROTECTED]> wrote: > On 1/25/07, Leandro Lucarella <[EMAIL PROTECTED]> wrote: > > > > > And another thing I didn't mention: I found myself fighting against the > > tool rather than fighting with the problem too many times. And I hate > > that. At least for my problem I found much more "artificial" SA than SO. > > My feeling was I had to adapt to the tool, fit my problem into it, not the > > other way, as it should be.My experience is the opposite. I was forever > > trying to fight SO to > get it to work for me and having to resort to nasty hacks to get the > intended result. With SA, there's no fighting. The docs are superb, > the mailing list is full of very helpful people and the tool itself is > a pleasure to work with. > > Granted, there's more typing involved (which only really takes a > fraction longer than SO imho, once you get used to SA's syntax) but > with that extra typing comes more flexibility by an order of > magnitude. > > I suppose it all comes down to what works for you. SO might be your > perfect tool, but for me SA rules the roost. :) > > -- > Lee McFadden > > blog:http://www.splee.co.uk > work:http://fireflisystems.com > skype: fireflisystems --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
