Drupal Database Maintainers Together at last

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

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <h2><h3><h4><a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <p> <div> <span>
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Glossary terms will be automatically marked with links to their descriptions. If there are certain phrases or sections of text that should be excluded from glossary marking and linking, use the special markup, [no-glossary] ... [/no-glossary]. Additionally, these HTML elements will not be scanned: a, abbr, acronym, code, pre.
  • You may insert videos with [video:URL]

More information about formatting options