[plug] Web database stuff - Bollocks

Simon Scott simon.scott at flexiplan.com
Fri Aug 24 08:59:03 WST 2001


	Its quite simple

	MySQL is super quick, but lacks some features (like transactions and
row locking)

	Postgresql is slower, but more 'high end' and supports row locking,
transactions, and a host of other highend features.

	If you're writing a dynamic website, use MySQL. If youre writing a
web-based application, use postgresql.

	Either way, with PHP (which I recommend for small/medium projects),
abstract the mysql and pgsql functions into a library so you can easily
switch between the two as necessary. PHP doesnt give you a 'database layer',
it simply provides functions specific to each database. They leave the
abstraction up to you.

	Also, you might want to look at Zope, depending on the size of the
site you are constructing.

	Above all, have fun with it.



	Thanks for the advice though, could someone comment on 
	the differences between PostgreSQL and MySQL? 




**********************************************************************
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
**********************************************************************



More information about the plug mailing list