[plug] web access to PostgreSQL

[Simon Scott]

	PHP all the way dude

	Its easy and fast. Very few gotchas. Plenty of pre-existing code
snippets and libraries to use.

	Depending on what you are doing, use MYSQL for speed or postgresql
if you require transactions/advanced locking.

	The only problem is that it has a seperate set of functions for each
database, making  it difficult to swap DBs. This can be resolved tho by
writing your own abstraction layer or possibly one might already exist.

	Ive been more impressed by PHP than I have been with anything in a
long time.




	From:	Denis Brown <dsbrown at cyllene.uwa.edu.au> on 17-05-2001 10:09
AM
	Please respond to plug at plug.linux.org.au@SMTP at Exchange
	To:	plug at plug.linux.org.au@SMTP at Exchange
	cc:	 

	Subject:	[plug] web access to PostgreSQL

	Dear PLUG members,

	A few weeks ago I raised a query about pgsql_perl5 and a compiling 
	problem.  That is now solved with a fresh (compiled-from-source)
Perl -- 
	there were a few .h files missing from the original installation.
So now 
	I've got it working.  Thanks to those who replied because this also
raised 
	my awareness of other libraries / methods of access.  For the
language I 
	have a choice including C, Perl, PHP.  Each of these has at least
one 
	interface to the SQL database and to the Apache server.  Okay,
here's the 
	query...

	Does anyone know of a document (FAQ entry?) comparing these in terms
of 
	performance, footprint and ease of coding?

	I've hunted around without success so far.  For example, if using
Perl, I 
	can interface to the database with pgsql_perl, related specific
modules or 
	the DBI / DBD scheme.  My gut feeling is that the DBI / DBD approach
should 
	have a larger footprint, perhaps be a bit slower because of the
extra 
	abstraction but be easier to code and change database engines.
pgsql_perl 
	and similar offerings may be leaner and hungrier, at the expense of 
	"intuitive" coding and difficulty to swap database engines.  If I go
PHP 
	instead.....?

	Am I on the right track here and is there a description of the
relevant 
	advantages, etc?

	TIA,
	Denis




**********************************************************************
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they   
are addressed. If you have received this email in error please notify 
the system manager.

This footnote also confirms that this email message has been swept by 
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************