MySql integration in Orchard

Today Orchard can be used with two different databases, i.e. Sql Ce and Sql Server (including Sql Express), which provides enough options not only for simple websites but also enterprise level ones requiring better reliability and performance. In the upcoming release Orchard will also support MySql.

Downloading Orchard with MySql support

Rickard Pettersson took the time to implement it based on the current development branch which uses NHibernate 3. So you will need to clone the repositories at the latest changeset from the 1.x branch, or you can also get a zip file containing the latest verion by clicking on this link.

Setting up Orchard with MySql

Once you have downloaded the latest source code, run it and the Setup screen should now look like this.

enter image description here

If you have an already running MySql server, just create a database and set the connection string. The Database Table Prefix is usefull if you want to reuse the same database accross different Orchard installations.

If you don't have a running MySql server and don't want the burden of setting one up then an very easy solution is to use Windows Azure Web Sites as you can setup a free hosted MySql instance.

Click Finish Setup, play with it, and report any bug you could find.

License compatibility

MySql is licensed under GPL, which includes both the database server and the client libraries. Fortunately it comes with open source exceptions which let us redistribute the client libraries as explained in the FAQ below.

Q3: Can an open source software project combine and distribute any of Oracle’s GPL-licensed MySQL software with other open source software under the FOSS License Exception? Does this include the MySQL database server?

A: Open source software projects and other developers are free to use and distribute GPL-licensed MySQL software with other open source software as long as they comply with the terms of the GPL. Open source software projects and other developers can also use and distribute open source applications with the GPL-licensed MySQL Client Libraries under the terms of the FOSS License Exception without causing the entire derivative work to be subject to the GPL.

The FOSS License Exception only applies to software licensed under the FOSS licenses listed in the section above titled “FOSS License List”, and only with respect to use and distribution of Oracle’s MySQL Client Libraries.

The FOSS License Exception does not apply to the MySQL database server or other Oracle or MySQL software. The terms of the GPL apply with respect to use and distribution of the MySQL database server with any other software.

This doesn't give you the right to use MySql for free, you still need to comply with the license, but it allows Orchard to be distributed with the client libraries, as Orchard is distributed under the BSD license.

