Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 Perl & Postgresql
Google
Post new topic Reply to topic
Author Message
ioconnor
 
 


Joined: 01 Apr 2006
Posts: 4

PostPosted: Wed Jul 26, 2006 8:22 pm Reply with quoteBack to top

I'm trying to offload some of the webserver work to be run via a script instead of tying up the users response. I wanted to write it in perl. However perl with postgresql is not supported while mysql is. Any chance of supporting this and instructions on how to set it up with my current triad system?

Here is a the code I used to determine mysql is supported but that the DBD for postgresql wasn't installed.

#!/usr/bin/perl -W
use strict;
use DBI;

# Get the list of drivers from the DBI
my @driver_names = DBI->available_drivers();

# Print the name of each driver
foreach my $driver (@driver_names) {
print("Driver: $driver\n");


And thank you very much for making everything so far run so smoothly. It's been a real pleasure being able to use apache, perl, postgresql, etc., without having to be an admin.
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Sat Jul 29, 2006 7:52 am Reply with quoteBack to top

the perl DBI interface for PostgreSQL is called DBD::Pg and can be installed with PerlPPM by typing
Code:
install DBD-Pg
View user's profileSend private message
ioconnor
 
 


Joined: 01 Apr 2006
Posts: 4

PostPosted: Sun Jul 30, 2006 4:07 pm Reply with quoteBack to top

Hmmm. Ok.

Is there a ruby interface to Postgresql too? Some of my code must be in ruby and rather than read the data in Python/Perl and then ship it to Ruby I'd rather just have Ruby directly interface with the database if possible.
View user's profileSend private message
Vlad Alexa Mancini
lead developer
lead developer


Joined: 07 Jul 2003
Posts: 1539

PostPosted: Mon Jul 31, 2006 7:34 am Reply with quoteBack to top

ioconnor wrote:

Is there a ruby interface to Postgresql too? Some of my code must be in ruby .................


you bet there is , the thing is that ruby is not available in apache2triad
View user's profileSend private message
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT