[Mono-list] MySQL

[Ben Clewett]

Daniel Morgan wrote:

> I have replied to you inline.

As I.

> Great!  We need some good testers to find the bugs and write tests.

I'll do my best.

> "Specifically, somewhere where I can get any corrent
> documentation on how this .dll should be used?"
>
> I'm not sure what .dll you are talking about.  Are you talking about the
> Mono.Data.MySql.dll assembly or the MySQL native client library?


I think I need to understand better what clients are available, and why 
there may be two (or more) written for .NET in C# and under GPL.

There is Mono.Data.MySQL. Coded in C# and currently 'heavily' under 
development, written by Daniel Morgan, Rodrigo Moya, Ravi Pratap and 
Brad Merrill.  Under GPL.

Is this the one which uses the libmySQL.dll and linmysqlclient.so?

Or is this the one which is pure C#, but may suffer in the future as it 
may fall behind the MySQL protocol?

Is this the official 'mono' MySQL API you refered to?


There is also http://sourceforge.net/projects/mysqlnet/ which is also 
GPL.  Also C#.  Written by Jun Su, Reggie Burnett and Adam Hunger. This 
currently shows no files, so i can't look at it.  This currently has 
problems with Mono, but you have a working version.

There is another .NET MySQL driver written in C# by Manuel Lucas Viņas 
Livschitz, also GPL.  Is this the same one, I can't seem to find the 
page where I downloaded this.

There is the one from http://www.einfodesigns.com/.  Not GPL.

This is the ONLY official .NET API from MySQL on 
http://www.mysql.com/portal/software/html/software-32-1.html.  Which 
seems odd as MySQL seem to encourage the stong use of GPL API's.


If you can enlighten me a little, I would be greatful.

Ben


> The MySQL provider in Mono right now uses a native client shared 
> library: on
> Windows, this shared library is libmySQL.dll and on Linux, it is
> libmysqlclient.so
>
> A MySQL provider written in 100% C# would be better for performance 
> reasons,
> but that would mean we would have to keep up with the client/server 
> protocol
> used for MySQL database access.  At least with MySQL's native client
> library, the API is stable.
>
> There is a GPL'ed MySQL provider in sourceforge.net and works on .NET, but
> it does not work on Mono due to problems in I/O or networking (I assume)
> right now.  I have a modified version on my hard drive if interested. 
>  I had
> to strip out the Windows.Forms and System.Drawing stuff in there since we
> don't need that for Mono.  This provider is written in 100% C# and 
> does not
> use any MySQL client library because it communicates directly with the 
> MySQL
> server.  This is the
> MySQLNet mentioned in Venu's article.  Here is the link to that GPL'ed
> driver
> http://sourceforge.net/projects/mysqlnet/
>