75 Comments

  • tutorials said

    I like the valuable info you provide for your articles.
    I will bookmark your weblog and check again right here frequently.
    I am relatively certain I'll be told lots of new stuff proper here! Good luck for the following!

  • criminal case unlimited energy said

    I almost never drop remarks, however after browsing a great
    deal of responses on MySql integration in Orchard. I do have a couple of questions for you if you do not mind.
    Could it be just me or do some of these comments come across like they are written
    by brain dead visitors? :-P And, if you are writing on additional social sites,
    I would like to follow everything new you have to post. Would
    you list of the complete urls of all your social networking pages like
    your Facebook page, twitter feed, or linkedin profile?

  • clash royale cheat 2017 said

    So useful information like always.

  • Reviews of essay writing service said

    Excellent stuff you shared here.. It’s difficult to find excellent writing like yours these days. I really appreciate individuals like you! 'MySql integration in Orchard' is very helpful for the student who are selected computer science as their main stream subject. Thank you

  • buy an essay online said

    I think what you published made a ton of sense.

    But, think on this, what if you added a little content?
    I mean, I don't want to tell you how to run your website, however what if you added a
    title to maybe get folk's attention? I mean MySql integration in Orchard is kinda plain.
    You could glance at Yahoo's front page and note how they create news titles to grab viewers to click.
    You might try adding a video or a picture or two to grab readers interested about everything've written. In my opinion, it would
    bring your posts a little livelier.

  • dissertation writing said

    With havin so much written content do you ever run into any problems of plagorism or copyright infringement?

    My blog has a lot of unique content I've either created
    myself or outsourced but it seems a lot of it is popping it
    up all over the web without my authorization. Do you
    know any techniques to help prevent content from being ripped off?
    I'd certainly appreciate it.

  • thesis writing said

    Hi there to all, how is the whole thing, I think every
    one is getting more from this site, and your views are good designed for new visitors.

  • cheap assignment writing service said

    Hi there! Someone in my Facebook group shared this website with us so I came to take
    a look. I'm definitely enjoying the information.
    I'm bookmarking and will be tweeting this to my
    followers! Exceptional blog and terrific design.

  • gamefly free trial said

    You can certainly see your skills within the work you write.
    The sector hopes for even more passionate writers such
    as you who aren't afraid to say how they believe.
    At all times go after your heart.

  • gamefly said

    Great post.

  • gamefly free trial said

    Spot on with this write-up, I really feel this amazing site needs far more attention. I'll probably be back again to
    see more, thanks for the info!

  • gamefly said

    Hi to all, the contents existing at this site are genuinely remarkable
    for people knowledge, well, keep up the nice work fellows.

  • gamefly free trial said

    You've made some good points there. I looked on the web for more info about the issue and found
    most people will go along with your views on this web site.

  • gamefly free trial said

    Incredible points. Great arguments. Keep up the good spirit.

  • gamefly free trial said

    In fact when someone doesn't be aware of after that its up to
    other visitors that they will assist, so here it happens.

  • how to download minecraft free said

    My spouse and I stumbled over here by a different web address and
    thought I might as well check things out. I like what
    I see so now i'm following you. Look forward to looking over your web
    page repeatedly.

  • minecraft download mojang said

    It is perfect time to make some plans for the future
    and it's time to be happy. I've read this post and if I could I desire to suggest you few interesting things
    or tips. Maybe you can write next articles referring to this article.
    I desire to read more things about it!

  • download minecraft said

    I'm not sure exactly why but this site is loading very slow for me.
    Is anyone else having this issue or is it a issue
    on my end? I'll check back later and see if the problem still
    exists.

  • how to download minecraft said

    Do you have a spam issue on this website; I also am a blogger, and I
    was curious about your situation; many of us have developed some nice methods and we
    are looking to swap methods with others, why not shoot me an email if
    interested.

  • how to download minecraft free said

    Why visitors still use to read news papers when in this technological world all
    is presented on net?

  • minecraft download free pc said

    Excellent post but I was wanting to know if you could write a litte more on this topic?

    I'd be very grateful if you could elaborate a little bit more.
    Thanks!

  • download minecraft free said

    I go to see daily some websites and websites to read content, however this web site offers
    feature based posts.

  • minecraft for free said

    Great information. Lucky me I recently found your blog by accident (stumbleupon).
    I have saved as a favorite for later!

  • g said

    whoah this blog is magnificent i really
    like studying your articles. Stay up the great work!
    You realize, lots of people are searching around for this information, you can aid them
    greatly.

  • minecraft free said

    I think this is among the most significant info for me. And i'm glad reading your article.
    But should remark on some general things, The website style is ideal, the articles is really great : D.
    Good job, cheers

  • g said

    I'm gone to inform my little brother, that he should also go to
    see this blog on regular basis to take updated from most up-to-date gossip.

  • how to download minecraft free said

    This piece of writing is truly a nice one it assists
    new internet viewers, who are wishing for blogging.

  • g said

    Hi there are using Wordpress for your site platform?
    I'm new to the blog world but I'm trying to get started and set
    up my own. Do you need any coding knowledge to make your own blog?
    Any help would be really appreciated!

  • g said

    Great goods from you, man. I've understand your stuff previous
    to and you are just extremely wonderful. I really like what
    you have acquired here, really like what you're saying and the
    way in which you say it. You make it entertaining and you still care for to keep it
    wise. I can't wait to read far more from you. This is really a
    wonderful site.

  • g said

    Pretty component of content. I simply stumbled upon your blog and in accession capital to claim that I get in fact enjoyed account
    your weblog posts. Anyway I'll be subscribing to your augment and even I fulfillment you get admission to persistently rapidly.

  • g said

    It's remarkable in favor of me to have a web page, which is
    valuable for my experience. thanks admin

  • minecraft pc download said

    Hey There. I found your blog using msn. This is an extremely well written article.
    I will be sure to bookmark it and come back to read more of your useful info.
    Thanks for the post. I'll certainly comeback.

  • minecraft free download said

    Awesome blog you have here but I was curious about if you knew
    of any user discussion forums that cover the same topics talked about here?
    I'd really love to be a part of group where I can get opinions from other knowledgeable individuals that share the same interest.
    If you have any recommendations, please let me know. Thanks a lot!

  • mojang minecraft download said

    I do not know if it's just me or if everybody else encountering problems with your site.

    It appears as if some of the text in your content are running off the screen.
    Can somebody else please comment and let me know if this is
    happening to them too? This may be a issue with my internet browser
    because I've had this happen previously. Many thanks

  • free minecraft download said

    I enjoy, cause I found just what I used to be taking a look
    for. You've ended my 4 day lengthy hunt! God Bless you man. Have
    a great day. Bye

  • minecraft download for free said

    I visit day-to-day some sites and blogs to read posts, but this webpage provides feature based articles.

  • minecraft free download said

    Hey There. I found your blog using msn. That is an extremely smartly written article.
    I'll make sure to bookmark it and return to read extra of your helpful information. Thank you for
    the post. I'll certainly comeback.

  • free minecraft said

    Hi! I could have sworn I've visited this site before but after going through a
    few of the articles I realized it's new to me. Anyhow, I'm definitely pleased I found it and I'll be bookmarking it and checking back regularly!

  • minecraft for free said

    What a stuff of un-ambiguity and preserveness of precious know-how about unpredicted
    emotions.

  • download minecraft said

    It's wonderful that you are getting thoughts from this paragraph as well as from our argument made here.

  • free minecraft download said

    Hi there everyone, it's my first visit at this web site, and post
    is genuinely fruitful in support of me, keep up posting these
    types of posts.

  • mojang minecraft download said

    Great post. I was checking constantly this blog and I'm impressed!

    Very useful information particularly the last part :)
    I care for such info much. I was seeking this particular info for a very long time.
    Thank you and best of luck.

  • gamefly free trial said

    It's great that you are getting thoughts from this post as well as from our argument made at
    this time.

  • how to get help in windows 10 said

    Hello, this weekend is fastidious in favor of me, because this occasion i am reading this
    impressive informative piece of writing here at my house.

  • gamefly free trial said

    Wonderful blog! I found it while searching on Yahoo News.

    Do you have any suggestions on how to get listed in Yahoo News?
    I've been trying for a while but I never seem to get there!
    Appreciate it

  • how to get help in windows 10 said

    You've made some decent points there. I checked on the net for more information about the issue and found most individuals will go along with your views on this web site.

  • gamefly free trial said

    When someone writes an paragraph he/she keeps the plan of a
    user in his/her mind that how a user can be aware of it.
    So that's why this article is amazing. Thanks!

  • gamefly free trial said

    Hello, Neat post. There's a problem with your web site in internet explorer, could check this?
    IE still is the market leader and a good section of
    people will leave out your wonderful writing because of
    this problem.

  • gamefly free trial said

    I'm truly enjoying the design and layout of your website.
    It's a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire
    out a designer to create your theme? Outstanding work!

  • gamefly free trial said

    Hello just wanted to give you a brief heads up and let you know
    a few of the pictures aren't loading properly. I'm not sure why
    but I think its a linking issue. I've tried it in two different web browsers and
    both show the same results.

  • gamefly free trial said

    I visit day-to-day some sites and information sites to read
    articles or reviews, but this web site provides quality based articles.

  • gamefly free trial said

    It's actually a nice and useful piece of info. I'm glad that you just shared this helpful information with us.
    Please keep us informed like this. Thanks for sharing.

  • gamefly free trial said

    Hello! I'm at work browsing your blog from my new apple iphone!
    Just wanted to say I love reading through your blog and look
    forward to all your posts! Carry on the great work!

  • gamefly free trial said

    Appreciating the time and effort you put into your blog and in depth information you
    present. It's awesome to come across a blog every once in a while that
    isn't the same out of date rehashed information. Excellent read!

    I've bookmarked your site and I'm adding your RSS feeds to my Google account.

  • gamefly free trial said

    Hey there! I understand this is sort of off-topic
    but I had to ask. Does running a well-established blog such as yours require a large
    amount of work? I'm completely new to running a blog however I do write
    in my diary daily. I'd like to start a blog so I can share
    my personal experience and feelings online. Please let me know if you have any recommendations or tips for new aspiring blog owners.
    Appreciate it!

  • tinyurl.com said

    Wow, superb blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your site is magnificent, as well
    as the content!

  • ps4 games 2019 list said

    magnificent post, very informative. I ponder why the opposite specialists of this sector do not realize
    this. You must continue your writing. I am sure, you have a huge
    readers' base already!

  • gamefly free trial said

    You need to take part in a contest for one of the best blogs on the web.
    I'm going to recommend this web site!

  • ps4 games 2017-18 said

    Hey I am so excited I found your website, I really found you by
    accident, while I was searching on Bing
    for something else, Regardless I am here now and would just like to say thanks a lot for a tremendous post and a all round interesting blog
    (I also love the theme/design), I don't have time to go
    through it all at the minute but I have book-marked it and
    also included your RSS feeds, so when I have time I will be back
    to read more, Please do keep up the excellent work.

  • tinyurl.com said

    It's really a cool and useful piece of information. I'm glad that
    you shared this useful information with us. Please
    stay us informed like this. Thanks for sharing.

  • gamefly free trial 2019 coupon said

    I am truly grateful to the owner of this web page who has shared this
    great article at at this time.

  • gamefly free trial 2019 coupon said

    Asking questions are really nice thing if you are not understanding anything completely, except this piece of writing presents good understanding
    even.

  • playstation 4 best games ever made 2019 said

    Thank you for every other informative site. The place else may I
    am getting that type of info written in such a perfect approach?

    I've a venture that I'm simply now running on, and I have been on the glance out for such info.

  • playstation 4 best games ever made 2019 said

    fantastic publish, very informative. I wonder why the opposite
    specialists of this sector do not understand this.
    You should proceed your writing. I am sure, you have a huge readers' base already!

  • playstation 4 best games ever made 2019 said

    Hi my loved one! I want to say that this post is awesome, nice written and come with approximately
    all significant infos. I would like to see extra posts like this .

  • quest bars cheap said

    I think the admin of this website is genuinely
    working hard in favor of his web page, since here every
    information is quality based material.

  • quest bars cheap said

    Link exchange is nothing else however it is simply placing the other person's blog link on your page at proper place and other
    person will also do similar for you.

  • quest bars cheap said

    Hi i am kavin, its my first occasion to commenting anywhere, when i read this post i thought i could also create comment due to this sensible post.

  • quest bars cheap said

    Hi, i think that i saw you visited my weblog thus i came to “return the favor”.I'm trying to find
    things to improve my website!I suppose its ok to use some of your ideas!!

  • quest bars said

    I really like reading through a post that can make men and women think.
    Also, thanks for allowing for me to comment!

  • quest bars cheap said

    Hi I am so excited I found your weblog, I really found you by error,
    while I was looking on Yahoo for something else, Regardless I am here
    now and would just like to say cheers for a marvelous post and a all round exciting blog (I also love the theme/design), I don’t have time to read
    it all at the minute but I have saved it and also added in your RSS feeds,
    so when I have time I will be back to read much more, Please do keep up
    the excellent jo.

  • http://tinyurl.com/yxwn7evu said

    I'm no longer certain where you are getting your information, however good topic.
    I needs to spend some time learning much more or working
    out more. Thank you for wonderful information I used to be on the lookout for this information for my mission.

  • tinyurl.com said

    What's up i am kavin, its my first time to commenting anywhere, when i read this paragraph i
    thought i could also create comment due to this brilliant piece of
    writing.

  • plenty of fish dating site said

    With havin so much content do you ever run into any problems of plagorism or
    copyright infringement? My website has a lot of completely unique content I've either authored
    myself or outsourced but it appears a lot of it
    is popping it up all over the web without my
    permission. Do you know any solutions to help reduce content
    from being ripped off? I'd truly appreciate it.

  • quest bars cheap said

    Wow, wonderful blog structure! How long have you ever been blogging
    for? you make blogging glance easy. The entire look of your website is excellent, as smartly as the content!

Add a Comment