[Mono-list] [Mono-aspnet-list] sqlite questions?

[Joe Audette]

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