hibernate didn't magically appear, it was refined with input from users over many years. if you want to help make sqlalchemy better for yours and other usage. its much better to give concrete examples, that can be used to improve it, then making grandiose negative statements. the idea behind sa's orm is indeed to obviate the need for most common application sql, if it fails for some reason on a given example, it would be helpful to actually here what the usage scenario/example is, perhaps you can post a comparison of a simple model between hibernate and sa.
for example.. usage complaints as relates to session, are typically things that can be handled by app server, via app agnostic appserver integration. sa exposes various session/txn layers for application flexibility and for easier integration into frameworks or different programming styles, in much the same way that hibernate does, and arguably sa is more flexible here for different usage modes (although hibernate's scaling/deployment options, ie. caches are much nicer). cheers, kapil On Dec 9, 11:35 am, "flyingfrog" <[EMAIL PROTECTED]> wrote: > Ok, this is my first approach with python + ORM, and i must say i can't > do what i want with it... Before that i used java Hibernate, think you > should know about. > I've tried both SQLObject and SQLAlchemy but both have been a delusion > :(, i'd like to share with you my considerations, hoping in some > suggestions! > > SQLObject forces you to embed "database code" into your model classes, > and i don't really want that. And it's really buggy! Too much for > production usage. > > SQLAlchemy lets you define separately DB code and python classes, but > then you hve a real duplication. And to use database functionalities > you always need to access session objects or connections, making > sql-like queries. And i don't want that. > > Thy're both good projects but none of them has catched the real > objective: no more sql within the application logic. Hibernate does it, > take a look! > > Anyway, maybe i didn't look so much into python world and there could > be other tools, or other ways of using these tools for doing what i > want to, please let me know if you know of any!! > > Bye --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---