[Tutor] Multiple DBs per application?

Alan Gauld alan.gauld at btinternet.com
Tue May 15 00:44:52 CEST 2012

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.

Alan G
Author of the Learn to Program web site

More information about the Tutor mailing list