Add Tables to mojoPortal database or create new?

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
7/15/2009 4:28:20 PM
Gravatar
Total Posts 8

Add Tables to mojoPortal database or create new?

Should we refrain from modifying (e.g. adding our own tables) the mojoPortal database?  If I want to database drive my features, which I do, should I create a separate database housing my data?

Thanks,

Evan

7/16/2009 6:38:41 AM
Gravatar
Total Posts 18439

Re: Add Tables to mojoPortal database or create new?

Its a personal choice, if you need to access those tables from other systems besides mojoPortal it might make sense in some cases to use a different db and connection string.  

But there is nothing wrong in my opinion to add your tables for a custom feature to the same db as the rest of mojoPortal. This keeps it simple if you need to join to any of the mojo tables like the mp_Users table and allows you to use the existing connection string. I would use a unique prefix for your table names to group them together and to differentiate them from the mojoPortal tables. Like most features of mojoPortal use the mp_ prefix, WebStore uses ws_, for my add on products I use sts_ (Source Treee Solutions).

If you package a custom feature according to conventions it also easy to use our installation system for your custom features, and this is also a benefit of using the same db instead of a different one.

Hope it helps,

Joe

7/16/2009 9:46:04 AM
Gravatar
Total Posts 8

Re: Add Tables to mojoPortal database or create new?

Thanks a lot for the help Joe.

7/16/2009 10:07:09 AM
Gravatar
Total Posts 18439

Re: Add Tables to mojoPortal database or create new?

Hi Evan,

Many thanks for the beers!

I shall raise my glass to you this evening.

Cheers,

Joe 

You must sign in to post in the forums. This thread is closed to new posts.