Recomended datasource?

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
7/14/2010 3:21:04 AM
Snowman
Gravatar
Total Posts 65
View Posts

Recomended datasource?

Hi,

We are typical using MS SQL as a datasource but to cut down on expense we have decided to go with a free database soulution. We know that MySQL cummunity server is a good datasource but I am not totaly sure that this is 100% free for commercial use?

Is there any free database that mojoPortal are more recomended with then others?

BestRegards

7/14/2010 6:38:45 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Recomended datasource?

SQL Express is free and I believe supports databases up to 4GB which should be ample.

MySql is also a good choice, this site runs on MySql, so MySql is the most tested data layer we have after MS SQL. PostgreSql is also very robust and free.

any of the open source databases or even MS SQL Express can be used for commercial purposes. With open source licenses the issues are typically not about how you may use them but how the software may be redistributed. If you are not re-distributing or modifying the source code of the database software you are not likely to violate the license.

Best,

Joe

7/14/2010 7:17:22 AM
Snowman
Gravatar
Total Posts 65
View Posts

Re: Recomended datasource?

Hi,

I found this :

it is differentiated from the rest of the SQL Server 2005 editions only by the following:

   * Lack of enterprise features support
   * Limited to one CPU
   * One GB memory limit for the buffer pool
   * Databases have a 4 GB maximum size

My question is then, is mojoPortal saving anything else becides text and pages in the database? Is maby images and files placed in the datasource as well?

BestRegards

7/14/2010 7:29:23 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Recomended datasource?

We are not currently storing images or other blobs in the database, though it is possible we will do so in the future for web farm support. However, if/when we do produce a web farm package it will probably be an add on product for sale and will only support MS SQL, SQL Express or SqlAzure, though one would probably not really use SQL Express in a web farm. My recommendation is for most people to use SQL Express and if your needs outgrow it then you can easily upscale to SQL Server or SqlAzure.

Best,

Joe

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