Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

use Perl Log In

[ Create a new account ]

Alias (5735)

Alias
(email not shown publicly)
http://ali.as/

Journal of Alias (5735)

Wednesday January 16, 2008

07:58 AM

DBD::Pg 2.0.0 coming soon!

[ #35401 ]

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

List all Journal entries

DBD::Pg 2.0.0 coming soon! More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Async++ (Score:1)

by Phred (5358)

Yeah this looks cool. Asychronous query capability, that's hot.
- Re: (Score:1)
  
  by kaare (663)
  
  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: (Score:1)
    
    by phaylon (6115)
    
    Looks pretty straight forward to me [cpan.org] :)
    
    --
    Ordinary morality is for ordinary people. -- Aleister Crowley
    - Re: (Score:1)
      
      by kaare (663)
      
      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: (Score:1)
        
        by stu42j (6348)
        
        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? (Score:2)

by vek (2312)

Alas no, still missing [cpan.org]. 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!