I first started looking at Umbraco yesterday. I've been trying to understand the database and came across two tables that seem to duplicate data available elsewhere:
* cmsContent
* cmsContentVersion
Am I right in my assumption that these are denormalized tables purely there for performance reasons?
Since you are new to Umbraco I think that you should know there are some good resources that shows the bacsic concepts of Umbraco. Here on the Umbraco.tv there are some free videos tutorials about Umbraco, some of them requires that you subscribe to the service, but some of them are free to watch http://umbraco.tv/videos/umbraco-v7/implementor/ and here are some videos if you are an writter og editor: http://umbraco.tv/videos/umbraco-v7/content-editor/
And you probably have seen that the Umbraco installation comes with a starter kit pre installed, that is also a good way to learn Umbraco. Back when I started working with Umbraco I setup two Umbraco installtions one with the starter kit and one without the starter kit, and in the installation without the starter kit I started build my own website, If I have some any doubts about how things was done in Umbraco I could look at the installation with the starter kit installed.
In Umbraco 7 the starter kit is pre installed but you can uninstalled it if you want to. Go to the developer section. Open the package folder, navigate to the installed package folder, and then click on the starter kit, and tab to the uninstall tab.
And as you have already discovered, there are this forum, and we are friendly people in there that will try to help, as much as we can. So if you have other questions don't hesitate to create a new topic in the forum.
Thank you for the detailed and fast reply. I just subscribed to umbraco.tv.
I am new to this product but after previously using Sharepoint I find Umbraco a breath of fresh air. I am impatient to get things working quickly so I'm trying to simultaneously learn the DB, API and the admin UI. I hope the three views of Umbraco will at some point make sense together. Recreating a starter template in a blank installation is a good idea - I think I'll do that next.
When I looked at the standard starter template it seemed to make sense. But, I then installed an MVC starter kit which was quite a bit more complex and also threw some errors so I think there must be dependencies I am missing.
I've also been using SQL Profiler to see what queries are being thrown at the DB while I use the admin UI but there were a lot of queries and it soon became confusing.
I'll work through the videos and the documentation you linked and post any questions I can't resolve myself.
Umbraco Database
I first started looking at Umbraco yesterday. I've been trying to understand the database and came across two tables that seem to duplicate data available elsewhere:
* cmsContent
* cmsContentVersion
Am I right in my assumption that these are denormalized tables purely there for performance reasons?
Hi David and welcome to our,
I think that the cmsContentVersion table is for rollback functionality in the Umbraco backoffice. You can read about the rollback functionality here: http://our.umbraco.org/wiki/reference/umbraco-client/context-menus/rollback
Since you are new to Umbraco I think that you should know there are some good resources that shows the bacsic concepts of Umbraco. Here on the Umbraco.tv there are some free videos tutorials about Umbraco, some of them requires that you subscribe to the service, but some of them are free to watch http://umbraco.tv/videos/umbraco-v7/implementor/ and here are some videos if you are an writter og editor: http://umbraco.tv/videos/umbraco-v7/content-editor/
I also think that this documentation would be nice to see, it´s just in the written format: http://our.umbraco.org/documentation/Using-Umbraco/Creating-Basic-Site/
And you probably have seen that the Umbraco installation comes with a starter kit pre installed, that is also a good way to learn Umbraco. Back when I started working with Umbraco I setup two Umbraco installtions one with the starter kit and one without the starter kit, and in the installation without the starter kit I started build my own website, If I have some any doubts about how things was done in Umbraco I could look at the installation with the starter kit installed.
In Umbraco 7 the starter kit is pre installed but you can uninstalled it if you want to. Go to the developer section. Open the package folder, navigate to the installed package folder, and then click on the starter kit, and tab to the uninstall tab.
And as you have already discovered, there are this forum, and we are friendly people in there that will try to help, as much as we can. So if you have other questions don't hesitate to create a new topic in the forum.
Hope this helps,
/Dennis
Hi Dennis,
Thank you for the detailed and fast reply. I just subscribed to umbraco.tv.
I am new to this product but after previously using Sharepoint I find Umbraco a breath of fresh air. I am impatient to get things working quickly so I'm trying to simultaneously learn the DB, API and the admin UI. I hope the three views of Umbraco will at some point make sense together. Recreating a starter template in a blank installation is a good idea - I think I'll do that next.
When I looked at the standard starter template it seemed to make sense. But, I then installed an MVC starter kit which was quite a bit more complex and also threw some errors so I think there must be dependencies I am missing.
I've also been using SQL Profiler to see what queries are being thrown at the DB while I use the admin UI but there were a lot of queries and it soon became confusing.
I'll work through the videos and the documentation you linked and post any questions I can't resolve myself.
Thanks again,
Dennis,
Would you mind editing your post to replace my email address?
Thanks,
I hadn't realised that my registration used my email address in place of my name.
David
is working on a reply...