[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