Re: Anyone here using SQLite ?

Agreed, but it is worth being aware of.

On Thu, Jan 27, 2011 at 9:59 AM, Richard Schoen <richard@xxxxxxxxxxxxxxx> wrote:

In ASP.Net or a Windows Form app that should work fine for a lightweight application.

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: Wed, 26 Jan 2011 11:44:37 +1300
from: Evan Harris <auctionitis@xxxxxxxxx>
subject: Re: [WEB400] Anyone here using SQLite ?

One per app. It locks at the file level not the table or row level so
mult-user/multi application access doesn't really work when different
processes want to access the database concurrently.

On Wed, Jan 26, 2011 at 11:27 AM, Richard Schoen
<richard@xxxxxxxxxxxxxxx> wrote:

My thought is one per app, although it might work ?for multi-user apps as well.

The file sits in a file system path just like an Access DB or XML file.

You call it out via a file path.

Apparently Android, iPhone and HTML5 can all use SQLite for storage.

So if you create an Android or iPad app, you would essentially let each app have a SQLite DB instance for it's settings/localized data.

Regards,
Richard Schoen
RJS Software Systems Inc.

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