Drupal 7 might work with Java databases. Eventually, we might even be able to run Drupal 7 on Google App Engine.
Yesterday I was writing a patch for better support of the ANSI SQL MERGE command in Drupal and stumbled upon HyperSQL -- a Java database -- which is supposedly the most ANSI SQL compatible DB. Then I tried to find out how we could use it (there are only JDBC drivers) and I have found that Quercus which is known to run Drupal, now uses PDO to expose JDBC drivers. Great, Drupal 7 database layer is built on PDO. Furthermore, I have found a database called H2 -- another Java database -- which says it can pretend to be PostgreSQL. While previous Drupals pretend to support PostgreSQL, with Drupal 7 it's serious. So what we need is someone to run all core tests in Quercus for Drupal 7 first, maybe with MySQL just to verify it's working well. Then comes the fun: connect to H2 using the PostgreSQL driver. If it works, awesome. If not, then check whether the same test fails with PostgreSQL. If this does not work out, then try writing a DBTNG writer on top of the PDO exposed JDBC drivers to either HyperSQL or H2 or both. Finally, deploy on GAE. Who's interested? I am willing to help in writing a DBTNG driver.
Edit: it seems that for GAE we want jiql not H2 / HyperSQL but that changes little in the general approach.
Commenting on this Story is closed.