Ian, you might be interested to know that I only use the lower-level select, update, etc. capabilities of SQLAlchemy and have no current plans to use the mappers. I have a lot of SQL experience and just haven't found that higher level of abstraction useful in my applications. However, I do find SQLAlchemy's clean API for lower-level SQL query construction to be outstanding, and don't mind a bit that it has "too much" capability for me. And it's certainly not "all at once"; there's a clean break between SQL-level operations and the ORM capabilities.
So why is it unrealistic to imagine that these lower-level capabilities of SQLAlchemy, which are already in place, working, and wonderfully documented, could be adopted as the universal solution you're looking for? If there's something in particular about those capabilities that you don't like, I'm sure constructive suggestions would be welcome. Best regards, Ed Ian Bicking wrote: > Ed Suominen wrote: >> The question I would ask is this: What does SQLAlchemy lack that is >> sought in this proposed SQL-API, and how much demand is there for that >> functionality? > > It's not what SQLAlchemy lacks, it's what it has. It's too much all at > once. It's scope does not fit what I want, and I'm pretty sure I'm not > alone on that; clearly that opinion is not universally held (certainly > not on sqlalchemy-users), but it's also unrealistic to imagine that > everyone is going to use SQLAlchemy. But there are things everyone can > agree on; everyone agrees on db-api, for all its flaws, because it's > easier to build on than replace. I think there is functionality not > currently in db-api which can be similarly universal. > > It's this scope that defines SQL-API, not the code -- if all the code > I've written for (or copied into) sqlapi gets blown away and replaced > (which is not impossible), that would not bother me at all. I'm not > possessive about the design or implementation, which is why I would be > quite happy to have Igor or Clark or anyone else contribute to this. > > ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
