Hugoware

The product of a web developer with a little too much caffeine

Vacation Week!

with 3 comments

I’ve been on vacation this week and didn’t spend much time programming… well, not on anything official at least. Mostly I’ve been poking around at stuff between games of Modern Warfare 2 and my chore list from The Wife. One of the more interesting things I’ve been playing with is using MySql with MonoDevelop and Ubuntu.

Since MSSQL normally costs extra in a hosted environment I typically end up using a handful of XML files or serialization to keep track of information. But now that I’ve been using Mono I started to consider that MySQL might be an option for further projects (especially since it’s normally free in hosted environments).

I did a post recently about getting started with cross platform development where I listed some resources to get you started but I didn’t mention anything about using SQL. Below are some tools that can get you started.

MySQL (Server)
Setup for the actual SQL server instance — Standard stuff here…

MySQL GUI Tools and the MySQL Workbench
Great set of tools to work with your SQL server instance. Just look at how polished some of these tools actually are!

A couple warnings before you get too far. Linux (or at least Ubuntu) is case sensitive — this means that if you try to include the DLL files for MySQL in your Mono project the case must match! When I downloaded the files they were all in lower case but the DLLs were imported using camel case (mysql.data.dll as opposed to MySql.Data.dll)

Also, I don’t see any way to use LINQtoSQL with MySQL (and it wouldn’t make sense if it did anyways). Be prepared to start writing your own queries just in case.

Advertisements

Written by hugoware

November 29, 2009 at 8:04 pm

3 Responses

Subscribe to comments with RSS.

  1. I recall reading a post either by Jon Galloway or a post the discussed the fact that Jon Galloway ported SubSonic to Mono a year. I’ve been trying to find out more.

    SubSonic supports MySQL and provides a similar function to LinqToSQL called Query surface.

    http://subsonicproject.com/docs/Query_Surface

    I am really geeked about Mono on Ubuntu. I find it incredibly productive and hope that more people start using this platform. As you’ve said, there are good tools for free, and if you looking to produce products on a tight budget you can’t go wrong here.

    I’ve been reading the code from MindTouch, a open source CMS / Wiki platform with the engine written in C# / Mono and the front end in PHP. They’ve been around since 2006 and the code is very good. Had I encountered this earlier I would have chosen MindTouch over SharePoint in a heartbeat.

    A lot of cool possibilities out there!

    ActiveEngine Sensei

    December 1, 2009 at 6:56 am

    • Cool stuff about Query Surface!

      As far as Mono is concerned, I’m still surprised that so much just works already! I’m actually able to install a Linux OS and write a .NET MVC app with a MySql background and it is painless so far! (well… except the case sensitivity for Ubuntu.. that threw me off some)

      I’m way psyched that I can just pick this stuff up and run with it and I’m not having to relearn all new stuff.

      I like learning new things, but it is nice to be so productive with very little education…

      webdev_hb

      December 1, 2009 at 1:25 pm

  2. Not sure what the progress of Entity Framework in Mono is but there is an EF provider for MySQL.
    http://dev.mysql.com/downloads/connector/net/6.0.html

    Mike Brown

    December 3, 2009 at 2:57 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: