By auxone on
I'd like to integrate a fairly complex database driven application into my Drupal site. More specifically, it is a type of web service and I'd like to authorize users of it based on users registered via Drupal. The service takes about 10 tables to function, and they need to be backed up regularly.
What is the best way to integrate this into my Drupal site? Should I create a new database for the 10 tables, then just reference the user table in the Drupal DB? Referencing two databases would complicate my design, and perhaps reduce performance, but I am afraid that I can't properly back up my tables if I throw them in with Drupal, or that it may break something.
Thanks for any replies.
T
Comments
table prefix
Either install Drupal with a prefix for the table names, of use a prefix for your own tables.
That way, you can use the same database without fear of conflicts over table names...
Pete.