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 <[email protected]> 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 > [email protected] > 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 [email protected] http://www.mojoportal.com http://twitter.com/joeaudette _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
