DBD::Pg 2.0.0 coming soon!

Alias on 2008-01-16T12:58:51

I normally don't like to link to other people's blogs, but this is one announcement I think people may have missed, that is extremely exciting.

It looks like the driver to everybody's favourite ACID-compliant database is getting a major new release!

http://xrl.us/beden


Async++

Phred on 2008-01-16T18:09:16

Yeah this looks cool. Asychronous query capability, that's hot.

Re:Async++

kaare on 2008-01-18T08:26:12

I haven't had time to look at the docs. I wonder how async q's are going to work.

Isn't this the first implementation of this feature for a DBI module?

Re:Async++

phaylon on 2008-01-18T14:54:08

Looks pretty straight forward to me :)

Re:Async++

kaare on 2008-01-23T10:03:48

I wonder why it's a DB handle method. How do you keep track of several async queries?

pg_ready can be called on a statement handle. But pg_result can not. So no help there.

Can you only have one async query at any given time? Guess I have to try it out.

Re:Async++

stu42j on 2008-01-23T18:41:01

That's the impression that I get as well - one query at a time. So, you can start a slow query and do other stuff while waiting, just not other database stuff. Or you can have multiple handles. Perhaps one handle for quick stuff and another async handle for the slow queries.

Ooooh, Cursor Support Perhaps?

vek on 2008-01-21T16:07:11

Alas no, still missing. Which is a shame really. You've just got to be careful when iterating over large datasets. Those coming from MySQL or Oracle can get bitten by this. Ahem. No, this never happened to me ;-)

Therefore the execute method fetches all data at once into data structures located in the front-end application. This fact must to be considered when selecting large amounts of data!