Re: Web application?

> > I don't know how you can live without thansactions, unless your database > consist's of just one table for inserts. > Check out the features of the latest version of MySQL. What isn't there now, will be there very soon. The lack of transactions can easily be overcome by proper programming logic. I *personally* prefer programming logic over a database server doing the work for me. It makes it easier to tell where things went wrong if the transaction fails. That's just my personal preference. And anyway, MySQL does transactions now, so it's a moot point. If you want them, you can have them in MySQL. Simply upgrade (which doesn't require dumping and importing your existing databases). > Anyway, why don't you look at this: > http://www.zend.com/zend/art/databases.php > > (I have seen a MySQL server insert 30/2/1999 in a date field, which doesn't > look ver good, just to talk a little about inconsistency). > If the field has been declared a *type* of DATE, this CANNOT happen. Just because someone called the field DATE doesn't mean that it was given the proper type declaration. If you send a date that doesn't make sense to a DATE field, the MySQL engine will convert it to "0000-00- 00"or the default value for the field. At any rate, I really do like PostgreSQL, I just have not ever been able to make it go anywhere near as fast as MySQL for the applications in which I have used it. I have studied both servers a bunch, but maybe I am missing something. Maybe it's just me? That's not entirely out of the realm of possibility. This thread has gone WAY off of topic. Let's get back to PHP and take the DB discussions onto the appropriate DB lists... Christopher Ostmo a.k.a. tech@AppIdeas.com AppIdeas.com Innovative Application Ideas Meeting cutting edge dynamic web site needs since the dawn of Internet time (1995) Business Applications: http://www.AppIdeas.com/ Open Source Applications: http://open.AppIdeas.com/