I am working on some Drupal integration with PostBooks and wanted to get some feedback on the database setup options. I have heard that xTuple is using a new schema within the xTuple database. However, I read this post and I’m not sure if it is worth the effort: http://drupal.org/node/45332
What at the benefits of putting Drupal in a Schema vs. a separate database? Drupal can handle multiple database connections (http://drupal.org/node/18429), so that approach seems more straight forward and doesn’t involve any Core hacks.
One benefit I can see for Schemas is not having to call “db_set_active(‘xTuple’);” and “db_set_active(‘default’);” in your module to switch back and forth between the databases. Is this correct?