So what is the "best practice" on deciding when to use another database or just add more tables to a single database?
And how many tables is too many in a single database?
for example: say I have a CRM project that has a database with 12 tables
I now want a project management system that needs another 12 tables but it could also use a table or 2 from the CRM system.
Then later I need a Venue management system that also has a bunch of tables but could use tables from above also.
In general I guess I'm asking, when is it time to create another database -vs- just adding more tables and what considerations are there.