Re: Web application?

Quoting Christopher Ostmo <tech@appideas.com>: > > > > 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 That's not good SQL programming, but if you can live with it. > 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). As far as I have seen, no native transactions. Berkeley or innovace (is that written correctly?) > > 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. Well, the data type was DATE (the fields name was something else, and in spanish), so your argument isn't good. > 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... I think your rught on this, and because I have a week of vacations now, I guess I will not be able to responce future messages from this thread! :-) Saludos... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------