Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
On Tue, 2009-11-03 at 08:35 +, 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. [...] I would suggest you do some research before giving advice to other people. A simple Google search for the words Sqlite mono (who would have thought of those?) would have been enough. -Gonzalo ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
I'll just have to chime in here and recommend at least taking a brief look at PostgreSQL as well. I tried it out a while back and haven't gone back to either MS SQL or MySQL since.. You'll have no problems getting Mono code to talk with it either. On Tue, Nov 3, 2009 at 12:35 AM, william leader william.lea...@gmail.comwrote: 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. -Will On Tue, Nov 3, 2009 at 5:01 AM, Dale E. Moore daleemo...@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-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list ___ Mono-aspnet-list mailing list mono-aspnet-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
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 daleemo...@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-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list ___ Mono-aspnet-list mailing list mono-aspnet-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
Hi Dale, The latest mojoPortal from our svn trunk repository is pre-configured to use SQLite in MonoDevelop using mojoportal.mds solution. I changed the default db configuration from pgsql recently just because its zero configuration, we inlcude a sqlite database and it just works. You can produce a package and deploy it to production including the pre-populated SQLite database. However, whether you would use SQLite for a production site/app depends a lot on the app and how many users it will have. SQLite is very fast but there is only 1 connection whereas pgsql and others have a connection pool. So if the site/app gets a lot of traffic it probably won't stand up well because each request is taking turns with the one connection. So it can work well for a few users but it does not scale real well to heavy web traffic. Hope it helps, Joe On Tue, Nov 3, 2009 at 4:01 AM, Marek Habersack gren...@twistedcode.net wrote: 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 ___ Mono-aspnet-list mailing list mono-aspnet-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list -- Joe Audette Software Solutions Architect Source Tree Solutions, LLC PO Box 621861 Charlotte, NC 28262 704.323.8225 joe.aude...@gmail.com http://www.mojoportal.com http://twitter.com/joeaudette ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
If you are using mojoPortal then you don't have to worry about this, the mojoMembership just talks to business objects which talk to data objects which already know their connection string from the appSettings. If you are using some other membership provider then you probably need to add a ConnectionString section to your web.config and add the connection string there with a name expected by or configured on the provider. However I don't know if there is a membership provider specifically for sqlite in Mono, maybe there is, there would have to be some scripts to create the appropriate tables in the sqlite database. Do a little googling about the ConnectionString section of Web.config. Hope it helps, Joe On Tue, Nov 3, 2009 at 9:14 AM, Dale E. Moore daleemo...@gmail.com wrote: Dear Joe; It's so good to 'hear your voice' here! I copied the DEV project to a TEST site and everything works, except the Forms Authentication; I can't login and I can't seem to tell sqlite where the Membership database is located. Thanks for your thoughts on growth; I will probably move to PostgreSQL if anybody other than me ever wants the functionality. Debugging my NewValues reverted to OldValues issue is still on my to do list; thanks for the encouragement; Dale On Tue, Nov 3, 2009 at 5:51 AM, Joe Audette joe.aude...@gmail.com wrote: Hi Dale, The latest mojoPortal from our svn trunk repository is pre-configured to use SQLite in MonoDevelop using mojoportal.mds solution. I changed the default db configuration from pgsql recently just because its zero configuration, we inlcude a sqlite database and it just works. You can produce a package and deploy it to production including the pre-populated SQLite database. However, whether you would use SQLite for a production site/app depends a lot on the app and how many users it will have. SQLite is very fast but there is only 1 connection whereas pgsql and others have a connection pool. So if the site/app gets a lot of traffic it probably won't stand up well because each request is taking turns with the one connection. So it can work well for a few users but it does not scale real well to heavy web traffic. Hope it helps, Joe On Tue, Nov 3, 2009 at 4:01 AM, Marek Habersack gren...@twistedcode.net wrote: 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 ___ Mono-aspnet-list mailing list mono-aspnet-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list -- Joe Audette Software Solutions Architect Source Tree Solutions, LLC PO Box 621861 Charlotte, NC 28262 704.323.8225 joe.aude...@gmail.com http://www.mojoportal.com http://twitter.com/joeaudette -- Joe Audette Software Solutions Architect Source Tree Solutions, LLC PO Box 621861 Charlotte, NC 28262 704.323.8225 joe.aude...@gmail.com http://www.mojoportal.com http://twitter.com/joeaudette ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
I'm using the default asp.net membership provider; which works fine in monodevelop, but; does not find the App_Data/aspnetdb.sqlite database when copied to TEST. I copied the mono connectionString, and membership definition into my web.config but then could never login even from monodevelop. I'm missing something in the membership setup in web.config, I think. On Tue, Nov 3, 2009 at 8:21 AM, Joe Audette joe.aude...@gmail.com wrote: If you are using mojoPortal then you don't have to worry about this, the mojoMembership just talks to business objects which talk to data objects which already know their connection string from the appSettings. If you are using some other membership provider then you probably need to add a ConnectionString section to your web.config and add the connection string there with a name expected by or configured on the provider. However I don't know if there is a membership provider specifically for sqlite in Mono, maybe there is, there would have to be some scripts to create the appropriate tables in the sqlite database. Do a little googling about the ConnectionString section of Web.config. Hope it helps, Joe On Tue, Nov 3, 2009 at 9:14 AM, Dale E. Moore daleemo...@gmail.com wrote: Dear Joe; It's so good to 'hear your voice' here! I copied the DEV project to a TEST site and everything works, except the Forms Authentication; I can't login and I can't seem to tell sqlite where the Membership database is located. Thanks for your thoughts on growth; I will probably move to PostgreSQL if anybody other than me ever wants the functionality. Debugging my NewValues reverted to OldValues issue is still on my to do list; thanks for the encouragement; Dale On Tue, Nov 3, 2009 at 5:51 AM, Joe Audette joe.aude...@gmail.com wrote: Hi Dale, The latest mojoPortal from our svn trunk repository is pre-configured to use SQLite in MonoDevelop using mojoportal.mds solution. I changed the default db configuration from pgsql recently just because its zero configuration, we inlcude a sqlite database and it just works. You can produce a package and deploy it to production including the pre-populated SQLite database. However, whether you would use SQLite for a production site/app depends a lot on the app and how many users it will have. SQLite is very fast but there is only 1 connection whereas pgsql and others have a connection pool. So if the site/app gets a lot of traffic it probably won't stand up well because each request is taking turns with the one connection. So it can work well for a few users but it does not scale real well to heavy web traffic. Hope it helps, Joe On Tue, Nov 3, 2009 at 4:01 AM, Marek Habersack gren...@twistedcode.net wrote: 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 ___ Mono-aspnet-list mailing list mono-aspnet-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-aspnet-list -- Joe Audette Software Solutions Architect Source Tree Solutions, LLC PO Box 621861 Charlotte, NC 28262 704.323.8225 joe.aude...@gmail.com http://www.mojoportal.com http://twitter.com/joeaudette -- Joe Audette Software Solutions Architect Source Tree Solutions, LLC PO Box 621861 Charlotte, NC 28262 704.323.8225 joe.aude...@gmail.com http://www.mojoportal.com http://twitter.com/joeaudette ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
Npgsql developers have re-licensed Npgsql under the BSD license. http://fxjr.blogspot.com/2007/08/npgsql-license-changed-to-bsd_27.html Npgsql http://npgsql.projects.postgresql.org/ Plus, Npgsql has (copied from the Npgsql web page): # Support for .Net 2.0 and 3.5 # Entity Framework (EF): In order to use it, you have to download a special build with the 3.5 suffix in its name on our download page. # Improved performance for large resultsets:Different from Npgsql1, Npgsql2 doesn't read all table contents before returning control to user code. This makes Npgsql much more memory efficient when dealing with large tables. # ASP.Net Providers --- On Tue, 11/3/09, Marek Habersack gren...@twistedcode.net wrote: From: Marek Habersack gren...@twistedcode.net Subject: Re: [Mono-list] [Mono-aspnet-list] sqlite questions? To: william leader william.lea...@gmail.com Cc: Dale E. Moore daleemo...@gmail.com, Mono-list@lists.ximian.com, monodevelop-list monodevelop-l...@lists.ximian.com, mono-aspnet-l...@lists.ximian.com Date: Tuesday, November 3, 2009, 3:58 AM william leader wrote: ... 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. ... ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
Yeap, we changed license so it would be more aligned with server license itself and also to help users with commercial products. Although LGPL already allowed them to use Npgsql, they had fears about it. Another motivation was VS.Net design support which may impose some restrictions in code distribution in source form which would give a conflict with LGPL. On Tue, Nov 3, 2009 at 13:04, Daniel Morgan monodanm...@yahoo.com wrote: Npgsql developers have re-licensed Npgsql under the BSD license. http://fxjr.blogspot.com/2007/08/npgsql-license-changed-to-bsd_27.html Npgsql http://npgsql.projects.postgresql.org/ Plus, Npgsql has (copied from the Npgsql web page): # Support for .Net 2.0 and 3.5 # Entity Framework (EF): In order to use it, you have to download a special build with the 3.5 suffix in its name on our download page. # Improved performance for large resultsets:Different from Npgsql1, Npgsql2 doesn't read all table contents before returning control to user code. This makes Npgsql much more memory efficient when dealing with large tables. # ASP.Net Providers --- On Tue, 11/3/09, Marek Habersack gren...@twistedcode.net wrote: From: Marek Habersack gren...@twistedcode.net Subject: Re: [Mono-list] [Mono-aspnet-list] sqlite questions? To: william leader william.lea...@gmail.com Cc: Dale E. Moore daleemo...@gmail.com, Mono-list@lists.ximian.com, monodevelop-list monodevelop-l...@lists.ximian.com, mono-aspnet-l...@lists.ximian.com Date: Tuesday, November 3, 2009, 3:58 AM william leader wrote: ... 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. ... ___ Mono-list maillist - mono-l...@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior ___ Mono-list maillist - Mono-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-list
