[Webdev] [Fwd: [ILUG] MySQL vs PostgreSQL]

[Kathryn Cassidy]

On Mon, Nov 13, 2000 at 01:10:44PM -0000, Adam Beecher wrote:
> Also agreed, but how many of the sites we develop really, honestly *need*
> transaction support? Sure, it'd be handy, but we can live without it until such
> time as it becomes available. In the meantime, we can replicate it in the code.
> And to be fair, they are working on it...
Depends on what you do.  If your definition of web development is
writing webpages with a bit of interactive content then no, you
probably won't need transactions, but if you're writing applications
with mysql which just happen to have web based front ends, then
transactions would often be useful.  Also, you can sort of replicate
some aspects of transactions in your code, but you won't get the full
functionality and it'll be an awful kludge.

Of course, you can't really have the speed of Mysql with transactions,
so you've got to decide which you need most...

> > > This brings me to a different question, what databases people have
> > > written their php apps with - if there is enough interest I'll set up a
> > > survey somewhere (if I get time).
Mysql, possibly PostgreSQL soon, and a bit of Oracle now and again
when I can't avoid it.

Kathryn.