Re: Is there something easier than ORM?

2009-02-17 Thread Kottiyath
一首诗 wrote: > Hi all, > > Recently I am studying some python ORM libraries, such as sqlalchemy. > > These are very powerful technologies to handle database. But I think > my project are not complicated to enough to benefit from a complete > ORM system. > > What I really want, is some easy ways to

Re: Is there something easier than ORM?

2009-02-17 Thread Diez B. Roggisch
一首诗 schrieb: Hi all, Recently I am studying some python ORM libraries, such as sqlalchemy. These are very powerful technologies to handle database. But I think my project are not complicated to enough to benefit from a complete ORM system. What I really want, is some easy ways to load data fr

Re: Is there something easier than ORM?

2009-02-17 Thread Michele Simionato
On Feb 17, 1:27 pm, 一首诗 wrote: > Hi all, > > Recently I am studying some python ORM libraries, such as sqlalchemy. > > These are very powerful technologies to handle database. But I think > my project are not complicated to enough to benefit from a complete > ORM system. > > What I really want, i

Re: Is there something easier than ORM?

2009-02-17 Thread 一首诗
Thanks for your reply. With sqlalchemy, an mapped must living in a session, you have no way to disconnect it with its session. For example : #- user = session.query(User).first() session.expunge(user) print user.name #Error here #

Re: Is there something easier than ORM?

2009-02-17 Thread Mike Driscoll
On Feb 17, 8:15 am, 一首诗 wrote: > Thanks for your reply. > > With sqlalchemy, an mapped must living in a session, you have no way > to disconnect it with its session. > > For example : > > #- > user = session.query(User).first() > session.expunge(user) > print us

Re: Is there something easier than ORM?

2009-02-17 Thread J. Cliff Dyer
On Tue, 2009-02-17 at 06:15 -0800, 一首诗 wrote: > Thanks for your reply. > > With sqlalchemy, an mapped must living in a session, you have no way > to disconnect it with its session. > > For example : > > #- > user = session.query(User).first() > session.expung

Re: Is there something easier than ORM?

2009-02-17 Thread Philip Semanchuk
On Feb 17, 2009, at 7:27 AM, 一首诗 wrote: Hi all, Recently I am studying some python ORM libraries, such as sqlalchemy. These are very powerful technologies to handle database. But I think my project are not complicated to enough to benefit from a complete ORM system. What I really want, is s

Re: Is there something easier than ORM?

2009-02-17 Thread Tim Golden
Philip Semanchuk wrote: [... snip comments on SqlAlchemy which could likewise apply to other similar offerings ...] I don't intend this as a criticism of SqlAlchemy. On the contrary I am impressed by what it does. But I often see people promoting ORM as the solution to all database access prob

Re: Is there something easier than ORM?

2009-02-17 Thread andrew cooke
Philip Semanchuk wrote: > In short, I gather that others on this list are a lot more fond of > SqlAlchemy and ORMs in general than I am. Granted, my experience is > very limited. I tried to integrate SqlAlchemy in one project, > struggled for a long time to express how I wanted my tables joined, >

Re: Is there something easier than ORM?

2009-02-17 Thread Robert Kern
On 2009-02-17 10:52, andrew cooke wrote: Philip Semanchuk wrote: In short, I gather that others on this list are a lot more fond of SqlAlchemy and ORMs in general than I am. Granted, my experience is very limited. I tried to integrate SqlAlchemy in one project, struggled for a long time to expre

Re: Is there something easier than ORM?

2009-02-17 Thread Martin v. Löwis
> So is there some libraries like that? I always use a DB-API implementation for the database I use, i.e. psycopg/psycopg2. Named tuples are really easy to provide: class NamedTuple: def __init__(self, names, values): for name, value in izip(names, values): setattr(self, name, valu

Re: Is there something easier than ORM?

2009-02-17 Thread alex23
On Feb 18, 3:10 am, Robert Kern wrote: > Its public image definitely suffers from the impression that it's "an ORM" > that > can be compared on equal terms with packages that actually are just ORMs. I > describe it as a very powerful toolkit for solving a wide variety of problems > involving SQL

Re: Is there something easier than ORM?

2009-02-18 Thread Michele Simionato
On Feb 17, 5:35 pm, Philip Semanchuk wrote: > > I don't intend this as a criticism of SqlAlchemy. On the contrary I am   > impressed by what it does. But I often see people promoting ORM as the   > solution to all database access problems, and I certainly don't feel   > like it is. I am also not

Re: Is there something easier than ORM?

2009-02-18 Thread M.-A. Lemburg
On 2009-02-17 13:27, 一首诗 wrote: > Hi all, > > Recently I am studying some python ORM libraries, such as sqlalchemy. > > These are very powerful technologies to handle database. But I think > my project are not complicated to enough to benefit from a complete > ORM system. > > What I really want

Re: Is there something easier than ORM?

2009-02-26 Thread Kevin Dangoor (Mozilla)
On Feb 17, 10:28 pm, alex23 wrote: > On Feb 18, 3:10 am, Robert Kern wrote: > > > Its public image definitely suffers from the impression that it's "an ORM" > > that > > can be compared on equal terms with packages that actually are just ORMs. I > > describe it as a very powerful toolkit for sol