boss_db
boss_db copied to clipboard
Multiple DBs and/or hosts?
Thanks for the hard work on boss_db!
Is it possible to use boss_db in the same application to talk to 2 different DBs (eg different MySQL DBs on the same host), or even better 2 different hosts altogether?
I might be looking at this wrong, but it seems to me one can only call boss_db:start/1
once? And it seems there's only one connection pool in the whole boss_db app?
You can configure it using the main configuration for one of the databases and the shards for others, so you can then be connected to multiple databases no matter the host or the type of the adapter. However, I had an issue when executing SQL code since it will be executed on the main database.
Is it possible to use multiple different databases, eg: postgres and riak ?