Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • David 10 posts 30 karma points
    Sep 21, 2014 @ 22:10
    David
    0

    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?

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Sep 21, 2014 @ 23:39
    Dennis Aaen
    0

    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

  • David 10 posts 30 karma points
    Sep 22, 2014 @ 00:37
    David
    0

    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,

  • David 10 posts 30 karma points
    Oct 09, 2014 @ 00:24
    David
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft