[Tutor] Multiple DBs per application?

bob gailer bgailer at gmail.com
Tue May 15 05:39:17 CEST 2012

On 5/14/2012 7:55 PM, Leam Hall wrote:
> On 05/14/2012 06:44 PM, Alan Gauld wrote:
>> On 14/05/12 20:33, leam hall wrote:
>>> Just a general question. If you have an application with different
>>> data types where it might be better to use one database over another,
>>> are there issues with having multiple databases used by the
>>> application?
>> No, you can usuially have multiple databases open at once.
>> You can have multiple instances of the same database or
>> different database types.
>> However the data types are rarely ta reason to use different databases.
>> More typically would be different performance requirements or security
>> issues. For example it's common to hold some data in an LDAP structure
>> for speed of access (at the expense of flexibility) and the rest of the
>> data in an RDBMS such as MySql. But using say MySQL and Oracle together
>> would normally only be done because they were pre-existing datastores
>> from another project.
> Thanks! I was more thinking of something like a CMS where user login 
> information and admin functions might be in a SQLite database and then 
> some larger backend big data stuff in MongoDB or similar. Just wasn't 
> sure if there was a basic flaw to the idea that I wasn't aware of.
Seems like a good idea. Right tool for right purpose.

Bob Gailer
Chapel Hill NC

More information about the Tutor mailing list