Re: Anyone here using SQLite ?

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

The thing I haven't quite figured out is where an instance SQLite sits that
would allow other scripts in different "contexts" (Java term) to access it.
 Or is the idea to have many SQLite instances - a new one for each app?

I am curious about SQLite because I plan on making use of it in the near
future on Android, so thanks for brining this up Richard! :-)

Aaron Bartell
www.MowYourLawn.com/blog
www.OpenRPGUI.com
www.SoftwareSavesLives.com



On Tue, Jan 25, 2011 at 7:48 AM, Richard Schoen <richard@xxxxxxxxxxxxxxx>wrote:

> Thanks for the feedback.
>
> My real interest is to potentially use SQLite with .Net as a lightweight
> alternative to deploying SQL Server or some other server database when an
> application does not have a ton of settings or database needs.
>
> MS Access databases or my own XML files can also be used, but I would
> rather stay with something a little lighter.
>
> In an ASP.Net web application, the Web.Config is a nice place to get the
> app started, but I like the idea of storing all the relevant settings in a
> database.
>
> Any downsides other than not running on i :-)
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
> ------------------------------
>
> message: 6
> date: Mon, 24 Jan 2011 15:01:09 -0700
> from: Pete Helgren <pete@xxxxxxxxxx>
> subject: Re: [WEB400] Anyone here using SQLite ?
>
> It was.  Now Derby or Java DB depending upon implementation.  It's built
> into WAS CE.
>
> http://en.wikipedia.org/wiki/Apache_Derby
>
> Pete Helgren
> Value Added Software, Inc
> www.asaap.com
> www.opensource4i.com
>
>
> --
> This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.