Ian, You might try Berkeley DB 11gR2 (read: Berkeley DB and SQLite combined) it allows you to run multi-process access to a SQLite database and scales really well.
http://download.oracle.com/berkeley-db/db-5.0.21.tar.gz Give it a whirl and then let me know what you think. -greg > -----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 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users