Re: [sqlite] Accessing an sqlite db from two different programs

> > Sent: Monday, 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 poss

Re: [sqlite] Accessing an sqlite db from two different programs

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

Re: [sqlite] Accessing an sqlite db from two different programs

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

Re: [sqlite] Accessing an sqlite db from two different programs

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

[sqlite] Accessing an sqlite db from two different programs

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

Re: [sqlite] Accessing an sqlite db from two different programs

> 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

Re: [sqlite] Accessing an sqlite db from two different programs

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,

[sqlite] Accessing an sqlite db from two different programs

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