Re: Anyone here using SQLite ?

[Richard Schoen <richard@xxxxxxxxxxxxxxx>]

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.