[Mono-aspnet-list] sqlite questions?

[Marek Habersack]

william leader wrote:
> I would suggest you consider using another database altogether. SQLite
> is meant to interface with c and c++ programs, neither of which is a
> language mono supports. Most asp.net applications are developed for
> Microsoft SQL server or MySQL server depending on where the developer
> wants the asp.net application to be run. Personally I would suggest
> MySQL as it has good support for ASP.net features like membership and
> role providers. Additionally the MySQL server can be run on a range of
> operating systems such as Windows and Linux. The MySQL libraries that
> allow .net languages such as C# to easily communicate with the MySQL
> server are known to work in both Microsoft and Mono environments. As a
> plus the community version of MySQL can be had for no cost, or if you
> need business support a commercial version is also available.
First of all, I suggest what Gonzalo did in his mail - do some research before ill-advising somebody 
and spreading misinformation.

In addition to what Gonzalo pointed out (the google search), there is also a pure C# port of SQLite 
(http://code.google.com/p/csharp-sqlite/).

As for recommending MySQL... I beg to differ - MySQL is not the only and not the best (IMHO) choice 
out there for .NET developers on any platform. One problem with MySQL provider for .NET is not 
really technical, but is never the less important - the connector is GPL-ed, so if your plan is to 
use it for a closed-source application which you want to sell (or even just provide in binary-only 
form) then you will either need to purchase commercial license from MySQL, open your code or resort 
to various tricks to circumvent GPL. Much better choice, as somebody else suggested, is PostgreSQL - 
  its .NET driver (Npgsql) is LGPL, has all the features you mentioned (membership, profile, role) 
and is shipped with Mono. Also, in my personal opinion, PostgreSQL offers much higher quality 
product (reliability, advanced features, security) than MySQL.

marek
> 
> -Will
> 
> On Tue, Nov 3, 2009 at 5:01 AM, Dale E. Moore <daleemoore at gmail.com> wrote:
>> Is this a good place to ask questions about sqlite? Can somebody please tell
>> me where to go;)
>>
>> Has everybody (or anybody) worked with monodevelop to put together an
>> asp.net application that uses an sqlite database that they then put into
>> production?
>>
>> hello, hello, hello ... is there anybody out there?
>>
>> _______________________________________________
>> Mono-aspnet-list mailing list
>> Mono-aspnet-list at lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>>
>>
> _______________________________________________
> Mono-aspnet-list mailing list
> Mono-aspnet-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>