Re: Is there something easier than ORM?

2009-02-26 Thread Kevin Dangoor (Mozilla)
On Feb 17, 10:28 pm, alex23 wuwe...@gmail.com wrote: On Feb 18, 3:10 am, Robert Kern robert.k...@gmail.com 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

Re: Is there something easier than ORM?

2009-02-18 Thread Michele Simionato
On Feb 17, 5:35 pm, Philip Semanchuk phi...@semanchuk.com 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.

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, is

Is there something easier than ORM?

2009-02-17 Thread 一首诗
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 from database,

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 load

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

Re: Is there something easier than ORM?

2009-02-17 Thread Michele Simionato
On Feb 17, 1:27 pm, 一首诗 newpt...@gmail.com 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

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, 一首诗 newpt...@gmail.com 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)

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.expunge(user)

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

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

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, and

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

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,

Re: Is there something easier than ORM?

2009-02-17 Thread alex23
On Feb 18, 3:10 am, Robert Kern robert.k...@gmail.com 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