y, June 28, 2010 6:36 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] Accessing an sqlite db from two different
> > programs
> >
> > absolutely no problem with sqlite.
> > ensure you are doing smallest update as possible.
> >
absolutely no problem with sqlite.
ensure you are doing smallest update as possible.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> -Original Message-
> From: Ian Hardingham [mailto:i...@mode7games.com]
> Sent: Tuesday, June 22, 2010 12:44 PM
> To: General Discussion of SQLite Database
> Subject: [sqlite] Accessing an sqlite db from two different programs
>
> Hey guys,
>
> If I have program 1 and pr
On 22 Jun 2010, at 5:44pm, Ian Hardingham wrote:
> If I have program 1 and program 2 which both open the same db file, but
> they never write to the same table (but might be reading one written by
> another), do I need to do a lot of locking? I'm not worried about race
> conditions.
SQLite w
Hey guys,
If I have program 1 and program 2 which both open the same db file, but
they never write to the same table (but might be reading one written by
another), do I need to do a lot of locking? I'm not worried about race
conditions.
Thanks,
Ian
> do I need to do a lot of locking?
You don't need to do it, SQLite will do that for you. And it doesn't
matter whether both applications write to the same table or different
ones - as long as they write to the same file those writes will be
serialized by locking made inside SQLite.
But you have
On 22 Jun 2010, at 5:44pm, Ian Hardingham wrote:
> If I have program 1 and program 2 which both open the same db file, but
> they never write to the same table (but might be reading one written by
> another), do I need to do a lot of locking? I'm not worried about race
> conditions.
Sorry, y
Hey guys,
If I have program 1 and program 2 which both open the same db file, but
they never write to the same table (but might be reading one written by
another), do I need to do a lot of locking? I'm not worried about race
conditions.
Thanks,
Ian
8 matches
Mail list logo