Re: Prep. Statements only in mysql-i?

From	"M. Strobel" <sorry_no_mail_here@nowhere.dee>
Newsgroups	comp.lang.php
Subject	Re: Prep. Statements only in mysql-i?
Date	2012-04-12 20:23 +0200
Message-ID	<9uoksiFr2iU1@mid.uni-berlin.de> (permalink)
References	(2 earlier) <jm6fke$o2l$1@dont-email.me> <9uoa8qF8p1U1@mid.uni-berlin.de> <jm72m2$7mp$1@dont-email.me> <9uohldF1pgU1@mid.uni-berlin.de> <jm75nj$pfu$1@dont-email.me>

Show all headers | View raw

Am 12.04.2012 20:08, schrieb Jerry Stuckle:
> On 4/12/2012 1:28 PM, M. Strobel wrote:
>> Am 12.04.2012 19:16, schrieb Jerry Stuckle:
>>> On 4/12/2012 11:22 AM, M. Strobel wrote:
>>>> Am 12.04.2012 13:51, schrieb Jerry Stuckle:
>>>>> On 4/12/2012 6:33 AM, M. Strobel wrote:
>>>>>> Am 12.04.2012 00:42, schrieb Alexandra Herzog:
>>>>>>
>>>>>>>     but my hoster only offers mysql
>>>>>>
>>>>>> It makes me angry to hear this. The mysql drivers were outdated long before the
>>>>>> makers stopped supporting it in 2006.
>>>>>>
>>>>>> /Str.
>>>>>
>>>>> MySQL not supported?  Who says?  It's the most commonly used database on the web.
>>>>> PostgreSQL and others are way behind in popularity (although I won't get into an
>>>>> argument as to which is "better").
>>>>>
>>>>> Or if you mean the mysql interface vs. mysqli, who says it isn't supported?
>>>>
>>>> mysql interface vs. mysqli. I know the first is old and slower, and the support info
>>>> I just read at  http://www.radicore.org/radicore-for-php.php
>>>>
>>>> /Str.
>>>>
>>>
>>> And how do you "know" that?  Both end up as calls to mysql_xxxx C functions.  The
>>> mysql_xxx calls in PHP are just wrappers to the C functions.  The mysqli_xxx calls
>>> have to do a lot more work before calling the appropriate mysql_xxx C functions.
>>>
>>> If the mysqli_xxx calls have to do more work before calling the same functions, how
>>> can they be faster?
>>
>> I admit my arguments are a bit sloppy, one could go more into depth.
>>
>> But true is that mysqli is strongly recommended for MySQL versions 4.1.3 or later,
>> see http://ca3.php.net/manual/en/mysqli.overview.php
>>
>> And I can't understand why the mysql interface is still advocated by some. Look at
>> the old mysql password format, ridiculous.
>>
>> /Str.
>>
> 
> The mysql interface has nothing to do with the old mysql password format.  Two
> entirely different things.

I still remember something I had to debug in 2006, see
http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html at
"what you should do if you upgrade your server but need to maintain backward
compatibility with pre-4.1 clients"

I won't write an article on this now.

/Str.

Thread

Prep. Statements only in mysql-i? Alexandra Herzog <herzog.alex@arcor.de> - 2012-04-11 22:42 +0000
  Re: Prep. Statements only in mysql-i? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-12 01:16 +0200
    Re: Prep. Statements only in mysql-i? Alexandra Herzog <herzog.alex@arcor.de> - 2012-04-12 11:29 +0200
      Re: Prep. Statements only in mysql-i? Michael Fesser <netizen@gmx.de> - 2012-04-12 17:14 +0200
      Re: Prep. Statements only in mysql-i? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-04-14 08:21 +0200
  Re: Prep. Statements only in mysql-i? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-04-12 12:33 +0200
    Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 07:51 -0400
      Re: Prep. Statements only in mysql-i? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-04-12 17:22 +0200
        Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 13:16 -0400
          Re: Prep. Statements only in mysql-i? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-04-12 19:28 +0200
            Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 14:08 -0400
              Re: Prep. Statements only in mysql-i? "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2012-04-12 20:23 +0200
                Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 16:34 -0400
            Re: Prep. Statements only in mysql-i? "Peter H. Coffin" <hellsop@ninehells.com> - 2012-04-12 13:29 -0500
      Re: Prep. Statements only in mysql-i? Adam Harvey <adam@adamharvey.name> - 2012-04-13 08:06 +0000
  Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 07:53 -0400
    Re: Prep. Statements only in mysql-i? Alexandra Herzog <herzog.alex@arcor.de>> - 2012-04-12 14:17 +0200
      Re: Prep. Statements only in mysql-i? Jerry Stuckle <jstucklex@attglobal.net> - 2012-04-12 09:21 -0400

csiph-web