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?

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Gonzalo Paniagua Javier-5]

On Tue, 2009-11-03 at 08:35 +0000, 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@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Mike Christensen]

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.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.

-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

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

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

[Joe Audette-2]

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 <grendel@...> 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-list@...
> 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.audette@...
http://www.mojoportal.com
http://twitter.com/joeaudette
_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Joe Audette-2]

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 <daleemoore@...> 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.audette@...> 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 <grendel@...>
>> 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-list@...
>> > 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.audette@...
>> 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.audette@...
http://www.mojoportal.com
http://twitter.com/joeaudette
_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[DaleEMoore]

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.audette@...> 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 <daleemoore@...> 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.audette@...> 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 <grendel@...>
>> 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-list@...
>> > 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.audette@...
>> 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.audette@...
http://www.mojoportal.com
http://twitter.com/joeaudette

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Daniel Morgan-3]

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 <grendel@...> wrote:

> From: Marek Habersack <grendel@...>
> Subject: Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
> To: "william leader" <william.leader@...>
> Cc: "Dale E. Moore" <daleemoore@...>, Mono-list@..., "monodevelop-list" <monodevelop-list@...>, mono-aspnet-list@...
> 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@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Francisco Figueiredo Jr.-2]

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 <monodanmorg@...> 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 <grendel@...> wrote:
>
>> From: Marek Habersack <grendel@...>
>> Subject: Re: [Mono-list] [Mono-aspnet-list] sqlite questions?
>> To: "william leader" <william.leader@...>
>> Cc: "Dale E. Moore" <daleemoore@...>, Mono-list@..., "monodevelop-list" <monodevelop-list@...>, mono-aspnet-list@...
>> 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@...
> 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@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Michael J. Ryan-4]

On 11/3/2009 1:43 AM, Gonzalo Paniagua Javier wrote:
 > On Tue, 2009-11-03 at 08:35 +0000, 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.

Beyond that, FirebirdSQL has a very mature set of drivers for Mono, as well as
feature rich support with NHibernate/Castle ActiveRecord/Fluent etc...

There's also PostgreSQL.

One bit of caution is that SQLite really won't scale well if there's a single
database with many people connecting at once (for writes)... It'll go a little
further than say Access/Jet but not nearly as much as a service based rdbms.
It may be a decent database for certain implementations, and if you can
segment the data into separate DBs it'll scale better under load.

--
Michael J. Ryan - http://tracker1.info/

... FRA #059: Free advice is seldom cheap.


_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

[Michael J. Ryan-4]

I'm pretty fond of both Postgres as well as Firebird myself.

On 11/3/2009 1:44 AM, Mike Christensen wrote:

> 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.leader@... <mailto: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 <http://asp.net> applications
>     are developed for
>     Microsoft SQL server or MySQL server depending on where the developer
>     wants the asp.net <http://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 <daleemoore@...
>     <mailto: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 <http://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@...
>     <mailto:Mono-aspnet-list@...>
>      > http://lists.ximian.com/mailman/listinfo/mono-aspnet-list
>      >
>      >
>     _______________________________________________
>     Mono-aspnet-list mailing list
>     Mono-aspnet-list@...
>     <mailto: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

--
Michael J. Ryan - http://tracker1.info/

... FRA #211: Employees are rungs on the ladder of success. Don't hesitate to
step on them.

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list