I'd like to use another db for some reports. My proposed solution is to support queries like: "USE db_name; SELECT * FROM table;". A diff for the recent dev version which does this is attached.

CommentFileSizeAuthor
db_set_active.diff797 bytesJakob Stoeck

Comments

Jakob Stoeck’s picture

Jakob Stoeck commented
Status: Active » Needs review
hicham7’s picture

hicham7 commented

Hello
what about using another database from another database server like postgresql for instance ?

a_c_m’s picture

a_c_m commented
Status: Needs review » Fixed

Just committed this to 1.x should be in the -dev version in a few hours.

@hicham7 it wont care what DB it is using http://api.drupal.org/api/function/db_set_active/6 which means it /should/ support any DB you can declare in settings.php then its up to you to make sure you use SQL that database can support.

hicham7’s picture

hicham7 commented

but according to this link http://drupal.org/node/18429
it's not possible to set up multiple databases connections of different types mysql and postgresql
in "settings.php".

a_c_m’s picture

a_c_m commented

@hicham7 - thats correct, but thats an issue with the db layer in drupal not this module, sorry.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.