hi -
there is far too much in that post to respond to, and i dont have the resources to crack open a huge new API with loads of tests and just run through them all (and i did do the "cracking" part...156 files for a test case posted to a mailing list is 155 files too many)...the various things youre having problems seem to be things that SA can certainly do (such as an inheriting relationship can easily reference itself or sub-types). if you can submit very simple illustrations as single-file test cases (also, one at a time, please), we can look into which features are things that you may be misunderstanding and which point to real deficiencies in SA's abilities. also the various issues and complaints you have with SA (not to mention the various behaviors that you deem "unnecessary") seem more an invite for you to write your own ORM and/or work with SA's code to create something new yourself, since SA's ORM is by no means a "there-must-only-be-one" type of system as you put it...SA's ORM is just one of any number of ways to map objects, it is in fact an approach that values mixing object and relational concepts together so its not appropriate for those who feel that relational concepts should be completely hidden, and it seems you have some very different ideas of how ORM should be done, to which i say, great, write it up and show us ! no need rambling about it/trying to get me to completely rewrite SA to suit a project that seems quite distinct. also i think that "vietnam of computer science" article is total horseshit written by someone who tried and failed to write his/her own object-relational layer at some time, gave up, and decided instead to devote all the rest of his/her energy writing 50000-word metaphorically-broken screeds about how all other ORMs are completely evil, without even trying them. to which I say, if ORMs are evil, then *just dont use them!* i didnt think there was any cabal of gangsters putting a gun to your head. in short, SA is about people *doing things with their databases right now* as opposed to rambling and handwaving about how ORMs should and should not work. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---