[plug] web access to PostgreSQL

[Mark Nold]

I've used Perl and PHP. PHP wins hands down with dynamic site development. 
(even though i still love Perl for everything else)

PHP DB abstraction was mentioned (hi Steve) basically this is a must have. 
(even if you just want to move from a ODBC windows test/demo box to a un*x 
server with Postgress)



The main flavours of DB Abstraction are:

PHPLib (phplib.netuse.de i think) - the original but a bit aging now. Im not 
sure how they have kept up over the last year or so.

Metabase - phpclasses.upperdesign.com -> never used it, heard some good things 
about it.

PEAR DB -> PEAR is to PHP what CPAN is to Perl. This comes with PHP, and i 
would suggest is the way to go.



Also check out www.phpwizard.net as they have MySQLAdmin (PHP MySQL Admin tool 
.. duh..) and MyPGAdmin (mmmm...) this site is run by Tobias Ratschiller ( a 
PHP contributor and Author). I have never tested either and i'd be super 
security conscious if you put one of these up.

There is moves to make an inbuilt (ie: C module not Scipts) DB abstraction and 
i believe it is currently available for Postgress and MySQL see: 
http://www.php.net/manual/en/ref.dbx.php


Another useful resource is www.phpbuilder.com one of the best PHP sites. There 
was an recent interesting comparison of MySQL and Postgress... but i think 
everyone has drawn lines in the Perl Vs PHP fight so i wont start that one....




mn





Mark Nold
markn at enspace.com
Senior Consultant

Change is inevitable, except from vending machines.




On Thursday, 17 May 2001 8:43, skribe [SMTP:skribe at amber.com.au] wrote:
> On Thu, 17 May 2001 10:49, Jason Nicholls wrote:
> >
>  In my opinion however, why bother learning PHP which is more limited
> > to web applications rather than Perl that can be used for almost anything!
>
> Almost anything, except write human readable code.  Perl resembles line
> noise.  PHP is also much much easier to learn
>
> skribe
> --
> Public key information available at:
> http://www.amber.com.au/~skribe/publickey.html
> Key fingerprint = A855 9CA3 953B 5195 C518  12F2 0E05 DCCD 5A88 E8A4
>
> If builders built buildings the way programmers wrote programs,
> then the first woodpecker to come along would destroy civilization.
>