New site with Umbraco 7.2.2 - MsSQL Express or MySQL?
Is there any benefits to choose MySQL instead of MsSQL Express?
Since there is a possibility for that we shall upload many videos to a site made with Umbraco later, I first choose MySQL on my developer site because of there is no limit in database size before cost of license. But now I see that videos are upload outside the database, and are not BLOB-files inside of the database.
MsSQL Express seems to have no cost considering the license costs before a limit of 10GByte (I have read somewhere), and its hard to see how that the database can pass this limit, so do you recommend to use MsSQL Express instead of MySQL on the production site?
I think that you only have to choice between the MSSQL Express or MSSQL server or SQLCE. I would not use the SQLCE in production, it´s good for some proof of concept, but I have seen an issue with using a SQLCE try to see the issue here: http://issues.umbraco.org/issue/U4-4621
I don´t think that the MySQL has got much attention, since the SQLCE database was introduced in Umbraco 4.6, if I remeber correctly. If it was me I would go with the MSSQL Server Express or a MSSQL Server.
Go with MSSQL - MySQL support has not been maintained for quite a while. It is possible to get it to work but it can be a challenge for those who have tried it seems. Secondly if you plan on using any community 3rd party packages that requires database access they most likely don't support anything other than MSSQL either.
You should perhaps even consider upgrading to MSSQL server instead of using Express if you can see that your application will scale a lot.
But have you considered handling the videos using other services? I don't suppose Youtube / Vimeo is an option but hosting services like http://wistia.com/ for instance or perhaps even Vimeo business https://vimeo.com/business (Not sure if it's possible to keep videos private). Perhaps it's better to let those 3rd party companies provide the video hosting factility and then integrate up against those instead when you need to get the videos on a website?
Yes, I've thought about it. Youtube.com was my first thought, but I will check out http://wistia.com or http://vimeo.com/business the third party when it becomes relevant. Thanks!
You're welcome - Sometimes it's just better to base such things on a system that is build to handle large amount of videos.
Another approach could perhaps be to store videos in a folder structure on your disk instead and then have a picker reading the folder structure somehow depending on how you need to serve and integrate the videos.
Some here also recommend SQL Ce, but if I choose to use SQL Express, do you recommend SQL Express 2014 SQL instead of Express 2012 with Umbraco 7.2.2 on a virtual server with Windows Server 2012 R2? If I want to migrate SQL Ce to SQL Express later, than I have to install SQL Express 2014?
Yeah I saw Sebastian writing the HQ seem to be using CE SQL a lot. But I have just had some bad experiences using it. And if you're using source control it's not possible to merge the database if you add data and one of your co-workers add data etc.
I have not tried SQL Express 2014 myself but I don't see what should be holding you back unless 2014 has higher system requirements etc. for instance.
New site with Umbraco 7.2.2 - MsSQL Express or MySQL?
Is there any benefits to choose MySQL instead of MsSQL Express?
Since there is a possibility for that we shall upload many videos to a site made with Umbraco later, I first choose MySQL on my developer site because of there is no limit in database size before cost of license. But now I see that videos are upload outside the database, and are not BLOB-files inside of the database.
MsSQL Express seems to have no cost considering the license costs before a limit of 10GByte (I have read somewhere), and its hard to see how that the database can pass this limit, so do you recommend to use MsSQL Express instead of MySQL on the production site?
Hi Tom,
I think that you only have to choice between the MSSQL Express or MSSQL server or SQLCE. I would not use the SQLCE in production, it´s good for some proof of concept, but I have seen an issue with using a SQLCE try to see the issue here: http://issues.umbraco.org/issue/U4-4621
Try to see the system requirements for Umbraco 7 here: https://our.umbraco.org/documentation/Installation/system-requirements
I don´t think that the MySQL has got much attention, since the SQLCE database was introduced in Umbraco 4.6, if I remeber correctly. If it was me I would go with the MSSQL Server Express or a MSSQL Server.
Hope this helps,
/Dennis
Thanks, then I will continue with MSSQL Server Express from now on..
Hi Tom
Go with MSSQL - MySQL support has not been maintained for quite a while. It is possible to get it to work but it can be a challenge for those who have tried it seems. Secondly if you plan on using any community 3rd party packages that requires database access they most likely don't support anything other than MSSQL either.
You should perhaps even consider upgrading to MSSQL server instead of using Express if you can see that your application will scale a lot.
But have you considered handling the videos using other services? I don't suppose Youtube / Vimeo is an option but hosting services like http://wistia.com/ for instance or perhaps even Vimeo business https://vimeo.com/business (Not sure if it's possible to keep videos private). Perhaps it's better to let those 3rd party companies provide the video hosting factility and then integrate up against those instead when you need to get the videos on a website?
/Jan
Yes, I've thought about it. Youtube.com was my first thought, but I will check out http://wistia.com or http://vimeo.com/business the third party when it becomes relevant. Thanks!
Hi Tom
You're welcome - Sometimes it's just better to base such things on a system that is build to handle large amount of videos.
Another approach could perhaps be to store videos in a folder structure on your disk instead and then have a picker reading the folder structure somehow depending on how you need to serve and integrate the videos.
/Jan
Some here also recommend SQL Ce, but if I choose to use SQL Express, do you recommend SQL Express 2014 SQL instead of Express 2012 with Umbraco 7.2.2 on a virtual server with Windows Server 2012 R2? If I want to migrate SQL Ce to SQL Express later, than I have to install SQL Express 2014?
Hi Tom
Yeah I saw Sebastian writing the HQ seem to be using CE SQL a lot. But I have just had some bad experiences using it. And if you're using source control it's not possible to merge the database if you add data and one of your co-workers add data etc.
I have not tried SQL Express 2014 myself but I don't see what should be holding you back unless 2014 has higher system requirements etc. for instance.
/Jan
Thanks, then I'll install SQL Express 2014 and try it against Umbraco 7.2.2.
Hi Tom
You're welcome - And I just noticed you got the installation problem you've been struggling with fixed as well :) Good times ahead!
/Jan
is working on a reply...