On Thu, 12 Aug 2004, Mathew Robertson wrote:

> you are kidding right?

Not at all.  That doesn't mean I expect to convince anyone though.
This is the kind of wisdom that usually only comes from experience!

> ACID capabilites and all that...
> proper locking semantics...
> long history with native support for transactions...
> proper SQL transaction semantics...

Over-rated.  Sure, if I was building banking software I might have a
different opinion, but I'm not.  A simple database with few critical
bugs protects my data better than your fancy ACID transactions!

How can I be so sure?  I've worked with big complex systems running on
both databases.  I've watched Bricolage completely destroy user data
despite using PostgreSQL's transaction support.  In contrast, Krang
hasn't lost data yet, as far as I know.  A few careful locks in the
right places seem to be just what the doctor ordered for a moderatly
complex content management system.  And if the catastrophic happens,
like a system crash, that's what nightly backups are for.  Nightly
backups might not be good enough for all applications, but they're
good enough for a content-management system.

> As you said, people can make spaghetti out of anything - how this
> makes MySQL 'better', I dont understand.

Experience.  Wrestle with a database strewn with triggers,
constraints, abstract types and functions sometime.  You'll be begging
to be back in the moderate mess of a badly designed MySQL DB.  There's
less there so there's just less to do badly.  It may not be an
emperical fact, but I didn't presented it as such!

-sam


-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users

Reply via email to