[DB-SIG] py-postgresql 0.9 Released: Speed & Query Libraries
lists at jwp.name
Wed Jun 17 21:30:15 CEST 2009
On Jun 16, 2009, at 11:51 PM, Michele Petrazzo - Unipex wrote:
> First of all, thanks for the module.
> Two questions:
> - I look around, but I don't find a reply to the question if you
> want to
> "backport" the py-postgresql to the python 2.X line. Have us some hope
> to use it in our "old" projects?
Well, there is pg_proboscis that py-postgresql was based on.
It is quite lacking by comparison, but functional.
But no, I don't plan to backport it.
> - Making some tests with a test db, I see that, like the other
> drivers, the cur.execute("select * from table"), load all the data in
> memory. Can be useful, if possible of course, to not use this lot of
> ram? With psycopg2 devels can use the "named cursor" for solve. Any
> chances to add this type of feature?
It shouldn't be loading it all into memory by default... If it is,
it's a bug.
However, It should be grabbing some pretty big chunks when it needs
more data to supply a fetchXXX request, so if you're looking at a wide
result set, that could use a large amount of memory.
More information about the DB-SIG