Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-24 Thread Micah Yoder
On Tuesday 15 April 2008 10:27:14 am Dawid Kuroczko wrote: Whch would you suggest? How do they differ? Sorry to bring this back up (I try to keep up with this list but it's hard!), but isn't licensing a concern? If I understand correctly, pygresql is BSD-licensed, but depends on MX which is

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-24 Thread Harald Armin Massa
Micah, psycopg2 has a license extensions which allows basically to use psycopg2 binaries without distributing source code as long as there are no modifications to the psycopg2 C code best wishes Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-20 Thread Paul Boddie
On 18 Apr, 14:12, [EMAIL PROTECTED] (Karsten Hilbert) wrote: If one wants to operate on one/a range of row(s) but the code fetches all rows (for various values of all) then I'd suspect there's something missing in the SQL statement, say, a LIMIT or appropriate WHERE conditions - regardless of

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-18 Thread Paul Boddie
On 15 Apr, 17:53, [EMAIL PROTECTED] (Erik Jones) wrote: On Apr 15, 2008, at 10:27 AM, Dawid Kuroczko wrote: By the looks of descriptions I am slightly inclined towards psycopg2, but I would feel better if I talked with people who actually used these libraries. Most definitely psycopg2,

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-18 Thread Karsten Hilbert
On Thu, Apr 17, 2008 at 04:06:57AM -0700, Paul Boddie wrote: One caveat: psycopg2 doesn't (or didn't) use cursors in a transparent fashion like pyPgSQL does. If you're traversing potentially large data sets, this will mean that psycopg2 will download all the result data into the client

[GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Dawid Kuroczko
So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? How do they differ? By the looks of descriptions I am slightly inclined towards psycopg2, but I would feel better if I talked with people who actually used these libraries.

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Erik Jones
On Apr 15, 2008, at 10:27 AM, Dawid Kuroczko wrote: So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? How do they differ? By the looks of descriptions I am slightly inclined towards psycopg2, but I would feel better if I

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Steve Crawford
Dawid Kuroczko wrote: So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? How do they differ? Well, pygresql seems unmaintained since mid 2006 and the psycopg2 site is currently and regularly down. Neither inspires

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Filip Rembiałkowski
Just a side note: pyPgSQL is broken with standard_conforming_strings = on (see groups.google.com/group/trac-dev) 2008/4/15, Dawid Kuroczko [EMAIL PROTECTED]: So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? How do they

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Karsten Hilbert
On Tue, Apr 15, 2008 at 09:21:19AM -0700, Steve Crawford wrote: So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? How do they differ? Well, pygresql seems unmaintained since mid 2006 and the psycopg2 site is

Re: [GENERAL] Which Python library - psycopg2 or pygresql?

2008-04-15 Thread Greg Smith
On Tue, 15 Apr 2008, Dawid Kuroczko wrote: So I thought, lets learn a bit of Python, and I stumbled upon a choice of these two libraries. Whch would you suggest? Use psycopg2. It's better maintained and has a better feature set at this point. I would specifically recommend that you look