Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: •Re: which database is best for perl ?

by Purdy (Hermit)
on Feb 10, 2004 at 16:05 UTC ( #327952=note: print w/replies, xml ) Need Help??


in reply to •Re: which database is best for perl ?
in thread which database is best for perl ?

If I can ask a further question here... I'm moving towards Pg myself (from MySQL) and one "gotcha" that I've come across is getting the insertid from the previously-inserted record. In MySQL, it was something like:
$sth_insert->execute( $chain, 'chain' ); push @relationship_ids, $dbh->{'mysql_insertid'};
In Postgres, I have to do something like this (b/c I don't know any better {yet}):
$sth_insert->execute( $chain, 'chain' ); push @relationship_ids, ( $dbh->selectrow_array( 'SELECT last_value FR +OM entities_id_seq' ) );
Thanks!

Jason

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://327952]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (5)
As of 2019-11-12 03:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (64 votes). Check out past polls.

    Notices?