For the first, in Paris, all the database maintainers of Drupal were in the same place at the same time. From the left is David Strauss (MySQL Driver), Larry Garfield (Database and MySQL Driver), Károly Négyesi (SQLite Driver), Damien Tournoud (SQLite and PostgreSQL Drivers) and myself (PostgreSQL Driver). Though there are only 5 of us. Each database in Drupal 7 has 2 maintainers for its Driver. At the time of this post there are no other CMS's around that have dedicated maintainers to there CMS pushing Drupal further as the best CMS and framework around.
Drupal 7 has some amazing new features coming up. One of the Database enhancements I'd like to mention is multiple schema/database support. Drupal has claimed for a while that Drupal could be shared between PostgreSQL schema's or MySQL databases using a dot syntax for referencing the table. Example, in PostgreSQL, if you had Drupal installed on a schema called 'common', and another one on a schema called 'media', you could allow users from the media schema to login into the 'common' drupal site by querying the 'common' tables instead of the 'media' tables. This is done by specifying the db_prefix for the user tables as 'common.'. The dot in the prefix is SQL syntax to reference a different schema rather than the current one.
Another example could be that you could install drupal on a seperate schema of another applications database and the application would have no idea it was there. There is really handy for when there are table name conflicts. Normally this was fixed by prefixing tables. Realistically, prefixing tables however is a poor mans version of schema support which works across MySQL, PostgreSQL and SQLite.


Hello from Russia! Can I
Hello from Russia!
Can I quote a post in your blog with the link to you?
of course!
of course!
Post new comment