sqlite questions?

[DaleEMoore]

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?

_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list

[Marek Habersack-6]

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@...> 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@...
>> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>>
>>
> _______________________________________________
> Mono-aspnet-list mailing list
> Mono-aspnet-list@...
> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>

_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list

[Marek Habersack-6]

Dale E. Moore wrote:
> Is this a good place to ask questions about sqlite? Can somebody please
> tell me where to go;)
On SQLite itself - no, in relation to Mono/ASP.NET - yes.

> Has everybody (or anybody) worked with monodevelop to put together an
> asp.net <http://asp.net> application that uses an sqlite database that
> they then put into production?
I don't use MonoDevelop, but for a production application which can use SQLite as an option, see
BlogEngine.NET.

marek
_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list

[rafael rueda]

MYSQL???. PostgreSQL offers much higher quality
> product (reliability, advanced features, security) than MySQL

Rafael Rueda

El mar, 03-11-2009 a las 09:58 +0100, Marek Habersack escribió:

> 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@...> 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@...
> >> http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
> >>
> >>
> > _______________________________________________
> > Mono-aspnet-list mailing list
> > Mono-aspnet-list@...
> > http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
> >
>
> _______________________________________________
> Monodevelop-list mailing list
> Monodevelop-list@...
> http://lists.ximian.com/mailman/listinfo/monodevelop-list

       
       
               
______________________________________________
LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y m�viles desde 1 c�ntimo por minuto.
http://es.voice.yahoo.com

_______________________________________________
Monodevelop-list mailing list
Monodevelop-list@...
http://lists.ximian.com/mailman/listinfo/monodevelop-list