I'd highly recommend DBIx::Class for perl database interaction, especially for a database schema you expect to use in many projects, or a large one. Try skimming/poring over http://search.cpan.org/perldoc?DBIx::Class::Manual::Intro http://search.cpan.org/perldoc?DBIx::Class::Manual::Example http://search.cpan.org/perldoc?DBIx::Class
You can install this in Ubuntu via the libdbix-class-perl library. As Don said, it's probably the same on Debian. If you're looking to do something lower level, or DBIx::Class looks too daunting, you can always try DBI: http://search.cpan.org/perldoc?DBI To be honest, looking at that page gives me the shakes, but it should help you establish a connection to the database. And if all you want to do is run one query for one script, then it could work. It's called libdbi-perl in Ubuntu, and is already installed on many (all?) Debian-based distros. Installing these modules through apt should automatically add them to your perl library search path, so all you'd have to do is use them in your project. Nate On Fri, Oct 16, 2009 at 7:48 AM, Donald Bindner <[email protected]> wrote: > You probably need one of the php support packages. My Ubuntu system has > another package called php5-pgsql with that module. Your Debian system > should be similar. > > Don > > On Fri, Oct 16, 2009 at 7:44 AM, Alyssa and Chris Gordon & Family > <[email protected]> wrote: >> >> So I successfully installed Debian (no GUI ,with DB, with webserver). I >> got the DB to run, have it automatically start when computer starts, and now >> I'm trying to connect to it from perl and PHP, neither of which seems to be >> able to. I've done a decent amount of online searching [I've started with >> PHP], and still and unable to configure them to work together. It seems >> that I need to update php.ini to include pgsql.so as an extension, configure >> the extension directory so it contains the actual pgsql.so. Problem is this >> file doesn't exist anywhere on my system. >> >> Can anyone point me to a website that provides details on how to setup PHP >> to load the libraries for PostgreSQL (or if you've done this same setup >> maybe you can let me know what I'm doing wrong). >> >> I haven't really looked at Perl yet, so I should be able to find >> instructions out there somewhere, but I'm going to attempt the DB connection >> soon, so if you happen to have any advice let me know. >> >> Thanks >> >> Chris >> >> ----------------------------------------------------------------- >> To get off this list, send email to [email protected] >> with Subject: unsubscribe >> ----------------------------------------------------------------- >> > > ----------------------------------------------------------------- To get off this list, send email to [email protected] with Subject: unsubscribe -----------------------------------------------------------------
