|
|
Rank: Fanatic
Joined: 7/19/2006
Posts: 433
Location: Göteborg, Sweden
|
Ruben, just want to say that this is a great initiative! I can't say that I've ever been stopped by the fact that Umbraco uses SQL Server (I use ultimahosts.net for budget hosting). But some companies have their preferred DBs and that's where a DAL would be great... // ;) Kalle
" - Yeah I'd like to share your point of view, as long as it's my view too... ( http://www.d-a-d.dk/lyrics/pointofview)
|
|
Rank: Addict
Joined: 2/19/2007
Posts: 634
Location: Belgium
|
Great work Ruben !
Umbraco tips and tricks: http://www.nibble.be - umbraco mvp 08/09 - certified level 1 & 2 professional
|
|
Rank: Aficionado
Joined: 10/30/2007
Posts: 179
Location: Bellingham
|
Rueben - Nice. Thanks! This is good stuff. Do you mind if I use your code (with acknowledgments) in an Amazon EC2 AMI I'm putting together for Umbraco? -Paul
motusconnect.com :: level-2 certified :: MVP 2008/2009 See you at Codegarden08 US in Chicago!
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
Hi Paul, Thanks for asking, of course you can use the code. But I'm still working on it, and in fact the Christmas festivities have slowed down my work a lot. Progress so far: *did a little more abstraction *created an extensions system -first extension: logging class that keeps track of every query This class will help me soon to analyze what steps I should take to make an MySQL compliant provider. Also, I've contacted Niels Hartvig and it's possible that I will join the core team and/or add the datalayer to the Umbraco distribution. If you need the latest version of my code, please e-mail me: [myfirstname].[mylastname]@gmail.com and I'll be happy to help you. Ruben
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Addict
Joined: 3/17/2008
Posts: 808
Location: Nyborg, Denmark
|
An umbraco ami would be so incredibly cool - can't wait :-D
Jeeeez, did I really start this :-)
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
:) yeah, keep us updated!
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Administration
Joined: 7/25/2006
Posts: 413
Location: vipperoed, denmark
|
Niels Hartvig wrote:
An umbraco ami would be so incredibly cool - can't wait :-D
forgive me for exposing my lacking knowledge - but what the heck is an AMI? :-) Kindly, Jesper
webbureau jesper.com doing webdesign / development / umbraco implementations / 2007&2008 MVP
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
Amazon Machine Image, Wikipedia
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Addict
Joined: 7/19/2006
Posts: 584
Location: Bad Homburg, Germany
|
|
|
Rank: Administration
Joined: 7/25/2006
Posts: 413
Location: vipperoed, denmark
|
oh .... I've heard about that but I still fail to see the Umbraco Ami connection. Another thing - Your signature says "even Access". I'm more like "even xml files". Kindly, Jesper
webbureau jesper.com doing webdesign / development / umbraco implementations / 2007&2008 MVP
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
Basicly, it's an out-of-the-box setup of Umbraco for the Amazon system mentioned. My signature, nice idea, and although I've read Kevin William's XML databases book, I don't think I can come up with an XML solution that would be fast enough for Umbraco. I just put "Access", because it must be the ugliest database system everyone knows ;)
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
But wait a minute... never say never... the datalayer I'm writing does make XML implementations possible. But it's up to you then, I'm afraid I won't try yet. First have to work on MySQL anyway.
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Administration
Joined: 7/25/2006
Posts: 413
Location: vipperoed, denmark
|
Xml .. slower yes. But for smaller solutions it might not be the case. They will be probably run "in memory" anyway. Kindly, Jesper
webbureau jesper.com doing webdesign / development / umbraco implementations / 2007&2008 MVP
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
Yes indeed, I went a little too fast there. It is possible, but you'd need a very small site, and I don't know if I'd use Umbraco for such a project. But it's worth trying.
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
Alright, using my logger extension I've obtained what should be a full SQL log of an Umbraco setup, including a standard package and a first page view. I expect that, if one can make those SQL instructions run on a certain database engine, 99% of all queries will run successfully. I'm curious what's going to happen when I run this on a MySQL server. I'll try this one of the following days. Click here to download the log file
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Aficionado
Joined: 12/21/2007
Posts: 122
Location: Belgium
|
And damn, naughty Umbraco developers, I also noticed my password being stored in plain text. We're going to talk about this later ;)
Umbraco Core Team Developer | Working on vNext | LinkedIn
|
|
Rank: Aficionado
Joined: 10/30/2007
Posts: 179
Location: Bellingham
|
Jesper - The idea behind creating an Umbraco AMI for Amazon EC2 is to broaden the potential appeal of Umbraco (I'm all about gettting Umbraco to 500k implementations in the next 2-years). One of the things I hear - and experienced first hand - is that Umbraco is hard to 'get to know.' I take this to mean that out of the box Umbraco is not nearly as impressive as it can be with a little bit of added content and a few of the excellent extensions available. Also, and I think this is a good thing, Umbraco has the greatest appeal for geeks (i.e.; developers and technically-oriented designers). Geeks rock(!!) of course, but there are lots of scenarios where Umbraco is the 'best' choice but never gets seriously considered because of the effort required to get it up and running. The installer with 3.0.3 goes a long way toward reducing the effort required. So, with Amazon (and JumpBox, ServePath, etc...) there is no actual 'setup.' A user just starts an instance of a machine (this is all virtual) and has a full environment ready to go. We could deliver an Umbraco AMI with the best of the best in terms of content and extensions - already configured and ready to use. Not to mention the incredible economic advantage afforded by these solutions. Granted, there is still a certain amount of technical knowledge required to start an Amazon EC2 instance (less so with JumpBox) but it seems there are plently of people creating friendly UI's to broaden the appeal of these services. I'll keep my blog updated with the progress of this. -Paul
motusconnect.com :: level-2 certified :: MVP 2008/2009 See you at Codegarden08 US in Chicago!
|
|
Rank: Addict
Joined: 3/17/2008
Posts: 808
Location: Nyborg, Denmark
|
The latest version on codeplex doesn't store user credentials in plain text and it'll be updated to do the same for the members section!
I must admit that I didn't took this area too seriously as I thought that if someone actually broke in and took your db, the user credentials was your smallest problem. That was a bit immature, so for umbraco 3.1 plain-text pw's is no longer default.
/n
Jeeeez, did I really start this :-)
|
|
Rank: Addict
Joined: 3/17/2008
Posts: 808
Location: Nyborg, Denmark
|
Regarding the xml part - I think you could find it to be as fast as an access db as the db is not that heavily queried (and almost not used in the runtime section). The only problem is multiple users with xml as one would need to make sure that saves are queued.
This is good times - thanks all for making this effort. I too would love to see 500k implementations in two years - with currently 25k downloads a month and a 900+% growth rate this year it's not unrealistic.
2008 - here we come :)
/n
Jeeeez, did I really start this :-)
|
|
Rank: Administration
Joined: 7/25/2006
Posts: 413
Location: vipperoed, denmark
|
Paul Sterling wrote:Jesper - The idea behind creating an Umbraco AMI for Amazon EC2 is to broaden the potential appeal of Umbraco (I'm all about gettting Umbraco to 500k implementations in the next 2-years). One of the things I hear - and experienced first hand - is that Umbraco is hard to 'get to know.' I take this to mean that out of the box Umbraco is not nearly as impressive as it can be with a little bit of added content and a few of the excellent extensions available. Also, and I think this is a good thing, Umbraco has the greatest appeal for geeks (i.e.; developers and technically-oriented designers). Geeks rock(!!) of course, but there are lots of scenarios where Umbraco is the 'best' choice but never gets seriously considered because of the effort required to get it up and running. The installer with 3.0.3 goes a long way toward reducing the effort required. So, with Amazon (and JumpBox, ServePath, etc...) there is no actual 'setup.' A user just starts an instance of a machine (this is all virtual) and has a full environment ready to go. We could deliver an Umbraco AMI with the best of the best in terms of content and extensions - already configured and ready to use. Not to mention the incredible economic advantage afforded by these solutions. Granted, there is still a certain amount of technical knowledge required to start an Amazon EC2 instance (less so with JumpBox) but it seems there are plently of people creating friendly UI's to broaden the appeal of these services. I'll keep my blog updated with the progress of this. -Paul Thanks for the info. It's all great initiatives. Jumpbox is cool - in some ways it's the same and in others it's the opposite - you download an easy installation and in Amazon you upload your own image and they handle flexible hosting. Both is cool. But how is this releated to this topic - the new DAL? If it's because we don't use MS SQL anymore then - and mono support is on it's way? Kindly, Jesper
webbureau jesper.com doing webdesign / development / umbraco implementations / 2007&2008 MVP
|
|
|
Guest |