MySQL

The world's most popular open source database

Contact a MySQL Representative


  • MySQL.com
  • Developer Zone
  • Partners & Solutions
  • Customer Login
  • DevZone
  • Downloads
  • Documentation
  • Articles
  • Forums
  • Bugs
  • Forge
  • Blogs
 
  • Pages

    • About me
    • Bio
    • Press Release: “Kaj Arnö Appointed MySQL VP of Community Relations”
  • Blogroll

    • Ein Finnlandschwede in Bayern
    • En finlandssvensk i Bayern
    • It’s some interesting topic
    • Kaj Arnö blog aggregation
    • No Software Patents!
    • Planet MySQL
  • Recent Posts

    • The Embedded Reporter in the Half-Marathon
    • Berlin Open 09: Social Networking
    • Search the planetary archives, and tag your blog entries
    • SELECTing SELECT statements for Wordpress MU blogging statistics
    • How do MySQL users keep track of digital pictures?
    • Presenting and blogging in Chinese
    • On the Merits of Voting
    • The Future of MySQL
    • The Great Open Cloud Shootout: Videos and other links
    • Karen’s Commitments to the MySQL Community
    • What hasn’t changed with MySQL
    • Andy Bechtolsheim to Keynote MySQL Conference on Thursday
    • The Great Open Cloud Shootout
    • MySQL Campus Tour 2009 — aka Dups on Rails
    • MySQL & Google Summer of Code 2009 — time to get going!
  • Tags

    Alexander Arnö Black Swan Blogging Blogs Brazil Business Model Call for Papers Call for Participation CfP Community Contributions David Axmark Event scheduler Football FOSDEM Growth Innovation Ivan Nikitin Language Launch Mårten Mickos Michael "Monty" Widenius Mountains Munich MySQL MySQL 5.1 MySQL AB MySQL Forge MySQL User Conference MySQL Users Conference Nassim Nicholas Taleb Open Source Oracle Paris Partitioning Photography Social Networking South Africa Sun Microsystems Sun Tech Days Thank you Travel Use case Web 2.0 Wordpress
  • Archives



  • Categories

    • Architecture of Participation
    • Connectors
    • Documentation
    • Events
    • Falcon
    • GPL
    • GUI
    • Licensing
    • MySQL
    • MySQL Cluster
    • MySQL Proxy
    • MySQL Server
    • MySQL Users Conferences
    • MySQL Workbench
    • Photography
    • PHP
    • Release Policy
    • Ruby on Rails
    • Running
    • Summer of Code
    • Sun
    • Sun visits
    • Travel
    • Use cases
    • Virtual company
  • Calendar

    October 2006
    M T W T F S S
    « Sep   Nov »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
Observations by Kaj Arnö @Sun
« YouTube & MySQL & babies
Pure PHP driver FAQ: Asking Georg Richter »

Developing a pure PHP driver for MySQL

Talking to the PHP community members, I see a recurring theme:

How does MySQL integrate with PHP — both from a technical and from a licensing perspective?

MySQL provides several ways to integrate between PHP and MySQL, most notably the ext/mysql and ext/mysqli drivers for PHP. These rely on the GPL licensed libmysql library, which by its nature is not compatible with the PHP license. With our not-so-optimally-named “FOSS Exception” , we have extended the rights of our community to use MySQL together with a number of non-GPL FOSS licenses, including the PHP license. This solution works well for many in the PHP community.

But we want to do more:

We plan to develop a pure PHP driver for MySQL, to be licensed under the PHP license itself and donated to the PHP Group for inclusion into PHP6.

We hope this will remove any and all licensing issues that the PHP community might otherwise have with MySQL.

Besides resolving licensing issues, we want the new pure PHP driver to technically integrate better with MySQL:

  • we intend to add support for client-side query caching in the PHP driver for MySQL, probably already to MySQL 5.1 Community Server
  • we intend to add support for a Prepared Statements cache to the PHP driver for MySQL, also implemented on the MySQL Server

We believe both of these will bring added technical value to users of PHP6. Tentatively, we should be able to deliver this in stages starting Q1 of 2007, in time for the preview release of PHP6.

We are still working out the details of this. Expect to see more specifics soon after the PHP conference in Frankfurt early November. Once we have worked out the details, I look forward to this initiative turning into a commitment from our side, and delivering results in the form of a more community-friendly, pure PHP driver for MySQL!

This entry was posted on Wednesday, October 25th, 2006 at 21:50 and is filed under MySQL, PHP. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

7 Responses to “Developing a pure PHP driver for MySQL”

  1. Georg Richter’s Weblog » Neues an der PHP6 Front Says:
    October 26th, 2006 at 0:09

    [...] So eben gab Kaj Arnö in seinem Blog bekannt, daß MySQL im März 2007 eine neue Library unter der PHP License veröffentlichen wird. [...]

  2. Internet Super Hero » Blog Archive » Umfrage: mysqlnd - MySQL native driver für PHP Says:
    November 13th, 2006 at 13:23

    [...] Es ist nicht lange her, daß Kaj den Plan verkündet hat, einen neuen nativen MySQL Treiber für PHP zu entwickeln. Der neue Treiber wird unter die PHP Lizenz gestellt werden. PHP intern ersetzt der neue Treiber die libmysql. [...]

  3. Webdevelopment Blog » Survey on mysqlnd - MySQL native driver for PHP Says:
    November 13th, 2006 at 21:56

    [...] Announcement: http://www.planetmysql.org/kaj/?p=69 Mini-FAQ: http://www.planetmysql.org/kaj/?p=71 [...]

  4. Internet Super Hero » Blog Archive » MySQL native driver for PHP: mysqlnd-5.0.0-alpha Says:
    February 2nd, 2007 at 13:35

    [...] we are proud to announce the first alpha version of the MySQL native driver for PHP: mysqlnd 5.0.0-alpha. The software is available for download on http://dev.mysql.com/downloads/connector/php-mysqlnd. [...]

  5. MySQLi Prepared Statements haben Nachteile bei Select-Anfragen at PHP-Consulting.de Says:
    February 18th, 2007 at 15:57

    [...] Dieses Problem beruht auf der zugrunde liegenden C API, betrifft also nicht nur PHP. Es gibt aber Bemühungen diesen Misstand in PHP6 zu beseitigen. [...]

  6. Internet Super Hero » Blog Archive » PDO_MYSQLND: The new features of PDO_MYSQL in PHP 5.3 Says:
    September 25th, 2008 at 12:04

    [...] Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL [...]

  7. PHP Planet — PDO_MYSQLND: The new features of PDO_MYSQL in PHP 5.3 Says:
    February 20th, 2009 at 18:53

    [...] Kaj’s announcement of the MySQL native driver for PHP (mysqlnd), we promised to to patch all three PHP MySQL [...]

Leave a Reply

Observations by Kaj Arnö @Sun is proudly powered by WordPress MU running on Blogs.mysql.com.
Entries (RSS) and Comments (RSS).