Re: Anyone here using SQLite ?

[Evan Harris <auctionitis@xxxxxxxxx>]

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.