Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #10917

Re: the changeover to mysqli

Show all headers | View raw

Christoph Michael Becker wrote:

> Tim Streater wrote:
>> In article <1cun3xxz7nbpj.zop5ye5ou0f7$.dlg@40tude.net>,
>> richard <noreply@example.com> wrote:
>>> Let's face it, html has deprecated a ton of things which are still in
>>> use. Why? because a hoard of people refuse to upgrade their systems.
>> 
>> You mean, update their web pages. Fat chance of that happening. And
>> because browsers still support almost everything that was ever
>> introduced, bar a couple of minor things, I see no reason, by and large,
>> to do so either. I just use the HTML5 doctype to ensure standards mode.
> 
> And that is exactly the reason, why those deprecated features won't be
> removed--because it would break too many existing sites.  If there were
> less websites relying on obsolete features, the browser's could be
> purged, which would be beneficial to ease further development.
> 
> The situation is similar with regard to the original MySQL extension.
> Cf. <https://wiki.php.net/rfc/mysql_deprecation>.

The most important issue with the mysql extension that appears to be 
overlooked by all discussing so far is not that the extension will be 
removed later.  It is the fact that it is patently inefficient and insecure 
by comparison *right now*.  It has no native support for

- reading a result into an array *without* a loop (there is no
  mysql_fetchall)
- transactions
- Prepared Statements

and so on.

It is no longer officially supported by the MySQL vendor, Oracle.  As a 
result, it does not support natively (if at all; I have not tried) features 
introduced in MySQL 5.1 and above.  The current MySQL stable version is 5.6.

The latest bugfix of php_mysql.c was in 2011:

<http://git.php.net/?p=php-src.git;a=history;f=ext/mysql/php_mysql.c;h=88bb9ab21ef9fb15a147fc776569e8548e0be83b;hb=HEAD>

That was 2 years ago.  An eternity in computer technology, considering that 
updates and especially security updated for maintained software are released 
on a daily (e.g., security.debian.org) to at most bimonthly (e.g., Firefox) 
basis.

See also <http://php.net/manual/en/mysqlinfo.api.choosing.php>

Deprecation is not merely a documentation status with PHP; it has 
consequences for running PHP code:

<http://git.php.net/?p=php-src.git;a=commitdiff;h=b7091aaf0137d97cf4aa4a402ec50b3946d369c0>

IOW, E_DEPRECATED warnings may pile up in your log and make the application 
and the server run slower than it could be.

Insofar your well-intentioned comparison with deprecated HTML features is 
missing the point.

Anyhow, I am afraid that none of our arguments will be convincing enough for 
*seemingly* natural-born ignorants like “richard”.  So why not save free-
time and just stop feeding the likely troll – both of them?


PointedEars
-- 
Prototype.js was written by people who don't know javascript for people
who don't know javascript. People who don't know javascript are not
the best source of advice on designing systems that use javascript.
  -- Richard Cornford, cljs, <f806at$ail$1$8300dec7@news.demon.co.uk>

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

the changeover to mysqli richard <noreply@example.com> - 2013-09-24 22:38 -0400
  Re: the changeover to mysqli Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-24 23:48 -0400
    Re: the changeover to mysqli Adam Harvey <usenet@adamharvey.name> - 2013-09-25 17:29 +0000
      Re: the changeover to mysqli richard <noreply@example.com> - 2013-09-25 15:01 -0400
        Re: the changeover to mysqli Adam Harvey <usenet@adamharvey.name> - 2013-09-25 19:28 +0000
          Re: the changeover to mysqli richard <noreply@example.com> - 2013-09-25 16:21 -0400
            Re: the changeover to mysqli Christoph Michael Becker <cmbecker69@arcor.de> - 2013-09-25 22:36 +0200
            Re: the changeover to mysqli Adam Harvey <usenet@adamharvey.name> - 2013-09-25 20:38 +0000
              Re: the changeover to mysqli richard <noreply@example.com> - 2013-09-25 20:16 -0400
            Re: the changeover to mysqli Denis McMahon <denismfmcmahon@gmail.com> - 2013-09-25 21:11 +0000
            Re: the changeover to mysqli Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-09-25 17:46 -0400
              Re: the changeover to mysqli Twayne <nobody@spamcop.net> - 2013-09-26 18:28 -0400
        Re: the changeover to mysqli Tim Streater <timstreater@greenbee.net> - 2013-09-25 22:38 +0100
          Re: the changeover to mysqli Christoph Michael Becker <cmbecker69@arcor.de> - 2013-09-25 23:58 +0200
            Re: the changeover to mysqli Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-25 22:53 -0400
              Re: the changeover to mysqli Christoph Michael Becker <cmbecker69@arcor.de> - 2013-09-26 20:59 +0200
                Re: the changeover to mysqli Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-26 15:41 -0400
            Re: the changeover to mysqli Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-09-27 01:09 +0200
      Re: the changeover to mysqli Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-25 15:34 -0400
        Re: the changeover to mysqli Fiver <numeralfive@gmail.com> - 2013-09-25 23:32 +0200
          Re: the changeover to mysqli Jerry Stuckle <jstucklex@attglobal.net> - 2013-09-25 22:54 -0400
            Re: the changeover to mysqli Fiver <numeralfive@gmail.com> - 2013-09-26 05:30 +0200
              Re: the changeover to mysqli Curtis Dyer <dyer85@gmail.com> - 2013-09-26 06:13 +0000
            Re: the changeover to mysqli Twayne <nobody@spamcop.net> - 2013-09-26 18:32 -0400
  Re: the changeover to mysqli Scott Johnson <noonehome@chalupasworld.com> - 2013-09-24 21:14 -0700
  Re: the changeover to mysqli David Robley <me@home.invalid> - 2013-09-25 13:50 +0930

csiph-web