. Updated Daily. Editions SDA India   SDA Indonesia
BUSINESS ENTERPRISE SOLUTIONS ARCHITECTURE INFORMATION SECURITY WIRELESS & MOBILITY DATA & STORAGE DEVELOPMENT HARDWARE













News

Wednesday, 7 February 2007

Article: Get Connected with mysqlnd Native Driver for PHP

 

 

The MySQL Developer Zone features an article that tells you about the MySQL native driver for PHP, an additional, alternative way to connect from PHP 6 to the MySQL Server 4.1 or newer. It is a replacement for the libmysql, the MySQL Client Library. So, it says that from now on you can use ext/mysqli either together with libmysql as done before with mysqlnd.

According to the article, it also verifies that there are no plans to remove libmysql support from ext/mysqli, which would break existing applications. It has added a new alternative to the PHP offerings.

The author points out the advantages of mysqlnd that are as follows:

  • The new development is licensed under the terms of the PHP license to solve any license issues.
  • During the early stage of the development , the version will be offered from MySQL. As soon as mysqlnd feature is complete and production is ready it will move it to the PHP project CVS repository on http://cvs.php.net.
  • On the C-level mysqlnd uses many of the proven and stable PHP internal functions. All the code of the new driver is contained in the ext/mysqli source directory. There is no need to link any external libraries. Thus you neither need to install the MySQL client library to compile PHP with ext/mysqli support nor do you need to take care of versions. So, compiling has been made easier.
  • The performance of some functions has been improved. It has measured considerable performance improvements, for example when fetching buffered result sets.

Features and Limitations

The article says that this first, alpha release is not feature complete. From the API additions discussed with Community members in November 2006 during the Frankfurt PHP conference, it managed to implement a first version of the following:
  • improved persistent connections
  • mysqli_fetch_all()
  • a first performance statistics call: mysqli_get_cache_stats()


Unfortunately the first alpha release does not include Prepared Statement Support, the article reports.

The article informs you that future versions of mysqlnd will support PHP 5. However, currently the focus will be in the development efforts on implementing core functionality like Unicode support and support for Prepared Statements. The reason is not to get distracted by differences between PHP 5 and PHP 6 at the moment, it says. Once the missing core functionality has been implemented, mysqlnd will be ported to PHP 5. The article also informs you that as of now there is no time plan for PHP 5 support and it will depend on the need of it.

 

Read the Article

 
 
print save email comment

print

save

email

comment

 
 

Search SDA Asia

Free eNewsletter

SDA Asia Magazine Free Download
 
 
 
Copyright @ 2009 SDA Asia Magazine - All Right Reserved Privacy Policy | Terms of Use