Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

•Re: which database is best for perl ?

by merlyn (Sage)
on Feb 09, 2004 at 12:18 UTC ( [id://327610]=note: print w/replies, xml ) Need Help??


in reply to which database is best for perl ?

For a "serverless server", my preferred choice is DBD::SQLite, and for a full-featured server, I recommend and prefer DBD::Pg (and thus PostgreSQL).

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.

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

Replies are listed 'Best First'.
Re: •Re: which database is best for perl ?
by Purdy (Hermit) on Feb 10, 2004 at 16:05 UTC
    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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://327610]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2024-04-19 22:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found