Home » Groups » Enterprise

My personal battle target for Druapl 7.x

hswong3i's picture
public
groups: Enterprise · Database
hswong3i - Fri, 2008-02-01 03:45

My primary battle plan should be enhance Drupal cross database compatibility. I have involved in this topic for around a year, and I would like to keep it on going. To accomplish this target, I would like to complete the following tasks before D7 code freeze:

<

ul>

  • Improve Database API for better abstraction

    Something should be done before any other targets, e.g. resolve reserved words conflict, split drivers into individual files for better management, indeed but simple abstraction for different database syntax, add INSERT/UPDATE/DELETE abstraction and enhance drupal_write_record() abstraction, etc. With a better common base for multiple database development, we will need much less time to study the differences between databases than that of before.

  • Add PHP PDO supporting

    Shipping D7 with PHP PDO should be a spotlight topic, since it is now official package for PHP5.2.x, and legacy drivers will soon be removed in PHP6.x. We may need some cleanup in our core query syntax, in order to let PDO get works.

  • Introduce more database backend

    Up to this point, I would like to introduce some other database backend for D7, e.g. Oracle, SQLite, IBM DB2 and also MSSQL. If we are able to support SQLite in D7, which also means we are going to standardize our core queries into SQL92 standard, the problem for maintain multiple database backend should no longer a critical problem; if we are able to support Oracle, the most complicated database I guess, this should no longer a problem for us to implement drivers for other databases.

    • I have summarize most of my personal battle targets in here. Most logic are proved as functioning, and they are all get set for the open of D7 public development. On the other hand, I would like to explore if this may integrate with other interest musings with Data API, so we will able get all stuff better in D7 ;-)


    Sitewide tags: Data API · database · database support
    » Login or register to post comments
     

    How collaborate I with DRUPAL developers to implement Oracle?

    softnew - Wed, 2008-02-06 14:09

    I can help you to implement the Oracle support.

    How can I do this?

    http://www.softnew.it

    Login or register to post comments

    Please refer to this Wiki

    hswong3i's picture
    hswong3i - Wed, 2008-02-06 19:03

    Please refer to this Wiki tasklist, and let's troubleshot those issues Oracle driver development needed for ;-)

    Rome Was Not Built In One Day.


    Login or register to post comments

    Why reinvent the wheel?

    emptyvoid - Tue, 2008-03-25 21:12

    Why is the group trying to reinvent the wheel here?

    I have used several versions of the following class libraries for over five years on about ten projects. And In some cases I had to switch databases mid project this class library supported it seamlessly.

    http://en.wikipedia.org/wiki/ADOdb

    I could imagine that perhaps there are special issues involving an API and integration with modules that would affect the decision to use ADOdb.

    Login or register to post comments