Creating MySQL support Options
Ruben
Posted: Friday, December 28, 2007 11:10:04 AM

Rank: Aficionado

Joined: 12/21/2007
Posts: 123
Location: Belgium
Alright about the password storage.
I've done a quick run on MySQL, and the first few lines didn't run already. It's because all names and data types in the CREATE TABLE queries are wrapped in square brackets (while it's not really needed). I suppose this is because the SQL was generated by a dumping script.

Niels and others, do you think my assumption is right that 90% of all fixes will be in the install script?

Later in the testing process, it could be possible to execute queries on an SQL Server database and a MySQL database at the same time, and compare if the results are equal.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
psterling@homax
Posted: Friday, December 28, 2007 6:40:18 PM

Rank: Aficionado

Joined: 10/30/2007
Posts: 191
Location: Bellingham
Jesper -

Quote:
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?


You're right, this topic is not really applicable to this thread - although my idea with an Amazon AMI is to use MySQL we can create one using MSSQL just the same. I'll keep this in a seperate thread going forward.

Thanks,
-Paul

motusconnect.com :: level-2 certified :: MVP 2008/2009
See you at Codegarden08 US in Chicago!
simm2
Posted: Saturday, December 29, 2007 12:43:09 AM
Rank: Enthusiast

Joined: 12/22/2007
Posts: 12
Mono support?
Is that something someone in the core team is working on?

Leonardo Pires did some attempts about half a year ago, but his blog (http://aspnetajax.blogspot.com/) has not been updated for quite some time now. About a month ago, I tried to get an overview of what needed to be done in that area, but MonoDevelop (the wannabe-Linux equivalent to Visual Studio) returned some nasty odd error messages (they didn't even seem to be .NET related), so I got scared away and never looked back. (I'm not familiar with .NET development on the Linux-platform, only PHP)

It could be quite fun though - to see Umbraco running on an Apache 2 instance with mod_mono and MySQL as its database system.
mortenbock
Posted: Saturday, December 29, 2007 3:00:48 PM

Rank: Addict

Joined: 7/19/2006
Posts: 739
Location: Århus, Denmark
As far as I know, V4 of Umbraco will be based on LINQ, and since LINQ is not supported by Mono, i don't think that Mono support is something we should expect anytime soon.

Morten Bock - Level 2 certified - MVP 2008/2009 - My danish blog with a few english posts

Ruben
Posted: Saturday, December 29, 2007 3:09:51 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 123
Location: Belgium
Can anybody confirm that Umbraco will be based on LINQ? Is this decision already made?

I'm not sure in how far LINQ will be compatible with different databases. (I haven't used it myself, but I saw a demonstration where classes got automatically generated based on one certain type of database, thus maybe making it database-dependent.) But I think it should be possible to create a datalayer that is compatible with LINQ, and then add adapters that further translate it into SQL. Because ultimately, that's what has to happen.

PS I'm very close to a working MySQL solution. The datalayer has improved a lot, extending it should be very easy.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
hartvig
Posted: Saturday, December 29, 2007 3:22:12 PM

Rank: Addict

Joined: 3/17/2008
Posts: 831
Location: Nyborg, Denmark
Just to clarify; nothing has been settled for v4 yet (the planning of the features haven't even started), but we've looked at both SubSonic and LINQ2SQL for O/R mapping. But v4 isn't due to release before end 2008/start 2009 so nothing is certain and every day brings new possibilities. For priority for umbraco is 3.1, documentation and then 4.0.

Mono support is not something that's on top of the list, but if we could be mono compliant AND still use the new features in .NET 3.5 we want it would be a nice to have. However, I don't know how relevant it would be - finding a reliable host with experience in running the latest mod_mono bits is probably not the easiest - and cheapest (the main reason for running mono as far as I know) job. And even if umbraco would do mono, there's no guarantee that community tools would.

/n

Jeeeez, did I really start this :-)
hartvig
Posted: Saturday, December 29, 2007 3:24:19 PM

Rank: Addict

Joined: 3/17/2008
Posts: 831
Location: Nyborg, Denmark
Niels Hartvig wrote:

For priority for umbraco is 3.1, documentation and then 4.0.


That line should have been, first priorities for umbraco are:
- Documentation
- umbraco 3.1
- umbraco 4.0

/n

Jeeeez, did I really start this :-)
Ruben
Posted: Saturday, December 29, 2007 3:25:38 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 123
Location: Belgium
It'd be great if I have a working datalayer for 3.1.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
hartvig
Posted: Saturday, December 29, 2007 4:32:34 PM

Rank: Addict

Joined: 3/17/2008
Posts: 831
Location: Nyborg, Denmark
It would be more than great - it would be a sweet surprise! 3.1 is scheduled for a March release, with beta by end of Jan. Primary enhancements are:
- Masterpages support
- Membership Provider support for users and members (finally!)
- Sitemap Provider support
- Top five frustrations fixed
- Datalayer - wow!

:)
niels...

Jeeeez, did I really start this :-)
Ruben
Posted: Monday, December 31, 2007 6:05:24 PM

Rank: Aficionado

Joined: 12/21/2007
Posts: 123
Location: Belgium
Please read New Datalayer - SQL Server and MySQL support.

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn
psterling@homax
Posted: Thursday, January 03, 2008 6:10:58 PM

Rank: Aficionado

Joined: 10/30/2007
Posts: 191
Location: Bellingham
Niels -

Is the 900% growth rate a measure of the number of downloads, the number of implementations, or something else?

Thanks,
-Paul

motusconnect.com :: level-2 certified :: MVP 2008/2009
See you at Codegarden08 US in Chicago!
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.