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'};

    [download]
    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' ) );

    [download]
    Thanks!

    Jason

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom