Re: [DB-SIG] SQLAlchemy and py-postgresql?

2009-04-07 Thread James Pye
On Apr 7, 2009, at 11:55 AM, Marco A. Gonzalez wrote: I understand that py-postgresql provides a DB-API 2.0 interface for using a PostgreSQL database. However, when I read about SQLAlchemy at http://www.sqlalchemy.org/docs/05/dbengine.html#supported-dbapis I saw that it uses psycopg2 for sup

Re: [DB-SIG] PEP 249

2009-04-07 Thread M.-A. Lemburg
On 2009-03-29 00:40, Adam wrote: > Suggestion: > Cursor execute function return self (cursor) to allow for code like: > cursor.execute(SQL).fetchall() > instead of > cursor.execute(SQL) > cursor.fetchall() DB-API modules are free to implement this. The cursor.execute() return value is not defi

[DB-SIG] SQLAlchemy and py-postgresql?

2009-04-07 Thread Marco A. Gonzalez
I'm trying to understand all the different pieces I need to use a database from Python, and I found SQLAlchemy and it seems "good" (without really knowing what I'm talking about yet.) I understand that py-postgresql provides a DB-API 2.0 interface for using a PostgreSQL database. However, w

Re: [DB-SIG] ORA-03113: end-of-file on communication channel\012 error

2009-04-07 Thread Dennis Benzinger
Am 07.04.2009 13:36, Wong Wah Meng-R32813 schrieb: > Hello guys, > > I would like to post a question on an issue that I have encountered on > an AIX 5.3 box. I intermittently encountered this issue when my > application access to database. Based on my troubleshooting with Oracle > DBA, I think I c

[DB-SIG] ORA-03113: end-of-file on communication channel\012 error

2009-04-07 Thread Wong Wah Meng-R32813
Hello guys, I would like to post a question on an issue that I have encountered on an AIX 5.3 box. I intermittently encountered this issue when my application access to database. Based on my troubleshooting with Oracle DBA, I think I can rule out the cause of this is in the Oracle, as the SQL does