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

[Joe Audette]

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