Re: [PHP] Web application? From: Martin Marques (martin <email protected>)
Date: 07/15/01

Quoting Christopher Ostmo <tech <email protected>>:

> >
> > 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 <email protected>
Programador, Administrador      |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>